SAP C_HANAIMP_18 問題集

質問 1：
In an XS Advanced project, what is the purpose of the .hdiconfig file?
A. To specify in which space the container should be deployed
B. To specify the namespace rules applicable to the name of database objects
C. To specify which HDI plug-ins are available
D. To specify an external schema in which calculation views will get their data
正解：C

質問 2：
In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.
A. To lock the calculation view from further modifications
B. To warn developers that the calculation view is no longer supported
C. To indicate that it should not be used as a data source to other calculation views
D. To ensure it is not exposed to reporting tools for consumption
正解：C

質問 3：
Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note:
There are 2 correct answers to this question.
A. Limit the number of joined columns
B. Define join direction in a full outer join
C. Use an inner join
D. Specify the join cardinality
正解：A,D

質問 4：
You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?
A. Calculated columns
B. Joins
C. Data sources of unions
D. Filters
正解：C

質問 5：
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. Metadata to enable consumption by external tools
C. A column view in a container
D. An SQL execution plan
正解：B,C

質問 6：
What are some best practices when developing calculation views?Note: There are 2 correct answers to this question.
A. Model star schemas using a sequence of join nodes.
B. Include all data flow logic within one calculation view.
C. Aggregate at the lowest possible node.
D. Avoid defining joins on calculated columns.
正解：A,C

質問 7：
Which options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.
A. Generate additional root nodes.
B. Assign them to a level below the root.
C. Define an expression to determine a parent.
D. Assign them to a node at the root level.
正解：A,D