SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

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 2

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you

perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

AThe first build is successful.The second build is successful.

BThe first build fails.The second build fails.

CThe first build is successful.The second build fails.

DThe first build fails.The second build is successful.

Answer : A

Question 3

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

Question 4

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

ADefine a restricted column in a union node.

BIn the union node, map both source customer name columns to one target column.

CInclude an aggregation node above the union node.

DAdd an intersect node above the union node.

Answer : C

Question 5

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

AExpected memory consumption

BUsage statistics of the calculation view

CJoins that are defined on calculated columns

DInformation about join cardinality

Answer : C, D

Question 6

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

AExecute a DROP statement in an SQL console connected to the HDI container.

BBuild the project that contained the deleted design-time file.

CExecute the refactor function for the calculation view.

DBuild the folder that contained the deleted design-time file.

Answer : D

Question 7

Why would you create a multistore table?

ATo implement a table that combines the features of row and column store

BTo enable partitioning of the table across different storage tiers

CTo improve read performance when the table is accessed by simultaneous applications

DTo evenly distribute the data across all available server nodes

Answer : B

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