SAP HANA 2.0 (SPS05)(C_HANAIMP_17)_v1.

Question. 1
Why does query performance decrease when the data volume of
the delta storage is large? Note: There are 2 correct answers to
this question.

The data is NOT sorted.

The data is uncompressed.

The data is unstructured.

The data is stored in the warm tier.

Answers A B

Question. 2
You are a data analyst working with medical records that
contain confidential patient information. Why do you use the
anonymization node in a calculation view? Note: There are 2
correct answers to this question.

To provide partial column values such as June-07-19##

To add noise to the data to hide the actual values

To restrict data access for specific users or roles

To hide individual patients in groups of similar records

Answers B D
Question. 3
In an XS Advanced project, what is the purpose of the .hdiconfig
file?

To specify in which space the container should be deployed

To specify an external schema in which calculation views will

get their data

To specify the namespace rules applicable to the name of

database objects

To specify the version of the HDI plug-ins that should be used

Answers D

Question. 4
Which of the following supports data replication?

SAP HANA smart data access

SAP HANA smart data integration

SAP HANA smart data quality

SAP HANA, streaming analytics option

Answers B
Question. 5
How can you define a variable that presents its value help
hierarchically? Note: There are 2 correct answers to this question.

Create a level hierarchy and assign it to the variable. Ensure the

variable's reference column is the leaf level of the hierarchy.

Create a parent-child hierarchy and assign it to the variable.

Ensure the variable's reference column is the child attribute of
the hierarchy.

Create a level hierarchy and assign it to the variable. Ensure the

variable's reference column is the top level of the hierarchy.

Create a parent-child hierarchy and assign it to the variable.

Ensure the variable's reference column is the parent attribute of
the hierarchy.

Answers A C

Question. 6
When you create a full text index, why do you specify
FAST_PREPROCESS OFF?

To generate text analysis results in multiple languages

To avoid the generation of the term document matrix

To prevent the creation of a fuzzy search index

To enable a full linguistic search

Answers D

Question. 7
Which of the following are warm data tier solutions? Note: There
are 3 correct answers to this question.

Extension Node

Dynamic Tiering

Native Storage Extension

Active / active read-enabled mode

Persistent memory

Answers A B E

Question. 8
What type of data is relevant for SAP HANA Graph modeling?

Highly networked

Hierarchical data

Time series
Forecast

Answers A

Question. 9
What does SAP HANA provide to support native application
development?

Incident tracking tools

Tools for code creation and debugging

Choice of development language

Tools to support automated regression testing

Full stack development

Answers C

Question. 10
You created a table and inserted data in it using SQL
statements inside the SAP HANA Deployment Infrastructure
(HDI) container of your project. You add this table as a data
source to a calculation view and try to build it. What do you
observe in the SAP HANA database container?

The build fails and the table is not dropped.

The build is successful and you get the expected data.

The build fails and the table is dropped.

The build is successful and the data preview is empty.

Answers D

Question. 11
You have created attribute views and analytic views in the SAP
HANA 1.0 XS Classic environment using SAP HANA Studio.
You want to migrate them to the new XS Advanced environment
of SAP HANA 2.0 SPS05. What is the sequence of the
activities?

Convert attribute views and analytic views to calculation views.

Migrate calculation views using the migration assistant.
Import the .zip file into the SAP Web IDE workspace

Import the .zip file into the SAP Web IDE workspace. Migrate
calculation views using migration assistant. Convert attribute
views and analytic views to calculation views

Migrate calculation views using migration assistant. Convert

attribute views and analytic views to calculation views. Import
the .zip file into the SAP Web IDE workspace

Import the .zip file into the SAP Web IDE workspace. Convert
attribute views and analytic views to calculation views. Migrate
calculation views using the migration assistant
Answers A

Question. 12
Why would you implement a graph neighborhood search?

Vertices that contain the same attributes

Edges that contain the same attributes

Vertices that are closely connected

The shortest path between vertices

Answers C

Question. 13
You created a calculation view that combines two tables in a join
node. To improve the runtime of your calculation view, you use a
referential join to prune data sources. How do you check if
pruning occurs? Note: There are 2 correct answers to this
question.

Use the SQL Analyzer to identify the tables used

Enable Debug Query mode to identify the columns used

Explore the number of used columns in the Performance

Analysis mode
Preview the data results in the calculation view

Answers B C

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

Control the flow logic using IF-THEN-ELSE conditions.

Increase parallelization by using variables to break up

statements.

Use declarative language instead of cursors.

