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

Activedumpsnet 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

Page: 1 / 9
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

Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

Options:

A.

Table function

B.

Procedure

C.

Scalar function

D.

Row table

Question 2

Which components are part of SAP HANA Cloud?Note: There are 2 correct answers to this question.

Options:

A.

SAP Analytics Cloud

B.

Data lake

C.

SAP HANA database

D.

SAP Enterprise Architecture Designer

Question 3

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 4

Which type of join supports a temporal condition in a calculation view?

Options:

A.

Referential join

B.

Inner join

C.

Text join

D.

Left outer join

Question 5

Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

Options:

A.

Projection

B.

Join

C.

Union

D.

Aggregation

Question 6

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 7

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 8

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 9

What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

Options:

A.

Access hierarchies created in external schemas

B.

Enable SQL SELECT statements to access hierarchies

C.

Provide reusable hierarchies for drilldown in a CUBE with star join

D.

Provide reusable hierarchies for drilldown in a CUBE without star join

Question 10

You have linked an underlying node to the star join node to define the data foundation. Which data source type can you then join to the data foundation?

Options:

A.

Tables

B.

CUBE calculation view

C.

DIMENSION calculation view

D.

Table functions

Question 11

Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

Options:

A.

To automate the generation of the code

B.

To pass parameters from calculation views

C.

To exploit additional data types

D.

To include ABAP syntax in the code

E.

To implement conditional logic

Question 12

In a database module, what is the purpose of the .hdiconfig file?

Options:

A.

To specify an external schema in which calculation views will get their data

B.

To specify which HDI plug-ins are available

C.

To specify in which space the container should be deployed

D.

To specify the namespace rules applicable to the name of database objects

Question 13

What is the default view node for a cube?

Options:

A.

PROJECTION

B.

SEMANTICS

C.

AGGREGATION

D.

UNION

Question 14

You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

Options:

A.

B.

"?"

C.

"0"

D.

"Null"

Question 15

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 16

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

Options:

A.

To include columns that are NOT requested by a query

B.

To avoid columns being unnecessarily used in an aggregation

C.

To apply filters that are hidden from the end user

D.

To allow filter push-down in stacked calculation views

Question 17

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

Options:

A.

Scalar function

B.

Table function

C.

Anonymous block

D.

Procedure

Question 18

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

Options:

A.

Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.

B.

Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.

C.

Combine the transaction tables using a join node in a calculation view of type CUBE with star join.Use a star join node to join the DIMENSIONS to the fact table.

D.

Combine the transaction tables using a star join node in a calculation view of type CUBE with star join.Use the same star join node to connect the DIMENSIONS to the fact table.

Question 19

What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

Options:

A.

Define an expression to determine a parent.

B.

Generate additional root nodes.

C.

Assign them to a level below the root.

D.

Assign them to a node at the root level.

Question 20

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.

Options:

A.

To prevent passing columns in stacked calculation views

B.

To ensure specific columns are NOT exposed to the reporting tool

C.

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

D.

To avoid exposing sensitive columns when defining calculated columns

Question 21

Referring to the diagram,

Question # 21

which privileges would a user require to view United States data when querying the CUBE calculation view?

Options:

A.

A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

B.

A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

C.

A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view

D.

SELECT privileges and Analytic Privileges (Country = United States) on both views

Question 22

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

Options:

A.

To benefit from additional SQL optimizations

B.

Incorrect aggregations may be generated

C.

Column engine language is not supported.

D.

To define limits for query unfolding

Question 23

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

Options:

A.

To ensure semantic correctness

B.

To hide columns that are not required

C.

To avoid duplicate rows in the output

D.

To force filters to apply at the lowest node

Question 24

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

Options:

A.

WHERE

B.

PLACEHOLDER

C.

HINT

D.

SET

Question 25

Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note: There are 2 correct answers to this question.

Options:

A.

Specify the join cardinality

B.

Limit the number of joined columns

C.

Use an inner join

D.

Define join direction in a full outer join

Question 26

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.

Load More C_HCMOD_05 Questions 
Page: 1 / 9
Total 88 questions
Get C_HCMOD_05 Full Access Download C_HCMOD_05 PDF