Online Access Free C_HANAIMP_17 Exam Questions

Which tool do you use to display the generated SQL for each node of your calculation view?

• A.Plan Visualizer
• B.Performance Analysis Mode
• C.SQL Analyzer
• D.Debug Query Mode

Why do you implement Active / active read-enabled mode?

• A.To improve query performance
• B.To enhance security for data access
• C.To provide offline access to data
• D.To synchronize query results with operational data

You created a table using the SQL conSQLe inside the HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it. What do you observe in the SAP HANA database container?

• A.The build fails but the table is not dropped.
• B.The build is successful, and you get the expected data.
• C.The build fails, and the table is dropped.
• D.The build is successful, but the data preview is empty.

What restrictions apply to a Graph node that you include in a calculation view?

• A.It cannot be included in a calculation view of type dimension.
• B.Its data source must be provided by a projection node.
• C.It must be the first node in the dataflow.
• D.It must be the final node in the dataflow.

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

• A.Create a level hierarchy and assign it to the variable.
  Ensure the variable's reference column is the top level of the hierarchy.
• B.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.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 parent attribute of the hierarchy.