HANA300

Question 1

Which SAP tool can you use to include geospatial and predictive processing as part of the data
transformation process?
Please choose the correct answer.
Response:

A. SAP Data Services
B. SDI
C. SDQ
D. SDA

Answer 1

C. SDQ

Question 2

What can be used to return multiple result sets?
Please choose the correct answer.
Response:

A. Table function
B. Scalar function
C. Procedure
D. View

Answer 2

C. Procedure

Question 3

Where is SDI used?
There are 2 correct answers to this question.
Response:

A. Data cleansing
B. Data streaming
C. Data transformation
D. For data loading

Answer 3

C. Data transformation
D. For data loading

Question 4

Where can you create a filter expression?
Please choose the correct answer.
Response:

A. In a Data Foundation node
B. In the Semantics node
C. In an Aggregation node
D. In a Projection node

Answer 4

D. In a Projection node

Question 5

You have a list of map locations for clinics. The government wants to build a new clinic where there is
the greatest need. You need to find the largest distance between any two clinics.
With your current knowledge, how do you do this?
Please choose the correct answer.
Response:

A. Use a spatial join to find the distance between clinics.
Use an aggregation with the maximum option.

B. Use a dynamic join to find the longest distance between clinics.
Use a ranking to find the top 10 values.

C. Use a spatial join to find the distance between clinics.
Use a level hierarchy for drilldown.

D. Use a temporal join to find the distance between clinics.
Use a union with constant values to “pivot” the values.

Answer 5

A. Use a spatial join to find the distance between clinics.
Use an aggregation with the maximum option.

Question 6

Which join types are available in a Join node of a calculation view?
There are 2 correct answers to this question.
Response:

A. Spatial joins
B. Referential joins
C. Cross joins
D. Temporal joins

Answer 6

A. Spatial joins
B. Referential joins

Question 7

Which of the following are components of SAP HANA Data Warehousing Foundation?
Note: There are 2 correct answers to this question
Response:

A. SAP Data Hub
B. Native DataStore Object
C. Composite Provider
D. Data Lifecycle Manager

Answer 7

B. Native DataStore Object
D. Data Lifecycle Manager

Question 8

Which deployment scenarios feature security staying in the application server and end users not logging in to the SAP HANA system?
There are 2 correct answers to this question.
Response:

A. SAP HANA as a platform with an SAP HANA XS application
B. SAP HANA as a reporting server
C. SAP HANA as a side-by-side accelerator
D. SAP HANA as a database

Answer 8

B. SAP HANA as a reporting server
D. SAP HANA as a database

Question 9

Why should you use variables in SQL Script?
There are 2 correct answers to this question.
Response:

A. To support processing push-down
B. To improve code readability
C. To increase parallelization opportunities
D. To implement flow control logic

Answer 9

B. To improve code readability
C. To increase parallelization opportunities

Question 10

Which of the following data provisioning tools can you use to read data directly from Twitter?
There are 3 correct answers to this question.
Response:

A. SAP Data Services
B. SDI
C. SAP HANA XS engine
D. SAP Replication Server
E. SDA

Answer 10

A. SAP Data Services
B. SDI
C. SAP HANA XS engine

Question 11

How could you improve the performance of joins in cube calculation views?
There are 2 correct answers to this question.
Response:

A. Reduce the number of columns used in the join
B. Specify the cardinality of the join
C. Avoid the use of referential joins.
D. Join on calculated columns

Answer 11

A. Reduce the number of columns used in the join
B. Specify the cardinality of the join

Question 12

You have assigned analytic privileges to users as shown in the diagram. What data can be viewed by the
users?
There are 2 correct answers to this question.

Response:

A. User 1 can view Canada for 2018
B. User 2 can view any year for United States
C. User 2 can view United States for 2017
D. User 1 can view any year for United States

Answer 12

B. User 2 can view any year for United States
D. User 1 can view any year for United States

Question 13

In which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system?
There are 2 correct answers to this question.
Response:

A. SAP HANA as a platform
B. SAP S/4HANA
C. SAP BW powered by SAP HANA
D. SAP HANA Live

Answer 13

A. SAP HANA as a platform
D. SAP HANA Live

Question 14

Question: 14

What is needed in an SAP Vora deployment?
There are 2 correct answers to this question.
Response:

A. SAP Data Services
B. SAP HANA data warehousing foundation
C. Apache Hadoop
D. Apache Spark

Answer 14

C. Apache Hadoop
D. Apache Spark

Question 15

You have Model B that is based on Model
A. You have NOT built any of the models yet. You delete Model A. What happens during the build?
There are 2 correct answers to this question.
Response:
A. The build of the entire HDB module is successful
B. You get a build error when you build Model B
C. You get an error when you build the entire HDB module
D. The build of Model B is successful

Answer 15

B. You get a build error when you build Model B
C. You get an error when you build the entire HDB module

Question 16

Why would you implement the SAP HANA Data Warehousing Foundation?
Please choose the correct answer.
Response:

A. To improve the loading and reporting performance of SAP Business Warehouse
B. To implement an SQL-driven approach to data warehousing
C. To add OLAP data warehousing capabilities to SAP HANA
D. To enable reporting on SAP HANA data using the full suite of SAP BusinessObjects

Answer 16

B. To implement an SQL-driven approach to data warehousing

Question 17

What does SAP HANA load when starting up and before indicating that it’s ready?
There are 3 correct answers to this question.
Response:

A. Some row tables
B. All system tables
C. Some column tables
D. All partitions
E. All row tables

Answer 17

B. All system tables
C. Some column tables
E. All row tables

Question 18

You want to see in a Union node which data sources return no results for a query. How do you achieve
this?
Please choose the correct answer.
Response:

A. Create a standard union.
B. Set the is Null property in the Manage Mapping dialog.
C. Set the Empty Union Behavior property.
D. Create a union pruning configuration table.

Answer 18

C. Set the Empty Union Behavior property.

Question 19

You’re writing a mobile application for the World Series. You have details about all the baseball players
and the baseball scores for all the previous games.
How do you use the data of the player information and the scores?
Please choose the correct answer.
Response:

A. Both the player information and the scores are used as transactional data.
B. The player information is used as master data, and the scores are used as transactional data.
C. The player information is used as transactional data, and the scores are used as master data.
D. Both the player information and the scores are used as master data.

Answer 19

B. The player information is used as master data, and the scores are used as transactional data.

Question 20

What statement is allowed in a user-defined function?
Please choose the correct answer.
Response:

A. COMMIT
B. JOIN
C. EXEC
D. INSERT

Answer 20

B. JOIN

Question 21

What is the default node for a calculation view of type cube?
Please choose the correct answer.
Response:

A. Join node
B. Projection node
C. Star join node
D. Aggregation node

Answer 21

D. Aggregation node

Question 22

Which of the following views can you extend with the SAP HANA Live Extension Assistant?
Please choose the correct answer.
Response:

A. Your own custom views
B. Query views with a union
C. Reuse views
D. All SAP-delivered views

Answer 22

C. Reuse views

Question 23

Which type of join supports a temporal conditions in a calculation view?
Please choose the correct answer.
Response:

A. Left outer join
B. Text join
C. Referential join
D. Inner join

Answer 23

D. Inner join

Question 24

Which are the recommended assignments in SAP HANA?
There are 2 correct answers to this question.
Response:

A. Roles to roles
B. Roles to privileges
C. Privileges to users
D. Roles to users

Answer 24

A. Roles to roles
D. Roles to users

Question 25

What are components of SAP HANA EIM?
There are 2 correct answers to this question.
Response:

A. SDA
B. SDI
C. SDS
D. SDQ

Answer 25

B. SDI
D. SDQ

Question 26

Which interface client is used for XSA application development?
Please choose the correct answer.
Response:

A. SAP HANA Studio
B. SAP HANA Web-based Workbench
C. SAP Web IDE for SAP HANA
D. SAP Web IDE

Answer 26

C. SAP Web IDE for SAP HANA

Question 27

Which of the following features analyze dependencies between models?
There are 2 correct answers to this question.

Response:

A. Impact analysis
B. Mapping Analysis
C. Column lineage
D. Data lineage

Answer 27

A. Impact analysis
D. Data lineage

Question 28

What must I create to develop a predictive model?
Please choose the correct answer.
Response:

A. Procedure
B. Calculation View
C. Predictive Analysis Library
D. Flowgraph

Answer 28

D. Flowgraph

Question 29

What are properties of domain fix values?
There are 2 correct answers to this question.
Response:

A. They are based on SQLScript functions.
B. They ask end users for input at runtime.
C. They are based on the ABAP Data Dictionary.
D. They are static values.

Answer 29

C. They are based on the ABAP Data Dictionary.
D. They are static values.

Question 30

For what tasks would you use the Where-Used feature in SAP HANA?
Please choose the correct answer.
Response:

A. To find all places where a developer updated information models
B. To find all places where an information model has been deployed
C. To find all places where an information model is used
D. To find all places where translations exist

Answer 30

C. To find all places where an information model is used

Question 31

What are the components of a graph workspace?
There are 2 correct answers to this question.
Response:

A. Vertex
B. Edge
C. Partition
D. Space

Answer 31

A. Vertex
B. Edge

Question 32

Which business intelligence tool can publish storyboards?
Please choose the correct answer.
Response:

A. SAP Lumira, designer edition
B. SAP BusinessObjects Analysis, edition for Microsoft Office
C. SAP BusinessObjects Web Intelligence
D. SAP Analysis for Microsoft Office

Answer 32

D. SAP Analysis for Microsoft Office

Question 33

Which type of cloud solution is Amazon Web Services (AWS) an example of?
Response:

A. Public cloud
B. Community cloud
C. Private cloud
D. Hybrid cloud

Answer 33

A. Public cloud

Question 34

What does SQL script provide to extend standard SQL?
There are 2 correct answers to this question.
Response:

A. Feature to encourage processing in the database
B. Support for ABAP Syntax
C. Additional data types for the definition of text and spatial data
D. Integrated source code version management

Answer 34

A. Feature to encourage processing in the database
C. Additional data types for the definition of text and spatial data

Question 35

Which business intelligence tool does NOT use BICS connectivity to SAP HANA?
There are 2 correct answers to this question.
Response:

A. SAP Analysis for Microsoft Office
B. SAP Lumira, discovery edition
C. Microsoft Excel
D. SAP Lumira, designer edition

Answer 35

A. SAP Analysis for Microsoft Office
D. SAP Lumira, designer edition

Question 36

The relational model of SAP HANA Live is built using which type of views?
Please choose the correct answer.
Response:

A. Analytic views and attribute views
B. Calculation views of data category cube with star join
C. Scripted calculation views
D. Calculation views of data category cube without star join

Answer 36

D. Calculation views of data category cube without star join

Question 37

Which database arteiact do you use to access external data from an XS Advanced project?
Please choose the correct answer.
Response:

A. Logical schema
B. Calculation view
C. Synonym
D. User-provided service

Answer 37

C. Synonym

Question 38

What are the currency conversion functionalities supported by SAP HANA?
There are 3 correct answers to this question.
Response:

A. Multiple exchange rate types
B. Enabling of decimal shifts
C. Conversion based on customer-defined tables
D. Determination of target currency based on attributes or input parameters

Answer 38

A. Multiple exchange rate types
B. Enabling of decimal shifts
D. Determination of target currency based on attributes or input parameters

Question 39

You want to call a procedure in a SELECT statement (e.g., a table function). Which clauses do you have to
specify?
There are 2 correct answers to this question.
Response:

A. WITH RESULTS VIEW
B. READS SQL DATA
C. LANGUAGE SQLSCRIPT
D. SEQUENTIAL EXECUTION

Answer 39

A. WITH RESULTS VIEW
B. READS SQL DATA

Question 40

In which programming languages can you create procedures in SAP HANA?
There are 2 correct answers to this question.
Response:

A. JavaScript
B. L
C. R
D. SQLScript

Answer 40

C. R
D. SQLScript

Question 41

Which recent technology advances have made SAP HANA possible?
There are 2 correct answers to this question.
Response:

A. Faster disk speeds
B. Multicore processors
C. Faster internet speeds
D. Larger and cheaper memory

Answer 41

B. Multicore processors
D. Larger and cheaper memory

Question 42

What can you use to limit users to see only 2018 data?
There are 2 correct answers to this question.
Response:

A. A view with a restricted column
B. A view with a filter
C. A SQL analytic privilege
D. An object privilege

Answer 42

B. A view with a filter
C. A SQL analytic privilege

Question 43

A referential join gives the same results as which other join type?
Please choose the correct answer.
Response:

A. Left outer join
B. Star join
C. Inner join
D. Spatial join

Answer 43

C. Inner join

Question 44

Which modeling features can you use in flowgraphs?
There are 2 correct answers to this question.
Response:

A. Predictive
B. Spatial
C. Graph
D. Text

Answer 44

A. Predictive
B. Spatial

Question 45

What do we implement to restrict access to specific data rows of a calculation view?
Please choose the correct answer.
Response:

A. SQL permission
B. HANA Database Procedure
C. Authorisation object
D. Analytic privilege

Answer 45

D. Analytic privilege

Question 46

In which type of node can you create calculated columns?
There are 2 correct answers to this question.

Response:

A. Rank node
B. Graph node
C. Projection node
D. Union node

Answer 46

C. Projection node
D. Union node

Question 47

