You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.
A. The hierarchy must be a shared hierarchy.
B. The hierarchy must be a local hierarchy.
C. The hierarchy must be exposed by a calculation view of type CUBE with star join.
D. The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY.
正解:A,C
質問 2:
Why would you enable Debug Query mode in a calculation view?
A. To set breakpoints and step through the execution
B. To check which database engines are invoked
C. To identify data sources that are not accessed by a query
D. To understand how tables are partitioned
正解:C
質問 3:
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
質問 4:
Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question.
A. Partitions
B. Indexes
C. Stored aggregates
D. Views
正解:B,C
質問 5:
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
質問 6:
Why should you define calculated column expressions using plain SQL and avoid using column engine language?
A. To access the full set of SQL functions
B. To allow imperative statements
C. To benefit from additional SQL optimizations
D. To prevent queries from unfolding
正解:C
Shena -
とうたうだけあって、丁寧に解説されています。
効率的にまとまっているC_HANAIMP_18参考書だと思います。