HANA300 Flashcards by Chris Jones

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

C. SDQ

How well did you know this?

Not at all

Perfectly

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

C. Procedure

How well did you know this?

Not at all

Perfectly

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

C. Data transformation
D. For data loading

How well did you know this?

Not at all

Perfectly

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

D. In a Projection node

How well did you know this?

Not at all

Perfectly

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.

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

How well did you know this?

Not at all

Perfectly

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

A. Spatial joins
B. Referential joins

How well did you know this?

Not at all

Perfectly

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

B. Native DataStore Object
D. Data Lifecycle Manager

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

C. Apache Hadoop
D. Apache Spark

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

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.

C. Set the Empty Union Behavior property.

How well did you know this?

Not at all

Perfectly

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.

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

How well did you know this?

Not at all

Perfectly

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

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

B. JOIN

How well did you know this?

Not at all

Perfectly

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

D. Aggregation node

How well did you know this?

Not at all

Perfectly

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

C. Reuse views

How well did you know this?

Not at all

Perfectly

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

D. Inner join

How well did you know this?

Not at all

Perfectly

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

A. Roles to roles
D. Roles to users

How well did you know this?

Not at all

Perfectly

What are components of SAP HANA EIM? There are 2 correct answers to this question. Response: A. SDA B. SDI C. SDS D. SDQ

B. SDI D. SDQ

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

C. SAP Web IDE for SAP HANA

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

A. Impact analysis D. Data lineage

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

D. Flowgraph

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.

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

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

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

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

A. Vertex B. Edge

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

D. SAP Analysis for Microsoft Office

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

A. Public cloud

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

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

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

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

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

D. Calculation views of data category cube without star join

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

C. Synonym

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

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

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

A. WITH RESULTS VIEW B. READS SQL DATA

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

C. R D. SQLScript

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

B. Multicore processors D. Larger and cheaper memory

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

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

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

C. Inner join

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

A. Predictive B. Spatial

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

D. Analytic privilege

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

C. Projection node D. Union node

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

C. From the underlying dimension views

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

B. WHERE clause D. JOIN condition

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.

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

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

A. Operational reporting moving back to the OLTP system

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

B. For currencies with more than two decimal places

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

C. SAP Lumira, discovery edition

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

A. A native, lightweight application server

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

B. Calculation views from other tenants in an MDC system

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

B. High availability C. Failover

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

A. Testing D. Correcting E. Validation

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

B. Improving your modeling design

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

C. Microsoft Excel

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.

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

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.

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.

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

B. Sentiments D. Requests

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

B. The mapping property

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

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

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.

C. They introduce security risks due to SQL injection

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

B. BW models combined with native SAP HANA models

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

A. Lazy load

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

A. JSON C. OData E. REST

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

B. Index server

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

D. A flowgraph

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.

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

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

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

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

A. In the SAP HANA database

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

A. Calculation views of data category cube without star join

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

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

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

A. CONTAINS

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

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

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.

C. Mark the field as hidden.

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

B. MDX C. ODBO D. BICS

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

B. Advanced DataStore Object

B. Sentiments D. Requests

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

A. ODBO B. JDBC D. ODBC

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

B. Microsoft Excel

B. Calculation views from other tenants in an MDC system

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

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

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

B. Build the project -> Build th HDB module

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

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

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

C. Temporal join

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

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

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

C. Column

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

D. Interval

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

C. Low

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

C. Edge D. Vertex

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

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

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

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

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

A. The nodes themselves

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

B. Text mining C. Fuzzy text search

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.

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.

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

A. Lines C. Polygons D. Points

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

C. Core Data Services

C. SAP Lumira, discovery edition

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.

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.

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

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

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

C. Range

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

A. Underlying calculation views and tables

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

B. The mapping property

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.

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

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.

D. Break large statements into smaller steps.

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

C. Variable

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

D. Point

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.

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.

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

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

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

A. Table function D. SQL VIEW

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

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

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

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

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

C. 9 Rows

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)

B. : (colon)

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

C. Inner join

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

C. Measures

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

A. Cypher Query Language D. GraphScript

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

D. Dynamic Partition Elements

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

C. SELECT *

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

A. 3 B. 2

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.

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.

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

A. SQL Plan Cache C. Trace and log files

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

A. Real-time C. Duplicate data

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

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

What does the C in ACID-compliant stand for? Please choose the correct answer. Response: A. Complete B. Complexity C. Consistency D. Constant

C. Consistency

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

A. Delta storage C. Main storage

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

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

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.

B. The hierarchy is a level type.

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

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

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

D. Calculation view of type cube with star join

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

C. Master data

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.

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.

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

D. SAP Business Suite

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

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

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

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

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.

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

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.

C. It acts based on combinations of events

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

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

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

A. JavaScript B. SAPUI5

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

B. Procedure

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

B. Synonyms D. Aggregates

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

D. Apriori

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

