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

You are creating a procedure to be consumed in a DYNAMIC analytic privilege. What must you consider? Note: There are 2 correct answers to this question.

A. The procedure should have the value DEFINER for the security mode

B. The procedure should include an input parameter to specify the user ID

C. The procedure should return a table with the list of allowed values

D. The procedure should be defined as read-only

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

A. Projection

B. Aggregate

C. Case

D. Pivot

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?

A. hdiconfig

B. .mtar

C. .namespace

D. .yaml

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

A. Assign semantic type.
•Choose client, source and target currencies.
•Choose conversion date and rate type.
•Define an expression in a calculated column.

B. Enable the measure for conversion.
•Choose client, source and target currencies.
•Choose conversion date and rate type.
•Assign the conversion rule to your calculation view.

C. Assign semantic type.
•Enable the measure for conversion.
•Choose client, source and target currencies.
•Choose conversion date and rate type.

D. Enable the measure for conversion.
•Choose client, source, and target currencies.
•Choose conversion date and rate type.
•Build the conversion rule.

You have imported a new calculation view into a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to build the calculation view, the build fails with a namespace-related issue.What could be the reason?
Note: There are 2 correct answers to this question.

A. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

B. The imported calculation view and its data source have different namespaces.

C. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

D. An .hdinamespace file is defined in the src folder that specifies a different namespace property than the one in the identifier of the calculation view.

How can you define a variable that presents its value help hierarchically? Note: There are 2 correct answers to this question.

A. Create a level hierarchy and assign it to the variable.
•Ensure the variable's reference column is the top level of the hierarchy.

B. Create a parent-child hierarchy and assign it to the variable.
•Ensure the variable's reference column is the parent attribute of the hierarchy.

C. Create a parent-child hierarchy and assign it to the variable.
•Ensure the variable's reference column is the child attribute of the hierarchy.

D. Create a level hierarchy and assign it to the variable.
•Ensure the variable's reference column is the leaf level of the hierarchy.

What privileges do you need to create a virtual table referencing a remote SAP HANA table? Note: There are 2 correct answers to this question.

A. SELECT on the source object

B. CREATE VIRTUAL TABLE on the remote source

C. CREATE ANY on the target schema

D. ALTER on the remote source