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

質問 1

Which of the following operations can you use when you create a calculation view using the SAP HANA studio graphical interface? (Choose two)

A. UNION

B. INSERT

C. PROJECTION

D. INTERSECT

正解: A,C

質問 2

You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA? (Choose three)

A. Use the database schema _SYS_REPO.

B. Use the data preview in SAP HANA studio.

C. Use SAP Landscape Transformation (SLT).

D. Write and execute an appropriate SQL statement.

E. Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence).

正解: B,D,E

質問 3

You want to allow another developer to access the information models in one of your packages.
What privilege do you have to assign to this user to allow access?

A. REPO.READ for the package

B. SELECT on _SYS_REPO

C. REPO.MAINTAIN_NATIVE_PACKAGES for the package

D. SELECT on _SYS_REPO with the grant option

正解: A

質問 4

Which of the following nodes do you use to implement filters in a graphical calculation view? (Choose two)

A. Projection

B. Aggregation

C. Join

D. Union

正解: A,B

質問 5

Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)

A. It is based on analytic denormalized data models

B. It persists transformed data

C. It runs directly on top of the operational data

D. It uses real-time replication of time-critical data

正解: C,D

質問 6

What is the lowest level of granularity you can use in an analytic privilege?

A. A column

B. An attribute value

C. An attribute

D. A view

正解: B

質問 7

You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this?

A. In the analytic privileges

B. In the SQL privileges

C. In the business layer

D. In the data foundation

正解: C

質問 8

Which of the following selection types are available when creating a variable in an analytic view? (Choose three)

A. Interval

B. Single value

C. Direct

D. Range

E. Column

正解: A,B,D

質問 9

You would like to authorize a user to see data in an analytic view only for company code 1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005.
Which of the following achieves this requirement?

A. One analytic privilege: the combination of company code = 1000 and fiscal year = 2000, and the combination of company code = 1005 and fiscal year = 2005

B. One analytic privilege: company codes = 1000 and 1005
One analytic privilege: fiscal years = 2000 and 2005

C. One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and

D. One analytic privilege: company code = 1000, fiscal year = 2000
One analytic privilege: company code = 1005, fiscal year = 2005

正解: D

質問 10

When must you create a calculation view in SAP HANA?

A. When you need to create a star schema

B. When key figures span across tables

C. When you need calculations before aggregations

D. When you need analytic operations like aggregation

正解: B

質問 11

A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables performs unexpectedly slow.
Which of the following could you investigate to be able to improve performance? (Choose two)

A. Whether an InfoCube compression is running.

B. Whether the calculation view needs to create large intermediate result sets.

C. Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services.

D. Whether savepoints are written during execution.

正解: B,C

質問 12

How can you assess the quality of the loaded data in SAP HANA? (Choose two)

A. Configure the SAP Landscape Transformation tool to implement the data quality process.

B. Compare reports in SAP BusinessObjects against source data for specific selections.

C. Perform master data quality checks in SAP ERP prior to replication in SAP HANA.

D. Compare data from reports in SAP BusinessObjects against the SAP HANA _SYS_STATISTICS table.

正解: B,C

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