NEW QUESTION NO: 10
You have created a SQL analytic privilege on an information view. Where do you tell the view to enable SQL analytic privileges?
Please choose the correct answer.
Response:
A. In the migration tool
B. In the SAP HANA studio preferences
C. In the restrictions settings of the SQL analytic privilege
D. In the semantic node of the information model
Answer: D

NEW QUESTION NO: 11
Which can a level hierarchy do?
Please choose the correct answer.
Response:
A. Have time-dependency
B. Show variable deepness in the data
C. Enable drill-down in a value help list
D. Be used for a bill of materials structure
Answer: C

NEW QUESTION NO: 12
What PAL algorithm would you use to analyze shopping baskets?
Please choose the correct answer.
Response:
A. Apriori
B. K-means
C. Link prediction
D. Decision tree
Answer: A

NEW QUESTION NO: 13
What can you use to limit the number of records produced by a calculation view?
There are 3 correct answers to this question.
Response:
A. Generated columns
B. Restricted columns
C. Filter expressions
D. Domain fix values
E. SAP client restrictions
Answer: C,D,E

NEW QUESTION NO: 14
Where can you create a filter expression?
Please choose the correct answer.
Response:
A. In the semantics node
B. In a data foundation node
C. In a projection node
D. In an aggregation node
Answer: C

NEW QUESTION NO: 15
What can a variable be used for?
Please choose the correct answer.
Response:
A. Calculated column expression
B. Filtering
C. Currency conversion
D. Call decision table in SQLScript
Answer: B

NEW QUESTION NO: 16
What artifacts do you use in the output area of a decision table node?
There are 2 correct answers to this question.
Response:
A. Conditions
B. Restrictions
C. Input parameters
D. Actions
Answer: A,D

NEW QUESTION NO: 17
Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge?
There are 2 correct answers to this question.
Response:
A. Creating a report in SAP Crystal Reports for Enterprise
B. Creating business intelligence content with SAP BusinessObjects Design Studio
C. Creating a REST web service in the SAP HANA XS engine
D. Creating a composite provider in SAP BW
Answer: B,C

NEW QUESTION NO: 18
What performance techniques should you implement to improve join per- formance?
There are 3 correct answers to this question.
Response:
A. Join as many tables as possible in an analytic view's data foundation.
B. Always mark joins as dynamic to improve performance.
C. Use left outer joins instead of right outer joins.
D. Always specify the cardinality of a join.
E. Use unions instead of joins for combining large data sets.
Answer: C,D,E

NEW QUESTION NO: 19
You are using the SAP HANA studio.
Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed?
There are 3 correct answers to this question.
Response:
A. SAP HANA smart data streaming (SDS) projects
B. SAP HANA extended application services (XS) programs
C. SAP HANA predictive analytics library (PAL) flows
D. SAP HANA smart data access (SDA) queries
E. SAP HANA enterprise information manager (EIM) jobs
Answer: A,C,E

NEW QUESTION NO: 20
You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the correct answer.
Response:
A. Temporal join
B. Dynamic join
C. Relational join
D. Self-join
Answer: D