Learn, Practice, and Improve with SAP C_HAMOD_2404 Practice Test Questions

What do you use in the definition of a dynamic SQL analytic privilege?

A. An organization hierarchy that provides role-based access to data.

B. A scalar function that returns a list of the allowed values for each attribute.

C. A table function that returns a list of allowed values.

D. A procedure that returns the data access condition as an SQL expression.

Referring to the diagram,

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

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

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

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

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

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

A. Data sources of unions

B. Joins

C. Calculated columns

D. Filters

Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.

A. Table function

B. Procedure

C. Row table

D. Scalar function

In a data source node of a flowgraph, in addition to tables and views, which other objects can you define as the data source? Note: There are 3 correct answers to this question.

A. virtual table

B. calculation view

C. procedure

D. synonym

E. table function

A cube calculation view consumes a dimension calculation view. You rename the design time file of the dimension view but do NOT choose the option to rename the runtime view and adjust the reference. Afterward, you perform the following operations:

•A: Build/deploy the dimension calculation view as a single object.

•B: Build/deploy the entire SAP HANA database module. What is the outcome of the build/deploy operations?

A. A is successful.
•Fails.

B. A fails.
•B is successful.

C. A fails.
•B fails.

D. A is successful.
•B is successful.

Which of the following are standard options provided to define analytic privileges? Note: There are 3 correct answers to this question.

A. Dynamic

B. SQL expression

C. Hierarchy function

D. Graph

E. Attributes