SAP Certified Associate - Data Engineer - SAP HANA - C_HAMOD

QUESTION NO: 1
Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

A. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country United States) on the DIMENSION calculation view B. SELECT privileges and Analytic Privileges (Country United States) on both views C. A SELECT privilege and an Analytic Privilege (Country United States) on the CUBE calculation view D. A SELECT privilege and an Analytic Privilege (Country United States) on the DIMENSION calculation view

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?

A. Procedure B. Scalar function C. Anonymous block D. Table function

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
Your flowgraphs defines a template table as a data target. What triggers the generation of the template table?

A. Defining the flowgraph data target node B. Building/deploying the flowgraph C. Saving the flowgraph D. Running the flowgraph

Correct Answer: A

QUESTION NO: 4
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.

A. Synonym B. SQL view C. Authorization D. Remote source

Correct Answer: A,C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note:
There are 2 correct answers to this question.

A. The block must start with a node that defines a table as a data source. B. The block must have only one start node. C. Only one block can be defined across a stack of calculation views. D. Multiple blocks can be defined only within a single calculation view.

Correct Answer: A,C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 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.

A. The Keep flag is activated for the Customer column. B. The Country column is requested. C. Join cardinality is set: 1. D. Integrity constraint is set to RIGHT.

Correct Answer: A,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
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?

A. In the union node, map both source customer name columns to one target column. B. Define a restricted column in a union node. C. Add an intersect node above the union node. D. Include an aggregation node above the union node.

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
You have generated a calculation view properties file. What does it contain?

A. All settings defined in a calculation view B. Documentation to support the calculation view C. Descriptions of all objects defined in a calculation view D. Dependencies between calculation views

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 9
You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR?

A. "2" B. <empty string> C. "#" D. "Null"

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

SAP Certified Associate - Data Engineer - SAP HANA - C_HAMOD_2404 Exam Questions