SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

ACount-distinct results are incorrect

BResults are read from static cache

CQuery processing time improves

DSQL compilation time increases

Answer : B, D

Question 2

You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data from a table located in an external schema within the same local database.Which of the following items do you need?Note: There are 2 correct answers to this question.

AAuthorization

BSynonym

CSQL view

DRemote source

Answer : A, B

Question 3

Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question.

AYou want to create a dynamic analytic privilege.

BA temporary table must be created within the code.

COptimal performance is a priority.

DThe code should modify data in a table.

EYou need to use conditional logic.

Answer : A, B, D

Question 4

What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

ACached results to improve read performance

BA column view in a container

CMetadata to enable consumption by external tools

DAn SQL execution plan

Answer : B, C

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

What is the SQL keyword used to process input parameters defined in a calculation view?

AHint

BPlaceholder

CWhere

DSet

Answer : B

Question 7

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

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