C_HAMOD_2404試験無料問題集（82題）「SAP Certified Associate - Data Engineer

出題：1

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

A. Combine the transaction tables using an aggregation node in a CUBE calculation view.
* Use a star join node to join the DIMENSIONS to the resulting fact table.

B. Combine the transaction tables using a join node in a CUBE calculation view.
* Combine the DIMENSIONS using another join node.
* Use a star join node to combine both resulting fact and dimension tables.

C. Combine the transaction tables using a star join node in a CUBE calculation view.
* Use a join node to join the DIMENSIONS to the resulting fact table.

D. Combine the transaction tables using a join node in a CUBE calculation view.
* Use a star join node to join the DIMENSIONS to the resulting fact table.

正解：D 解答を投票する

出題：2

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

A. Use dynamic SQL.

B. Break up large statements by using variables.

C. Control the flow logic using IF-THEN-ELSE conditions.

D. Choose declarative language instead of imperative language.

正解：B,D 解答を投票する

出題：3

Why would you use an anonymous block when writing SQLScript?

A. To execute a statement without creating entries in the database log.

B. To check the results without applying user privileges.

C. To test your code without generating a logic container.

D. To hide the actual tables by using aliases in the code.

正解：C 解答を投票する

出題：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. Authorization

C. SQL view

D. Remote source

正解：A,B 解答を投票する

出題：5

A cube calculation view consumes a dimension calculation view. You rename the design time file of the dimension view but do NOT choose the option to rename the runtime view and adjust the reference. Afterward, you perform the following operations:
* A: Build/deploy the dimension calculation view as a single object.
* B: Build/deploy the entire SAP HANA database module. What is the outcome of the build/deploy operations?

A. A fails.
* B is successful.

B. A is successful.
* B is successful.

C. A fails.
* B fails.

D. A is successful.
* Fails.

正解：B 解答を投票する

出題：6

In a flowgraph, which node do you use to select only the required columns from a data source and to filter specific rows?

A. Projection

B. Pivot

C. Aggregate

D. Case

正解：C 解答を投票する