C-HANAIMP-14 by SAP Valid Free Exam Practice Test

Question 1

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.

A. An analytic privilege on the both calculation views B. An object privilege on the WORLD calculation view C. An analytic privilege on the WORLD calculation view D. An analytic privilege on the INDIA calculation view

Correct Answer: A

Question 2

Global session variables can be used in SQLScript to share a scalar value between procedures and functions that are running in the same session. The value of a global session variable is not visible from another session.
Please choose the correct answer.
Response:

A. SET <key>= <value>; B. SET <value>= <key>; C. SET <global>= <key>; D. SET <key>= <global>;

Correct Answer: A

Question 3

Which words are associated with the log volume?
There are 2 correct answers to this question.
Response:

A. Transaction manager B. Synchronous C. Savepoint D. Page manager

Correct Answer: A,B

Question 4

For which data types does SAP HANA automatically create full-text indexes?
There are 3 correct answers to this question.
Response:

A. CLOB B. NVARCHAR C. SHORTTEXT D. BINTEXT E. TEXT

Correct Answer: C,D,E

Question 5

Which of the following VDM views can be called by applications and reports?
There are 2 correct answers to this question.
Response:

A. Private views B. Value help views C. Query views D. Reuse views

Correct Answer: B,C

Question 6

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 CDS view C. Store green as a measure D. Store green as a spatial data type

Correct Answer: A

Question 7

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 generated value can be overwritten at runtime. B. The input parameter must be set to mandatory. C. The function must be of the type scalar. D. The function can return multiple values

Correct Answer: A,C

Question 8

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. SQL function B. Table function C. Window function D. Scalar function

Correct Answer: D

Question 9

The entity is the core artifact for persistence-model definition using the CDS syntax. You create a database entity as a design-time file in the SAP HANA repository.
Which are the following prerequisites to create an entity in CDS (core data services)?
There are 2 correct answers to this question
Response:

A. You must have access to an SAP HANA system B. You must have access to schema for the CDS catalog objects C. You must have already created a development workspace and a project. D. You must have deployed to schema for the CDS catalog objects

Correct Answer: A,C

Question 10

Which are the recommended assignments in SAP HANA?
There are 2 correct answers to this question.

A. Privileges to users B. Roles to privileges C. Roles to users D. Roles to roles

Correct Answer: C,D

Question 11

Which of the following data provisioning tools can you use to read data directly from Twitter?
There are 3 correct answers to this question.

A. SAP HANA XS engine B. SDI C. SRS D. SDA E. SAP Data Services

Correct Answer: A,B,E

Question 12

What PAL algorithm would you use to analyze shopping baskets?
Please choose the correct answer.
Response:

A. Decision tree B. Apriori C. Link prediction D. K-means

Correct Answer: B

SAP Certified Application Associate - SAP HANA 2.0 (SPS02) - C-HANAIMP-14 Exam Practice Test