Why would you create SQL in calculation views?
A. To provide an alternative to graphical modeling
B. To enable write capabilities
C. To implement custom logic
D. To fine-tune performance
正解:C
質問 2:
What do you use in the definition of a dynamic SQL analytic privilege?
A. An organization hierarchy that provides role-based access to data.
B. A procedure that returns the data access condition as an SQL expression.
C. A scalar function that returns a list of the allowed values for each attribute.
D. A table function that returns a list of allowed values.
正解:B
質問 3:
What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.
A. Read performance decreases.
B. Aggregates are not adjusted.
C. Memory is not optimized.
D. New records are not read.
正解:B,C
質問 4:
What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.
A. Cached results to improve read performance
B. A column view in a container
C. An SQL execution plan
D. Metadata to enable consumption by external tools
正解:B,D
質問 5:
Why would you partition a table in an SAP HANA Cloud database?Note: There are 2 correct answers to this question.
A. To improve query performance when accessing large column tables
B. To improve response time when multiple users access the same table
C. To improve data replication performance on large row tables
D. To overcome the 2 billion record limit
正解:A,D
質問 6:
In a calculation view, what is the purpose of a variable?
A. To pass values between procedures and calculation views
B. To filter an attribute at run-time based on a user input
C. To break up complex SQL into smaller steps
D. To provide a dynamic value in a calculated column
正解:B
質問 7:
Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.
A. Julian
B. Factory
C. Fiscal
D. Gregorian
正解:C,D
質問 8:
In an XS Advanced project, what is the purpose of the .hdiconfig file?
A. To specify the namespace rules applicable to the name of database objects
B. To specify in which space the container should be deployed
C. To specify which HDI plug-ins are available
D. To specify an external schema in which calculation views will get their data
正解:C
777 お客様のコメント





Hashimoto -
SAPの問題集は今回も信用して使いさせてもらいました。C_HANAIMP_18の問題集を購入して翌日にして更新もしてくれて、おかげさまで、試験に無事合格しました。Pass4Testさん、いつもお世話になっております。