SAP C_HANAIMP_18 Exam Questions 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

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

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

APartition large tables.

BLimit the number of stacked calculation views.

CImplement union pruning.

DAvoid aggregating data early in the data flow.

Answer : A, B

Question 4

Why do we use Git when modeling calculation views?Note: There are 2 correct answers to this question.

ATo manage versions of source files

BTo display dependencies in stacked scenarios

CTo automate the build process

DTo enable collaboration between developers

Answer : A, D

Question 5

Why would you implement active / active read-enabled mode?

ATo provide offline access to data

BTo synchronize query results with operational data

CTo enhance security for data access

DTo improve query performance

Answer : B

Question 6

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 7

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

ATo ensure semantic correctness

BTo force filters to apply at the lowest node

CTo hide columns that are not required

DTo avoid duplicate rows in the output

Answer : B

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