C_HANAIMP_18 by SAP Actual Free Exam Q&As

Question 1

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

A. To avoid duplicate rows in the output B. To ensure semantic correctness C. To hide columns that are not required D. To force filters to apply at the lowest node

Discussion 0

Correct Answer: D Vote an answer

Question 2

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. Join B. Projection C. Union D. Aggregation

Discussion 0

Correct Answer: B Vote an answer

Question 3

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

A. Query processing time improves B. SQL compilation time increases C. Results are read from static cache D. Count-distinct results are incorrect

Discussion 0

Correct Answer: B,C Vote an answer

Question 4

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

A. To ensure specific columns are NOT exposed to the reporting tool B. To remove a column that is also used as a Label column C. To prevent passing columns in stacked calculation views D. To avoid exposing sensitive columns when defining calculated columns

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

In a calculation view, what is the purpose of a variable?

A. To pass values between procedures and calculation views B. To break up complex SQL into smaller steps C. To filter an attribute at run-time based on a user input D. To provide a dynamic value in a calculated column

Discussion 0

Correct Answer: C Vote an answer

Question 6

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February.

What is the optimal way to do this?

A. Use an aggregation node. B. Use a union node. C. Use a minus node. D. Use an intersect node.

Discussion 0

Correct Answer: B Vote an answer

Question 7

You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

A. <empty string> B. "?" C. "Null" D. "0"

Discussion 0

Correct Answer: A Vote an answer

Question 8

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

A. You did NOT define a valid table type. B. Your function refers to a scalar function. C. Your function includes a TRUNCATE statement. D. You did not define at least one input parameter.

Discussion 0

Correct Answer: C Vote an answer

Question 9

What are some of the restrictions that apply when defining parallelization blocks in calculation views?Note:
There are 2 correct answers to this question.

A. Only one block can be defined across a stack of calculation views. B. The block must only have one start node. C. The block must start with a node that defines a table as a data source. D. Multiple blocks can only be defined within a single calculation view.

Discussion 0

Correct Answer: A,C Vote an answer

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C_HANAIMP_18 Exam Practice Test