SAP c-hanaimp-17 practice test

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

• A. Synonym
• B. Association
• C. Virtual Table
• D. Alias

In a calculation view, which object type do you assign to a projection node to consume a Predictive
Analysis Library (PAL) function?

• A. Synonym
• B. Scalar function
• C. Table function
• D. Input parameter

Which is the correct syntax when you refer to an input parameter in a calculation view expression?

• A. $$Choose_Country$S
• B. :Choose_Country
• C. ..Choose_Country"
• D. @Choose_Country

What do you use a hierarchy function for? Note: There are 3 correct answers.

• A. Calculate distance between root and each hierarchy node
• B. Identify hierarchy nodes that have no parent
• C. Count the number of siblings for each hierarchy node
• D. Determine the shortest path between each pair of nodes
• E. Describe the relationship between nodes using attributes

In SAP HANA Series Data, which of the following methods do you use to convert finer interval
readings to a coarser interval?

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

Why do we support SQL development in SAP HANA data modeling projects?

• A. To provide access to your data model to additional client tools.
• B. To support development of custom logic within calculation views.
• C. To make changes to the runtime objects of your calculation view with SQL.
• D. As an alternative to developing calculation views when high performance is essential.

What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI
container?

• A. Database connection
• B. Wrapper
• C. Function
• D. Synonym

Which of the following are warm tier Solutions Note: There are 3 correct answers?

• A. Active / active read-enabled mode
• B. Native Storage Extension
• C. Extension Node
• D. Dynamic Tiering
• E. Persistent Memory

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.

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

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

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

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.

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

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

What does a graph neighborhood search reveal?

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

You have a calculation view which includes nodes as shown in the graphic. You decide to select the
"Ignore Multiple Output for Filters" check box on Projection Node 3. What might the effects of this
be?
Note: There are 2 correct answers to this question.

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