C-HANATEC-11 Exam Training Practice Tests (SAP Certified Technology Associate

Question 1

You want to analyze the root cause of a query that is performing poorly What does SAP recommended that you used in the SAP Hana studio?
Please choose the correct answer.
Response:

A. the database trace B. the prepared statement functionality C. the expensive statements trace D. the visualize plan functionality

Correct Answer: D

Question 2

Which system privilege do you need to stop and start an SAP HANA database
Please choose the correct answer.
Response:

A. MONETARY ADMIN B. SERVICE ADMIN C. LICENSE ADMIN D. SESSION ADMIN

Correct Answer: B

Question 3

What is the correct hierarchy of the SAP HANA component model?
Please choose the correct answer.
Response:

A. Package --> Product --> Delivery Unit --> Object B. Delivery Unit --> Product --> Package --> Object C. Product --> Delivery Unit --> Package --> Object D. Product --> Package --> Delivery Unit --> Object

Correct Answer: C

Question 4

What happens when you start the SAP HANA database?
There are 2 correct answers to this question.
Response:

A. For the ROW tables, the secondary indexes are created during load. B. The COLUMN store is completely loaded into the memory. C. The ROW store is completely loaded into the memory. D. For the COLUMN tables, the primary indexes are created during load.

Correct Answer: A,C

Question 5

What situation can Trigger Delta merge?
Please choose the correct answer.
Response:

A. a predefined time of day is reached B. An SQL statement reads data from the Delta storage C. the number of records in the main storage exceeds a limit D. the memory consumption of The Delta storage exceeds a limit

Correct Answer: D

Question 6

Which of the following can you use to analyze an expensive SQL statement?
There are 2 correct answers to this question.
Response:

A. The performance trace view B. The hdbcons tool C. The plan visualizer D. The plan explanation

Correct Answer: C,D

Question 7

Which of the following files should be considered in your SAP HANA backup strategy?
There are 3 correct answers to this question.
Response:

A. Configuration files B. Kernel filesE. Data and log files C. Dump files D. Export and import files

Correct Answer: A,B

Question 8

Which of the following techniques would you use to upgrade an SAP Hana system and keep the downtime to a minimum?
Please choose the correct answer.
Response:

A. high availability B. system replication C. Storage replication D. partitioning

Correct Answer: B

Question 9

Which steps are combined in the software update manager database migration option
(DMO) procedure?
There are 2 correct answers to this question
Response:

A. database upgrade B. SAP system upgrade C. Unicode conversion D. dual stack split

Correct Answer: B,C

Question 10

Which of the following are required to monitor SAP HANA in SAP Solution Manager?
There are 2 correct answers to this question.
Response:

A. SMD agent running on SAP Solution Manger B. Host agent running on SAP Solution Manager C. SMD agent running on SAP HANA D. Host agent running on SAP HANA

Correct Answer: C,D

SAP Certified Technology Associate - SAP HANA (SPS11) - C-HANATEC-11 Exam Practice Test