SAP HANA 2 UPDATED ACTUAL Exam
Questions and CORRECT 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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
ECCB
ACCD - CORRECT ANSWER - 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 - CORRECT
ANSWER - 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 - CORRECT
ANSWER - 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 - CORRECT ANSWER - Choose declarative
language instead of imperative language
Break up large statements by using variables
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 - CORRECT ANSWER -
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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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?
To manage versions of source files
To display dependencies in stacked scenarios
To automate the build process
To enable collaboration between developers - CORRECT ANSWER - To manage versions
of source files
To enable collaboration between developers
Questions and CORRECT 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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
ECCB
ACCD - CORRECT ANSWER - 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 - CORRECT
ANSWER - 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 - CORRECT
ANSWER - 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 - CORRECT ANSWER - Choose declarative
language instead of imperative language
Break up large statements by using variables
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 - CORRECT ANSWER -
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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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?
To manage versions of source files
To display dependencies in stacked scenarios
To automate the build process
To enable collaboration between developers - CORRECT ANSWER - To manage versions
of source files
To enable collaboration between developers
