SAP C_HAMOD_2404 Practice Test - Questions Answers, Page 2
Question list
List of questions
Related questions
Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.
To push down filters to the lowest level calculation views
To convert the data types of input parameters
To pass variable values to external value help views
To assign variables to one or more attributes
What can you do with shared hierarchies? Note: There are 2 correct answers to this question.
Provide reusable hierarchies for drilldown in a CUBE with star join
Access hierarchies created in external schemas
Provide reusable hierarchies for drilldown in a CUBE without star join
Enable SQL SELECT statements to access hierarchies
Why would you set the 'Ignore multiple outputs for filters' property in a calculation view?
To ensure semantic correctness
To avoid duplicate rows in the output
To force filters to apply at the lowest node
To hide columns that are not required
Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.
In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY PRICE. In which type of node do you define the calculation to display the correct result?
Projection
Union
Aggregation
Join
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.
The hierarchy must be defined as a local hierarchy.
The hierarchy must be a shared hierarchy.
The hierarchy must be a parent-child hierarchy.
The hierarchy must be exposed by a CUBE calculation view with star join.
In a calculation view, what is the purpose of a variable?
To provide a dynamic value in a calculated column
To break up complex SQL into smaller steps
To pass values between procedures and calculation views
To filter an attribute at run-time based on a user input
In a calculated column, which object do you use to process a dynamic value in an expression?
Input Parameter
Variable
Table function
Procedure
You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameters of calculation view B are not proposed as source parameters.
What might be the reason for this?
The names of the input parameters do not match.
You selected the wrong parameter mapping TYPE.
Your source calculation view is of type DIMENSION.
You already mapped the input parameters in another calculation view.
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?
''
<empty string>
'2'
'Null'
What is a restricted measure?
A measure that can only be displayed by those with necessary privileges
A measure that is filtered by one or more attribute values
A measure that can be consumed by a CUBE and not a DIMENSION
A measure that cannot be referenced by a calculated column
Question