C_HAMOD_2404 Sample Questions Answers

You have products that appear in table A and sometimes also in table B. What would you use to find products only appearing in table A?

Why would you choose to implement a referential join?

Which project structure object corresponds to a unique HDI container?

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2correct answers to this question.

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you. When you preview calculation view A, what data do you see?

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February. What is the optimal way to do this?

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 2correct answers to this question.

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 3correct answers to this question.

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2correct answers to this question.

Which of the following tasks are necessary to implement data replication?Note: There are 3correct answers to this question.

In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?

You create a user-provided service to access tables in external schemas.

In which file type do you assign the user-provided service to your database module?

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

What options do you have to handle orphan nodes in your hierarchy? Note: There are 2correct answers to this question.

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

You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR?

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?

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?

In a flowgraph, which node do you use to select only the required columns from a data source and to filter specific rows?

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

What are the key steps to implement currency conversion in a calculation view?