C_HANAIMP141問題集、SAP実際の試験問題

質問 1

When you try to delete an attribute view you receive the error message, "One or more objects are dependent upon this object".
Which of the following functions can you use to find out which objects depend on this view?
Note: There are 2 correct answers to this question.

A. History function

B. Display XML function

C. Auto Documentation function

D. Where-used function

正解: C,D

質問 2

Where can you create a restricted column in a graphical calculation view?

A. Projection node

B. Aggregation node

C. Union node

D. Join node

正解: B

質問 3

Where can you reactivate a user after too many invalid logon attempts?
Note: There are 2 correct answers to this question.

A. In the SQL Console

B. In the INVALID_CONNECT_ATTEMPS view

C. In the user properties in the SAP HANA studio

D. In the user-specific schema

正解: A,C

質問 4

How can you import information models into SAP HANA using the Quick Launch view?

A. Choose Import -> SAP HANA Content -> Delivery Unit.

B. Choose Data Provisioning -> Load.

C. Choose the Redeploy button.

D. Choose Import -> SAP HANA Content -> Import Data From Local File.

正解: A

質問 5

What is the function of an aggregation node in a calculation view?

A. It provides grouping of filter criteria.

B. It calculates the sum, minimum, or maximum values for selected columns.

C. It joins the result sets from different data sources.

D. It allows grouping of columns required for your information model.

正解: B

質問 6

Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax calculates sales tax based on input parameter SALES.
Using a scripted calculation view, how can you call the calc_tax function?

A. v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","calc_tax(SALES)"]);

B. :v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);

C. v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;

D. :v_tax = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE;

正解: C

質問 7

You want to implement an SAP HANA data model based on tables in a new schema that you just created.
Which technical user requires select rights on your new schema?

A. _SYS_SECURITY

B. _SYS_BIC

C. _SYS_BI

D. _SYS_REPO

正解: D

質問 8

You want to improve query performance by introducing filters into the SAP HANA information model.
Which of the following can you use to reduce data transfer between views?
Note: There are 2 correct answers to this question.

A. Calculated columns

B. Analytic privileges

C. Client-independent views

D. Constraint filters

正解: B,D

SAP Certified Application Associate (Edition 2014) - SAP HANA - C_HANAIMP141 模擬練習