C_HANATEC_10 Online Practice Questions and Answers

Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?

There are 2 correct answers to this question.

Response:

A. Ensure that replicated changes are kept within the logging tables.

B. Record relevant changes in logging tables.

C. Decluster table classes into a transparent format.

D. Include only relevant tables for DB recording.

When you try to create a delivery unit from the SAP HANA studio you receive the following error message.

'Cannot create Delivery Unit as content vendor is not defined for this system'. How do you troubleshoot this

issue?

Please choose the correct answer.

Response:

A. Maintain the vendor ID

B. Maintain the content_vendor parameter

C. Grant REPO.MAINTAIN_NATIVE_PACKAGES privilege

D. Grant REPO.MAINTAIN_DELIVERY_UNITS privilege

You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can

you implement this security strategy?

Please choose the correct answer.

Response:

A. By assigning package privileges to the necessary users

B. By assigning analytic privileges to the necessary users

C. By assigning SQL privileges to the necessary users

D. By assigning system privileges to the necessary users

Which of the following connection types does Direct Extractor Connection (DXC) use to transfer data to

SAP HANA?

Please choose the correct answer.

Response:

A. RFC connection

B. Secondary database connection

C. http connection

D. BICS connection

Which of the following can you use to analyze an expensive SQL statement?

There are 2 correct answers to this question.

Response:

A. Open the Plan Visualizer.

B. Open the Plan Explanation.

C. Open the hdbcons tool.

D. Open the SQL Plan Cache.

What do you have to consider when you design a backup plan?

There are 2 correct answers to this question.

Response:

A. The newest data must be backed up most often.

B. The column table data needs to be compressed before a backup.

C. The backup execution must be monitored.

D. The database backup must be stored at a different location than the database server.

Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts?

There are 2 correct answers to this question.

Response:

A. CCMS agent

B. Collection script

C. Host agent

D. SMD agent

Which view displays the current SAP HANA Support Package level?

Please choose the correct answer.

Response:

A. M_LANDSCAPE_HOST_CONFIGURATION

B. M_VERSION_MEMORY

C. M_HOST_INFORMATION

D. M_DATABASE

After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.

Which of the following parameter settings allows you to do this?

Please choose the correct answer.

Response:

A. Autostart to "Enable" in the profile file /usr/sap//SYS/profile/_HDB_

B. Autostart to "TRUE" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL

C. Autostart to "Yes" in the profile file /usr/sap//SYS/profile/DEFAULT.PFL

D. Autostart to "1" in the profile file /usr/sap//SYS/profile/_HDB_

Which of the following are characteristics of a design-time role?

There are 2 correct answers to this question.

Response:

A. It is revoked if the grantee user is deleted.

B. It is transportable between systems.

C. It is granted and revoked directly by an administrator.

D. It is granted through the execution of stored procedures.