SAP C_HANAIMP_18 Exam Practice Test Instant Access

Question 1

When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

AVirtual Table

BSynonym

CAssociation

DAlias

Answer : B

Question 2

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 3

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 4

In a calculation view, why would you implement an SQL expression?Note: There are 3 correct answers to this question.

ATo convert currencies

BTo generate hierarchies

CTo define a filter

DTo generate a calculated column

ETo generate a restricted column

Answer : C, D, E

Question 5

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

AA SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

BSELECT privileges and Analytic Privileges (Country = United States) on both views

CA SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

DA SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view

Answer : A

Question 6

Why might you use the Keep Flag property in an aggregation node?

ATo ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

BTo retain the correct aggregation behavior in stacked views

CTo include columns that are NOT requested by a query but are essential for the correct result

DTo exclude columns that are NOT requested by a query to avoid incorrect results

Answer : C

Question 7

Which of the following supports data replication?

ASAP HANA smart data access

BSAP HANA, streaming analytics option

CSAP HANA smart data quality

DSAP HANA smart data integration

Answer : D

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