SAP HANA UPDATED Exam Questions
and CORRECT Answers
Why would you implement SAP HANA spatial services? (2)
To forecast movements of elements
To map all possible relationships in a network of elements
To calculate distances between elements
To identify unions and intersections of elements - CORRECT ANSWER - - To calculate
distances between elements
- To identify unions and intersections of elements
Why would you implement active I active read-enabled mode?
To synchronize query results with operational data
To improve query performance
To provide offline access to data
To enhance security for data access - CORRECT ANSWER - To synchronize query
results with operational data
You create a full-text index. For what text feature clause do you need to specify a configuration?
TEXT MINING
SEARCH ONLY
FUZZY SEARCH INDEX
TEXT ANALYSIS - CORRECT ANSWER - Text Analysis
,You deleted the design-time file of a calculation view in your HDB module. Which of the
following is the optimal way to ensure that the corresponding runtime object is also removed
from the database? (2)
Execute a DROP statement in an SQL console connected to the HDI container.
Execute the refactor function for the calculation view.
Build the folder that contained the deleted design-time file.
Build the project that contained the deleted design-time file. - CORRECT ANSWER --
Build the folder that contained the deleted design-time file.
- Build the project that contained the deleted design-time file.
What spatial data type would you use to store multiple shop locations?
ST_MultiPoint
ST_Point
ST_MultiLineString
ST_Polygon - CORRECT ANSWER - ST_MultiPoint
What must you create to access a Predictive Analysis Library (PAL) procedure from inside your
HDI container?
Function
Database Connection
Wrapper
Synonym - CORRECT ANSWER - Function
Which deployment scenarios feature security staying in the application server and end users not
logging in to the SAP HANA system? (2)
SAP HANA as a side-by-side accelerator
,SAP HANA as a platform with an SAP HANA XS application
SAP HANA as a reporting server
SAP HANA as a database - CORRECT ANSWER - SAP HANA as a reporting server
SAP HANA as a database
Which of the following SAP data provisioning tools can provide real-time data provisioning? (3)
SAP Data Services
SDQ
SAP Landscape Transformation Replication Server
SAP Replication Server
SDI - CORRECT ANSWER - - SAP Landscape Transformation Replication Server
- SAP Replication Server
- SDI
Which of the following are capabilities of SAP HANA smart data access? (2)
Exposure of real-time data from remote tables
Push-down of queries to remote data sources
Cleansing and harmonization of data from disparate sources
Replication of remote data - CORRECT ANSWER - Exposure of real-time data from
remote tables
Push-down of queries to remote data sources
What can be used to return multiple result sets?
Procedure
Scalar function
, View
Table function - CORRECT ANSWER - Procedure
What conditions must be met before you can implement time dependency on a hierarchy in a
calculation view? (2)
The hierarchy must be a parent-child hierarchy.
The key date parameter must be derived from an input parameter
The hierarchy must be enabled for SQL access
The hierarchy must be a level hierarchy. - CORRECT ANSWER - The hierarchy must be
a parent-child hierarchy.
The key date parameter must be derived from an input parameter
Why might you want to reference a user-provided service in a project?
To access data from another container
To access data from your project container
To access data from a classic database schema - CORRECT ANSWER - To access data
from a classic database schema
What are properties of domain fix values? (2)
They are based on SQLScript functions.
They are based on the ABAP Data Dictionary.
They ask end users for input at runtime.
They are static values. - CORRECT ANSWER - They are based on the ABAP Data
Dictionary.
They are static values.
and CORRECT Answers
Why would you implement SAP HANA spatial services? (2)
To forecast movements of elements
To map all possible relationships in a network of elements
To calculate distances between elements
To identify unions and intersections of elements - CORRECT ANSWER - - To calculate
distances between elements
- To identify unions and intersections of elements
Why would you implement active I active read-enabled mode?
To synchronize query results with operational data
To improve query performance
To provide offline access to data
To enhance security for data access - CORRECT ANSWER - To synchronize query
results with operational data
You create a full-text index. For what text feature clause do you need to specify a configuration?
TEXT MINING
SEARCH ONLY
FUZZY SEARCH INDEX
TEXT ANALYSIS - CORRECT ANSWER - Text Analysis
,You deleted the design-time file of a calculation view in your HDB module. Which of the
following is the optimal way to ensure that the corresponding runtime object is also removed
from the database? (2)
Execute a DROP statement in an SQL console connected to the HDI container.
Execute the refactor function for the calculation view.
Build the folder that contained the deleted design-time file.
Build the project that contained the deleted design-time file. - CORRECT ANSWER --
Build the folder that contained the deleted design-time file.
- Build the project that contained the deleted design-time file.
What spatial data type would you use to store multiple shop locations?
ST_MultiPoint
ST_Point
ST_MultiLineString
ST_Polygon - CORRECT ANSWER - ST_MultiPoint
What must you create to access a Predictive Analysis Library (PAL) procedure from inside your
HDI container?
Function
Database Connection
Wrapper
Synonym - CORRECT ANSWER - Function
Which deployment scenarios feature security staying in the application server and end users not
logging in to the SAP HANA system? (2)
SAP HANA as a side-by-side accelerator
,SAP HANA as a platform with an SAP HANA XS application
SAP HANA as a reporting server
SAP HANA as a database - CORRECT ANSWER - SAP HANA as a reporting server
SAP HANA as a database
Which of the following SAP data provisioning tools can provide real-time data provisioning? (3)
SAP Data Services
SDQ
SAP Landscape Transformation Replication Server
SAP Replication Server
SDI - CORRECT ANSWER - - SAP Landscape Transformation Replication Server
- SAP Replication Server
- SDI
Which of the following are capabilities of SAP HANA smart data access? (2)
Exposure of real-time data from remote tables
Push-down of queries to remote data sources
Cleansing and harmonization of data from disparate sources
Replication of remote data - CORRECT ANSWER - Exposure of real-time data from
remote tables
Push-down of queries to remote data sources
What can be used to return multiple result sets?
Procedure
Scalar function
, View
Table function - CORRECT ANSWER - Procedure
What conditions must be met before you can implement time dependency on a hierarchy in a
calculation view? (2)
The hierarchy must be a parent-child hierarchy.
The key date parameter must be derived from an input parameter
The hierarchy must be enabled for SQL access
The hierarchy must be a level hierarchy. - CORRECT ANSWER - The hierarchy must be
a parent-child hierarchy.
The key date parameter must be derived from an input parameter
Why might you want to reference a user-provided service in a project?
To access data from another container
To access data from your project container
To access data from a classic database schema - CORRECT ANSWER - To access data
from a classic database schema
What are properties of domain fix values? (2)
They are based on SQLScript functions.
They are based on the ABAP Data Dictionary.
They ask end users for input at runtime.
They are static values. - CORRECT ANSWER - They are based on the ABAP Data
Dictionary.
They are static values.
