SAP C_HAMOD_2404 Exam Practice Test Instant Access

Question 1

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?

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

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

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

DExecute the refactor function for the calculation view.

Answer : A

Question 2

Why do we use Git when modeling calculation views?

ATo display dependencies in stacked scenarios

BTo automate the build process

CTo manage versions of source files

DTo enable collaboration between developers

Answer : C

Question 3

You have imported a new calculation view into 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 .hdinamespace specifies 'sub-folder':'append', so calculation views can only be created in subfolders.

BThe imported calculation view and its data source have different namespaces.

CThe namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

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 : B, C

Question 4

In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.

ATo warn developers that the calculation view is no longer supported

BTo indicate that it should not be used as a data source to other calculation views

CTo lock the calculation view from further modifications

DTo redirect queries on this calculation view to another one

Answer : A, B

Question 5

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.

ASynonym

BRemote source

CSQL view

DAuthorization

Answer : A, D

Question 6

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.

AThe Country column is requested.

BJoin cardinality is set: 1.

CThe Keep flag is activated for the Customer column.

DIntegrity constraint is set to RIGHT.

Answer : C, D

Question 7

Which of the following approaches might improve the performance of joins in a CUBE calculation view? Note: There are 2 correct answers to this question.

ASpecify the join cardinality.

BLimit the number of joined columns.

CDefine join direction in a full outer join.

DUse an inner join.

Answer : A, B

SAP C_HAMOD_2404 SAP Certified Associate - Data Engineer - SAP HANA Exam Practice Test