SAP Certified Associate - Data Engineer - SAP HANA
Last exam update: Nov 18 ,2025
Page 1 out of 6. Viewing questions 1-15 out of 80
Question 1
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.
Answer:
C D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 2
What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.
A.
Assign them to a parent determined by an expression.
B.
Assign them to a leaf level node.
C.
Assign them to an existing node at the root level.
D.
Define them as additional root nodes.
Answer:
C D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 3
Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.
A.
To push down filters to the lowest level calculation views
B.
To convert the data types of input parameters
C.
To pass variable values to external value help views
D.
To assign variables to one or more attributes
Answer:
A C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 4
What can you do with shared hierarchies? Note: There are 2 correct answers to this question.
A.
Provide reusable hierarchies for drilldown in a CUBE with star join
B.
Access hierarchies created in external schemas
C.
Provide reusable hierarchies for drilldown in a CUBE without star join
D.
Enable SQL SELECT statements to access hierarchies
Answer:
A D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 5
Why would you set the "Ignore multiple outputs for filters" property in a calculation view?
A.
To ensure semantic correctness
B.
To avoid duplicate rows in the output
C.
To force filters to apply at the lowest node
D.
To hide columns that are not required
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 6
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?
A.
Projection
B.
Union
C.
Aggregation
D.
Join
Answer:
A
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 7
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.
A.
The hierarchy must be defined as a local hierarchy.
B.
The hierarchy must be a shared hierarchy.
C.
The hierarchy must be a parent-child hierarchy.
D.
The hierarchy must be exposed by a CUBE calculation view with star join.
Answer:
B D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 8
In a calculation view, what is the purpose of a variable?
A.
To provide a dynamic value in a calculated column
B.
To break up complex SQL into smaller steps
C.
To pass values between procedures and calculation views
D.
To filter an attribute at run-time based on a user input
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 9
In a calculated column, which object do you use to process a dynamic value in an expression?
A.
Input Parameter
B.
Variable
C.
Table function
D.
Procedure
Answer:
A
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 10
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?
A.
The names of the input parameters do not match.
B.
You selected the wrong parameter mapping TYPE.
C.
Your source calculation view is of type DIMENSION.
D.
You already mapped the input parameters in another calculation view.
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 11
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"
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 12
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
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 13
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.
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 14
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.
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 15
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?