From where does the Extract Semantics feature get the definition of hierar- chies?
Please choose the correct answer.
Response:

A. From the table data sources
B. From the SQL view data sources
C. From the underlying dimension views
D. From the current calculation view

Answer 47

C. From the underlying dimension views

Question 48

In which parts of a SELECT statement can you include the ST_Within spatial predicate?
Note: There are 2 correct answers to this question.
Response:

A. HAVING clause
B. WHERE clause
C. GROUP BY clause
D. JOIN condition

Answer 48

B. WHERE clause
D. JOIN condition

Question 49

Which are features of a calculated column?
There are 2 correct answers to this question.
Response:

A. Its calculations are persisted.
B. It’s a column in the result set.
C. It’s created in the Semantics node.
D. It’s created in the output area.

Answer 49

B. It’s a column in the result set.
D. It’s created in the output area.

Question 50

Which sentence best describes SAP HANA Live?
Please choose the correct answer.
Response:

A. Operational reporting moving back to the OLTP system
B. Operational reporting moving back to the OLAP system
C. Analytical reporting moving back to the OLTP system
D. Analytical reporting moving back to the OLAP system

Answer 50

A. Operational reporting moving back to the OLTP system

Question 51

You’re working with a currency measure. What is decimal shift used for?
Please choose the correct answer.
Response:

A. To avoid rounding errors during the conversion
B. For currencies with more than two decimal places
C. To undo the decimal adjustment for ABAP
D. To increase the accuracy of the currency conversion

Answer 51

B. For currencies with more than two decimal places

Question 52

You want to publish your business intelligence content directly to SAP Analytics Cloud. Which tool do
you use?
Please choose the correct answer.
Response:

A. SAP Crystal Reports for Enterprise
B. SAP Analysis for Microsoft Office
C. SAP Lumira, discovery edition

Answer 52

C. SAP Lumira, discovery edition

Question 53

What is XS?
Please choose the correct answer.
Response:

A. A native, lightweight application server
B. A user interface
C. A data cleansing engine
D. An optional engine to handle excessive data loads

Answer 53

A. A native, lightweight application server

Question 54

What data source is available for Join nodes in calculation views?
Please choose the correct answer.
Response:

A. Web services from the Internet
B. Calculation views from other tenants in an MDC system
C. Scalar functions from all SAP HANA systems
D. All procedures in the current SAP HANA system

Answer 54

B. Calculation views from other tenants in an MDC system

Question 55

Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 2 correct answers to this question.
Response:

A. Disaster recovery
B. High availability
C. Failover
D. Backups

Answer 55

B. High availability
C. Failover

Question 56

When modeling a decision tree, what are the stages of the learning phase?
There are 3 correct answers to this question.
Response:

A. Testing
B. Rejection
C. Training
D. Correcting
E. Validation

Answer 56

A. Testing
D. Correcting
E. Validation

Question 57

Refactoring is used with which of the following actions?
Please choose the correct answer.
Response:

A. Documenting
B. Improving your modeling design
C. Translating
D. Deployment

Answer 57

B. Improving your modeling design

Question 58

Which business intelligence tool queries SAP HANA using MDX?
Please choose the correct answer.
Response:

A. SAP Analysis for Microsoft Office
B. SAP BusinessObjects Web Intelligence
C. Microsoft Excel
D. SAP Lumira, discovery edition

Answer 58

C. Microsoft Excel

Question 59

You want to join 2 tables in a calculation view. When would you use non-equi join?
Please choose the correct answer.
Response:

A. The cardinality is 1: N
B. The join is part of star join.
C. The cardinality is impossible to determine.
D. The join requires a <(less than) operator.

Answer 59

D. The join requires a <(less than) operator.

Question 60

Why should HANA consultants develop SQL skills?
There are 2 correct answers to this question.
Response:

A. So they can develop sophisticated data flows that extend beyond graphical modeling tools.
B. So User authentication and authorization can be secures through the HANA platform.
C. Because scripted calculation views are recommended.
D. So they can perform basic database operations such as creating, filling and reading tables.

Answer 60

A. So they can develop sophisticated data flows that extend beyond graphical modeling tools.
D. So they can perform basic database operations such as creating, filling and reading tables.

Question 61

What can you extract using the standard text analysis configuration: Voice of the Customer?
There are 2 correct answers to this question.
Response:

A. Suggestions
B. Sentiments
C. Recommendations
D. Requests

Answer 61

B. Sentiments
D. Requests

Question 62

You rename a field in the Semantics node to add clarity for end users. What does SAP HANA use to keep
track of what the original field name is?
Please choose the correct answer.
Response:

A. The label column property
B. The mapping property
C. The name property
D. The label property

Answer 62

B. The mapping property

Question 63

What is a multistore table?
Please choose the correct answer.
Response:

A. A table that can be shared across multiple instances of HANA
B. A table that can distribute its partitions across memory and extended storage tiers
C. A table that can hold data in row and column orientation
D. A table that can be shared across multiple instances of SAP HANA Cockpit

Answer 63

B. A table that can distribute its partitions across memory and extended storage tiers

Question 64

Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?
Please choose the correct answer.
Response:

A. They are deprecated
B. They can harm SQL optimization
C. They introduce security risks due to SQL injection
D. NOT all reporting tools can consume the results.

Answer 64

C. They introduce security risks due to SQL injection

Question 65

When we refer to mixed modeling, what do we mean?

Please choose the correct answer.
Response:

A. Classic BW models combined with SAP HANA optimized BW models
B. BW models combined with native SAP HANA models
C. Models from BW on anyDB combined with models from BW on HANA
D. NetWeaver models combined with native SAP HANA models

Answer 65

B. BW models combined with native SAP HANA models

Question 66

What type of load does SAP HANA perform when starting up?
Please choose the correct answer.
Response:

A. Lazy load
B. Complete load
C. Fast load
D. Log load

Answer 66

A. Lazy load

Question 67

What is the SAP HANA Application Function Library (AFL)?
There are 2 correct answers to this question.
Response:

A. Repository of ready-made business functions
B. Repository of ready-to-run applications that are powered by SAP HANA
C. Repository of ready-made predictive algorithms
D. Repository of connections that can be used by business functions

Answer 67

A. Repository of ready-made business functions
C. Repository of ready-made predictive algorithms

Question 68

How can you optimize performance when writing SQL for use with calculation views?
There are 2 correct answers to this question.
Response:

A. Increase paralization by using variables to break up statements
B. Control the flow logic using IF-THEN-ELSE conditions
C. Use calculation engine (CE) functions instead of plain SQL
D. Use declarative language instead of cursors

Answer 68

A. Increase paralization by using variables to break up statements
D. Use declarative language instead of cursors

Question 69

Which of the following SAP data provisioning tools can provide real-time data provisioning?
There are 3 correct answers to this question.
Response:

A. SDI
B. SDQ
C. SAP Replication Server
D. SAP Data Services
E. SAP Landscape Transformation Replication Server

Answer 69

A. SDI
C. SAP Replication Server
E. SAP Landscape Transformation Replication Server

Question 70

Why do you create a time dimension calculation view?
Please choose the correct answer.
Response:

A. To support temporal joins in a cube calculation view with star schema
B. To enhance a calculation view with a drilldown on a time hierarchy
C. To enable time dependency on parent-child hierarchies
D. To provide date-based help values for a DIRECT type input parameter

Answer 70

B. To enhance a calculation view with a drilldown on a time hierarchy

Question 71

When creating a system connection in SAP HANA Studio, which of these is essential information?
There are 3 correct answers to this question.
Response:

A. URL
B. A valid user and password
C. Host
D. Instance

Answer 71

B. A valid user and password
C. Host
D. Instance

Question 72

What can you use SAP HANA smart data access for?
There are 2 correct answers to this question.
Response:

A. To replicate remote data sources
B. To load harmonize data from disparate sources
C. To push down queries to data sources
D. To expose data from remote tables

Answer 72

C. To push down queries to data sources
D. To expose data from remote tables

Question 73

In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of
the dimensions use full outer joins and one dimension uses a left outer join you did not set cardinality of
the data sources.
Why will this NOT work?
Please choose the correct answer.
Response:

A. Full outer joins are NOT available in the star join node.
B. Full outer joins CANNOT be mixed on the same star join node with other join types.
C. Full outer joins require to be set
D. Full outer joins restricted to one dimension in a star join node

Answer 73

D. Full outer joins restricted to one dimension in a star join node

Question 74

When do you use the hidden attribute in a dimension calculation view?
Please choose the correct answer.
Response:

A. When you want to hide an attribute that is not required for client consumption.
B. When you want to include an attribute that is not required for cube consumption.
C. When you want to hide the attribute in your cube calculation view.
D. When you need to include the attribute in your calculation view to define a join.

Answer 74

A. When you want to hide an attribute that is not required for client consumption.

Question 75

Which of the following techniques can you use to improve the performance of calculation views?
There are 2 correct answers to this question.
Response:

A. Minimize layering of calculation views
B. Implement union pruning
C. Partition large tables
D. Avoid aggregating data early in the data flow

Answer 75

A. Minimize layering of calculation views
B. Implement union pruning

Question 76

You want to retrieve data from a web application. Which of the following could you use?
There are 3 correct answers to this question.
Response:

A. JSON
B. BICS
C. OData
D. JDBC
E. REST

Answer 76

A. JSON
C. OData
E. REST

Question 77

Of which SAP HANA process are the transaction manager and page manager a part?
Please choose the correct answer.
Response:

A. Name server
B. Index server
C. Application server
D. Statistics server

Answer 77

B. Index server

Question 78

Which of the following would you create to build a predictive model?
Please choose the correct answer.
Response:

A. A procedure
B. A function
C. A decision tree
D. A flowgraph

Answer 78

D. A flowgraph

Question 79

What performance techniques should you implement to improve the performance of SAP HANA
information views?
There are 3 correct answers to this question.
Response:

A. Investigate partitioning of large tables.
B. Push down aggregations to SAP HANA.
C. Minimize the transfer of data between the execution engines.
D. Perform calculation before aggregation in your analytic views.
E. Apply filters as late as possible.

Answer 79

A. Investigate partitioning of large tables.
B. Push down aggregations to SAP HANA.
C. Minimize the transfer of data between the execution engines.

Question 80

Which scenario is supported to base an analytic privilege on a hierarchy defined on an attribute column?
Please choose the correct answer.
Response:

A. Create a classical analytic privilege based on a parent-child hierarchy
B. Create an SQL analytic privilege based on a parent-child hierarchy
C. Create an SQL analytic privilege based on a level hierarchy
D. Create a classical analytic privilege based on a level hierarchy

Answer 80

B. Create an SQL analytic privilege based on a parent-child hierarchy

Question 81

Where is SAP HANA Live installed?
Please choose the correct answer.
Response:

A. In the SAP HANA database
B. On SAP Landscape Transformation Replication Server
C. On the SAP ERP application server
D. In the reporting tool

Answer 81

A. In the SAP HANA database

Question 82

The relational model of SAP HANA Live is built using which type of views?
Please choose the correct answer.
Response:

A. Calculation views of data category cube without star join
B. Scripted calculation views
C. Analytic views and attribute views
D. Calculation views of data category cube with star join

Answer 82

A. Calculation views of data category cube without star join

Question 83

Why do you assign semantic types to measures or attributes in calculation views?
Please choose the correct answer.
Response:

A. To ensure consistency across calculation views
B. To provide meaningful value help when using variables
C. To allow client applications to present data in appropriate formats
D. To enable the activation of the calculation view

Answer 83

C. To allow client applications to present data in appropriate formats

Question 84

What predicate do you use for fuzzy text search in the WHERE clause of a SQL statement?
Please choose the correct answer.
Response:

A. CONTAINS
B. IN
C. ANY
D. LIKE

Answer 84

A. CONTAINS

Question 85

How can you optimize performance when writing SQL for use with calculation views?
There are 2 correct answers to this question.
Response:

A. Use declarative language instead of cursors
B. Control the flow logic using IF-THEN-ELSE conditions
C. Use calculation engine (CE) functions instead of plain SQL
D. Increase paralization by using variables to break up statements

Answer 85

A. Use declarative language instead of cursors
D. Increase paralization by using variables to break up statements

Question 86

You want to use a field in a formula but don’t want to expose the values of the original field to the end
users. What do you do?
Please choose the correct answer.
Response:

A. Change the data type of the field.
B. Make the field a key column.
C. Mark the field as hidden.
D. Rename the field.

Answer 86

C. Mark the field as hidden.

Question 87

Which of the following database terms are used when providing OLAP data with hierarchies?
There are 3 correct answers to this question.
Response:

A. JDBC
B. MDX
C. ODBO
D. BICS
E. ODBC

Answer 87

B. MDX
C. ODBO
D. BICS

Question 88

In SAP BW/4HANA, what do you use instead of an InfoCube?
Please choose the correct answer.
Response:

A. Open ODS View
B. Advanced DataStore Object
C. InfoObject
D. CompositeProvider

Answer 88

B. Advanced DataStore Object

Question 89

What can you extract using the standard text analysis configuration: Voice of the Customer?
There are 2 correct answers to this question.
Response:

A. Suggestions
B. Sentiments
C. Recommendations
D. Requests

Answer 89

B. Sentiments
D. Requests

Question 90

Which of these does SAP HANA use to connect to BI tools?
There are 3 correct answers to this question.
Response:

