SAP SAP Certifications C_HANAIMP_17 Questions & Answers

• Question 11:

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

  A. To break up complex SQL into smaller steps

  B. To pass values between procedures and calculation views

  C. To provide a run-time attribute filter based on a user input

  D. To provide a dynamic value in a calculated column

  Correct Answer: AC

• Question 12:

  What are the components of a graph workspace?

  Note: There are 2 correct answers to this question.

  A. Dimension

  B. Vertex

  C. Edge

  D. Association

  Correct Answer: BC

• Question 13:

  Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

  A. They can harm SQL optimization.

  B. NOT all reporting tools can consume the results.

  C. They introduce potential security risk.

  D. They call multiple processing engines

  Correct Answer: C

• Question 14:

  Why do you create a multi store table?

  A. To improve read performance when accessed by simultaneous applications

  B. To have the opt on to partition the table across different storage tiers

  C. To evenly distribute the data across all available server nodes

  D. To have a table that combines the characteristics of row and column stores

  Correct Answer: B

• Question 15:

  You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?

  A. Define a union node as the start of the parallelization block.

  B. Define a projection node as the end of the parallelization block.

  C. Assign tables as the only data sources in the nodes that start the parallelization block.

  D. Define a source column as partitioning value in the start node of the parallelization block.

  Correct Answer: C

• Question 16:

  Why might you use the Keep Flag property in an aggregation node?

  A. To cache the results of the aggregation node for drill-down

  B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

  C. To include columns that are NOT requested by a query but are essential for the correct result

  D. To retain the correct aggregation behavior in stacked views.

  Correct Answer: C

• Question 17:

  You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views belong to the same project. Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

  A. Export the HDB module -> Export the project

  B. Build the HDB module -> Build the project

  C. Activate the project -> Build the HDB module

  D. Build the project -> Build the HDB module

  Correct Answer: D

• Question 18:

  How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

  A. Call the SAP-provided PAL decision tree procedure from the table function

  B. Use dynamic SQL in the table function to generate the SQL code

  C. Copy and adapt the SQL code generated by a flow graph into the table function

  D. Build a flow graph and call it from the table function using input parameters

  Correct Answer: CD

• Question 19:

  Which of the following are warm tier Solutions? Note: There are 3 correct answers.

  A. Active / active read-enabled mode

  B. Native Storage Extension

  C. Extension Node

  D. Dynamic Tiering

  E. Persistent Memory

  Correct Answer: CDE

• Question 20:

  You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect? Note: There are 2 correct answers to this question.

  

  A. When the query requests PRODUCT_GROUP and PRODUCT_ID

  B. When the query requests only the PRODUCT_ID

  C. When the query requests PRODUCT_GROUP

  D. When Source A has no records

  Correct Answer: CD