SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

In an XS Advanced project, what is the purpose of the .hdiconfig file?

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

BTo specify which HDI plug-ins are available

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

DTo specify in which space the container should be deployed

Answer : B

Question 2

You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view.Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

ALabel column

BShow lineage

CImpact analysis

DWhere used

Answer : B

Question 3

Why do you create calculation views of data category DIMENSION with type TIME?

ATo provide additional time-related navigation possibilities

BTo add a temporal condition to a join to find matching records from two tables based on a date

CTo store historical versions of attributes

DTo provide the time intervals required by time-dependent parent-child hierarchies

Answer : A

Question 4

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

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

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

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

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

Answer : B, C

Question 5

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

APartition large tables.

BLimit the number of stacked calculation views.

CImplement union pruning.

DAvoid aggregating data early in the data flow.

Answer : A, B

Question 6

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?

AYour function refers to a scalar function.

BYou did NOT define a valid table type.

CYou did not define at least one input parameter.

DYour function includes a TRUNCATE statement.

Answer : D

Question 7

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?

ADefine a restricted column in a union node.

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

CInclude an aggregation node above the union node.

DAdd an intersect node above the union node.

Answer : C

SAP Certified Application Associate - SAP HANA 2.0 SPS06 C_HANAIMP_18 Exam Questions