C-HANAIMP151試験無料問題集（220題）「SAP Certified Application Associate

出題：1

You have to do reverse pivot transformations on large data tables before loading the data into SAP HANA.
Which of the following do you recommend to use?

A. SAP BusinessObjects Data Services 4.0

B. SAP HANA Direct Extractor Connection (DXC)

C. SAP System Landscape Directory (SLD)

D. SAP Landscape Transformation (SLT)

正解：A 解答を投票する

出題：2

In SAP HANA studio, in which of the following can you create users?

A. The SQL editor

B. The Administration console

C. The Content node

D. The Roles node

正解：A,B 解答を投票する

出題：3

In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?

A. COUNT

B. SUM

C. MIN

D. MAX

正解：B 解答を投票する

出題：4

You need to retrieve data from SAP HANA that is restricted to a certain region and specific users.
How can you implement this security strategy?

A. By assigning Analytic privileges to the necessary users

B. By assigning SQL privileges to the necessary users

C. By assigning Package privileges to the necessary users

D. By assigning System privileges to the necessary users

正解：A 解答を投票する

出題：5

Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT.
Where in the attribute properties of ID_1 can you change this?

A. In the alias label

B. In the alias name

C. In the label

D. In the name

正解：A,B 解答を投票する

出題：6

Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such asOperational Reporting for SAP HANA?

A. Customized tables and columns are replicated.

B. Relevant tables are replicated.

C. SAP will create information models based on customer requirements.

D. Pre-designed information models are imported into SAP HANA.

正解：B,D 解答を投票する

出題：7

You have created an MS Excel report on SAP HANA data.
On which of the following could you store the Excel file and make it available for other users?

A. Shared network drive

B. SAP HANA studio Content node

C. SAP HANA database

D. SAP BusinessObjects Information Design Tool

正解：A 解答を投票する

出題：8

How can you improve the performance of an information model?

A. Use attribute views wherever possible.

B. Use constraint filters.

C. Use generated columns.

D. Use indexes on all measures.

E. Use analytic views wherever possible.

正解：B,C,E 解答を投票する

出題：9

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?

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

B. Whether savepoints are written during execution.

C. Whether an InfoCube compression is running.

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

正解：A,D 解答を投票する

出題：10

Which of the following objects would SAP HANA identify as the left object of a join in the graphical calculation view?

A. The object that has its field identified first in the join output.

B. The object that is connected to the join node first.

C. The object that is displayed on the left hand side in the join details panel.

D. The object that is displayed on the left hand side in the graphical calculation view.

正解：B 解答を投票する

出題：11

In which View, client queries can be less optimized and could significantly be slower compare to other models

A. Calculation (SQL)

B. Attribute

C. Analytic

D. Calculation (CE Functions)

正解：A 解答を投票する

出題：12

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 business layer

B. In the analytic privileges

C. In the data foundation

D. In the SQL privileges

正解：A 解答を投票する

出題：13

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?

A. Upgrade to at least SAP NetWeaver Business Warehouse 7.30 SP5.

B. Perform a database migration from your current DB to SAP HANA D

C. Execute the report RS_BW_POST_MIGRATION.

D. Install SAP Business Warehouse Accelerator (BWA).

E. Recreate SAP BW indexes after SAP HANA database migration.

正解：A,B,C 解答を投票する

出題：14

You have imported models from the development system. What is the recommended way toactivate dependent models in SAP HANA?

A. Use the Activate with History function.

B. Use the Cascade Activate function.

C. Activate each view manually.

D. Use the Where-Used List function.

正解：B 解答を投票する

C-HANAIMP151試験無料問題集「SAP Certified Application Associate - SAP HANA (Edition 2015) 認定」