C_HANATEC_12 by SAP Valid Free Exam Practice Test

Question 1

Which technologies use trigger-based replication?
There are 2 correct answers to this question.
Response:

A. ABAP extractors B. Test Data Migration Server (TDMS) C. Near Zero Downtime D. Standard SQL database replication E. TREX engine

Correct Answer: B,C

Question 2

What services must be configured and running on the SAP Hana server to monitor the SAP
Hana instance in SAP Solution manager?
There are 2 correct answers to this question
Response:

A. SAP SMD agent B. SAP host agent C. compile service D. preprocessor service

Correct Answer: A,B

Question 3

What information is shown on the overview tab of the administration console in the SAP
Hana studio?
There are 3 correct answers to this question
Response:

A. Linux kernel version B. operational status C. system parameters D. distributed system E. memory usage of the services

Correct Answer: A,B,D

Question 4

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 expensive statements trace C. the prepared statement functionality D. the visualize plan functionality

Correct Answer: D

Question 5

Which features can you enable during the installation of the SAP Hana studio?
There are 2 correct answer to this question
Response:

A. SAP Hana administration B. SAP Hana studio RSA plug-in C. SAP Hana studio SAPUI5 plug-in D. SAP Hana Studio database development

Correct Answer: A,D

Question 6

You have to load data in real time from external systems into SAP HANA,. Which Data
Provisioning tools can you use?
There are 3 correct answers to this question.
Response:

A. Smart Data Access (SDA) B. Smart Data Integration (SDI) C. SAP Replication Server (SRS) D. SAP Data Services (SDS) E. SAP LT Replication Server (SLT)

Correct Answer: B,C,E

Question 7

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 8

You want the user SOLMAN_ADMIN to be able to modify the properties of the SAP HANA instance during system configuration in SAP Solution Manager.
Which role must you assign to the user SOLMAN_ADMIN to achieve this?
Please choose the correct answer.
Response:

A. SAP_SYSREC_ALL B. SAP_SOLAR02_ALL C. SAP_SYSTEM_REPOSITORY_ALL D. SAP_SM_ADMIN_COMPONENT_ALL

Correct Answer: C

SAP Certified Technology Associate - SAP HANA (Edition 2016) - C_HANATEC_12 Exam Practice Test