C-HANATEC-14 by SAP Valid Free Exam Practice Test

Question 1

For which communication channel do you need to set up encryption manually?
Please choose the correct answer.
Response:

A. Between SAP HANA systems in system replication scenarios B. Between hosts in an SAP HANA scale-out system C. Between databases in an SAP HANA multitenant database container system D. Between the SAP HANA server and clients

Correct Answer: D

Question 2

A user is complaining about missing privileges when executing a query. How do you configure the indexserver trace to obtain the missing privileges?
Please choose the correct answer.
Response:

A. Select trace level Info for the authorization component. B. Select trace level Debug for the authenticationcodec component. C. Select trace level Error for the auditing component. D. Select trace level Warning for the authentication component.

Correct Answer: A

Question 3

At the end of the SAP HANA Cockpit 2.0 installations, how can you obtain the URL of the SAP HANA cockpit and the SAP HANA cockpit manager?
Please choose the correct answer.
Response:

A. Installation logs screen B. COCKPIT_ADMIN user logs C. Installation log file D. Installation config screen

Correct Answer: A

Question 4

Where is SDI used?
There are 2 correct answers to this question.
Response:

A. Data transformation B. For data loading C. Data cleansing D. Data streaming

Correct Answer: A,B

Question 5

Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview page. This page displays the detailed status of the selected SAP HANA system.
Which of the following options are listed?
There are 3 correct answers to this question.
Response:

A. Security B. Monitoring and Administration C. Memory Management D. Resource Management E. Performance Management

Correct Answer: A,B,E

Question 6

Which connection types are allowed when you use system replication with the Active/Active option?
There are 2 correct answers to this question.
Response:

A. Implicit hint-based statement routing B. Explicit read and write on the secondary system C. Explicit read only on the secondary system D. Automatic round-robin statement routing

Correct Answer: A,C

Question 7

The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?
Please choose the correct answer.
Response:

A. Resident memory B. Physical memory C. Standby memory D. Virtual memory

Correct Answer: D

Question 8

A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system or object privilege do you assign to the technical user account on the target system?
Please choose the correct answer.
Response:

A. SELECT on _SYS_REPO B. USER ADMIN C. CATALOG READ D. SELECT on _SYS_TASK

Correct Answer: C

Question 9

You need to analyze resource usage and forecast the requirements for your SAP HANA database. Which app do you start in SAP HANA cockpit 2.0?
Please choose the correct answer.
Response:

A. Manage Workload Classes B. Troubleshoot Unresponsive System C. Monitor Expensive Statements D. Disk Usage

Correct Answer: D

Question 10

Which of the following elements are valid rules for the location of the backup files?
There are 3 correct answers to this question.
Response:

A. The Volume ID is automatically added to a specified file name. B. The backup ID is unique for each persistence only. C. The backup files should never be in the same directory and on the same file system as the data. D. The backup folder will be created automatically when the backup process is started.

Correct Answer: A,B,C

SAP Certified Technology Associate - SAP HANA 2.0 - C-HANATEC-14 Exam Practice Test