B. Scalar function

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

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

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?

B. To observe the generated SQL for each node

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.

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

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

A. ABAP CDS

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

A. Transaction manager C. Synchronous

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

B. Shared hierarchies in a star join view

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()

D. SCORE()

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

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

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

A. In the semantic layer of the calculation view

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.

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

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

A. SAP Web IDE for SAP HANA

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

C. SAP Crystal Reports for Enterprise

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.

A. Extraction of key facts from a business article.

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

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

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

C. To access data from a classic database schema

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.

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

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

C. Round-robin D. Hash E. Range

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.

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.

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

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

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

A. SDA B. SDI D. SAP Vora

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.

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

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. D. Null

B. THE source amount D. Null

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

D. Referential join

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

A. The build is successful but the is NOT present

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

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

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

A. An analytic privilege on both calculation views

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

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

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

C. Extract - Transform - Load

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

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

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

B. Read-optimized

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.

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.

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

B. ST_MultiPoint

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.

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.

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.

B. Create a .hdbprocedure file.

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

D. SAP Analysis for Microsoft Office

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

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

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

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

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

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

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

D. Calculation view of dimension type with a union node

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

D. ABAP CDS

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

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

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

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

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.

A. Change the Apply Privileges property of the view.

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

B. Text analysis

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

B. When referential integrity is assured

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.

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.

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

D. /sap/hba

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.

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

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

A. MDX B. SQL

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

B. Always as the bottom (leaf) node

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

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

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

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

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

B. An input parameter from the Semantics node

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

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

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

C. Union

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.

D. To identify the longest running SQL statements.

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

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

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

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

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

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

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.

D. You did NOT enable the Keep Flag.

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

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

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.

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.

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.

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

To what subset of SQL does the SELECT statement belong? Please choose the correct answer. Response: A. DDL B. DML C. DQL D. DCL

C. DQL

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

B. Vertices that are closely connected

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

D. From the Join nodes up to the semantics node

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

C. Data preparation functions D. Predictive algorithms

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()

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

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

E. Temporal Join

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

B. Rank node

What character is used to terminate SQL statements? Please choose the correct answer. Response: A. : (colon) B. ; (semicolon) C. ? (question mark) D. . (period)

B. ; (semicolon)

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

C. Projection

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

C. ABAP CDS

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

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

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

A. Select a space for running the project

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

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

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.

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.

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

B Log area C Data volume

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

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

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

B Insert-only

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

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

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

A Text join

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

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

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

C SAP HANA XSA Administration tool

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.

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

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

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

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

B Projection

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

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

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.

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

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.

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

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.

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

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.

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

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

A Rule Set B Configuration E Dictionary

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.

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

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.

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

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.

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

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

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

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

B. Multistore tables

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

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

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.

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

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.

B. They can use imperative logic.

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.

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

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.

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.

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.

B. To identify the longest running SQL statements.

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

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

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

A. ONLY the required columns and the required partitions

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

A. Time

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

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

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

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

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.

C. They can use imperative logic.

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

A. Composite B. Basic

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

A. Query views C. Value help views

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.

A. Store green as an attribute.

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

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

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

D. Level hierarchy

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

B. SAP HANA AFL

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

D. Impact Analysis

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

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

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

C. Classification

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

D. Union node

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

C. /sap/hba

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

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

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

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

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

A. 2

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

A. SAP HANA Data Warehousing foundation

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

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

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

A. Raster data D. Vector data

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

C. Right outer join

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

D. SAP HANA as an SQL Data Warehouse

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

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

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

C. The user calling the function

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

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

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

C. To secure the SAP HANA Database

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

B. _SYS_BIC schema

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

D. Self-join

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

D. Open-source Git

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

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

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

D. Use a union node

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

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

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

B. Enable drilldown in a value help list

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.

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

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.

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.

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

B. Polygon

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

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

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

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

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

D. .hdbflowgraph

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

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

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

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

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

B. Horizontal aggregation

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

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

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

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

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

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

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

A. SAP HANA as an SQL Data Warehouse

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

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

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

A. Input parameters C. Value help D. Variables

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

A. Use a union node

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

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

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

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

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.

B. Implement union pruning conditions.

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

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

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

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

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.

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.

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

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

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

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

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

B. To model highly-networked entities

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

A. Kerberos authentication

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

D. _SYS_BIC schema

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.

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

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

A Data lineage C Impact analysis

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

A Persistence layer D Data modeling layer

An XS Advanced project can contain multiple HDB modules. Determine whether this statement is true or false. True False

True

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

False

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

True

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.

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

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

False

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)

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

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

A Synchronous B Transaction manager

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

B Spatial D Predictive

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

C To observe the generated SQL for each node

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

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

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

B Referential joins D Spatial joins

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.

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

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.

B The data is unstructured. D The data is NOT sorted.

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.

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.

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.

C To support development of custom logic within calculation views

HANA300 Flashcards

(339 cards)