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

Question 1

Which of the following must you configure to enable monitoring of SAP HANA in DBA
Cockpit?
Please choose the correct answer.
Response:

A. A database connection in DBA Cockpit

B. A database connection in the table DBCON

C. The CCMS agent in SAP HANA

D. The CCMS connection in DBA cockpit

Correct Answer: A

Question 2

Authorization grants access to application resources and services based on the defined user permissions. Which of the following combinations are true regarding user type and role/role collections?
There are 2 correct answers to this question
Response:

A. Administrator A role collection containing the XS_Administrator role template

B. Administrator Developer WebIDE_CONTROLLER_USER role collection

C. Developer A role collection containing the WebIDE_Developer

D. Administrator Developer XS_CONTROLLER_USER role collection

Correct Answer: C,D

Question 3

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

A. M_VERSION_MEMORY

B. M_HOST_INFORMATION

C. M_DATABASE

D. M_LANDSCAPE_HOST_CONFIGURATION

Correct Answer: C

Question 4

In SAP HANA, what is the recommended memory size you must reserve for dynamic objects?
Please choose the correct answer.
Response:

A. The same size as the total size of the data files

B. The same size as the memory required for static data

C. The same size as the total size of the log files

D. The same size as the uncompressed source data

Correct Answer: B

Question 5

A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement?
Please choose the correct answer.
Response:

A. Analytic privileges

B. Package privileges

C. System privileges

D. SQL privileges

Correct Answer: A

Question 6

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 expensive statements trace

B. the database trace

C. the prepared statement functionality

D. the visualize plan functionality

Correct Answer: D

Question 7

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 Studio database development

B. SAP Hana administration

C. SAP Hana studio RSA plug-in

D. SAP Hana studio SAPUI5 plug-in

Correct Answer: A,B

Question 8

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

Welcome to TestSimulate

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