Use calculation engine (CE) functions instead of plain SQL.

Answers B C

Question. 15
Why might you use the Keep Flag property in an aggregation
node?

To retain the correct aggregation behavior in stacked views

To exclude columns that are NOT requested by a query to avoid

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

To ensure that the aggregation behavior defined in the

aggregation node for a measure CANNOT be overridden by a
query

Answers C

Question. 16
In a calculation view, where can you write SQL code? Note: There
are 3 correct answers to this question.

Filter expression

Input parameter

Calculated column expression

Currency conversion

Parent-child hierarchy

Answers A B C

Question. 17
What can you identify using Performance Analysis mode?
Note: There are 2 correct answers to this question.
Joins that are defined on calculated columns

Information about join cardinality

Usage statistics of the calculation view

If the data is in the hot or warm storage tier

Answers A B

Question. 18
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?

Label column

Where used

Impact analysis

Show lineage

Answers D
Question. 19
Which are functions of SAP HANA series data? Note: There are
2 correct answers to this question.

Identify abnormal observations.

Anonymize observations.

Geo-code observations.

Align observations to a consistent time interval.

Answers C D

Question. 20
Why should you define calculated column expressions using
plain SQL and avoid using column engine language?

To access the full set of SQL functions

To benefit from additional SQL optimizations

To allow imperative statements

To prevent queries from unfolding

Answers B
Question. 21
Why would you develop an SQL procedure instead of a
function?

The code should modify data in the table.

You want to create a dynamic analytic privilege.

Optimal performance is a priority.

You need to use conditional logic.

A temporary table must be created within the code.

Answers A

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

Limit the number of joined columns.

Specify the join cardinality.

Determine join direction in a full outer join.

Use an inner join.

Answers A B
Question. 23
What are the key steps to implement currency conversion in a
calculation view?

Enable the measure for conversion. Choose client, source, and

target currencies. Choose conversion date and rate type. Build
the conversion rule

Assign semantic type. Enable the measure for conversion.

Choose client, source and target currencies. Choose conversion
date and rate type

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

Assign semantic type. Choose client, source and target

currencies. Choose conversion date and rate type .Define an
expression in a calculated column

Answers B

Question. 24
Which are the components of SAP HANA Cloud? Note: There are
2 correct answers to this question.

Native Storage Extension

SAP Data Warehouse Cloud

SAP Analytics Cloud

SAP HANA Cloud data lake

SAP HANA in-memory database

Answers B C

Question. 25
What are the benefits of SQL development in calculation view
modeling?

To develop models for optimal performance

To enable changes to data sources

To provide an alternative to graphical modeling

To implement custom logic

Answers D

Question. 26
Why do you use the Hidden Columns checkbox in the semantics
node of your calculation view? Note: There are 2 correct answers
to this question.

To ensure specific columns are NOT exposed to the reporting tool

To avoid exposing sensitive columns when defining calculated

columns
To remove a column that is also used as a Label column

To prevent passing columns in stacked calculation views

Answers A D

Question. 27
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?

Projection

Union

Join

Aggregation

Answers A

Question. 28
Why would you create a multistore table?
To improve read performance when the table is accessed by
simultaneous applications

To evenly distribute the data across all available server nodes

To implement a table that combines the features of row and

column store

To have the option to partition the table across different storage

tiers

Answers D

Question. 29
When modeling in the SAP Web IDE for SAP HANA, which
object do you build to provide access to tables in external
schemas?

Synonym

Virtual Table

Alias

Association

Answers A
Question. 30
Why would you implement active / active read-enabled mode?
Note: There are 2 correct answers to this question.

To provide offline access to data

To synchronize query results with operational data

To improve query performance

To enhance security for data access

Answers B D

Question. 31
You create a table function to remove historic records, sum the
current total weekly working hours for each employee, and
update the personnel table with the results. The build of the table
function fails. Which of the following could be a valid reason?

You did not define at least one input parameter.

You did NOT define a valid table type.

Your function includes a TRUNCATE statement.

Your function refers to a scalar function.

Answers C
Question. 32
Why do you use the Transparent Filter property in a calculation
view?

To avoid columns being unnecessarily used in a Group By

clause

To allow filter push-down in stacked calculation views

To apply default filters that are hidden to the end user

To include columns that are NOT requested by a query

Answers A

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

A partitioning column must be defined

Only one block can be defined across a calculation view stack

It must begin with a data source of the type table

You can define only one per calculation view

Only one start node can be defined

