C-HCMOD-01問題集、SAP実際の試験問題

質問 1

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

A. SELECT privileges and Analytic Privileges (Country = United States) on both views

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

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

正解: B

質問 2

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?

A. The query requests only a subset of the cached results.

B. The cache data retention period has expired.

C. You did not define a filter in the cache setting.

D. You did not define any columns in the cache setting.

正解: D

質問 3

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you. When you preview calculation view A, what data do you see?

A. US for P1 and P2, and GE for P2

B. US for P1 and P2, and GE for P1 and P2

C. US for P1

D. US for P1 and GE for P1

正解: D

質問 4

A new release of SAP HANA Cloud, SAP HANA database is available as of today. If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next release?

A. 1 year

B. 2 weeks

C. 3 months

D. 7 months

正解: C

質問 5

What are some of the typical roles in an SAP HANA Cloud implementation? Note: There are 2 correct answers to this question.

A. Data architect

B. Kubernetes expert

C. ABAP developer

D. Modeler

正解: A,D

質問 6

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

A. To improve response time when multiple users access the same table

B. To overcome the 2 billion record limit

C. To improve query performance when accessing large column tables

D. To improve data replication performance on large row tables

正解: C

質問 7

What are the key steps to implement currency conversion in a calculation view?

A. Assign semantic type/Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type

B. Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Deploy the conversion rule

C. Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column

D. Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Assign the conversion rule to your calculation view

正解: A

質問 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. Projection

B. Aggregation

C. Join

D. Union

正解: A

質問 9

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question.

A. The hierarchy must be a parent-child hierarchy.

B. The hierarchy must be a shared hierarchy.

C. The hierarchy must be exposed by a calculation view of type CUBE with star join.

D. The hierarchy must be a local hierarchy.

正解: B,C

SAP Certified Application Associate - SAP HANA Cloud Modeling - C-HCMOD-01 模擬練習