A. ODBO
B. JDBC
C. IDOC
D. ODBC

Answer 90

A. ODBO
B. JDBC
D. ODBC

Question 91

Which business intelligence tool queries SAP HANA using MDX?
Please choose the correct answer.
Response:

A. SAP Lumira, discovery edition
B. Microsoft Excel
C. SAP Analysis for Microsoft Office
D. SAP BusinessObjects Web Intelligence

Answer 91

B. Microsoft Excel

Question 92

What data source is available for Join nodes in calculation views?
Please choose the correct answer.
Response:

A. Web services from the Internet
B. Calculation views from other tenants in an MDC system
C. Scalar functions from all SAP HANA systems
D. All procedures in the current SAP HANA system

Answer 92

B. Calculation views from other tenants in an MDC system

Question 93

BI tools connect to the SAP HANA database using which of these?
There are 4 correct answers to this question.
Response:

A. ODBO
B. JDBC
C. TRFC
D. ODBC
E. BICS

Answer 93

A. ODBO
B. JDBC
D. ODBC
E. BICS

Question 94

Before deploying your calculation views to a PROD environment, which sequence of steps is required?
Please choose the correct answer.
Response:

A. Activate the project -> Build the HDB module
B. Build the project -> Build th HDB module
C. Build the HDB module -> Build the project
D. Export the HDB module -> Export the project

Answer 94

B. Build the project -> Build th HDB module

Question 95

You use parallelism to calculate a year-to-date value quickly, and you elimi- nate a table from the
database. What are some of the implications of this action?
There are 3 correct answers to this question.
Response:

A. Faster inserts into the database
B. Less code
C. Better user interfaces
D. Faster response times
E. Smaller database backups

Answer 95

B. Less code
D. Faster response times
E. Smaller database backups

Question 96

Which join type makes use of date ranges?
Please choose the correct answer.
Response:

A. Inner join
B. Text join
C. Temporal join
D. Spatial join

Answer 96

C. Temporal join

Question 97

Which of the following node types can you use to build a dimension view?
There are 3 correct answers to this question.
Response:

A. Data foundation node
B. Semantics node
C. Star join node
D. Union node
E. Aggregation node

Answer 97

B. Semantics node
D. Union node
E. Aggregation node

Question 98

What type of input parameters do you use to choose the data from a field in the current table?
Please choose the correct answer.
Response:

A. Derived from table
B. Direct
C. Column
D. Value help

Answer 98

C. Column

Question 99

What variable type do you use if you want to allow the user to choose the years from 2011 to 2014?

Please choose the correct answer.
Response:

A. Single value
B. Range
C. Multiple entries
D. Interval

Answer 99

D. Interval

Question 100

In a text-type fuzzy search I enter ‘SAP’ as the search word. Against term ‘SAPPHIRE’ will I get a high or
low score?
Please choose the correct answer.
Response:

A. Medium
B. Normal
C. Low
D. High

Answer 100

C. Low

Question 101

What are the components of a graph workspace?
There are 2 correct answers to this question.
Response:

A. Partition
B. Space
C. Edge
D. Vertex

Answer 101

C. Edge
D. Vertex

Question 102

You want to star schema using calculating view. The measure are based on columns from two transaction table dimension calculation views provide the attributes.
What is the correct approach?

Please choose the correct answer.
Response:

A. 1. Combine the transaction table using an aggregation node in a calculation view of cube with star
join
2. Use a star join node to join the dimensions to the fact table
B. 1. Combine the transaction table using a join node in a calculation view of cube with star join
2. Use a star join node to join the dimensions to the fact table
C. 1. Combine the transaction table using a star join node in a calculation view of cube with star join
2. Use a star node to join the dimensions to the fact table
D. 1. Combine the transaction table using a star join node in a calculation view of cube with star join
2. Use an aggregation node to join the dimensions to the fact table

Answer 102

B. 1. Combine the transaction table using a join node in a calculation view of cube with star join
2. Use a star join node to join the dimensions to the fact table

Question 103

How should you create a procedure?
Please choose the correct answer.
Response:

A. Create a runtime object in a HANA project
B. Create a runtime object in the SQL console.
C. Create a design-time object in a HANA project.
D. Create a design-time object in a SQL console

Answer 103

C. Create a design-time object in a HANA project.

Question 104

What are the vertices in a graph model?
Please choose the correct answer.
Response:

A. The nodes themselves
B. The attributes of the nodes
C. The relationships between the nodes

Answer 104

A. The nodes themselves

Question 105

In text processing, where do you use the Term Document Matrix?
Please choose 2 correct answers.
Response:

A. Fact and entity extraction
B. Text mining
C. Fuzzy text search
D. Linguistic extraction

Answer 105

B. Text mining
C. Fuzzy text search

Question 106

What are the features of a parent-child hierarchy?
There are 3 correct answers to this question.
Response:

A. A single dedicated column is used to store the parent of each record of the table.
B. Parent and child field have the same data type.
C. Heterogeneous fields are combined in a hierarchy.
D. Recursive data structure defines the hierarchy.

Answer 106

A. A single dedicated column is used to store the parent of each record of the table.
B. Parent and child field have the same data type.
D. Recursive data structure defines the hierarchy.

Question 107

What are the basic spatial shapes you can store in SAP HANA Spatial?
There are 3 correct answers to this question.
Response:

A. Lines
B. Graphs
C. Polygons
D. Points

Answer 107

A. Lines
C. Polygons
D. Points

Question 108

What is the recommended way to create full-text indexes?
Please choose the correct answer.
Response:

A. SQL statements in the SQL console
B. User-defined functions
C. Core Data Services
D. Procedures

Answer 108

C. Core Data Services

Question 109

You want to publish your business intelligence content directly to SAP Analytics Cloud. Which tool do
you use?
Please choose the correct answer.
Response:

A. SAP Crystal Reports for Enterprise
B. SAP Analysis for Microsoft Office
C. SAP Lumira, discovery edition

Answer 109

C. SAP Lumira, discovery edition

Question 110

Identify the principles that you need to follow during modeling.
There are 2 correct answers to this question.
Response:

A. You should create joins on key columns.
B. You should reduce data transfer between the views by applying filters as low down as possible.
C. You should push data processing to the client as much as possible.
D. You should perform calculations before aggregation.

Answer 110

A. You should create joins on key columns.
B. You should reduce data transfer between the views by applying filters as low down as possible.

Question 111

Why would you use SAP HANA Vora?
Please choose the correct answer.
Response:

A. To ensure consistent HANA performance by offloading workloads when CPU usage is high
B. To combine unstructured data stored on Hadoop with structured enterprise data for OLAP analysis

C. To provide a high-performance warm data store for data that is accessed infrequently
D. To provide secure cloud integration with any HANA application

Answer 111

B. To combine unstructured data stored on Hadoop with structured enterprise data for OLAP analysis

Question 112

Which variable type would you define if you want to use operators such as Greater Than or Less Than?
Please choose the correct answer.
Response:

A. Expression
B. Interval
C. Range
D. Multiple Entries

Answer 112

C. Range

Question 113

What can you discover using Data Lineage?
Response:

A. Underlying calculation views and tables
B. Access statistics
C. Data changes since last refresh
D. Frequency of load

Answer 113

A. Underlying calculation views and tables

Question 114

You rename a field in the Semantics node to add clarity for end users. What does SAP HANA use to keep
track of what the original field name is?
Please choose the correct answer.
Response:

A. The name property
B. The mapping property
C. The label property
D. The label column property

Answer 114

B. The mapping property

Question 115

What are properties of domain fix values?
There are 2 correct answers to this question.
Response:

A. They are based on SQLScript functions.
B. They are based on the ABAP Data Dictionary.
C. They are static values.
D. They ask end users for input at runtime.

Answer 115

B. They are based on the ABAP Data Dictionary.
C. They are static values.

Question 116

What performance technique should you implement to improve the performance of SAP HANA
information views that include SQLScript?
Please choose the correct answer.
Response:

A. Use SELECT *.
B. Use dynamic SQL.
C. Use imperative logic.
D. Break large statements into smaller steps.

Answer 116

D. Break large statements into smaller steps.

Question 117

Identify the object that adds a WHERE clause to the query.
Please choose the correct answer.
Response:

A. Input parameter
B. Modeler
C. Variable
D. Attributes

Answer 117

C. Variable

Question 118

How would you most likely represent the location of an ATM in a visual application that uses SAP HANA
spatial processing?
Please choose the correct answer.
Response:

A. Polygon
B. Multipolygon
C. Line
D. Point

Answer 118

D. Point

Question 119

How does SQL Script extend SQL?
There are 3 correct answers to this question.
Response:

A. It adds imperative expressions to control data flow.
B. It improves push-down opportunities.
C. It enables usage of variables to break up complex code.
D. It allows an alternative syntax to simplify expressions.
E. It provides the data definition language (DDL) to create column tables.

Answer 119

A. It adds imperative expressions to control data flow.
C. It enables usage of variables to break up complex code.
E. It provides the data definition language (DDL) to create column tables.

Question 120

What is the SAP HANA Application Function Library (AFL)?
There are 2 correct answers to this question.
Response:

A. Repository of ready-made business functions
B. Repository of connections that can be used by business functions
C. Repository of ready-to-run applications that are powered by SAP HANA
D. Repository of ready-made predictive algorithms

Answer 120

A. Repository of ready-made business functions
D. Repository of ready-made predictive algorithms

Question 121

Which of the following data sources can you include in a graphical calculation view?
There are 2 correct answers to this question.
Response:

A. Table function
B. Scalar function
C. Procedure
D. SQL VIEW

Answer 121

A. Table function
D. SQL VIEW

Question 122

What are valid types of calculation view?
There are 3 correct answers to this question.
Response:

A. Dimension
B. Cube with star schema
C. Dimension with star schema
D. Cube

Answer 122

A. Dimension
B. Cube with star schema
D. Cube

Question 123

What are the key features of SAP HANA?
There are 3 correct answers to this question.
Response:

A. Automatic compression of data
B. Removes the need for cache
C. In-memory database
D. Combined OLTP and OLAP processing on one platform

Answer 123

A. Automatic compression of data
C. In-memory database
D. Combined OLTP and OLAP processing on one platform

Question 124

A Calculation view includes a rank node that users 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?
Please choose the correct answer.
Response:

A. 2 ROWS
B. 8 Rows
C. 9 Rows
D. 6 Rows

Answer 124

C. 9 Rows

Question 125

What character is prepended to a SQLScript variable when it’s used as an input variable?
Please choose the correct answer.
Response:

A. & (ampersand)
B. : (colon)
C. ! (exclamation mark)
D. _ (underscore)

Answer 125

B. : (colon)

Question 126

You join two tables using a referential join and set the cardinality to 1…n What type of join is executed
at runtime if your query does not request columns from the right table?
Please choose the correct answer.

Response:

A. left outer join
B. Full outer join
C. Inner join
D. Right outer join

Answer 126

C. Inner join

Question 127

What do you call the data displayed in the data foundation of an SAP HANA information view?
Please choose the correct answer.
Response:

A. Key figures
B. Characteristics
C. Measures
D. Facets

Answer 127

C. Measures

Question 128

Which are of the following languages supported by SAP HANA Graph are optimized for graph
processing?
There are 2 correct answers to this question.
Response:

A. Cypher Query Language
B. SQL
C. SQL Script
D. GraphScript

Answer 128

A. Cypher Query Language
D. GraphScript

Question 129

You want to ignore columns defined in the Rank node that aren’t included in the query. What setting do
you set?
Please choose the correct answer.
Response:

A. Keep Flag
B. Hidden
C. Default Client
D. Dynamic Partition Elements

Answer 129

D. Dynamic Partition Elements

Question 130

What SELECT statement isn’t recommended for use with column tables?
Please choose the correct answer.
Response:

A. SELECT ALL
B. SELECT with a time-travel clause
C. SELECT *
D. SELECT in a subquery

Answer 130

C. SELECT *

Question 131

How many tiers do you usually find in an SAP HANA application?
There are 2 correct answers to this question.
Response:

A. 3
B. 2
C. 1
D. 4

Answer 131

A. 3
B. 2

Question 132

What are the rules for defining a stepparent in a hierarchy?
There are 2 correct answers to this question.
Response:

A. The stepparent node ID must be entered according to the node style you selected for the hierarchy.
B. A stepparent only applies to parent-child hierarchies.
C. The stepparent node must already exist in the hierarchy at any level.
D. The stepparent node must already exist in the hierarchy at the root level.

Answer 132

A. The stepparent node ID must be entered according to the node style you selected for the hierarchy.
D. The stepparent node must already exist in the hierarchy at the root level.

Question 133

What information can you find in the SAP HANA Cockpit?
There are 2 correct answers to this question.
Response:

A. SQL Plan Cache
B. List of operators
C. Trace and log files
D. SQL generated in each step

Answer 133

A. SQL Plan Cache
C. Trace and log files

Question 134

What are typical characteristics of SAP HANA data replication?
There are 2 correct answers to this question.
Response:

A. Real-time
B. Virtualization
C. Duplicate data
D. Streaming

Answer 134

A. Real-time
C. Duplicate data

Question 135

Why did SAP move from XS to XSA?
There are 2 correct answers to this question.
Response:

