VCEdump

C_HANAIMP_17 SAP Certified Application Associate - SAP HANA 2.0 (SPS05)

PDF question preview Back to product

Free preview

12 sample questions

The complete product contains 80 questions.

Question formats

Single choice8

Multiple choice4

Compare study plans

SAP · C_HANAIMP_17

C_HANAIMP_17 questions and answers

Review the question wording, option layout, and available explanations before choosing a study plan.

Question 1

Single choice

In your calculation view, you need to define a custom data source using SQLScript.
In which object do you write your SQL Script?

A
Table function
B
CDS view
C
Procedure
D
Virtual Table

Reveal answer details Close answer details

Correct answerA

Question 2

Single choice

Why do you build a calculation view of type SQL Access only?

A
To enable SQL access to your hierarchies
B
To provide a high-performance model when only attributes are required
C
To provide a data source that can only be consumed by a function or procedure
D
To provide a data source that is only consumed by other calculation views

Reveal answer details Close answer details

Correct answerD

Question 3

Single choice

In text processing, where do you use the Term Document Matrix?

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

Reveal answer details Close answer details

Correct answerA

Question 4

Single choice

You combine two customer master data tables with a union node in a calculation view. Both 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?

A
Add a minus node above the union node.
B
Add an intersect node above the union node.
C
Include an aggregation node above the union node.
D
In the union node, map both source customer name columns to one target column.

Reveal answer details Close answer details

Correct answerC

Question 5

Single choice

Why do you create a multi store table?

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

Reveal answer details Close answer details

Correct answerB

Question 6

Multiple choice

How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

A
Call the SAP-provided PAL decision tree procedure from the table function
B
Use dynamic SQL in the table function to generate the SQL code
C
Copy and adapt the SQL code generated by a flow graph into the table function
D
Build a flow graph and call it from the table function using input parameters

Reveal answer details Close answer details

Correct answersC, D

Question 7

Single choice

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?

A
Show lineage
B
Database Explorer
C
Where used
D
Auto-map byname

Reveal answer details Close answer details

Correct answerA

Question 8

Multiple choice

Why do you use parameter mapping in a calculation view?

Note: There are 2 correct answers to this question.

A
To convert the data types of input parameters
B
To push down filters to the lowest level calculation views
C
To pass variable values to external value help views
D
To enable an input parameter in a calculation view

Reveal answer details Close answer details

Correct answersB, C

Question 9

Multiple choice

What are the components of a custom text analysis?

Note: There are 3 correct answers to this question.

A
Rule set
B
Python script
C
Term Document Matrix
D
Dictionary
E
Configuration

Reveal answer details Close answer details

Correct answersA, D, E

Question 10

Multiple choice

You combine two tables in a join using multiple columns in each table. Why do you enable the dynamic join option?

Note: There are 2 correct answers to this question.

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

Reveal answer details Close answer details

Correct answersA, C

Question 11

Single choice

When would you develop an SQL procedure instead of a function?

A
You need to implement Data Definition Language (DDL) statements.
B
The code should modify data in the table.
C
Optimal performance is apriority.
D
You need to use conditional logic.
E
You want to create a dynamic analytic privilege.

Reveal answer details Close answer details

Correct answerB

Question 12

Single choice

You want to map an input parameter of the 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 the calculation view B is not proposed to you as a source parameter.

What might be the reason for this?

A
You selected the wrong parameter mapping TYPE.
B
The names of the input parameters do not match.
C
You already mapped the input parameters in another calculation view.
D
Your source calculation view is of the type SQL Access Only.

Reveal answer details Close answer details

Correct answerC