最新的SAP Certified Application Associate認證 C_HCMOD_01考試題庫

問題1

A calculation view includes a rank node that uses the source data and settings shown in the graphic.
Your query requests all columns of the rank node. How many rows are in the output of your query?

A. 9

B. 6

C. 5

D. 2

正確答案: A

問題2

Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.

A. Scalar function

B. Row table

C. Table function

D. Procedure

正確答案: B,C

問題3

What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question.

A. Configure data tiering

B. Create graph workspaces

C. Develop SAP Fiori apps

D. Develop calculation views

正確答案: B,D

問題4

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud. Why should you switch calculated column expression language from column engine to SQL?

A. To define limits for query unfolding

B. Incorrect aggregations may be generated

C. Column engine language is not supported.

D. To benefit from additional SQL optimizations

正確答案: D

問題5

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 calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.

B. Combine the transaction tables using a join node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.

C. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use the same star join node to connect the DIMENSIONS to the fact table.

D. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.

正確答案: B

問題6

You want to ensure that your calculation view does not give unexpected results based on the selected columns in the query. What is the recommended approach for verifying the results?

A. Select and deselect columns from the output mapping.

B. Select Data Preview for the calculation view.

C. Execute a custom SQL query in the SQL Console.

D. Set the HIDE property for columns NOT required.

正確答案: B,C

問題7

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. Scalar function

B. Table function

C. Procedure

D. Anonymous block

正確答案: B

問題8

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it. What do you observe in the SAP HANA database container?

A. The deployment fails and the table is not dropped.

B. The deployment fails and the table is dropped.

C. The deployment is successful and the data preview returns expected data.

D. The deployment is successful but the data preview returns an error message.

正確答案: A

問題9

Which type of join supports a temporal condition in a calculation view?

A. Left outer join

B. Inner join

C. Referential join

D. Text join

正確答案: B

最新的SAP Certified Application Associate - SAP HANA Cloud Modeling - C_HCMOD_01免費考試真題

最新更新

站內鏈接

聯系我們