A. To include ABAP as a key development language for native SAP HANA applications
B. To implement micro-services architecture
C. To provide better source code management tools inside SAP HANA
D. To move to Cloud Foundry architecture to allow flexible application deployment options

Answer 135

B. To implement micro-services architecture
D. To move to Cloud Foundry architecture to allow flexible application deployment options

Question 136

What does the C in ACID-compliant stand for?
Please choose the correct answer.
Response:

A. Complete
B. Complexity
C. Consistency
D. Constant

Answer 136

C. Consistency

Question 137

To maintain good read performance in a constantly changing database, which two components are
used?
There are 2 correct answers to this question.
Response:

A. Delta storage
B. Column store
C. Main storage
D. Memory store

Answer 137

A. Delta storage
C. Main storage

Question 138

Where do you build a flowgraph?
There are 2 correct answers to this question.
Response:

A. Web-based development workbench
B. SAP HANA Studio modeler perspective
C. Web IDE for SAP HANA
D. SAP HANA Studio development perspective

Answer 138

C. Web IDE for SAP HANA
D. SAP HANA Studio development

Question 139

In your calculation view, you CANNOT enable a hierarchy for time dependency. What could be the
reason for this?
Response:

A. You did NOT include a history column table.
B. The hierarchy is a level type.
C. You did NOT reference a DIMENSION of the type TIME.
D. The hierarchy is a parent-child type.

Answer 139

B. The hierarchy is a level type.

Question 140

What is the role of core modeling in SAP HANA?
There are 2 correct answers to this question.
Response:

A. To develop more secure user authentication
B. To simplify applications
C. To develop reuseable data processing logic in the database
D. To push data-intensive processing up to the application to obtain the best performance

Answer 140

B. To simplify applications
C. To develop reuseable data processing logic in the database

Question 141

A traditional cube is represented by which SAP HANA view type?
Please choose the correct answer.
Response:

A. Calculation view of type dimension
B. SQL view
C. CDS view
D. Calculation view of type cube with star join

Answer 141

D. Calculation view of type cube with star join

Question 142

For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
Response:

A. Calculated data
B. Materialized cube data
C. Master data
D. Transactional data

Answer 142

C. Master data

Question 143

You create a hierarchy in a dimension calculation view. You then consume this dimension calculation
view with star join in a cube calculation view. How do you allow SQL access to the hierarchy?
Response:

A. 1.Enable SQL access in the view properties of the cube calculation view with star join.
2.Obtain generated node names in shared hierarchies.
B. 1.Enable SQL access in the view properties of the dimension calculation view.
2.Obtain generated node names in shared hierarchies.
C. 1.Enable SQL access in the view properties of the dimension calculation view.
2.Obtain generated node names in local hierarchies.
D. 1.Enable SQL access in the view properties of the cube calculation view with star join.
2.Obtain generated node names in local hierarchies.

Answer 143

A. 1.Enable SQL access in the view properties of the cube calculation view with star join.
2.Obtain generated node names in shared hierarchies.

Question 144

Which SAP solution does SAP HANA Live support?
Please choose the correct answer.
Response:

A. SAP BW/4HANA
B. SAP S/4HANA
C. SAP Ariba
D. SAP Business Suite

Answer 144

D. SAP Business Suite

Question 145

You have a calculation view which includes nodes as shown in the graphic.

You decide to select the “Ignore multiple output for Filters” checkbox on projection node 3. What might
the effects of this be?
There are 2 correct answers to this question.
Response:

A. Increased performance
B. Decreased performance
C. A change to the data that is returned by the view
D. The view will return the profit calculation for only the US

Answer 145

A. Increased performance
D. The view will return the profit calculation for only the US

Question 146

What do SAP S/4HANA embedded analytics and SAP HANA Live have in common?
There are 3 correct answers to this question.
Response:

A. Their data access is controlled using analytic privileges
B. They are built using ABAP CDS
C. They can be extended by customers
D. They are built an maintained by SAP
E. They expose operational data from SAP Sources

Answer 146

C. They can be extended by customers
D. They are built an maintained by SAP
E. They expose operational data from SAP Sources

Question 147

How should I ensure my users do not see values in a sensitive column that is part of a standard SAP
HANA Live view?
Please choose the correct answer.
Response:

A. Use the Extension Assistant to remove the column.
B. Delete the column from the private view.
C. Delete the column from the query view.
D. Mark the column as ‘hidden’ in the semantic layer of the view.

Answer 147

D. Mark the column as ‘hidden’ in the semantic layer of the view.

Question 148

Which of the following are characteristics of SAP HANA Smart Data Streaming?
Please choose the correct answer.
Response:

A. It is a standalone product for use with any target system.
B. It uses databases queries
C. It acts based on combinations of events
D. It provides reports and analysis on the received data.

Answer 148

C. It acts based on combinations of events

Question 149

What information can you find in Performance Analysis Mode when you view the analysis for a Join
node?
There are 2 correct answers to this question.
Response:

A. Suggested filter for the tables in the Join node
B. Time taken by the join
C. Tables used by the join in the node
D. Total number of records returned by the node

Answer 149

C. Tables used by the join in the node
D. Total number of records returned by the node

Question 150

What is normally used to build SAP HANA XSC applications inside SAP HANA?
There are 2 correct answers to this question.
Response:

A. JavaScript
B. SAPUI5
C. ABAP
D. Java

Answer 150

A. JavaScript
B. SAPUI5

Question 151

You need to return multiple result sets using SQL Script. What do you use?
Please choose the correct answer.
Response:

A. Scalar function
B. Procedure
C. Scripted calculation view
D. Table function

Answer 151

B. Procedure

Question 152

Which of the following are no longer required in the architecture of SAP S/4HANA?
There are 2 correct answers to this question.
Response:

A. Column tables
B. Synonyms
C. Indexes
D. Aggregates

Answer 152

B. Synonyms
D. Aggregates

Question 153

What PAL algorithm would you use to analyze shopping baskets?
Please choose the correct answer.
Response:

A. Link prediction
B. Decision tree
C. K-means
D. Apriori

Answer 153

D. Apriori

Question 154

You created a user-defined function with a return type of BIGINT. What type of function have you
created?
Please choose the correct answer.
Response:

A. Window function
B. Scalar function
C. SQL function
D. Table function

Answer 154

B. Scalar function

Question 155

In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary?
Please choose the correct answer.
Response:

A. To extract common entities such as company, country, currencies, and so on, found in documents
B. To extract the sentiment from customer feedback on social media
C. To identify close matches in words and expressions, to catch misspellings
D. To identify the problem which customers are facing

Answer 155

B. To extract the sentiment from customer feedback on social media

Question 156

Why do you use the query debug mode in a calculation view?
Please choose the correct answer.
Response:

A. To measure the overall run-time of the query
B. To observe the generated SQL for each node
C. To check if SAP HANA can paralyze the entire query
D. To check which database engines will be invoked by each node?

Answer 156

B. To observe the generated SQL for each node

Question 157

When would you use a function?
Please choose the correct answer.
Response:

A. When you need to define complex data sources for my calculation view that require conditional logic.
B. To develop a calculation view with the best possible performance.
C. When you need to write results back to a table.
D. To break SQL into smaller statements.

Answer 157

A. When you need to define complex data sources for my calculation view that require conditional logic.

Question 158

The virtual data model for SAP S/4HANA is based on which of these?
Please choose the correct answer.
Response:

A. ABAP CDS
B. SAP HANA CDS
C. SAP HANA Live
D. Universe

Answer 158

A. ABAP CDS

Question 159

Which words are associated with the log volume?
There are 2 correct answers to this question.
Response:

A. Transaction manager
B. Page manager
C. Synchronous
D. Savepoint

Answer 159

A. Transaction manager
C. Synchronous

Question 160

Which hierarchies can you enable for SQL access?
Please choose the correct answer.
Response:

A. Local hierarchies in a star join view
B. Shared hierarchies in a star join view
C. Level hierarchies in a calculation view of type cube
D. Time-dependent hierarchies in a dimension view

Answer 160

B. Shared hierarchies in a star join view

Question 161

What do you use in a SQL query to sort fuzzy text search results by relevance?
Please choose the correct answer.
Response:

A. TOP
B. RANK()
C. SORT BY
D. SCORE()

Answer 161

D. SCORE()

Question 162

What enables the delta buffer technique to speed up both reads and inserts in SAP HANA?
Please choose the correct answer.
Response:

A. Using both row-based and column-based tables
B. Using column-based tables only
C. Using only the insert-only technique
D. Using row-based tables only

Answer 162

A. Using both row-based and column-based tables

Question 163

Where can you set the default value for the SAP client for the entire calculation view?
Please choose the correct answer.
Response:

A. In the semantic layer of the calculation view
B. In the Join node of the calculation view
C. In the Preferences option of the Tools menu
D. In the default node of the calculation view

Answer 163

A. In the semantic layer of the calculation view

Question 164

What is scale-out?
There are 2 correct answers to this question.
Response:

A. Use of commodity servers that are used in high volume steaming applications.
B. Use of standby servers in the event of hardware failure.
C. Use of multiple servers to spread processing and improve performance.
D. Use of remote servers to store archived data that is rarely used.

Answer 164

B. Use of standby servers in the event of hardware failure.
C. Use of multiple servers to spread processing and improve performance.

Question 165

What development tool is available for creating SAP HANA XSA and HDI information models?
Please choose the correct answer.
Response:

A. SAP Web IDE for SAP HANA
B. Database Explorer
C. SAP HANA Web-Based Development Workbench
D. SAP HANA Studio

Answer 165

A. SAP Web IDE for SAP HANA

Question 166

You’re given an old government paper form with lines, blocks, and fields. You’re asked to create a report
that looks like this form.
Which business intelligence tools do you use?
Please choose the correct answer.
Response:

A. SAP Lumira, discovery edition
B. SAP BusinessObjects Web Intelligence
C. SAP Crystal Reports for Enterprise
D. SAP Lumira, designer edition

Answer 166

C. SAP Crystal Reports for Enterprise

Question 167

What is an example of a use of Text Analysis?
Please choose the correct answer.
Response:

A. Extraction of key facts from a business article.
B. Extraction of key facts from entire database transactions
C. Cluster documents that discuss similar topics.
D. Developing a user input field where misspellings are tolerated.

Answer 167

A. Extraction of key facts from a business article.

Question 168

You have Model B that is based on Model A. You have successfully built both models. You delete Model
B. What happens during the build?
There are 2 correct answers to this question.
Response:

A. The build of the entire HDB module is successful
B. Model B gets deleted from the HDI container
C. You get a build error when you build Model A
D. You get an error when you build the entire HDB module
E. The build of Model A is successful

Answer 168

A. The build of the entire HDB module is successful
D. You get an error when you build the entire HDB module

Question 169

Why might you want to reference a user-provided service in a project?
Please choose the correct answer.
Response:

A. To access data from your project container
B. To access data from another container
C. To access data from a classic database schema

Answer 169

C. To access data from a classic database schema

Question 170

Which of the following approaches can be used to implement union pruning?
Note: There are 2 correct answers to this question.
Response:

A. Define a restricted column and include it in both data sources of a union.
B. Define the cardinality between the data sources.
C. Define a constant value for each data source in the Union node.
D. Define union pruning conditions in a pruning configuration table.

Answer 170

C. Define a constant value for each data source in the Union node.
D. Define union pruning conditions in a pruning configuration table.

Question 171

Which table partitioning types does SAP HANA support?
There are 3 correct answers to this question.
Response:

A. Cluster
B. Composite
C. Round-robin
D. Hash
E. Range

Answer 171

C. Round-robin
D. Hash
E. Range

Question 172

Identify the features and benefits of a calculation view.
There are 3 correct answers to this question.
Response:

A. It supports you to include more advanced calculations.
B. It is not possible to join several fact tables in a calculation view.
C. It can be defined as a graphical view or a scripted view.
D. It can contain calculated attributes.

Answer 172

A. It supports you to include more advanced calculations.
C. It can be defined as a graphical view or a scripted view.
D. It can contain calculated attributes.

Question 173

Why might you use the keep flag in an aggregation node?
Please choose the correct answer.
Response:

A. To retain the results of the aggregation node for reuse in a drill-down based on hierarchy
B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be
overridden by a query
C. To include columns that are NOT requested by a query but are essential for the correct result

Answer 173

C. To include columns that are NOT requested by a query but are essential for the correct result

Question 174

Which SAP tools can work with data from Hadoop?
There are 3 correct answers to this question.
Response:

A. SDA
B. SDI
C. RDSync
D. SAP Vora
E. SAP Landscape Transformation Replication Server

Answer 174

A. SDA
B. SDI
D. SAP Vora

Question 175

In which of the following circumstances do you use graph processing?
There are 2 correct answers to this question.
Response:

A. To identify the strongly connected members of a social media group.
B. To identify customer sentiments from social media content.
C. To improve performance on complex charts and dashboards.
D. To find the shortest path between supplier and consumer.

Answer 175

A. To identify the strongly connected members of a social media group.
D. To find the shortest path between supplier and consumer.

Question 176

You set up in currency conversion in a calculation view. When your currency conversion fails, what could
you choose to populate the target column?
There are 2 correct answers to this question.
Response:

A. A DEFAULT value
B. THE source amount
C. <EMPTY>
D. Null</EMPTY>

Answer 176

B. THE source amount
D. Null

Question 177

What type of join should you use?
Please choose the correct answer.

