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

問題1

In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

A. The first deployment fails.The second deployment is successful.

B. The first deployment is successful.The second deployment fails.

C. The first deployment is successful.The second deployment is successful.

D. The first deployment fails.The second deployment fails.

正確答案: C

問題2

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

A. Use an aggregation node.

B. Use a minus node

C. Use a union node.

D. Use an intersect node.

正確答案: D

問題3

You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram.

When you preview calculation view A, the account number is not masked.What could be the reason?

A. The UNMASKED privilege has NOT been granted at the schema level.

B. The type of the Account_Number column is VARCHAR.

C. You previewed the data with the technical user in SAP Business Application Studio.

D. You did not define masking in calculation view A.

正確答案: D

問題4

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 and an Analytic Privilege (Country = United States) on the CUBE 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 DIMENSION calculation view

D. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

正確答案: D

問題5

Why might you use the Keep Flag property in an aggregation node?

A. To exclude columns that are NOT requested by a query to avoid incorrect results

B. To retain the correct aggregation behavior in stacked views

C. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

D. To include columns that are NOT requested by a query but are essential for the correct result

正確答案: D

問題6

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

問題7

Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

A. To push down filters to the lowest level calculation views

B. To assign variables to one or more attributes

C. To pass variable values to external value help views

D. To convert the data types of input parameters

正確答案: A,C

問題8

Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

A. Join

B. Union

C. Aggregation

D. Projection

正確答案: D

問題9

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

A. Hierarchy function

B. SQL expression

C. Attributes

D. Dynamic

E. Graph

正確答案: B,C,D

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

最新更新

站內鏈接

聯系我們