SAP Certified Technology Associate - SAP HANA (Edition 2016)

Question 1

Which SAP Hana command line tools do you use during the zero downtime maintenance process?
There are 2 correct answers to this question
Response:

A. Hdbupd

B. Hdbinst

C. Hdblcm

D. Hdbnsutil

Correct Answer: A,D

Question 2

What does the save point process in SAP HANA do?
Please choose the correct answer.
Response:

A. It saves changed data to disk when transactions are committed.

B. It saves changed data to disk at regular intervals.

C. It synchronizes changed data to the disaster recovery system.

D. It frees up memory by saving non-active data to disk.

Correct Answer: B

Question 3

What are prerequisites when replicating SAP Business warehouse authorizations to SAP
Hana?
There are 2 correct answers to this question
Response:

A. The SAP <SID> uses must be granted the required privileges in order to deploy a view

B. The infoprovider must be activated with the external SAP Hana view settings enable

C. the SAP <SID> user must be granted the required privileges in order to access a view

D. The infoprovider must be activated with the same name as an existing SAP Hana view

Correct Answer: A,B

Question 4

Which view displays the current SAP HANA Support Package level?
Please choose the correct answer.
Response:

A. M_DATABASE

B. M_HOST_INFORMATION

C. M_VERSION_MEMORY

D. M_LANDSCAPE_HOST_CONFIGURATION

Correct Answer: A

Question 5

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_SYSTEM_REPOSITORY_ALL

B. SAP_SOLAR02_ALL

C. SAP_SM_ADMIN_COMPONENT_ALL

D. SAP_SYSREC_ALL

Correct Answer: A

Question 6

What are the characteristics of a design-time role?
There are 3 correct answers to this question
Response:

A. it is granted through the execution of stored procedure

B. it can be transported between systems

C. It is created by the technical user_SYS_REPO.

D. it is granted and revoked directly by the database user

E. it is revoked if the grantee user is deleted

Correct Answer: A,B,C

Question 7

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. SAP Hana studio

B. kernel trace

C. SQL trace

D. early watch alert

Correct Answer: B,C

Question 8

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

A. Standard SQL database replication

B. ABAP extractors

C. TREX engine

D. Test Data Migration Server (TDMS)

E. Near Zero Downtime

Correct Answer: D,E

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

Latest Update

Useful Links

Contact Us