SAP C_HANAIMP_18 Quiz 1 Topic 1 Questions 1-5

Question: 1

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?

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

BThe first build fails.The second build fails.

CThe first build is successful.The second build fails.

DThe first build fails.The second build is successful.

Show Answer

Question: 2

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

ATo avoid columns being unnecessarily used in an aggregation

BTo include columns that are NOT requested by a query

CTo apply filters that are hidden from the end user

DTo allow filter push-down in stacked calculation views

Show Answer

Question: 3

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

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

BSelect and deselect columns from the output mapping.

CSet the HIDE property for columns NOT required.

DSelect Data Preview for the calculation view.

Show Answer

Question: 4

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

ATo convert the data types of input parameters

BTo assign variables to one or more attributes

CTo push down filters to the lowest level calculation views

DTo pass variable values to external value help views

Show Answer

Question: 5

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?

A. '?' B. 'Null' C. '0'

D<empty string>

Show Answer

SAP C_HANAIMP_18 Quiz:1 Topic:1 Questions:1-5