SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration

QUESTION NO: 1
What can you store in the statement library?Note: There are 2 correct answers to this question.

A. The SAP SQL statement collection B. Your personal SQL scripts C. Your personal stored procedures D. The executed statements trace

Correct Answer: A,B

QUESTION NO: 2
How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database?

A. In an SAP BTP CLI, execute the RECOVER DATABASE command with the recovery timestamp. B. Open a SAP support ticket and provide the recovery timestamp to SAP HANA Cloud support. C. Open the SAP HANA Cloud Central, select the Start Recovery option, and set the timestamp. D. In an SQL Console, execute the command RECOVER DATABASE command with the recovery timestamp.

Correct Answer: B

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

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

Correct Answer: A,C,E

QUESTION NO: 4
Which database technology does native storage extension utilize in SAP HANA Cloud?

A. Row store B. Multi-cloud C. Disk-based D. Data fabric

Correct Answer: C

QUESTION NO: 5
Which feature do you use to dynamically manage SAP HANA database workloads per client session?

A. Parallel execution of SQL statements B. Workload classes C. Non-uniform memory access (NUMA) D. Admission control

Correct Answer: B

QUESTION NO: 6
You are working in the SAP BTP cockpit.Where can you find overall information regarding the provisioning and consumption of resources at a global account level?

A. In Entitlements B. In Usage Analytics C. In Regions D. In Quotas

Correct Answer: D

QUESTION NO: 7
What are some of the typical tasks performed by the SAP HANA Cloud modeler role?Note: There are 2 correct answers to this question.

A. Create graph workspaces B. Manage data tiers C. Develop Fiori apps D. Develop calculation views

Correct Answer: A,D

QUESTION NO: 8
Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.

A. Table partitions B. Indexes C. Pre-calculated aggregates D. Stored procedures

Correct Answer: B,C

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

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

Correct Answer: A,C

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