Online Access Free C_HANATEC_10 Practice Test

You deleted billions of records from several tables in the SAP HANA database. However, the file system for the data
volumes did not gain any free space.
What is the reason?
Please choose the correct answer.
Response:

• A.You did not execute a full backup and restore to reduce the size of the data volumes.
• B.You did not execute the ALTER SYSTEM RECLAIM LOG.
• C.SAP HANA keeps the space for later reuse.
• D.SAP HANA did not trigger a delta merge yet.

Which of the following are characteristics of a design-time role?
There are 2 correct answers to this question.
Response:

• A.It is transportable between systems.
• B.It is granted and revoked directly by an administrator.
• C.It is granted through the execution of stored procedures.
• D.It is revoked if the grantee user is deleted.

You are reviewing the execution plan of an SQL statement.
You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has
been active.
How can you accomplish this?
Please choose the correct answer.
Response:

• A.Use EXPLAIN (graphically) in the DBA Cockpit.
• B.Use Job Progress in the SAP HANA studio.
• C.Use the Visualize Plan functionality in the SAP HANA studio.
• D.Use Performance Trace in HDB admin.

Which tasks can you perform using the resident SAP HANA lifecycle management tool?
There are 3 correct answers to this question.
Response:

• A.Change the license of the SAP HANA system.
• B.Uninstall SAP HANA components
• C.Rename the SAP HANA system.
• D.Add additional hosts to the SAP HANA system
• E.Copy an SAP HANA system.

If you want to create or drop tables in a schema, which privilege type do you need?
Please choose the correct answer.
Response:

• A.SQL
• B.Analytic
• C.System
• D.Package