SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

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 2

You have generated a calculation view properties file.What does it contain?

ADescriptions of all objects defined in a calculation view

BAll settings defined in a calculation view

CDependencies between calculation views

DDocumentation to support the calculation view

Answer : A

Question 3

Why would you create SQL in calculation views?

ATo implement custom logic

BTo provide an alternative to graphical modeling

CTo enable write capabilities

DTo fine-tune performance

Answer : A

Question 4

What are some of the restrictions that apply when defining parallelization blocks in calculation views?Note: There are 2 correct answers to this question.

AThe block must start with a node that defines a table as a data source.

BMultiple blocks can only be defined within a single calculation view.

CThe block must only have one start node.

DOnly one block can be defined across a stack of calculation views.

Answer : A, D

Question 5

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

AText join

BLeft outer join

CInner join

DReferential join

Answer : C

Question 6

Why would you partition a table in an SAP HANA Cloud database?Note: There are 2 correct answers to this question.

ATo improve response time when multiple users access the same table

BTo overcome the 2 billion record limit

CTo improve data replication performance on large row tables

DTo improve query performance when accessing large column tables

Answer : B, D

Question 7

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February.

What is the optimal way to do this?

AUse a union node.

BUse a minus node.

CUse an intersect node.

DUse an aggregation node.

Answer : A

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