C_HANAIMP_18問題集、SAP実際の試験問題

質問 1

Why would you use the Transparent Filter property in a calculation view?

A. To include columns that are NOT requested by a query

B. To apply filters that are hidden from the end user

C. To allow filter push-down in stacked calculation views

D. To avoid columns being unnecessarily used in an aggregation

正解: C

質問 2

How can you define a variable that presents its value help hierarchically?Note: There are 2 correct answers to this question.

A. Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the parent attribute of the hierarchy.

B. Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the top level of the hierarchy.

C. Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the leaf level of the hierarchy.

D. Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the child attribute of the hierarchy.

正解: C,D

質問 3

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node.How many rows are in the output of your query?

A. 9

B. 5

C. 6

D. 2

正解: A

質問 4

What are some best practices when developing calculation views?Note: There are 2 correct answers to this question.

A. Aggregate at the lowest possible node.

B. Include all data flow logic within one calculation view.

C. Model star schemas using a sequence of join nodes.

D. Avoid defining joins on calculated columns.

正解: A,C

質問 5

Which options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

A. Assign them to a node at the root level.

B. Assign them to a level below the root.

C. Define an expression to determine a parent.

D. Generate additional root nodes.

正解: A,D

質問 6

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

A. Implement union pruning.

B. Avoid aggregating data early in the data flow.

C. Partition large tables.

D. Limit the number of stacked calculation views.

正解: C,D

質問 7

Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

A. Projection

B. Aggregation

C. Join

D. Union

正解: A

質問 8

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

A. Implement union pruning.

B. Avoid aggregating data early in the data flow.

C. Partition large tables.

D. Limit the number of stacked calculation views.

正解: C,D

質問 9

Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

A. Scalar function

B. Table function

C. Row table

D. Procedure

正解: B,C

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C_HANAIMP_18 模擬練習