SAP C_HAMOD_2404 Exam Practice Test Instant Access

Question 1

What is a restricted measure?

AA measure that can only be displayed by those with necessary privileges

BA measure that is filtered by one or more attribute values

CA measure that can be consumed by a CUBE and not a DIMENSION

DA measure that cannot be referenced by a calculated column

Answer : B

Question 2

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

Question 3

You run a CREATE REMOTE SOURCE SQL statement to create a smart data integration remote source, but the statement fails. What could be the reason? Note: There are 2 correct answers to this question.

AThe credentials clause defines TYPE 'PASSWORD' but does not specify a technical user

BThe remote system is not reached through the company network

CYou do not have the CREATE REMOTE SOURCE privilege on the remote system

DThe specified adapter is not registered with your SAP HANA system

Answer : A, D

Question 4

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this?

AThe query requests only a subset of the cached results.

BYou did not define a filter in the cache setting.

CYour cache setting does not specify any columns.

DThe cache data retention period has expired.

Answer : B

Question 5

You combine two tables in a join node using multiple columns in each table.

Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.

ATo force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

BTo allow data analysis at different levels of granularity with the same calculation view

CTo ensure that the aggregation always happens after the join execution

DTo ensure that the join execution uses only the join columns requested in the query

Answer : B, D

Question 6

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 7

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.

How do you check if pruning occurs? Note: There are 2 correct answers to this question.

ACheck the SQL query generated by the Data Preview.

BUse the SQL Analyzer to identify the tables used.

CEnable the Debug Query mode to identify the source columns used.

DObserve which columns are mapped using the Performance Analysis mode.

Answer : C, D

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