Response:
A. Temporal join
B. Inner join
C. Text join
D. Referential join

Answer 177

D. Referential join

Question 178

You created a table using the SQL console inside the HANA deployment infrastructure (HD) container of
project You export project and re-import it with a different project name to same database.
What do you observe the SAP HANA database module?
Please choose the correct answer.
Response:

A. The build is successful but the is NOT present
B. The build is successful and the table and its data are present
C. The build fails and the table is NOT present

Answer 178

A. The build is successful but the is NOT present

Question 179

Which of the following ways of publishing SAP HANA information model content could require some
JavaScript knowledge?
Please choose the correct answer.
Response:

A. Creating a report in SAP Crystal Reports for Enterprise
B. Creating a REST web service in the SAP HANA XS engine
C. Creating business intelligence content with SAP Lumira, designer edition
D. Creating a CompositeProvider in SAP BW

Answer 179

C. Creating business intelligence content with SAP Lumira, designer edition

Question 180

You have two calculation views for viewing manufactured products. The WORLD calculation view shows
worldwide information.
The INDIA calculation view is built on top of the WORLD calculation view and shows information for
Indian products.
What privilege must you assign to see your department’s specific data in a report built on the INDIA
calculation view?
Please choose the correct answer.
Response:

A. An analytic privilege on both calculation views
B. An analytic privilege on the WORLD calculation view
C. An analytic privilege on the INDIA calculation view
D. An object privilege on the WORLD calculation view

Answer 180

A. An analytic privilege on both calculation views

Question 181

What are the key features of SAP HANA?

There are 3 correct answers to this question.
Response:

A. Removes the need for cache
B. Combined OLTP and OLAP processing on one platform
C. Automatic compression of data
D. In-memory database

Answer 181

B. Combined OLTP and OLAP processing on one platform
C. Automatic compression of data
D. In-memory database

Question 182

What is the correct sequence for loading data with SAP Data Services?
Please choose the correct answer.
Response:

A. Extract - Load - Transform
B. Load - Extract - Transform
C. Extract - Transform - Load
D. Load - Transform - Extract

Answer 182

C. Extract - Transform - Load

Question 183

You want to read a table from an SAP HANA classical schema. What do you need to do to get it working?
There are 3 correct answers to this question.
Response:

A. Make use of a user-provided service
B. Use an explicit reference to the schema
C. Assign the provided ::access role to your container’s technical user
D. Make use of the built-in HDI service
E. Create a synonym

Answer 183

A. Make use of a user-provided service
C. Assign the provided ::access role to your container’s technical user
E. Create a synonym

Question 184

What phrase describes the main table area in the delta merge scenario?
Please choose the correct answer.
Response:

A. Row store
B. Read-optimized
C. Unsorted inserts
D. Write-optimized

Answer 184

B. Read-optimized

Question 185

Identify the features and benefits of a calculation view.
There are 3 correct answers to this question.
Response:

A. It is not possible to join several fact tables in a calculation view.
B. It can be defined as a graphical view or a scripted view.
C. It can contain calculated attributes.
D. It supports you to include more advanced calculations.

Answer 185

B. It can be defined as a graphical view or a scripted view.
C. It can contain calculated attributes.
D. It supports you to include more advanced calculations.

Question 186

What spatial data type would you use to store multiple shop locations?
Please choose the correct answer.
Response:

A. ST_Point
B. ST_MultiPoint
C. ST_Polygon
D. ST_MultiLineString

Answer 186

B. ST_MultiPoint

Question 187

What are the rules for defining a stepparent in a hierarchy?
There are 2 correct answers to this question.
Response:

A. A stepparent only applies to parent-child hierarchies.
B. The stepparent node must already exist in the hierarchy at the root level.
C. The stepparent node must already exist in the hierarchy at any level.
D. The stepparent node ID must be entered according to the node style you selected for the hierarchy.

Answer 187

B. The stepparent node must already exist in the hierarchy at the root level.
D. The stepparent node ID must be entered according to the node style you selected for the hierarchy.

Question 188

What is the preferred way to create a procedure?
Please choose the correct answer.
Response:

A. Create a .procedure file.
B. Create a .hdbprocedure file.
C. Use the Import menu in the SAP Web IDE for SAP HANA.
D. Use the CREATE PROCEDURE statement in the SQL console.

Answer 188

B. Create a .hdbprocedure file.

Question 189

You need a business intelligence tool that is Microsoft Excel-based and can use parent-child hierarchies.
Which tool do you use?
Please choose the correct answer.
Response:

A. SAP Lumira, designer edition
B. SAP Lumira, discovery edition
C. SAP BusinessObjects Web Intelligence
D. SAP Analysis for Microsoft Office

Answer 189

D. SAP Analysis for Microsoft Office

Question 190

What should you use to create tables in an HDI container?
There are 2 correct answers to this question.
Response:

A. SAP Enterprise Architecture Designer
B. SQL Console
C. Core Data Services (CDS)
D. Database Explorer

Answer 190

A. SAP Enterprise Architecture Designer
C. Core Data Services (CDS)

Question 191

You have a calculation view which includes nodes as shown in the graphic.

You decide to select the “Ignore multiple output for Filters” checkbox on projection node 3. What might
the effects of this be?
There are 2 correct answers to this question.
Response:

A. The view will return the profit calculation for only the US
B. Decreased performance
C. Increased performance
D. A change to the data that is returned by the view

Answer 191

A. The view will return the profit calculation for only the US
C. Increased performance

Question 192

What are key features of SAP HANA?
There are 3 correct answers to this question.
Response:

A. Removes the need for cache
B. Automatic compression of data
C. Combined OLTP and OLAP processing on one platform
D. In-memory database

Answer 192

B. Automatic compression of data
C. Combined OLTP and OLAP processing on one platform
D. In-memory database

Question 193

You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers
are stored. You have an identical table in which you store French customers.
What type of calculation view should you create to combine the customers in to two columns that
mirror the structure of the sources tables?
Please choose the correct answer.
Response:

A. Calculation view of cube type with a union node
B. Calculation view of cube type with a join node
C. Calculation view of dimension type with a join node
D. Calculation view of dimension type with a union node

Answer 193

D. Calculation view of dimension type with a union node

Question 194

The virtual data model for SAP S/4HANA is based on which of these?
Please choose the correct answer.
Response:

A. SAP HANA CDS
B. Universe
C. SAP HANA Live
D. ABAP CDS

Answer 194

D. ABAP CDS

Question 195

What are the three areas of SAP HANA Text Processing?
There are 3 correct answers to this question.
Response:

A. Text Analysis
B. Text Search
C. Text Mining
D. Text Profiling

Answer 195

A. Text Analysis
B. Text Search
C. Text Mining

Question 196

Which of the following are valid types of privileges in SAP HANA?
There are 3 correct answers to this question.
Response:

A. Application privileges
B. Data privileges
C. Package privileges
D. Attribute privileges
E. System privileges

Answer 196

A. Application privileges
C. Package privileges
E. System privileges

Question 197

Your newly created analytic privilege does NOT want to build. What must you do?
Please choose the correct answer.
Response:

A. Change the Apply Privileges property of the view.
B. Grant rights to the _SYS_REPO user.
C. Change the analytic privilege to use an SQL Expression.
D. Assign the ::access role to the HDI container user.

Answer 197

A. Change the Apply Privileges property of the view.

Question 198

Which text feature do you use to find sentiment in textual data?
Please choose the correct answer.
Response:

A. Full-text index
B. Text analysis
C. Text mining
D. Fuzzy text search

Answer 198

B. Text analysis

Question 199

When can you use the referential join?
Please choose the correct answer.
Response:

A. When you have to report on all dimensions to confirm if there are matching facts or not.
B. When referential integrity is assured
C. When you have to report on all posted facts
D. When you have to report on facts with matching dimensions

Answer 199

B. When referential integrity is assured

Question 200

You have copied a design-time file from a source folder to a target folder that has the same namespace
setting. In which of the following scenarios will a build of the copy design-time file be successful?
There are 2 correct answers to this question.
Response:

A. The source design-time file has never been built.
B. The source design-time file has been deleted from the source folder in the meantime.
C. The build of the copy design-time file will always be successful
D. The source design-time file has been built once but the built has failed.

Answer 200

A. The source design-time file has never been built.
D. The source design-time file has been built once but the built has failed.

Question 201

In which package in SAP HANA will you find the SAP HANA Live views?
Please choose the correct answer.
Response:

A. /sap/bc
B. /public
C. /sap/hana/democontent
D. /sap/hba

Answer 201

D. /sap/hba

Question 202

You are building a new calculation view, A, Which includes a projection node that refers to another
calculation view, B. WHY would you use the extract semantics feature?
Please choose the correct answer.
Response:

A. To automatically map the input parameters from calculation view B to an input parameter of
calculation A
B. TO SET the semantics of calculation view A TO THE DEFAULT VALUES
C. TO apply the semantics of calculation view B TO the semantics of calculation view A
D. To improve the performance of calculation view A by only referencing the semantics calculation view
B and not duplicating it.

Answer 202

C. TO apply the semantics of calculation view B TO the semantics of calculation view A

Question 203

What are the database query languages used by SAP HANA?
There are 2 correct answers to this question.
Response:

A. MDX
B. SQL
C. ODBC
D. JDBC
E. ABAP

Answer 203

A. MDX
B. SQL

Question 204

Where in a calculation view can you add a Graph node?
Please choose the correct answer.
Response:

A. Anywhere from the bottom (leaf) node to the default node
B. Always as the bottom (leaf) node
C. Only as the top node

Answer 204

B. Always as the bottom (leaf) node

Question 205

What are the features of dynamic analytic privileges?
There are 2 correct answers to this question.
Response:

A. Filter the condition based on a variable entered by the user when they query the view
B. Filter the data based on a variable entered by the user when they query the view
C. Change the filter condition in the underlying tables and views
D. Reuse the same analytic privilege for several users who need to access different data

Answer 205

C. Change the filter condition in the underlying tables and views
D. Reuse the same analytic privilege for several users who need to access different data

Question 206

In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can
build the SAP HANA database (HDB) module successfully?
There are 2 correct answers to this question.
Response:

A. Ensure that the name of your HDB module is included in the corresponding schema names
B. Explicitly build the HDB module instead of the project
C. Ensure that you have only one HDB module in your project
D. Assign the project to a space to which you have developer authorizations

Answer 206

A. Ensure that the name of your HDB module is included in the corresponding schema names
D. Assign the project to a space to which you have developer authorizations

Question 207

What do you use to build a financial report for the company’s board members that allows them to
choose if they want the report to be in euros or dollars?
Please choose the correct answer.
Response:

A. A variable from a Projection node
B. An input parameter from the Semantics node
C. An input parameter from an Aggregation node
D. A variable from the Semantics node

Answer 207

B. An input parameter from the Semantics node

Question 208

What do you create to find the number of unique items sold per shop?
Please choose the correct answer.
Response:

A. A calculation view with a counter in an Aggregation node
B. A calculation view with a counter in a Projection node
C. A calculation view with a restricted column in an Aggregation node
D. An analytic view with a calculated column in a Star Join node

Answer 208

A. A calculation view with a counter in an Aggregation node

Question 209

What type of node is recommended to combine two data sources that have a similar set of dimensions?
Please choose the correct answer.
Response:

A. Inner join
B. Join
C. Union
D. Star join

Answer 209

C. Union

Question 210

When do you use the SQL Analyzer?
Please choose the correct answer.
Response:

A. To hide the syntax errors in my SQL code.
B. To investigate the generated SQL for each node in my calculation view.
C. To highlight syntax errors in my SQL code.
D. To identify the longest running SQL statements.

Answer 210

D. To identify the longest running SQL statements.

Question 211

Why do you create a multistory table?
Please choose the correct answer.
Response:

A. To have the option to partition the table across different storage tiers
B. To improve read performance when accessed by simultaneous applications
C. To have a table that combines the characteristics of row and column stores
D. To evenly distribute the data across all available server nodes

Answer 211

A. To have the option to partition the table across different storage tiers

Question 212

Which of the following data operations can you perform with SDA?
There are 3 correct answers to this question.
Response:

A. Data federation
B. Logical data warehouse
C. Physical data warehouse
D. Real-time replication

Answer 212

A. Data federation
B. Logical data warehouse
D. Real-time replication

Question 213

What can you determine using the hierarchy function in a calculation view?
There are 3 correct answers to this question.
Response:

A. Distance between root and each hierarchy node
B. Time interval of hierarchy nodes
C. Hierarchy nodes that have no parent
D. Source attributes of a composite hierarchy node
E. Number of siblings for a hierarchy node

Answer 213

A. Distance between root and each hierarchy node
D. Source attributes of a composite hierarchy node
E. Number of siblings for a hierarchy node

Question 214

You created a calculated column in a star join view for a table containing the number of units ordered,
the price per unit, and the number of units in stock. You get the wrong results.
What could be the problem?
Please choose the correct answer.
Response:

A. You did NOT enable the currency conversion.
B. You mistyped the calculated column expression.
C. You chose the SQL expression syntax.
D. You did NOT enable the Keep Flag.

Answer 214

D. You did NOT enable the Keep Flag.

Question 215

In SAP HANA Series Data processing, what is the definition of a profile?
Please choose the correct answer.
Response:

