C_HANATEC_11 by SAP Valid Free Exam Practice Test

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. SQL trace B. kernel trace C. early watch alert D. SAP Hana studio

Correct Answer: A,B

Question 2

For one-step logon to the system on the PARMA host with instance number 01 as database user MONA with the password RED, which of the following command helps?
Please choose the correct answer.
Response:

A. hdbsql -n PARMA -p 1 -u MONA -i RED B. hdbsql -i PARMA -n 1 -u MONA -p RED C. hdbsql -n PARMA -i 1 -u MONA -p RED D. hdbsql -p PARMA -i 1 -u MONA -n RED

Correct Answer: C

Question 3

Which of the following are benefits of using the database migration option(DMO) procedure of the software update manager during migration to SAP Hana?
There are 2 correct answers to this question
Response:

A. a system of any source release can be upgraded and migrated in a single step B. the shadow kernel runs on the target SAP Hana database host C. in-place migration keeps the application server and system ID stable D. the original database is kept and can be reactivated as a fallback

Correct Answer: C,D

Question 4

Which of the following can be encrypted by an SAP Hana system?
Please choose the correct answer.
Response:

A. backups B. individual tables C. log volumes D. Data volume

Correct Answer: D

Question 5

Which of the following are parts of SAP HANA sizing?
There are 3 correct answers to this question.
Response:

A. Network bandwidth sizing B. Disk sizing C. Memory sizing D. Data and log file sizing E. CPU sizing

Correct Answer: B,C,E

Question 6

Which operating system commands show the SAP HANA processes?
There are 2 correct answers to this question.
Response:

A. HDB version B. HDB proc C. HDB admin D. HDB info

Correct Answer: B,D

Question 7

Which of the following commands installs or updates the repository for SAP HANA studio?
Please choose the correct answer.
Response:

A. hdbinst -a studio - -repository=<source_repository_path> B. hdbinst -a studio - -copy_repository=<target_repository_path> C. hdbinst -a studio - -copy_repository=<source_repository_path> D. hdbinst -a studio - -repository=<target_repository_path>

Correct Answer: B

Question 8

Which delivered role is mandatory for a system administrator in SAP HANA?
Please choose the correct answer.
Response:

A. SAP_ALL B. IC MODELER C. SYS_ADMIN D. CONTENT_ADMIN

Correct Answer: D

Question 9

The statistics server was stopped during an upgrade by the system administrator.
Which of the following parameters in statisticsserver.ini do you modify to restart the statistics server?
Please choose the correct answer.
Response:

A. statsserv in the trace section B. statsconnect in the trace section C. editing in the statisticsserver_general section D. active in the statisticsserver_general section

Correct Answer: D

Question 10

Which tool do you use to update the SAP that is installed on your Windows workstation
Please choose the correct answer.
Response:

A. hdbsetup SAP Hana lifecycle management tool B. setup.sh SAP Hana on-site configuration tool C. SUM software update manager for SAP Hana D. hdblcm SAP Hana lifecycle management tool

Correct Answer: D

SAP Certified Technology Associate - SAP HANA (SPS11) - C_HANATEC_11 Exam Practice Test