C_HCMOD_05 Exam Results

SAP Certified Application Associate - SAP HANA Cloud Modeling Questions and Answers

Question 9

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

Query processing time improves

Results are read from static cache

SQL compilation time increases

Count-distinct results are incorrect

Question 10

Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

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

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

A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view

SELECT privileges and Analytic Privileges (Country = United States) on both views

Question 11

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

To provide additional time-related navigation possibilities

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

To store historical versions of attributes

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

Question 12

Which tool generates and executes the SQL for a specific node of your calculation view?

Debug Query mode

Explain plan

SQL analyzer

Database explorer