C_HANAIMP_17 Online Practice Questions and Answers

Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the new features are not displayed.

What could be the reason for this?

A. You need to update the project settings to reference the new revision.

B. Your calculation views have not been built in the new version of the Web IDE.

C. The calculation views have not been migrated to the new revision.

D. The .hdiconfig file has not been updated to the latest calculation view build plug-in.

When would you develop an SQL procedure instead of a function?

A. You need to implement Data Definition Language (DDL) statements.

B. The code should modify data in the table.

C. Optimal performance is apriority.

D. You need to use conditional logic.

E. You want to create a dynamic analytic privilege.

Why do you use parameter mapping in a calculation view?

Note: There are 2 correct answers to this question.

A. To convert the data types of input parameters

B. To push down filters to the lowest level calculation views

C. To pass variable values to external value help views

D. To enable an input parameter in a calculation view

Why does query performance decrease when the data volume of the delta storage is large?

Note: There are 2 correct answers to this question.

A. The data is unstructured.

B. The data is uncompressed.

C. The data is stored in the warm tier.

D. The data is NOT sorted.

Why do you create calculation views of data category DIMENSION with type TIME?

A. To provide the time intervals required by time-dependent parent-child hierarchies.

B. To store historical version of attributes.

C. To add a temporal condition to a join to find matching records from two tables based on a date.

D. To provide additional time-related navigation possibilities

When modeling in the Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

A. Synonym

B. Association

C. Virtual Table

D. Alias

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view?

A. Analytic Privileges and SELECT privileges on the CUBE Calculation view

B. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view

C. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view

D. SELECT or Privileges and Analytic Privileges on both views

Why do we use Git when modeling calculation views?

A. Develop conceptual prototypes

B. Enable collaboration between developers

C. Provide access to external schemas

D. Control specifically object versioning

Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

A. D

B. C

C. A

D. B

Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output from the screen shot?

A. Create a restricted column for each year.

B. Implement a union node and map each year as a separate column.

C. Create 3 calculated columns.

D. Create a filter expression that uses an OR operator.