Weekend Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. SAP
  3. SAP Certified Application Associate
  4. C_HCMOD_05 - SAP Certified Application Associate - SAP HANA Cloud Modeling

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

Demo: 26 questions
Total 88 questions
Get C_HCMOD_05 Full Access Download C_HCMOD_05 PDF

SAP Certified Application Associate - SAP HANA Cloud Modeling Questions and Answers

Question 1

In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

Options:

A.

To ensure it is not exposed to reporting tools for consumption

B.

To indicate that it should not be used as a data source to other calculation views

C.

To warn developers that the calculation view is no longer supported

D.

To lock the calculation view from further modifications

Question 2

In a calculation view, what is the purpose of a variable?

Options:

A.

To pass values between procedures and calculation views

B.

To provide a dynamic value in a calculated column

C.

To break up complex SQL into smaller steps

D.

To filter an attribute at runtime based on a user input

Question 3

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

Options:

A.

Higher data compression rates

B.

Improved write performance on frequent updates

C.

Additional indexes are used

D.

Parallel access is improved

E.

Higher performance for query operations

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?

Options:

A.

Use a union node.

B.

Use an intersect node.

C.

Use an aggregation node.

D.

Use a minus node

Question 5

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

Options:

A.

They can limit parallelization of query execution.

B.

They introduce potential security risks.

C.

They could modify the database.

D.

They call multiple processing engines.

Question 6

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

Options:

A.

To pass variable values to external value help views

B.

To assign variables to one or more attributes

C.

To push down filters to the lowest level calculation views

D.

To convert the data types of input parameters

Question 7

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

Options:

A.

Set the HIDE property for columns NOT required.

B.

Write and execute a custom SQL query in the SQL Console.

C.

Select Data Preview for the calculation view.

D.

Select and deselect columns from the output mapping.

Question 8

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

Options:

A.

To improve response time when multiple users access the same table

B.

To improve query performance when accessing large column tables

C.

To improve data replication performance on large row tables

D.

To overcome the 2 billion record limit

Question 9

Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

Options:

A.

Analytics

B.

Intelligent Suite

C.

Experience Management

D.

Application Development & Integration

Question 10

What is a restricted measure?

Options:

A.

A measure that can be consumed by a CUBE and not a DIMENSION.

B.

A measure that is filtered by one or more attribute values.

C.

A measure that can only be displayed by those with necessary privileges.

D.

A measure that cannot be referenced by a calculated column.

Question 11

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

Options:

A.

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

B.

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

C.

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

D.

To retain the correct aggregation behavior in stacked views

Question 12

You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

Options:

A.

Staging area -> Working directory -> Local Git repository

B.

Working directory -> Staging area -> Local Git repository

C.

Working directory -> Local Git repository -> Staging area

D.

Local Git repository -> Staging area -> Working directory

Question 13

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.

Options:

A.

Pre-calculated aggregates

B.

Indexes

C.

Stored procedures

D.

Table partitions

Question 14

What do you use in the definition of a dynamic SQL analytic privilege?

Options:

A.

A table function that returns a list of allowed values.

B.

A scalar function that returns a list of the allowed values for each attribute.

C.

A procedure that returns the data access condition as an SQL expression.

D.

An organization hierarchy that provides role-based access to data.

Question 15

You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

Options:

A.

Calculated columns

B.

Filters

C.

Joins

D.

Data sources of unions

Question 16

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.

What could be the problem?Note: There are 2 correct answers to this question.

Options:

A.

The Country column is requested.

B.

Join cardinality is set :1.

C.

The Keep flag is activated for the Customer column.

D.

Integrity constraint is set to RIGHT.

Question 17

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?

Options:

A.

US for P1 and GE for P1

B.

US for P1 and P2, and GE for P1 and P2

C.

US for P1

D.

US for P1 and P2, and GE for P2

Question 18

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

Options:

A.

Your function includes a TRUNCATE statement.

B.

Your function refers to a scalar function.

C.

You did NOT define a valid table type.

D.

You did not define at least one input parameter.

Question 19

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?

Options:

A.

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

B.

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

C.

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

D.

Execute the refactor function for the calculation view.

Question 20

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

Options:

A.

Create graph workspaces

B.

Configure data tiering

C.

Develop calculation views

D.

Develop SAP Fiori apps

Question 21

You want to join two tables in a calculation view.Why do you use a non-equi join?

Options:

A.

Join columns have different data types.

B.

The number of joined columns is different in each table.

C.

Join columns need to be ignored when NOT requested by the query.

D.

The join condition is not represented by matching values.

Question 22

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

Options:

A.

The hierarchy must be exposed by a calculation view of type CUBE with star join.

B.

The hierarchy must be a shared hierarchy.

C.

The hierarchy must be a local hierarchy.

D.

The hierarchy must be a parent-child hierarchy.

Question 23

At which levels of a project structure can you execute a deploy operation?Note: There are 2 correct answers to this question.

Options:

A.

Individual source file

B.

Entire workspace

C.

Sub-folder of a database module

D.

Individual container

Question 24

What is the recommended tool for developing cloud foundry applications?

Options:

A.

SAP Business Application Studio

B.

SAP HANA Cloud Central

C.

SAP HANA Web IDE

D.

SAP HANA cockpit

Question 25

You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.

However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

Options:

A.

You already mapped the input parameters in another calculation view.

B.

The names of the input parameters do not match.

C.

You selected the wrong parameter mapping TYPE.

D.

Your source calculation view is of type DIMENSION.

Question 26

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

Options:

A.

To generate hierarchies

B.

To define a filter

C.

To convert currencies

D.

To generate a restricted column

E.

To generate a calculated column

Load More C_HCMOD_05 Questions
Demo: 26 questions
Total 88 questions
Get C_HCMOD_05 Full Access Download C_HCMOD_05 PDF