SAP Certified Application Associate - SAP HANA 2.0 (SPS05) (C-HANAIMP-17) Free Practice Test

Question 1

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. Requests

C. Sentiments

D. Suggestions

Correct Answer: B,C

Question 2

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

A. The data is uncompressed.

B. The data is stored in the warm tier.

C. The data is NOT sorted.

D. The data is unstructured.

Correct Answer: A,C

Question 3

Why do we use Git when modeling calculation views?

A. Enable collaboration between developers

B. Provide access to external schemas

C. Develop conceptual prototypes

D. Control specifically object versioning

Correct Answer: D

Question 4

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 one table located in an external schema. Which of the following items must you build?
Note: There are 2 correct answers to this question.

A. Authorization

B. Project

C. .hdinamespacefile

D. Synonym

Correct Answer: A,D

Question 5

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. Decreased performance

B. A change to the data that is returned by the view

C. Increased performance

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

Correct Answer: C,D

Question 6

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

A. Wrapper

B. Function

C. Database connection

D. Synonym

Correct Answer: B

Question 7

Why do you use the debug query mode in a calculation view?

A. To highlight potential performance issues at design-time

B. To check which database engines will be invoked by each node

C. To observe the generated SQL for each node

D. To measure the overall run-time of the query

Correct Answer: C

Question 8

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

A. To push down filters to the lowest level calculation views

B. To enable an input parameter in a calculation view

C. To pass variable values to external value help views

D. To convert the data types of input parameters

Correct Answer: A,C

Question 9

Why do you implement Active / active read-enabled mode?

A. To enhance security for data access

B. To improve query performance

C. To provide offline access to data

D. To synchronize query results with operational data

Correct Answer: D

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA 2.0 (SPS05) (C-HANAIMP-17) Free Practice Test