SAP C_HANAIMP_18 Exam Practice Test Instant Access

Question 1

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node.How many rows are in the output of your query?

Answer : C

Question 2

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to build the calculation view, the build fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

AThe imported calculation view and its data source have different namespaces.

BThe namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

CThe .hdinamespace specifies 'sub-folder':'append', so calculation views can only be created in subfolders.

DAn .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.

Answer : A, B

Question 3

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.

AUse an inner join

BLimit the number of joined columns

CSpecify the join cardinality

DDefine join direction in a full outer join

Answer : B, C

Question 4

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

AAssign them to a level below the root.

BDefine an expression to determine a parent.

CAssign them to a node at the root level.

DGenerate additional root nodes.

Answer : C, D

Question 5

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

AYou did not define any columns in the cache setting.

BThe cache data retention period has expired.

CThe query requests only a subset of the cached results.

DYou did not define a filter in the cache setting.

Answer : A

Question 6

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?

AProcedure

BScalar function

CAnonymous block

DTable function

Answer : D

Question 7

Using the table in the diagram, you need to create a cube calculation view.What is the simplest approach to create the output from the screenshot?

ACreate 3 calculated columns.

BCreate a restricted column for each country.

CImplement a union node and map each year as a separate column.

DCreate a filter expression that uses an OR operator.

Answer : C

SAP C_HANAIMP_18 SAP Certified Application Associate - SAP HANA 2.0 SPS06 Exam Practice Test