You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

• A.The hierarchy must be a local hierarchy.
• B.The hierarchy must be exposed by a calculation view of type CUBE with star join.
• C.The hierarchy must be a shared hierarchy.
• D.The hierarchy must be a parent-child hierarchy.

Comment: *

Name: *

Email: *

Verification: *

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

• A.The output parameter is defined as NVARCHAR
• B.The procedure is write-enabled
• C.You defined more than one output parameter
• D.No input parameter is specified

Comment: *

Name: *

Email: *

Verification: *

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

• A.To add a temporal condition to a join to find matching records from two tables based on a date
• B.To store historical versions of attributes
• C.To provide additional time-related navigation possibilities
• D.To provide the time intervals required by time-dependent parent-child hierarchies

Comment: *

Name: *

Email: *

Verification: *

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

• A.To improve data replication performance on large row tables
• B.To improve response time when multiple users access the same table
• C.To overcome the 2 billion record limit
• D.To improve query performance when accessing large column tables

Comment: *

Name: *

Email: *

Verification: *

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 filter an attribute at runtime based on a user input
• D.To provide a dynamic value in a calculated column

Comment: *

Name: *

Email: *

Verification: *