SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration (C_HCADM_05) Free Practice Test

Question 1

Why would you create a calculation view?

A. To store layers of pre-aggregated results

B. To define data distribution rules

C. To define a function that can be consumed by SQL

D. To define a virtual modeling layer on top of tables

Correct Answer: D

Question 2

Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question.

A. You want to develop calculation views.

B. You want to create database objects using source files.

C. You want to use containers to isolate objects.

D. You want to use synonyms to access external data.

E. You want to use SAP Business Application Studio.

Correct Answer: A,C,E

Question 3

Which tool do you use to execute SQL queries on the SAP HANA Cloud database?

A. SQL Editor

B. HDBSQL

C. SQLScript

D. SQL Console

Correct Answer: D

Question 4

What options do you have when deploying an SAP HANA Cloud, SAP HANA database with an integrated data lake? Note: There are 2 correct answers to this question.

A. Create an SAP HANA Cloud database and include a data lake in one step.

B. Create an SAP HANA Cloud database and later add a data lake.

C. Create an SAP HANA Cloud database with the data lake on premise.

D. Create an SAP HANA Cloud database with a separate data lake.

Correct Answer: A,B

Question 5

Who owns all database objects deployed using the SAP HANA Deployment Infrastructure (HDI)?

A. The _SYS_REPO technical user

B. The user who created the role

C. The DBADMIN user of the tenant database

D. The container-specific technical user

Correct Answer: D

Question 6

How can you view the audit trail in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

A. Using the SQL Console in the SAP HANA database explorer

B. Using the Loggregator via the Cloud Foundry CLI

C. Using the audit trail trace in the SAP HANA database explorer

D. Using the Auditing card in the SAP HANA cockpit

Correct Answer: A,C

Question 7

What are the supported resource sizes when you deploy an SAP HANA Cloud, SAP HANA database instance in an SAP BTP trial account?

A. 45GB RAM, 2 vCPUs, and 120GB storage

B. 30GB RAM, 4 vCPUs, and 120GB storage

C. 30GB RAM, 2 vCPUs, and 120GB storage

D. 45GB RAM, 4 vCPUs, and 120GB storage

Correct Answer: B

Question 8

Which type of SAP HANA Cloud instances can you provision in an SAP BTP enterprise account? Note: There are 2 correct answers to this question.

A. SAP HANA database

B. SAP SQL Anywhere

C. SAP IQ

D. Data lake

Correct Answer: A,D

Question 9

Which parameters can you change when creating an SAP HANA Cloud, data lake using an SAP BTP enterprise account?Note: There are 2 correct answers to this question.

A. The amount of memory

B. The amount of storage

C. The number of replicas

D. The number of workers

Correct Answer: B,D

Welcome to TestSimulate

SAP Certified Technology Associate - SAP HANA Cloud Provisioning and Administration (C_HCADM_05) Free Practice Test