SAP C_HCMOD_05 Exam Practice Test Instant Access

Question 1

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 2

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

ATo generate hierarchies

BTo define a filter

CTo convert currencies

DTo generate a restricted column

ETo generate a calculated column

Answer : B, D, E

Question 3

Why would you create SQL in calculation views?

ATo implement custom logic

BTo provide an alternative to graphical modeling

CTo fine-tune performance

DTo enable write capabilities

Answer : A

Question 4

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

AUse a union node.

BUse an intersect node.

CUse an aggregation node.

DUse a minus node

Answer : B

Question 5

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 6

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

AUS for P1 and GE for P1

BUS for P1 and P2, and GE for P1 and P2

CUS for P1

DUS for P1 and P2, and GE for P2

Answer : A

Question 7

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

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