Online Access Free C-HCADM-02 Exam Questions

What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question.

• A.New records are not read.
• B.Aggregates are not adjusted.
• C.Read performance decreases.
• D.Memory is not optimized.

Which user account is assigned by default when you open the SAP HANA database explorer in SAP HANA Cloud?

• A.HDLADMIN
• B.DBADMIN
• C.SYSTEM
• D.COCKPIT_MONITOR

What is the purpose of the statement library in the SAP HANA database explorer?Note: There are 2 correct answers to this question.

• A.To execute scripts from the SQL statement collection for SAP HANA
• B.To collect all the executed SQL statements and generate a searchable library list
• C.To determine special database information not available in the SAP HANA cockpit
• D.To share custom SQL scripts with the whole administrator team

When is the first column store compression executed?

• A.When a delta merge is triggered
• B.When partitions are regenerated
• C.When a backup is started
• D.When the table is created

In which view is the pre-installed statements library stored?

• A.M_PREPARED_STATEMENTS
• B.M_EXECUTED_STATEMENTS
• C.M_SYSTEM_INFORMATION_STATEMENTS
• D.M_REMOTE_STATEMENTS