SAP HANA 2 EXAM 2025 QUESTIONS
AND ANSWERS
When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access
to tables in the external schema?
Virtual Table
Association
Alias
Synonym - ANS Synonym
In a calculation view, what is the purpose of a variable?
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
To provide a dynamic value in a calculated column - ANS To filter an attribute at run-time
based on a user input
What are the key steps to implement currency conversion in a calculation view
ECCA
AECC
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 1
,ECCB
ACCD - ANS AECC
You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of
the following conditions must be met? (2)
The hierarchy must me a local hierarchy
The hierarchy must me a shared hierarchy
The hierarchy must be exposed by a calculation view of type CUBE with star join
The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY - ANS The
hierarchy must be exposed by a calculation view of type CUBE with star join.
The hierarchy must be a shared hierarchy.
In an XS Advanced project, what is the purpose of the .hdiconfig file?
To specify which HDIplug-ins are available
To specify the namespace rules applicable to the name of database objects
To specify an external schema in which calculation views will get their data - ANS To specify
the version of the HDI plug-ins
What are some of the best practices for writing SQLScript for use with calculation views? (2)
Create the flow logic using IF-THEN-ELSE conditions
Choose declarative language instead of imperative language
Use dynamic SQL
Break up large statements by using variables - ANS Choose declarative language instead of
imperative language
Break up large statements by using variables
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 2
, You are managing your source files using Git. In which sequence does your file progress
towards COMMIT?
Staging area -> working directory -> Local Git Repository
Working directory -> Local Git repository -> Staging area
Working directory -> staging area -> Local Git repository
Local Git repository -> staging area -> working directory - ANS Working directory -> staging
area -> Local Git repository
You want to map an input parameter of calculation view A to an input parameter of calculation
view B. Input parameters for calculation view B are not proposed as source Parameters.
You already mapped the input parameters in another calculation view
You selected the wrong parameter mapping TYPE
The names of the input parameters do not match
Your source calculation view is of type DIMENSION - ANS You already mapped the input
parameters in another calculation view
What can you do with shared hierarchies? (2)
Provide reusable hierarchies for drilldown in a CUBE without star join
Access hierarchies created in external schemas
Provide reusable hierarchies for drilldown in a CUBE with star join
Enable SQL SELECT statements to access hierarchies - ANS Enable SQL SELECT statements to
access hierarchies
Provide reusable hierarchies for drilldown in a CUBE without star join
Why do you use Git when modeling calculation views?
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 3
AND ANSWERS
When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access
to tables in the external schema?
Virtual Table
Association
Alias
Synonym - ANS Synonym
In a calculation view, what is the purpose of a variable?
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
To provide a dynamic value in a calculated column - ANS To filter an attribute at run-time
based on a user input
What are the key steps to implement currency conversion in a calculation view
ECCA
AECC
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 1
,ECCB
ACCD - ANS AECC
You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of
the following conditions must be met? (2)
The hierarchy must me a local hierarchy
The hierarchy must me a shared hierarchy
The hierarchy must be exposed by a calculation view of type CUBE with star join
The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY - ANS The
hierarchy must be exposed by a calculation view of type CUBE with star join.
The hierarchy must be a shared hierarchy.
In an XS Advanced project, what is the purpose of the .hdiconfig file?
To specify which HDIplug-ins are available
To specify the namespace rules applicable to the name of database objects
To specify an external schema in which calculation views will get their data - ANS To specify
the version of the HDI plug-ins
What are some of the best practices for writing SQLScript for use with calculation views? (2)
Create the flow logic using IF-THEN-ELSE conditions
Choose declarative language instead of imperative language
Use dynamic SQL
Break up large statements by using variables - ANS Choose declarative language instead of
imperative language
Break up large statements by using variables
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 2
, You are managing your source files using Git. In which sequence does your file progress
towards COMMIT?
Staging area -> working directory -> Local Git Repository
Working directory -> Local Git repository -> Staging area
Working directory -> staging area -> Local Git repository
Local Git repository -> staging area -> working directory - ANS Working directory -> staging
area -> Local Git repository
You want to map an input parameter of calculation view A to an input parameter of calculation
view B. Input parameters for calculation view B are not proposed as source Parameters.
You already mapped the input parameters in another calculation view
You selected the wrong parameter mapping TYPE
The names of the input parameters do not match
Your source calculation view is of type DIMENSION - ANS You already mapped the input
parameters in another calculation view
What can you do with shared hierarchies? (2)
Provide reusable hierarchies for drilldown in a CUBE without star join
Access hierarchies created in external schemas
Provide reusable hierarchies for drilldown in a CUBE with star join
Enable SQL SELECT statements to access hierarchies - ANS Enable SQL SELECT statements to
access hierarchies
Provide reusable hierarchies for drilldown in a CUBE without star join
Why do you use Git when modeling calculation views?
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 3