A. The granularity of time intervals, such as day, hour, or minute
B. The values that you are storing, such as temperature, energy consumption, or speed
C. A variant of data set, such as actual, forecast, or long-term plan
D. The object you collect data against, such as house, buidling, or town

Answer 215

D. The object you collect data against, such as house, buidling, or town

Question 216

What performance techniques should you implement to improve join performance?
There are 3 correct answers to this question.
Response:

A. Always specify the cardinality of a join.
B. Use left outer joins instead of right outer joins.
C. Use unions instead of joins for combining large datasets.
D. Always mark joins as dynamic to improve performance.
E. Join as many tables as possible in a star join view’s data foundation.

Answer 216

A. Always specify the cardinality of a join.
B. Use left outer joins instead of right outer joins.
C. Use unions instead of joins for combining large datasets.

Question 217

What is SQLScript?
Please choose the correct answer.
Response:

A. An extension to standard SQL that provides additional expressions, functions and datatypes.
B. A simplified query language aimed at business users that generates SQL.
C. A subset of standard SQL that is exposed to HANA database procedures.
D. A subset of standard SQL that is exposed to HANA modelers.

Answer 217

A. An extension to standard SQL that provides additional expressions, functions and datatypes.

Question 218

To what subset of SQL does the SELECT statement belong?
Please choose the correct answer.
Response:

A. DDL
B. DML
C. DQL
D. DCL

Answer 218

C. DQL

Question 219

What does a graph neighborhood reveal?
Please choose the correct answer.
Response:

A. Strongly connected Vertices
B. Vertices that are closely connected
C. Vertices that contain the same attributes
D. Shortest path between vertices

Answer 219

B. Vertices that are closely connected

Question 220

In which direction do you build calculation views when including the source tables in Join nodes?
Please choose the correct answer.
Response:

A. From the Join node down to the default node
B. From the Semantics node up to the default node
C. From the Semantics node down to the Join nodes
D. From the Join nodes up to the semantics node

Answer 220

D. From the Join nodes up to the semantics node

Question 221

What is included with the Predictive Analysis Library (PAL)?
There are 2 correct answers to this question.
Response:

A. Text mining functions
B. Flowgraphs
C. Data preparation functions
D. Predictive algorithms

Answer 221

C. Data preparation functions
D. Predictive algorithms

Question 222

What does SQLScript provide in SAP HANA?
There are 3 correct answers to this question.
Response:

A. Variables to break up complex statements
B. Creation of column tables
C. Flow control logic
D. Powerful client-side processing
E. Aggregation functions such as AVG()

Answer 222

A. Variables to break up complex statements
B. Creation of column tables
C. Flow control logic

Question 223

Identify the join that checks the From and To column on the left table.

Please choose the correct answer.
Response:

A. Text Join
B. Full Outer Join
C. Left Outer Join
D. Right Outer Join
E. Temporal Join

Answer 223

E. Temporal Join

Question 224

What node can you use for sorting results, for example, to show the top 100?
Please choose the correct answer.
Response:

A. Aggregation node
B. Rank node
C. Union node
D. Projection node

Answer 224

B. Rank node

Question 225

What character is used to terminate SQL statements?
Please choose the correct answer.
Response:

A. : (colon)
B. ; (semicolon)
C. ? (question mark)
D. . (period)

Answer 225

B. ; (semicolon)

Question 226

Your calculation view includes the following SALES_ORDER_ID and ITEM as attributes, and QUANTITY
and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula
QUANTITY*PRICE.

In which node do you define the calculation to display the correct aggregated result?
Please choose the correct answer.
Response:

A. Aggregation
B. Union
C. Projection
D. Join

Answer 226

C. Projection

Question 227

Which version of CDS is used by S/4HANA?
Please choose the correct answer.
Response:

A. None of these
B. HANA CDS
C. ABAP CDS
D. Both ABAP CDS and HANA CDS

Answer 227

C. ABAP CDS

Question 228

What are features of SDA?
There are 2 correct answers to this question.
Response:

A. Merging data from multiple sources
B. Data cleansing
C. Evaluation and execution of push down possibilities to remote sources
D. Automatic data type translation

Answer 228

C. Evaluation and execution of push down possibilities to remote sources
D. Automatic data type translation

Question 229

What do you need to do after creating a new project with an HDB module?
Please choose the correct answer.
Response:

A. Select a space for running the project
B. Convert the new module to an HDB module
C. Create an .hdinamespace file

Answer 229

A. Select a space for running the project

Question 230

Why would you create a procedure?
There are 2 correct answers to this question.
Response:

A. If you need to insert records into a table
B. If you need a mixture of scalar and tabular output parameters
C. If you need to provide a data source to a graphical calculation view
D. If you need to define a calculated column expression

Answer 230

A. If you need to insert records into a table
B. If you need a mixture of scalar and tabular output parameters

Question 231

A column table definition includes a spatial column that has the VALIDATION FULL property. You execute an SQL statement to insert a geometry into this column. The statement fails.

Which of the following are possible reasons for the failure?
There are 2 correct answers to this question.
A The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one.
B The geometry is an ST_MULTIPOLYGON that specifies only one polygon.
C The geometry is an ST_POLYGON where the last defined point is not the same as the first one.
D The geometry is an ST_POLYGON that has an inner ring that is completely inside the outer ring.

Answer 231

A The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one.
C The geometry is an ST_POLYGON where the last defined point is not the same as the first one.

Question 232

What are the two storage components used to restore the database in case of power failure?
There are 2 correct answers to this question.

Response:

A Delta store
B Log area
C Data volume
D Memory

Answer 232

B Log area
C Data volume

Question 233

What conditions must be met to ensure the Dynamic join feature works properly?
There are 2 correct answers to this question.

Response:

A At least one joined column must be specified in the query.
B The join must be defined on key columns
C Cardinality must be set
D Multiple columns must be defined in the join

Answer 233

A At least one joined column must be specified in the query.
D Multiple columns must be defined in the join

Question 234

What technique is used to convert record updates into insert statements in the delta buffer?
Please choose the correct answer.

Response:

A Parallelism
B Insert-only
C Sorted inserts
D Unsorted inserts

Answer 234

B Insert-only

Question 235

You want to implement parallelization in a calculation view. Which restrictions apply to the parallelization block?
There are 3 correct answers to this question.

Response:

A Only one start node can be defined
B You can define only one per calculation view
C A partitioning column must be defined
D Only one block can be defined across a calculation view stack
E It must begin with a data source of the type table

Answer 235

A Only one start node can be defined
D Only one block can be defined across a calculation view stack
E It must begin with a data source of the type table

Question 236

You’re selling books that have been translated into various languages. What join type should you use?
Please choose the correct answer.

If has SPRAS on it …

Response:

A Text join
B Referential join
C Temporal join
D Left outer join

Answer 236

A Text join

Question 237

What are the key steps to implement currency conversion in a calculation view?
Please choose the correct answer.

Response:

A
- Assign semantic type
- Enable the measure for conversion
- Choose client, source and target currencies Choose conversion date and rate type
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
- Choose client, source and target currencies
- Choose conversion date and rate type Define an expression in a calculated column
D
- Enable the measure for conversion
- Choose client, source, and target currencies Choose conversion date and rate type
- Build the conversion rule

Answer 237

A - Assign semantic type
- Enable the measure for conversion
- Choose client, source and target currencies Choose conversion date and rate type

Question 238

Where do you assign a user as a developer in a development space?
Please choose the correct answer.

Response:

A SAP Web IDE for SAP HANA
B SAP HANA Cockpit
C SAP HANA XSA Administration tool

Answer 238

C SAP HANA XSA Administration tool

Question 239

Which options do you have to handle orphan nodes in your hierarchy?
There are 2 correct answers to this question.

Response:

A Assign them to a level below the root.
B Assign them to a node at the root level
C Generate additional root nodes.
D Define an expression to determine a parent.

Answer 239

B Assign them to a node at the root level
C Generate additional root nodes.

Question 240

You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option?
There are 2 correct answers to this question.

Response:

A To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
B To ensure that the join execution only uses the join columns requested in the query
C To ensure that the aggregation always happens after the join execution
D To allow data analysis at different levels of granularity with the same calculation view

Answer 240

B To ensure that the join execution only uses the join columns requested in the query
D To allow data analysis at different levels of granularity with the same calculation view

Question 241

Your calculation view consumes one data source which includes the following columns: SALES_ORDER_ID, PRODUCT_ID and 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?
Please choose the correct answer.

Response:

A Aggregation
B Projection
C Join
D Union

Answer 241

B Projection

Question 242

What information can you find in Performance Analysis Mode when you view the analysis for a Join node?
There are 2 correct answers to this question.

Response:

A Tables used by the join in the node
B Total number of records returned by the node
C Suggested filter for the tables in the Join node
D Time taken by the join

Answer 242

A Tables used by the join in the node
B Total number of records returned by the node

Question 243

You define a hierarchy in a calculation view. You went to expose the hierarchy to SQL. Which of the following conditions must be met?
There are 2 correct answers to this question.

Response:

A The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY.
B The hierarchy must be exposed by a calculation view of type CUBE with star join.
C The hierarchy must be a shared hierarchy.
D The hierarchy must be a local hierarchy.

Answer 243

B The hierarchy must be exposed by a calculation view of type CUBE with star join.
C The hierarchy must be a shared hierarchy.

Question 244

Which of the following tasks are required to get the database objects created in the HDI container?
There are 2 correct answers to this question.

Response:

A Explicitly build the HDB module instead of the MTA project.
B Assign the project to a space to which you have developer authorizations.
C Create at least one namespace in the HDB module.
D Build the MTA project.

Answer 244

A Explicitly build the HDB module instead of the MTA project.
B Assign the project to a space to which you have developer authorizations.

Question 245

Which of the following approaches improve the performance of joins in a cube calculation view?
There are 2 correct answers to this question.

Response:

A Determine join direction in a full outer join.
B Use an inner join
C Specify the join cardinality.
D Limit the number of joined columns.

Answer 245

C Specify the join cardinality.
D Limit the number of joined columns.

Question 246

How does SAP S/4HANA embedded analytics differ from SAP HANA Live?
There are 2 correct answers to this question.

Response:

A Authorizations are at the application level.
B Authorizations are at the database level.
C It uses ABAP CDS views.
D It uses SAP HANA calculation views.

Answer 246

A Authorizations are at the application level.
C It uses ABAP CDS views.

Question 247

What are the components of a custom text analysis?
There are 3 correct answers to this question.

Response:

A Rule Set
B Configuration
C Term Document Matrix
D Python Script
E Dictionary

Answer 247

A Rule Set
B Configuration
E Dictionary

Question 248

What performance technique should you implement to improve join performance?
Please choose the correct answer.

Response:

A Use joins instead of unions for combining large datasets.
B Join on key fields between tables in a dimension view.
C Do NOT use dynamic joins if you require optimal performance.
D Always use referential joins in star join views.

Answer 248

B Join on key fields between tables in a dimension view.

Question 249

Which options do you have to handle orphan nodes in your hierarchy?
There are 2 correct answers to this question.

Response:

A Generate additional root nodes.
B Assign them to a node at the root level
C Assign them to a level below the root.
D Define an expression to determine a parent.

Answer 249

A Generate additional root nodes.
B Assign them to a node at the root level

Question 250

A company sends out a lot of quotes. Some customers accept the quotes, and they’re invoiced. The
company asks you to find a list of the customers that did NOT accept the quotes.
How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.
Response:
A. Use a right outer join.
Filter to show only the NULL values on the right table.
B. Use a left outer join.
Filter to show only the NULL values on the right table.
C. Use a right outer join.
Filter to show only customers on the left table.
D. Use a left outer join.
Filter to show only customers on the right table.

Answer 250

B. Use a left outer join.
Filter to show only the NULL values on the right table.

Question 251

What restrictions apply to a graph node that you include in a calculation view?
Please choose the correct answer.
Response:
A. It must be the final node in the data flow
B. It must be the first node in the data flow.
C. It cannot be included in a calculation view of type dimension
D. Its data sources must be provided by a projection node

Answer 251

B. It must be the first node in the data flow.

Question 252

Which type of tables required extended storage?
Please choose the correct answer.
Response:

A. Row tables
B. Multistore tables
C. In-memory tables
D. Column tables

Answer 252

B. Multistore tables

Question 253

What can you identify using the performance Analysis Mode?
There are 2 correct answers to this question.
Response:

A. Usage statistics of the calculation view
B. Longest running query step
C. Information about join cardinality
D. Joins that are based on calculated columns

Answer 253

C. Information about join cardinality
D. Joins that are based on calculated columns

Question 254

You have successfully built an SAP HANA database (HDB) module. It contains a dimension calculation
view that is only consumed by one cube calculation view.
- In the dimension calculation view, you change the name of a column that is referenced by the cube
calculation view.
- You then accidentally delete the design-time object of the cube calculation view.
During the build, which of the following scenarios are possible?

There are 2 correct answers to this question.
Response:

A. When you build only the dimension calculation view, the build fails.
B. When you build the HDB module, the build fails.
C. When you build the HDB module, the build is successful.
D. When you build only the dimension calculation view, the build is successful.

Answer 254

A. When you build only the dimension calculation view, the build fails.
C. When you build the HDB module, the build is successful.

Question 255

What should you keep in mind about user-defined functions?
Please choose the correct answer.
Response:

