March Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

C_HANAIMP_18 Questions and Answers

Question # 6

How can you define a variable that presents its value help hierarchically?Note: There are 2 correct answers to this question.

A.

Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the parent attribute of the hierarchy.

B.

Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the leaf level of the hierarchy.

C.

Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the child attribute of the hierarchy.

D.

Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the top level of the hierarchy.

Full Access
Question # 7

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

A.

Hint

B.

Placeholder

C.

Where

D.

Set

Full Access
Question # 8

What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

A.

Cached results to improve read performance

B.

A column view in a container

C.

Metadata to enable consumption by external tools

D.

An SQL execution plan

Full Access
Question # 9

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?

A.

Your function refers to a scalar function.

B.

You did NOT define a valid table type.

C.

You did not define at least one input parameter.

D.

Your function includes a TRUNCATE statement.

Full Access
Question # 10

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

A.

To convert the data types of input parameters

B.

To assign variables to one or more attributes

C.

To push down filters to the lowest level calculation views

D.

To pass variable values to external value help views

Full Access
Question # 11

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?

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.

Include an aggregation node above the union node.

D.

Add an intersect node above the union node.

Full Access
Question # 12

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you

perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

A.

The first build is successful.The second build is successful.

B.

The first build fails.The second build fails.

C.

The first build is successful.The second build fails.

D.

The first build fails.The second build is successful.

Full Access