SAP C_HCMOD_05 Exam Practice Test Instant Access

Question 1

Why would you use the Transparent Filter property in a calculation view?

ATo include columns that are NOT requested by a query

BTo avoid columns being unnecessarily used in an aggregation

CTo apply filters that are hidden from the end user

DTo allow filter push-down in stacked calculation views

Answer : B

Question 2

In SAP HANA Cloud, which tasks are handled by the cloud provider?Note: There are 3 correct answers to this question.Sizing, provisioning, and monitoring the database

ATuning the database to run optimally on the underlying operating system, and hardware

BManaging users, roles, and permissions in the database

CBacking up the operating system and the database software

DInstalling, configuring, and upgrading the operating system

Answer : A, C, D

Question 3

Why might you use the Keep Flag property in an aggregation node?

ATo ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

BTo exclude columns that are NOT requested by a query to avoid incorrect results

CTo include columns that are NOT requested by a query but are essential for the correct result

DTo retain the correct aggregation behavior in stacked views

Answer : C

Question 4

Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

ATo pass variable values to external value help views

BTo assign variables to one or more attributes

CTo push down filters to the lowest level calculation views

DTo convert the data types of input parameters

Answer : A, C

Question 5

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

ADeploy the folder that contained the deleted design-time file.

BExecute a DROP statement in an SQL Console connected to the HDI container.

CDeploy the project that contained the deleted design-time file.

DExecute the refactor function for the calculation view.

Answer : C

Question 6

What is the SQL keyword used to process input parameters defined in a calculation view?

AWHERE

BPLACEHOLDER

CHINT

DSET

Answer : B

Question 7

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

ATo prevent passing columns in stacked calculation views

BTo ensure specific columns are NOT exposed to the reporting tool

CTo remove a column that is also used as a Label column

DTo avoid exposing sensitive columns when defining calculated columns

Answer : B, C

SAP C_HCMOD_05 SAP Certified Application Associate - SAP HANA Cloud Modeling Exam Practice Test