A. They can call procedures.
B. They can use imperative logic.
C. They can use dynamic SQL.
D. They can commit transactions.

Answer 255

B. They can use imperative logic.

Question 256

You have logs from a website. How do you show the total number of website visitors that used a mobile
phone?
There are 2 correct answers to this question.
Response:

A. Create a filter expression.
B. Create a rank column.
C. Create a restricted column.
D. Create a hierarchy expression parameter.

Answer 256

A. Create a filter expression.
C. Create a restricted column.

Question 257

Which of the following are capabilities of SAP HANA Live Browser?
There are 3 correct answers to this question.
Response:
A. You can launch the views using SAP Analysis Edition for Microsoft Excel.
B. You can develop personal lists of frequently used query views.
C. You can graphically illustrate the dependencies between SAP HANA Live views.
D. You can adjust the views by adding additional columns.

Answer 257

A. You can launch the views using SAP Analysis Edition for Microsoft Excel.
B. You can develop personal lists of frequently used query views.
C. You can graphically illustrate the dependencies between SAP HANA Live views.

Question 258

When do you use the SQL Analyzer?
Please choose the correct answer.
Response:

A. To highlight syntax errors in my SQL code.
B. To identify the longest running SQL statements.
C. To investigate the generated SQL for each node in my calculation view.
D. To hide the syntax errors in my SQL code.

Answer 258

B. To identify the longest running SQL statements.

Question 259

What are features of Business Suite on SAP HANA?
There are 2 correct answers to this question.
Response:

A. Embedded Analytics
B. Massive performance improvement
C. Combine operational analytics and transaction processin
D. ABAP is replaced with JAVA

Answer 259

B. Massive performance improvement
C. Combine operational analytics and transaction processin

Question 260

A partitioned column table is present only in the persistent layer of an SAP HANA system Which columns
and partitions are loaded into memory when the table is accessed by an application?
Please choose the correct answer.
Response:

A. ONLY the required columns and the required partitions
B. All the partitions but ONLY the required columns
C. ONLY the required partitions and all the columns

Answer 260

A. ONLY the required columns and the required partitions

Question 261

While converting currencies, which parameter is as important as source and target currencies?
Please choose the correct answer.
Response:

A. Time
B. Location
C. Money
D. Season

Answer 261

A. Time

Question 262

In your rank node, why do you set the dynamic partition element flag?
Please choose the correct answer.
Response:

A. To define time dependency on a partition
B. To determine the ranking threshold value base on an input parameter
C. To determine the partitioning logic using an SQL expression
D. To generate the ranking partition based on the column selected in the query

Answer 262

D. To generate the ranking partition based on the column selected in the query

Question 263

In which SAP HANA views will you find measures?
There are 2 correct answers to this question.
Response:

A. Calculation view of type dimension
B. Database views
C. Calculation view of type cube with star join
D. Calculation view of type cube

Answer 263

C. Calculation view of type cube with star join
D. Calculation view of type cube

Question 264

What should you keep in mind about user-defined functions?
Please choose the correct answer.
Response:

A. They can use dynamic SQL.
B. They can call procedures.
C. They can use imperative logic.
D. They can commit transactions.

Answer 264

C. They can use imperative logic.

Question 265

Which are views of the SAP supplied virtual data model of Embedded Analytics?
There are 2 correct answers to this question.
Response:

A. Composite
B. Basic
C. Attribute
D. Calculation

Answer 265

A. Composite
B. Basic

Question 266

Which of the following VDM views can be called by applications and reports?
There are 2 correct answers to this question.
Response:

A. Query views
B. Private views
C. Value help views
D. Reuse views

Answer 266

A. Query views
C. Value help views

Question 267

If we change the transaction “Laura buys 10 apples” to “Laura buys 10 green apples,” how would we
store the color green?
Please choose the correct answer.
Response:

A. Store green as an attribute.
B. Store green as a spatial data type.
C. Store green as a measure.
D. Store green as a CDS view.

Answer 267

A. Store green as an attribute.

Question 268

In a calculation view, what is the purpose of a variable?
Please choose the correct answer.
Response:

A. To provide a run-time attribute filter based on a user input
B. To pass values between procedures and calculation views
C. To capture the interim result of a calculation in an expression
D. To break up complex SQL into smaller steps

Answer 268

A. To provide a run-time attribute filter based on a user input

Question 269

You want to build a hierarchy on a time-based data structure, such as year, month, and day. What type
of hierarchy do you use?
Please choose the correct answer.
Response:

A. Ragged hierarchy
B. Unbalanced hierarchy
C. Parent-child hierarchy
D. Level hierarchy

Answer 269

D. Level hierarchy

Question 270

What must be installed for PAL to work?
Please choose the correct answer.
Response:

A. SAP HANA AFM
B. SAP HANA AFL
C. SAP HANA BFL
D. SAP HANA SINA

Answer 270

B. SAP HANA AFL

Question 271

You have a cube calculation view that consumes a dimension view. You suspect some dimension
columns have been renamed in the cube calculation view.
Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate
from?
Please choose the correct answer.
Response:

A. Database explorer
B. Where used
C. Show lineage
D. Impact Analysis

Answer 271

D. Impact Analysis

Question 272

What can you use to limit the number of records produced by a calculation view?
There are 3 correct answers to this question.
Response:

A. Domain fix values
B. Filter expressions
C. SAP client restrictions
D. Restricted columns
E. Generated columns

Answer 272

A. Domain fix values
B. Filter expressions
C. SAP client restrictions

Question 273

What PAL algorithm category can you use for supervised learning?
Please choose the correct answer.
Response:

A. Social network analysis
B. Clustering
C. Classification
D. Association

Answer 273

C. Classification

Question 274

What node uses a special configuration table to optimize performance?
Please choose the correct answer.
Response:

A. Aggregation node
B. Join node
C. Projection node
D. Union node

Answer 274

D. Union node

Question 275

In which package in SAP HANA will you find the SAP HANA Live views?
Please choose the correct answer.
Response:

A. /sap/hana/democontent
B. /public
C. /sap/hba
D. /sap/bc

Answer 275

C. /sap/hba

Question 276

Which are true statements?
There are 3 correct answers to this question.
Response:

A. SAP HANA is available in the cloud or on premise or a combination of both
B. Customers can re-use their own certified hardware components in an SAP HANA system
C. SAP HANA runs on Intel x86 and SPARC hardware platforms
D. SAP HANA can be installed only by certified engineers for production purposes
E. SAP HANA runs on Unix

Answer 276

A. SAP HANA is available in the cloud or on premise or a combination of both
B. Customers can re-use their own certified hardware components in an SAP HANA system
D. SAP HANA can be installed only by certified engineers for production purposes

Question 277

Which of the following must you consider when you define namespaces in an SAP HANA database (HDB)
module?
There are 3 correct answers to this question.
Response:

A. Two different objects can have the same name if they are assigned to different namespaces
B. Modeling content should be created before the namespace rules have been defined
C. synonyms can have different namespaces
D. A namespace is a mandatory component of the object identifier
E. The namespace defined in a design-time object must match the namespace properties of the folder in
which it is located

Answer 277

A. Two different objects can have the same name if they are assigned to different namespaces
C. synonyms can have different namespaces
D. A namespace is a mandatory component of the object identifier

Question 278

How many processing tiers do you usually find in a native SAP HANA application stack?
Please choose the correct answer.
Response:

A. 2
B. 3
C. 4
D. 1

Answer 278

A. 2

Question 279

Where will you find the Data Distribution Optimizer?
Please choose the correct answer.
Response:

A. SAP HANA Data Warehousing foundation
B. SAP S4/HANA Dictionary
C. SAP BW/4HANA
D. SAP HANA Studio

Answer 279

A. SAP HANA Data Warehousing foundation

Question 280

You are building a cube calculation view with an aggregation node that calculates total sales, based on
the data shown in the graphic.

The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE *
QUANTITY.
How do you ensure accurate results, regardless of the column in the query output?
Please choose the correct answer.
Response:

A. Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL
B. Set STATE as an aggregated column
C. Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL
D. Set the Transparent Filter property for STATE

Answer 280

C. Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL

Question 281

Which type of data are used to represent spatial information?
There are 2 correct answers to this question.
Response:

A. Raster data
B. Graph data
C. Column data
D. Vector data

Answer 281

A. Raster data
D. Vector data

Question 282

What join type should you use to see all the suppliers?
Please choose the correct answer.

Response:

A. Referential join
B. Left outer join
C. Right outer join
D. Inner join

Answer 282

C. Right outer join

Question 283

For which deployment scenario does SAP deliver prebuilt data models?
Please choose the correct answer.
Response:

A. SAP HANA as a platform
B. SAP HANA as a side-by-side accelerator
C. SAP HANA on the cloud
D. SAP HANA as an SQL Data Warehouse

Answer 283

D. SAP HANA as an SQL Data Warehouse

Question 284

An SAP HANA Live model is displayed as in invalid view in the list of models in the SAP HANA Live
browser. What could be the reason?
There are 2 correct answers to this question.
Response:

A. The model’s underlying table is not fully replicated
B. The model has been deleted
C. The model is missing an underlying table
D. The model is missing a dependent view

Answer 284

C. The model is missing an underlying table
D. The model is missing a dependent view

Question 285

You created a user-defined function with the INVOKER security option. Which user’s authorizations are
checked when the function is executed?
Please choose the correct answer.
Response:

A. The owner of the function
B. The container’s technical user
C. The user calling the function
D. The SYSTEM user

Answer 285

C. The user calling the function

Question 286

Why would you use the XS Advanced migration Assistant?
There are 2 correct answers to this question.
Response:

A. To convert attribute views to CDS VIEWS
B. To move HDI-developed calculation views to repository packages
C. TO convert analytic views to calculation views
D. To convert studio-developed objects for use with Web IDE FOR SAP HANA

Answer 286

C. TO convert analytic views to calculation views
D. To convert studio-developed objects for use with Web IDE FOR SAP HANA

Question 287

What is a role of the SAP HANA Cockpit?
Please choose the correct answer.
Response:

A. To provide KPIs to help focus on business performance
B. To provide key system performance information for one or more HANA instances
C. To secure the SAP HANA Database
D. To provide an application developer collaboration hub

Answer 287

C. To secure the SAP HANA Database

Question 288

In an XSA/HDI environment, where do you find run-time objects?
Please choose the correct answer.
Response:

A. Repository package
B. _SYS_BIC schema
C. Container schema
D. Database user schema

Answer 288

B. _SYS_BIC schema

Question 289

You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the correct answer.
Response:

A. Temporal join
B. Dynamic join
C. Relational join
D. Self-join

Answer 289

D. Self-join

Question 290

In an XSA/HDI environment, which of the following is used for source version control of calculation
views?
Please choose the correct answer.
Response:

A. CTS (Change Transport System)
B. CMS (Change Management System)
C. SAP HANA studio
D. Open-source Git

Answer 290

D. Open-source Git

Question 291

In SAP BW, when we refer to mixed modeling, what do we mean?
Response:

A. Integration of models from BW on non-HANA databases combined with SAP HANA optimized
BWmodels
B. Integration of SAP NetWeaver Components into complex SAP HANA BW models
C. Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views
D. Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA
Calculation views

Answer 291

D. Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA
Calculation views

Question 292

Using a calculation view containing the projections shown in the graphic, how would you identify which
companies sold products in January 2018 AND February 2018?
Please choose the correct answer.

Projection Sales January 2018
Projection Sales February 2018
Company Product Quantity Company Product Quantity

Response:

A. Use a full outer join
B. Use a left outer join
C. User an intersect node
D. Use a union node

Answer 292

D. Use a union node

Question 293

How do you move code to SAP HANA?
There are 2 correct answers to this question.
Response:

A. Use row tables in SAP HANA
B. Use stored procedures in SAP HANA
C. Use graphical data models in SAP HANA
D. Delete the application server

Answer 293

B. Use stored procedures in SAP HANA
C. Use graphical data models in SAP HANA

Question 294

Which of the following can a level hierarchy do?
Please choose the correct answer.
Response:

A. Show variable deepness in the data
B. Enable drilldown in a value help list
C. Have time-dependency
D. Be used for a bill of materials (BOM) structure

Answer 294

B. Enable drilldown in a value help list

Question 295

You’re creating a currency conversion. What options do you have for the Target Currency field?
There are 3 correct answers to this question.
Response:

A. Select a table type.
B. Select a column.
C. Select a fixed currency.
D. Use an input parameter.
E. Use the Derived from Table option.

Answer 295

B. Select a column.
C. Select a fixed currency.
D. Use an input parameter.

Question 296

How can you define a variable that presents its value help hierarchically?
There are 2 correct answers to this question
Response:

A. Create a parent-child hierarchy and assign it to the variable
Ensure the variables reference column is the child attribute of the hierarchy
B. Create a parent-child hierarchy and assign it to the variable
Ensure the variables reference column is the parent attribute of the hierarchy
C. Create a level hierarchy and assign it to the variable
Ensure the variables references column is the top level of the hierarchy
D. Create a level hierarchy and assign it to the variable
Ensure the variables reference column is the leaf level of the hierarchy.

Answer 296

B. Create a parent-child hierarchy and assign it to the variable
Ensure the variables reference column is the parent attribute of the hierarchy
D. Create a level hierarchy and assign it to the variable
Ensure the variables reference column is the leaf level of the hierarchy.