Answers C D E
Question. 34
Why do you use Debug Query mode in a calculation view?

To highlight potential performance issues at design time

To observe the generated SQL for each node

To display the input parameter values using breakpoints

To check which database engines will be invoked by each node

Answers B

Question. 35
After importing a project in the workspace of the SAP Web IDE,
you execute a build at the HDB module level. The build fails.
What could be the reason? Note: There are 2 correct answers to
this question.

Your HDB module references a user-provided service that does

not exist.

You have not defined the HDI build plug-in version.

You have not assigned the project to a space.

You have not built the project yet.

Answers A C
Question. 36
Why do you create calculation views of data category
DIMENSION with type TIME?

To provide the time intervals required by time-dependent parent-

child hierarchies

To provide additional time-related navigation possibilities

To store historical versions of attributes

To add a temporal condition to a join to find matching records

from two tables based on a date

Answers B

Question. 37
Which of the following are usually not required in the
architecture of SAP S/4HANA? Note: There are 2 correct
answers to this question.

Views

Partitions

Stored aggregates

Indexes
Answers A C

Question. 38
You combine two customer master data tables with a union node
in a calculation view. Both of the master data tables include the
same customer name. The same customer can exist in both
tables. How do you ensure that each customer appears only once
in the results?

Define a restricted column in a union node.

Include an aggregation node above the union node.

Add an intersect node above the union node.

In the union node, map both source customer name columns to

one target column.

Answers D

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

To allow data analysis at different levels of granularity with

the same calculation view
To ensure that the aggregation always happens after the join
execution

To force the calculation at the relevant level of granularity, even

if this level is not the grouping level defined by the query

To ensure that the join execution only uses the join columns
requested in the query

Answers A C

Question. 40
You import a project that includes an SAP HANA database
(HDB) module to your workspace. You need to create a
calculation view that uses data from a table located in an
external schema within the same local database. Which of the
following items do you need? Note: There are 2 correct answers to
this question.

SQL view

Remote source

Authorization

Synonym

Answers C D
Question. 41
In SAP Web IDE, you rename a dimension calculation view that
is used by a cube calculation view. You do NOT use the option to
rename the runtime view and adjust the reference. Afterward,
you perform the following build operations: Build the dimension
calculation view as a single object. Build the entire SAP HANA
database module. What is the outcome of the build operations?

The first build fails. The second build fails.

The first build is successful. The second build fails.

The first build fails. The second build is successful.

The first build is successful. The second build is successful.

Answers D

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

Partition large tables.

Implement union pruning.

Limit the number of stacked calculation views.

Avoid aggregating data early in the data flow.

Answers A C
Question. 43
You decide to implement SAP S/4HANA in a private cloud,
managed by SAP. Which solution do you choose?

SAP Cloud Platform

SAP HANA Cloud

SAP HANA Enterprise Cloud

SAP S/4HANA Cloud

Answers C

Question. 44
What are some best practices when developing calculation views?
Note: There are 2 correct answers to this question.

Include all data flow logic within one calculation view.

Avoid mixing CDS views with calculation views.

Create calculation views that can be unfolded.

Create star schemas using analytic views.

Answers B D
Question. 45
Which of the following are capabilities of SAP HANA smart
data access? Note: There are 2 correct answers to this question.

Push-down of queries to remote data sources

Exposure of real-time data from remote tables

Replication of remote data

Cleansing and harmonization of data from disparate sources

Answers A B

Question. 46
What do you use in the definition of a dynamic SQL analytic
privilege?

A procedure that returns the data access condition as an SQL

expression

An organization hierarchy that provides role-based access to

data

A table function that returns a list of allowed values

A scalar function that returns a list of the allowed values for

each attribute

Answers A
Question. 47
After implementing static cache in a calculation view, you
notice that queries are not hitting the cache. What might be the
reason for this?

You did not define any columns in the cache setting.

Your calculation view checks analytic privileges.

Your calculation view can be fully unfolded.

You set the hint to use cache at the top-most calculation view.

Answers B

Question. 48
You have imported a new calculation view in a folder that
contains an .hdinamespace file. This calculation view consumes
one data source which is a table. When trying to build the
calculation view, there is a namespace-related issue and the
build fails. What could be the reason? Note: There are 2 correct
answers to this question.

The imported calculation view and its data source have different
namespaces.

The .hdinamespace specifies "sub-folder":"append", so calculation

views can only be created in subfolders.
The namespace used within the calculation view to reference the
table is different from the actual namespace in the identifier of
this table.

