SAP c-hamod-2404 practice test

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. "ס"
• B. <empty string>
• C. "2"
• D. "Null"

What is a restricted measure?

• A. A measure that can only be displayed by those with necessary privileges
• B. A measure that is filtered by one or more attribute values
• C. A measure that can be consumed by a CUBE and not a DIMENSION
• D. A measure that cannot be referenced by a calculated column

Using the table in the diagram, you need to create a cube calculation view. What is the simplest
approach to create the output from the screenshot?

• A. Create a filter expression that uses an OR operator.
• B. Create 3 calculated columns.
• C. Implement a union node and map each year as a separate column.
• D. Create a restricted column for each year.

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.

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. 6
• B. 9
• C. 2
• D. 5

Why might you use the Keep Flag property in an aggregation node?

• A. To exclude columns that are NOT requested by a query to avoid incorrect results
• B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• C. To include columns that are NOT requested by a query but are essential for the correct result
• D. To retain the correct aggregation behavior in stacked views

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?

• A. Use an aggregation node.
• B. Use a union node.
• C. Use an intersect node.
• D. Use a minus node.

Which type of join supports a temporal condition in a calculation view?

• A. Text join
• B. Referential join
• C. Inner join
• D. Left outer join

What is generated when you build/deploy a CUBE calculation view design-time file? Note: There are
2 correct answers to this question.

• A. Metadata to enable consumption by external tools
• B. A column view in a container
• C. An SQL execution plan
• D. Cached results to improve read performance

What are the limitations of using a full outer join in a star join node? Note: There are 2 correct
answers to this question.

• A. It CANNOT be mixed in the same star join node with other join types.
• B. Only one column can be included in the join condition.
• C. It must appear in the last DIMENSION in the star join node.
• D. It is restricted to one DIMENSION in a star join node.