Question 297

What SAP HANA spatial type would you most likely use to represent the State of Colorado on a visual
application?
Please choose the correct answer.
Response:

A. Point
B. Polygon
C. Square
D. Line

Answer 297

B. Polygon

Question 298

You imported the following objects. Which of them always require an activity from you before they can
be built?
There are 2 correct answers to this question.
Response:

A. Multi-target application
B. Logical schema definition
C. SAP HANA database module
D. Synonyms definition

Answer 298

A. Multi-target application
C. SAP HANA database module

Question 299

In a calculation view, where can you use SQL?
There are 3 correct answers to this question.
Response:

A. Input parameter
B. Filter expression
C. Calculated column expression
D. Union pruning conditions
E. Aggregation node

Answer 299

A. Input parameter
B. Filter expression
C. Calculated column expression

Question 300

What type of file would you create in the SAP Web IDE for SAP HANA to do data cleaning?
Please choose the correct answer.
Response:

A. .hdbgraphworkspace
B. .hdbtabledata
C. .hdbcds
D. .hdbflowgraph

Answer 300

D. .hdbflowgraph

Question 301

What is the persistent storage layer used for?
There are 2 correct answers to this question.
Response:

A. To unload the least-used data when the memory is full
B. TO improve the parallel processing of queries
C. To enable data to be recovered if hardware fails
D. To store the data primarily used for transaction processing

Answer 301

A. To unload the least-used data when the memory is full
C. To enable data to be recovered if hardware fails

Question 302

What information can you find in the Plan Graph?
There are 2 correct answers to this question.
Response:

A. Number of records returned in each step
B. SQL Plan Cache
C. Time taken for each step
D. Execution engines used

Answer 302

A. Number of records returned in each step
C. Time taken for each step

Question 303

In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings
to a coarser interval?
Please choose the correct answer.
Response:

A. Horizontal disaggregation
B. Horizontal aggregation
C. Vertical aggregation
D. Vertical disaggregation

Answer 303

B. Horizontal aggregation

Question 304

What are the values for X, Y, and Z?
Please choose the correct answer.

Response:

A. X = Customer 2, Y = 200, Z = 400
B. X = Customer 1, Y = 400, Z = 400
C. X = Customer 1, Y = 800, Z = 800
D. X = Customer 2, Y = 400, Z = 800

Answer 304

B. X = Customer 1, Y = 400, Z = 400

Question 305

Which technologies does SAP HANA use to load more data into memory?
There are 3 correct answers to this question.

Response:

A. Use ZIP compression
B. Store data in column tables
C. Eliminate indices
D. Use dictionary compression
E. Use multicore CPU parallelism

Answer 305

B. Store data in column tables
C. Eliminate indices
D. Use dictionary compression

Question 306

Your calculation view presents employee names which must only be seen by managers. Which steps are
required to implement this?
There are 2 correct answers to this question.
Response:

A. Set the column to hidden in the calculation view
B. Assign the UNMASK privilege to the managers for the calculation view
C. Include an anonymization node in the calculation view
D. Create SQL expression to define the concealing logic for the column

Answer 306

C. Include an anonymization node in the calculation view
D. Create SQL expression to define the concealing logic for the column

Question 307

For which deployment scenario does SAP deliver prebuilt data models?
Please choose the correct answer.
Response:

A. SAP HANA as an SQL Data Warehouse
B. SAP HANA as a side-by-side accelerator
C. SAP HANA as a platform
D. SAP HANA on the cloud

Answer 307

A. SAP HANA as an SQL Data Warehouse

Question 308

What is the persistent storage layer used for?
There are 2 correct answers to this question.
Response:

A. TO improve the parallel processing of queries
B. To store the data primarily used for transaction processing
C. To unload the least-used data when the memory is full
D. To enable data to be recovered if hardware fails

Answer 308

C. To unload the least-used data when the memory is full
D. To enable data to be recovered if hardware fails

Question 309

You want to show a male and female option to end users. What feature do you use?
There are 3 correct answers to this question.
Response:

A. Input parameters
B. Domain fix values
C. Value help
D. Variables
E. Expressions

Answer 309

A. Input parameters
C. Value help
D. Variables

Question 310

Using a calculation view containing the projections shown in the graphic, how would you identify which
companies sold products in January 2018 AND February 2018?
Please choose the correct answer.
Projection Sales January 2018
Projection Sales February 2018
Company Product Quantity Company Product Quantity

Response:

A. Use a union node
B. Use a left outer join
C. User an intersect node
D. Use a full outer join

Answer 310

A. Use a union node

Question 311

Which deployment scenario can you use to accelerate reporting from an old SAP R/3 system?
Please choose the correct answer.
Response:

A. SAP HANA as a side-by-side accelerator
B. SAP HANA as a platform
C. SAP HANA Multitenant Database Containers (MDC)
D. SAP HANA as a database

Answer 311

A. SAP HANA as a side-by-side accelerator

Question 312

An SAP HANA Live model is displayed as in invalid view in the list of models in the SAP HANA Live
browser. What could be the reason?
There are 2 correct answers to this question.
Response:

A. The model has been deleted
B. The model is missing a dependent view
C. The model’s underlying table is not fully replicated
D. The model is missing an underlying table

Answer 312

B. The model is missing a dependent view
D. The model is missing an underlying table

Question 313

What performance technique should you implement to improve the performance of SAP HANA
information views?
Please choose the correct answer.
Response:

A. Output as many fields as possible.
B. Implement union pruning conditions.
C. Supply reporting tools with all the data in one transfer.
D. Build single large views.

Answer 313

B. Implement union pruning conditions.

Question 314

What are features of SAP S/4HANA?
There are 2 correct answers to this question.
Response:

A. Optimized for SAP HANA but maintains compatibility with other platforms
B. Embedded Analytics
C. SAP HANA Live provides real time operational analytics
D. Rewritten ABAP code optimized for SAP HANA

Answer 314

B. Embedded Analytics
D. Rewritten ABAP code optimized for SAP HANA

Question 315

Using the table in the diagram, you need to create a cube calculation view. What is the simplest
approach to create the output form the screenshot?
Please choose the correct answer.
Table A Output A
Year Value 2014 2015 2016
2014 100 300 500 200
2014 200
2015 100
2015 100
2015 200
2015 100
2015 200
Response:

A. Implement a union node and map each year as a separate column
B. Create a restricted column for each year
C. Create a filter expression that uses an OR operator

Answer 315

A. Implement a union node and map each year as a separate column

Question 316

Which of the following benefits characterize the use of a design time filter?
There are 3 correct answers to this question.
Response:

A. The filter is applied on the result set of a query.
B. It reduces the result set of data.
C. It is defined on the runtime in the SQL query.
D. It is applied before a table join is executed.
E. The filter is applied on the table before the query is executed.

Answer 316

B. It reduces the result set of data.
D. It is applied before a table join is executed.
E. The filter is applied on the table before the query is executed.

Question 317

What are advantages of column store tables?
There are 3 correct answers to this question.
Response:

A. Data footprint is automatically reduced through compression
B. Columns can be partitioned
C. They are optimized for high-volume read / write transactional processing
D. Only the columns required are actually loaded to memory

Answer 317

A. Data footprint is automatically reduced through compression
B. Columns can be partitioned
D. Only the columns required are actually loaded to memory

Question 318

On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP
Microsoft Excel and Apache Hadoop and load the data into SAP HANA.
Which tools can you use?
There are 2 correct answers to this question.
Response:

A. SAP HANA smart data access
B. SAP Data Services
C. SAP Landscape Transformation Replication Server
D. SAP HANA smart data integration

Answer 318

B. SAP Data Services
C. SAP Landscape Transformation Replication Server

Question 319

Why do you use SAP HANA Graph?
Please choose the correct answer.
Response:

A. To access advanced chart types from calculation views
B. To model highly-networked entities
C. To develop a dashboard to present KPIs
D. To push down graphic processing of the database

Answer 319

B. To model highly-networked entities

Question 320

What do you have to assign to users to allow Single Sign-On (SSO)?
Please choose the correct answer.
Response:

A. Kerberos authentication
B. TRUST ADMIN system privilege
C. Application privileges
D. SQL analytic privileges

Answer 320

A. Kerberos authentication

Question 321

In an XSA/HDI environment, where do you find run-time objects?
Please choose the correct answer.
Response:

A. Database user schema
B. Container schema
C. Repository package
D. _SYS_BIC schema

Answer 321

D. _SYS_BIC schema

Question 322

In a calculation view, what should you consider when you create an input parameter that derives its
value from a user-defined function?
There are 2 correct answers to this question.
Response:

A. The function must be of the type scalar.
B. The input parameter must be set to mandatory.
C. The generated value can be overwritten at runtime.
D. The function can return multiple values.

Answer 322

A. The function must be of the type scalar.
C. The generated value can be overwritten at runtime.

Question 323

Which of the following tools is used to analyze dependencies between models?
Choose the correct answers.
A Data lineage
B Column lineage
C Impact analysis

Answer 323

A Data lineage
C Impact analysis

Question 324

In a full stack application development project using Web IDE XS Advanced, which are provided by an HDB module?
Choose the correct answers.

A Persistence layer
B User interface
C Business logic
D Data modeling layer

Answer 324

A Persistence layer
D Data modeling layer

Question 325

An XS Advanced project can contain multiple HDB modules.

Determine whether this statement is true or false.

True
False

Answer 325

True

Question 326

The database objects defined in design-time files located in the same project folder can have different namespaces.

Determine whether this statement is true or false.

True
False

Answer 326

False

Question 327

A HDB module always corresponds to a physical database schema.
Determine whether this statement is true or false.

True
False

Answer 327

True

Question 328

You have successfully built a project that you imported into the SAP Web IDE workspace, but you cannot see the corresponding runtime database objects in the Database Explorer. What could be the reason?
Choose the correct answer.
A The project is not assigned to a Space.
B Building a project does not generate the database objects defined in its HDB modules.
C You do not have the Developer role in the assigned Space.

Answer 328

B Building a project does not generate the database objects defined in its HDB modules.

Question 329

A calculation view CV1 has been created in your project folder but has never been built. Your perform a build of another calculation view CV2 that consumes CV1. The CV1 file will be included in the build of CV2.
Determine whether this statement is true or false.

True

False

Answer 329

False

Question 330

Which spatial data formats can you import into SAP HANA?
There are 2 correct answers to this question.

Response:

A GeoJSON
B Well-Known Text (WKT)
C ESRI shapefiles
D Scalable Vector Graphic (SVG)

Answer 330

A GeoJSON - Help shows this too
C ESRI shapefiles
B Well-Known Text (WKT)

Question 331

Which words are associated with the log volume?
There are 2 correct answers to this question.

Response:

A Synchronous
B Transaction manager
C Page manager
D Savepoint

Answer 331

A Synchronous
B Transaction manager

Question 332

Which modeling features can you use in flowgraphs?
There are 2 correct answers to this question.

Response:

A Graph
B Spatial
C Text
D Predictive

Answer 332

B Spatial
D Predictive

Question 333

Why do you use Debug Query mode in a calculation view?
Please choose the correct answer.

Response:

A To check which database engines will be invoked by each node?
B To check if SAP HANA can paralyze the entire query
C To observe the generated SQL for each node
D To measure the overall run-time of the query

Answer 333

C To observe the generated SQL for each node

Question 334

In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully?
There are 2 correct answers to this question.

Response:

A Explicitly build the HDB module instead of the project
B Ensure that you have only one HDB module in your project
C Assign the project to a space to which you have developer authorizations
D Ensure that the name of your HDB module is included in the corresponding schema names

Answer 334

C Assign the project to a space to which you have developer authorizations

D Ensure that the name of your HDB module is included in the corresponding schema names

Question 335

Which join types are available in a Join node of a calculation view?
There are 2 correct answers to this question.

Response:

A Temporal joins
B Referential joins
C Cross joins
D Spatial joins

Answer 335

B Referential joins
D Spatial joins

Question 336

In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function?
There are 2 correct answers to this question.

Response:

A The function can return multiple values.

B The input parameter must be set to mandatory.

C The function must be of the type scalar.

D The generated value can be overwritten at runtime.

Answer 336

C The function must be of the type scalar.

D The generated value can be overwritten at runtime.

Question 337

Why does query performance decrease when the data volume of the delta storage is large?
There are 2 correct answers to this question.

Response:

A The data is stored in the warm tier.

B The data is unstructured.

C The data is uncompressed.

D The data is NOT sorted.

Answer 337

B The data is unstructured.
D The data is NOT sorted.

Question 338

How does SQL Script extend SQL?
There are 3 correct answers to this question.

Response:

A It improves push-down opportunities.

B It allows an alternative syntax to simplify expressions.

C It enables usage of variables to break up complex code.

D It provides the data definition language (DDL) to create column tables.

E It adds imperative expressions to control data flow.

Answer 338

C It enables usage of variables to break up complex code.

D It provides the data definition language (DDL) to create column tables.

E It adds imperative expressions to control data flow.

Question 339

Why do we support SQL development in SAP HANA data modelling projects?
Please choose the correct answer.

Response:

A As an alternative to developing calculation views when high performance is essential

B To make changes to the runtime objects of your calculation view with SQL

C To support development of custom logic within calculation views

D To provide access to your data model to additional client tools.

Answer 339

C To support development of custom logic within calculation views