The .hdinamespace file specifies a different namespace property

than the one in the identifier of the calculation view.

Answers A C

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

Scalar function

Table function

Procedure

Row table

Answers B D

Question. 50
In a calculation view, what is the purpose of a variable?

To pass values between procedures and calculation views

To filter an attribute at run-time based on a user input

To provide a dynamic value in a calculated column

To break up complex SQL into smaller steps

Answers B

Question. 51
You have made changes to the design-time files of several
calculation views in your DEV environment. These calculation
views all belong to the same project.Before deploying your
calculation views to a PROD environment, which sequence of
steps is required in the DEV environment?

Build the HDB module -> Build the project

Activate the project -> Build the HDB module

Export the HDB module -> Export the project

Build the project -> Build the HDB module

Answers D

Question. 52
Why would you build a calculation view of type SQL Access
only?
To provide a high performance model when only attributes are
required

To provide a data source that can only be consumed by a

function or procedure

To enable SQL access to your hierarchies

To provide a data source that is only consumed by other

calculation views

Answers D

Question. 53
Which of the following is required to use predictive modeling in
SAP HANA 2? Note: There are 2 correct answers in this
question.

Installation of the Business Function Library

Authorizations for calling Predictive Analysis Library

procedures

Deployment of a data provisioning agent

Installation of the Application Function Library

Answers
Question. 54
Which tool should you use to generate and execute the SQL for a
specific node of your calculation view?

Explain Plan

Debug Query Mode

SQL Analyzer

Database Explorer

Answers B

Question. 55
What restrictions apply to a graph node that you include in a
calculation view?

It cannot be included in a calculation view of type dimension.

It must be the first node in the data flow.

It must be the final node in the data flow.

Its data source must be provided by a projection node.

Answers B
Question. 56
Why do you use parameter mapping in a calculation view? Note:
There are 2 correct answers to this question.

To enable an input parameter in a calculation view

To pass variable values to external value help views

To push down filters to the lowest level calculation views

To convert the data types of input parameters

Answers A C

Question. 57
What are the limitations of using a full outer join in a star join
node? Note: There are 2 correct answers to this question.

It is restricted to one dimension in a star join node.

It CANNOT be mixed in the same star join node with other join
types.

It is NOT available in a star join node.

It must appear in the last dimension in the star join node.

Answers A D
Question. 58
You want to join 2 tables in a calculation view. Why do you use
a non-equi join?

The number of joined columns is different in each table.

Join columns need to be ignored when NOT requested by the

query.

The join condition is not represented by matching values.

Join columns do not have the same data type.

Answers A

Question. 59
Why do you partition a table in SAP HANA?. Note: There are 2
correct answers to this question.

To improve query performance when accessing large column

tables

To improve loading performance on large row tables

To overcome the two billion record limit

To improve response time when multiple users access the same

table

Answers A B
Question. 60
You want to create a star schema using a calculation view. The
measures are based on columns from two transaction tables.
Dimension calculation views provide the attributes. What is the
correct approach?

Combine the transaction tables using a join node in a

calculation view of type cube with star join. Use a star join node
to join the dimensions to the fact table.

Combine the transaction tables using a star join node in a

calculation view of type cube with star join. Use a join node to
join the dimensions to the fact table.

Combine the transaction tables using an aggregation node in a

calculation view of type cube with star join. Use a star join node
to join the dimensions to the fact table.

Combine the transaction tables using a star join node in a

calculation view of type cube with star join. Use the same star
join node to connect the dimensions to the fact table.

Answers A
Question. 61
In your calculation view, you want to consume a custom data
source defined using SQLScript. In which type of object do you
write your code?

CDS view

Table function

Scalar function

Procedure

Answers B

Question. 62
Why does SAP issue warnings about the use of imperative or
procedural SQLScript statements?

They could modify the database.

They can harm SQL optimization.

They call multiple processing engines.

They introduce potential security risks.

Answers D
Question. 63
Which options do you have to handle orphan nodes in your
hierarchy? Note: There are 2 correct answers to this question.

Assign them to a level below the root.

Define an expression to determine a parent.

Generate additional root nodes.

Assign them to a node at the root level.

Answers A D

Question. 64
You define a hierarchy in a calculation view. You want to expose
the hierarchy to SQL. Which of the following conditions must be
met?

The hierarchy must be a local hierarchy.

The hierarchy must be exposed by a calculation view of type

CUBE with star join.

The hierarchy must be a shared hierarchy.

