C-HANAIMP-17問題集、SAP実際の試験問題

質問 1

In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function?

A. Scalar function

B. Table function

C. Synonym

D. Input parameter

正解: B

質問 2

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 Build 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

質問 3

How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

A. Build a flow graph and call it from the table function using input parameters

B. Call the SAP-provided PAL decision tree procedure from the table function

C. Copy and adapt the SQL code generated by a flow graph into the table function

D. Use dynamic SQL in the table function to generate the SQL code

正解: A,C

質問 4

What are the components of a graph workspace?
Note: There are 2 correct answers to this question.

A. Edge

B. Vertex

C. Association

D. Dimension

正解: A,B

質問 5

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 DIMENSION Calculation view

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

C. SELECT or Privileges and Analytic Privileges on both views

D. Analytic Privileges and SELECT privileges on the CUBE Calculation view

正解: B

質問 6

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

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

B. To retain the correct aggregation behavior in stacked views.

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

D. To cache the results of the aggregation node for drill-down

正解: C

質問 7

You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?
Note: There are 2 correct answers .

A. The hierarchy must be defined in a calculation view of type SQL ACCESSONLY.

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

質問 8

Which of the following allows data replication?

A. SAP HANA smart data quality

B. SAP HANA smart data integration

C. SAP HANA streaming analytics

D. SAP HANA smart data access

正解: B

質問 9

You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
Note: There are 2 correct answers to this question.

A. To hide individual patients in groups of similar records

B. To restrict data access for specific users or roles

C. To add noise to the data to hide the actual values

D. To provide partial value such as #34343#34##

正解: A,C

SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C-HANAIMP-17 模擬練習