SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

You want to join two tables in a calculation view.Why do you use a non-equi join?

AJoin columns need to be ignored when NOT requested by the query.

BJoin columns have different data types.

CThe number of joined columns is different in each table.

DThe join condition is not represented by matching values.

Answer : D

Question 2

Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.

AExtension Node

BPersistent memory

CNative Storage Extension

DDynamic Tiering

EActive / active read-enabled mode

Answer : A, C, D

Question 3

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 4

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

ADynamic

BHierarchy function

CSQL expression

DAttributes

EGraph

Answer : A, C, D

Question 5

What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

AIt must appear in the last DIMENSION in the star join node.

BIt CANNOT be mixed in the same star join node with other join types.

COnly one column can be included in the join condition.

DIt is restricted to one DIMENSION in a star join node.

Answer : A, D

Question 6

Why would you build a calculation view of type SQL Access only?

ATo enable SQL access to your hierarchies

BTo provide a data source that can only be consumed by a function or procedure

CTo provide a high performance model when only attributes are required

DTo provide a data source that is only consumed by other calculation views

Answer : D

Question 7

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

AThey could modify the database.

BThey call multiple processing engines.

CThey introduce potential security risks.

DThey can limit parallelization of query execution.

Answer : C

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