SAP Certified Technology Associate - SAP HANA (Edition 2016) - C_HANATEC

Question 1

Application users report that a query sometimes runs much slower than usual. You suspect that the high system load is slowing down the query execution
Where can you review the overall system workload when a query is executed?
There are 2 correct answers to this question
Response:

A. kernel trace B. SQL trace C. early watch alert D. SAP Hana studio

Discussion 0

Correct Answer: A,B Vote an answer

Question 2

Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit?
There are 3 correct answers to this question.
Response:

A. View the tables in the _SYS_STATISTICS schema. B. Display the statuses of database resources. C. Implement backup scheduling. D. Monitor an SQLDBC trace. E. Execute system recovery.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 3

You plan to migrate a non-SAP database to SAP HANA using the Database Migration
Option of the Software Update Manager SP16. Which URL should you use?
Please choose the correct answer.
Response:

A. http://<host>:<port>/lmsl/sumabap/<SID>/doc/sluigui B. http://<host>:<port>/lmsl/sumabap/<SID>/doc/gui C. http://<host>:<port>/lmsl/upgrade/<SID>/doc/gui D. http://<host>:<port>/lmsl/HDBLCM/<SID>/index.html

Discussion 0

Correct Answer: A Vote an answer

Question 4

Which of the following tools can you use to create and manage SAP HANA database users?
There are 2 correct answers to this question.
Response:

A. hdbsql B. SAP Netweaver Identity Management C. Microsoft Active Directory D. SAP Solution Manager

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

How can you determine which SAP HANA parameters have been changed in your system?
There are 2 correct answers to this question
Response:

A. by checking the index server trace file displaying information from the last system startup B. by checking the configuration files in the respective folders on the operating system C. by checking the configuration tab of the administration console in the SAP Hana studio D. by checking the monitoring view M_LANDSCAPE_HOST_CONFIGURATION"

Discussion 0

Correct Answer: B,C Vote an answer

Question 6

You are investigating a problem with the SAP Hana database. You opened a customer message with SAP support.
SAP support asks you to provide last trace information from the SAP Hana instance. How do you gather this information?
There are 2 correct answers to this question
Response:

A. execute the "collect (SQL procedure)" function in the administration console B. run the recoversys.py script on the SAP Hana server C. Run the full system info dump.py script on the SAP HANA server. D. Run HBD info comment on the SAP Hana server

Discussion 0

Correct Answer: A,C Vote an answer

Question 7

Which components do you need before installing and SAP lumira server?
There are 2 correct answers to this question
Response:

A. SAP HANA Studio installed on the client workstation B. SAP Hana UI Toolkit her information access (INA) C. SAP Hana self-service analytics application function library (SAL AFL) D. SAP lumira data access extension framework

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

You are using continuous system replication between SAP HANA systems in two separate data centers.
What are the advantages of this scenario?
There are 2 correct answers to this question.
Response:

A. The take-over happens in less than 3 minutes. B. Database changes are continuously updated to the secondary site. C. Memory and CPU are used on the secondary site for shadow processes. D. The take-over only requires a roll forward since the last synchronization point.

Discussion 0

Correct Answer: B,D Vote an answer

SAP Certified Technology Associate - SAP HANA (Edition 2016) - C_HANATEC_12 FREE EXAM DUMPS QUESTIONS & ANSWERS