C_HCADM_01 Exam Training Practice Tests (SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration)]

Question 1

What are the advantages of column store tables compared to row store tables?Note: There are 3 correct answers to this question.

A. Additional indexes are used B. Improved write performance on frequent updates C. Parallel access is improved D. Higher data compression rates E. Higher performance for query operations

Correct Answer: B,D,E

Question 2

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

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

Correct Answer: D

Question 3

Which audit trail target can you select in the SAP HANA Cloud, SAP HANA database?

A. CSV text file B. Kernel trace C. Linux syslog D. Database table

Correct Answer: D

Question 4

Which tools are available in SAP HANA Cloud Central?Note: There are 2 correct answers to this question.

A. SAP HANA cockpit B. SAP Business Application Studio C. SAP HANA Cloud Capacity Unit Estimator D. SAP HANA database explorer

Correct Answer: A,D

Question 5

In which schema does the SAP HANA Cloud, SAP HANA database instance store historical performance data?

A. _SYS_STATISTICS B. _SYS_EPM_DATA C. _SYS_WORKLOAD_REPLAY D. _SYS_SQL_ANALYZER

Correct Answer: A

Question 6

Which database restore options are available in SAP HANA Cloud, SAP HANA database?Note: There are 2 correct answers to this question.

A. Recover instance from a backup B. Installing, configuring, and upgrading the operating system C. Recreate instance from a backup D. Reset instance to a backup E. Clone instance from a backup

Correct Answer: A,C

Question 7

Which import sources are supported by the SAP HANA database explorer to import data into an SAP HANA Cloud, SAP HANA database?Note: There are 2 correct answers to this question.

A. Azure Cloud Storage B. IBM public cloud C. Alibaba Cloud OSS D. Exoscale Object Storage

Correct Answer: A,C

Question 8

In the SAP BTP account model, why would you create directories?Note: There are 2 correct answers to this question.

A. To organize and filter subaccounts B. To assign quotas and entitlements C. To manage users and roles D. To purchase SAP BTP services

Correct Answer: A,B

Question 9

Which user is automatically created when you add a data lake to an SAP HANA Cloud, SAP HANA database?

A. DBA B. HDLADMIN C. SYSTEM D. DBADMIN

Correct Answer: D

SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration - C_HCADM_01 Exam Practice Test