The hierarchy must be defined in a calculation view of type SQL

ACCESS ONLY.

Answers B
Question. 65
What are some of the elements defined in a graph workspace?
Note: There are 2 correct answers to this question.

Source and target columns of the vertex table

Source and target columns of the edge table

The vertex table

The language used to construct the graph

Answers B C

Question. 66
Why would you implement a hierarchy function node in a
calculation view?

To enable a hierarchical drill-down in reporting tools

To assist the developer by visualizing hierarchies

To display value help using hierarchies

To generate a list of descendants for a hierarchy node

Answers A
Question. 67
Which type of join supports a temporal condition in a
calculation view?

Inner join

Text join

Left outer join

Referential join

Answers A

Question. 68
What is the SQL keyword used to process input parameters
defined in a calculation view?

Placeholder

Set

Where

Hint

Answers A
Question. 69
Why would you implement SAP HANA spatial services? Note:
There are 2 correct answers to this question.

To forecast movements of elements

To map all possible relationships in a network of elements

To calculate distances between elements

To identify unions and intersections of elements

You deleted the design-time file of a calculation view in your

HDB module.

Answers C D

Question. 70
Which of the following is the optimal way to ensure that the
corresponding runtime object is also removed from the database?
Note: There are 2 correct answers to this question.

Build the folder that contained the deleted design-time file.

Execute a DROP statement in an SQL console connected to the

HDI container.

Build the project that contained the deleted design-time file.

Execute the refactor function for the calculation view.

Answers A C
Question. 71
Why might you use SAP HANA Graph with text analysis?

To highlight similarities between documents using hierarchies

To provide a visual method to build a custom text analysis

To illustrate multi-point relationships between text entities

To uncover the dependencies between parts of speech

None

Answers B

Question. 72
Question 10 of 80

A calculation view includes a rank node that uses 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?

 5

Answers B

Question. 73
Question 24 of 80

A calculation view consumes the data sources shown in the

graphic. You want to identify which companies sold products in
January 2018 AND February 2018.

What is the optimal way to do this?

 Use a minus node.

Use a union node.

Use an aggregation node.

Use an intersect node.

Answers B

Question. 74
Question 30 of 80
You are building a new calculation view A that uses calculation
view B, as shown in the diagram. When you preview the
calculation view A, the Account Number is not masked.

What could be the reason?

Analytic privilege _SYS_BI_CP_ALL has been assigned.

You did not define masking in calculation view A.

The UNMASKED privilege for calculation view A has been

granted.

You previewed the data with the technical user in SAP Web
IDE for SAP HANA.

Answers C
Question. 75
Question 31 of 80

You have a calculation view that 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?

Note: There are 2 correct answers to this question.

The performance of the calculation view will increase.

The view will return the profit calculation only for the US.

The view will return the profit calculation for all the
countries.

The performance of the calculation view will decrease.

Answers B

Question. 76
Question 35 of 80

Using the table in the diagram, you need to create a cube

calculation view.

What is the simplest approach to create the output from the

screenshot?

Implement a union node and map each year as a separate

column.

Create 3 calculated columns.

Create a restricted column for each year.

Create a filter expression that uses an OR operator.

Answers A
Question. 77

Question 39 of 80

Two calculation views, A and B, are defined as shown in the

diagram. The three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

US for P1 and GE for P1

US for P1

No data at all

US for P1 and P2, and GE for P2

Answers B

Question. 78
Question 53 of 80

Which of the following results are generated when you query

this temporal hierarchy using a time-validity period interval of
March to May?

Answers C

Question. 79

Question 58 of 80
Referring to the diagram, which privileges would a user require
to view United States data when querying the CUBE calculation
view?

A SELECT privilege and an Analytic Privilege (Country

= United States) on the DIMENSION calculation view

SELECT privileges and Analytic Privileges (Country =

United States) on both views

A SELECT privilege and an Analytic Privilege (Country

= United States) on the CUBE calculation view

A SELECT privilege on the CUBE and an Analytic

Privilege (Country = United States) on the DIMENSION
calculation view

Answers D
Question. 80

Question 60 of 80

You want to map an input parameter of calculation view A to the

input parameter of calculation view B using the parameter
mapping feature in the calculation view editor. However, the
input parameter of calculation view B is not proposed to you as a
source parameter.

What might be the reason for this?

You already mapped the input parameters in another

calculation view.

You selected the wrong parameter mapping TYPE.

Your source calculation view is of the type SQL Access

Only.
 The names of the input parameters do not match.

Answers B