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

質問 1

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

正解: B

質問 2

Why would you use the Transparent Filter property in a calculation view?

A. To include columns that are NOT requested by a query

B. To apply filters that are hidden from the end user

C. To allow filter push-down in stacked calculation views

D. To avoid columns being unnecessarily used in an aggregation

正解: C

質問 3

What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

A. Access hierarchies created in external schemas

B. Enable SQL SELECT statements to access hierarchies

C. Provide reusable hierarchies for drilldown in a CUBE without star join

D. Provide reusable hierarchies for drilldown in a CUBE with star join

正解: B,C

質問 4

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. "Null"

B. "?"

C. "0"

D. <empty string>

正解: D

質問 5

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 intersect node.

B. Use a union node.

C. Use an aggregation node.

D. Use a minus node

正解: A

質問 6

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

C. Row table

D. Procedure

正解: B,C

質問 7

What do you use in the definition of a dynamic SQL analytic privilege?

A. A scalar function that returns a list of the allowed values for each attribute.

B. A procedure that returns the data access condition as an SQL expression.

C. A table function that returns a list of allowed values.

D. An organization hierarchy that provides role-based access to data.

正解: B

質問 8

Which project structure object corresponds to a unique HDI container?

A. space

B. src folder

C. database module

D. project

正解: B

質問 9

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. Anonymous block

C. Table function

D. Procedure

正解: C

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