SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12)

QUESTION NO: 1
Which SAP HANA studio function displays the views that will be affected when you rename an attribute view?
Please choose the correct answer.

A. Where-used list B. Neighbor C. Properties D. Tables used

Correct Answer: A

QUESTION NO: 2
In which type of node can you create calculated columns?
There are 2 correct answers to this question.
Response:

A. Projection node B. Union node C. Rank node D. Join node

Correct Answer: A,D

QUESTION NO: 3
What statement do you have to run before you can return table results from a procedure?
Please choose the correct answer.

A. CREATE TYPE B. CREATE TABLE TYPE C. CREATE TABLE D. CREATE VIEW

Correct Answer: A

QUESTION NO: 4
What is the recommended way to create full-text indexes going forward?
Please choose the correct answer.
Response:

A. User-defined functions B. SQL statements in the SQL Console C. Procedures D. Core Data Services

Correct Answer: D

QUESTION NO: 5
What are the advantages of columnar storage?
There are 2 correct answers to this question.
Response:

A. Improved compression B. Improved data writing performance C. Improved performance when all fields are selected D. Improved data reading performance

Correct Answer: A,D

QUESTION NO: 6
As what are most of the views in SAP HANA Live created?
Please choose the correct answer.
Response:

A. CDS data sources B. Calculation views C. Cubes D. Table functions

Correct Answer: B

QUESTION NO: 7
What information can you find in the Visualize Plan tool?
There are 2 correct answers to this question.
Response:

A. The execution engines used B. The SQL Plan Cache C. The time taken for each step D. The number of records returned in each step

Correct Answer: C,D

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

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

Correct Answer: A,C

QUESTION NO: 9
Which of the following are reasons you should use Core Data Services (CDS) to create a schema?
There are 2 correct answers to this question.
Response:

A. The database administrator might type the name wrong. B. The focus is on the business requirements. C. The database administrator should not get those privileges in the production system. D. The focus is on the database administration requirements.

Correct Answer: B,C

QUESTION NO: 10
What happens when you activate an information model? ?
There are 2 correct answers to this question.
Response:

A. It generates a runtime object. B. It checks the validation rules. C. It exports an active version. D. It reverts to the active version.

Correct Answer: A,B

QUESTION NO: 11
When do you always have both an active and an inactive version of an infor- mation model available in the SAP HANA development system?
Please choose the correct answer.
Response:

A. When validation of a model fails B. When you edit an existing model C. When you create a new model D. When you selected Revert to Active on an inactive version

Correct Answer: B

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

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

Correct Answer: D

QUESTION NO: 13
What do you use in a SQL query to sort fuzzy text search results by relevance?
Please choose the correct answer.
Response:

A. RANK() B. SCORE() C. TOP D. SORT BY

Correct Answer: B

QUESTION NO: 14
You want to reuse a decision table on multiple tables with a similar data structure. You design the decision table that passes a specific table name as an input parameter when you execute the decision table.
What do you have to use in the data foundation to achieve this?
Please choose the correct answer.
Response:

A. A scripted calculation view B. A dynamic join C. A virtual table D. A table type

Correct Answer: D

SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12) - C-HANAIMP-12 Exam Questions