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

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

Demo: 12 questions
Total 1 questions

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

Question 1

Which project structure object corresponds to a unique HDI container?

Options:

A.

project

B.

space

C.

src folder

D.

database module

Question 2

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

Options:

A.

Multiple blocks can only be defined within a single calculation view.

B.

Only one block can be defined across a stack of calculation views.

C.

The block must only have one start node.

D.

The block must start with a node that defines a table as a data source.

Question 3

You have generated a calculation view properties file.What does it contain?

Options:

A.

Descriptions of all objects defined in a calculation view

B.

All settings defined in a calculation view

C.

Dependencies between calculation views

D.

Documentation to support the calculation view

Question 4

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 5

What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

Options:

A.

Data architect

B.

Modeler

C.

Kubernetes expert

D.

ABAP developer

Question 6

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

Options:

A.

Define a restricted column in a union node.

B.

In the union node, map both source customer name columns to one target column.

C.

Add an intersect node above the union node.

D.

Include an aggregation node above the union node.

Question 7

Why would you create SQL in calculation views?

Options:

A.

To implement custom logic

B.

To provide an alternative to graphical modeling

C.

To fine-tune performance

D.

To enable write capabilities

Question 8

A new version of SAP HANA Cloud, SAP HANA database is available from today.If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

Options:

A.

7 months

B.

3 months

C.

2 weeks

D.

1 year

Question 9

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 10

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

Options:

A.

You want to use SAP Business Application Studio.

B.

You want to use containers to isolate objects.

C.

You want to develop calculation views.

D.

You want to create database objects using source files.

E.

You want to use synonyms to access external data.

Question 11

Using the table in the diagram, you need to create a CUBE calculation view.

What is the simplest approach to create the output shown in the screenshot?

Options:

A.

Implement a union node and map each country as a separate column.

B.

Create a restricted column for each country.

C.

Create a filter expression that uses an OR operator.

D.

Create 3 calculated columns.

Question 12

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.

Demo: 12 questions
Total 1 questions