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

質問 1

Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities?

A. ODBC connector via MDX requests to analytic or calculation views

B. ODBO connector via MDX requests to column tables

C. ODBO connector via SQL requests to analytic or calculation views

D. ODBO connector via MDX requests to analytic or calculation views

正解: D

質問 2

Which of the following are restrictions of the SAP HANA flat file upload?

A. The upload does not allow to change the column names of new tables.

B. A table must have the same column order as the flat file when you append data.

C. A new table must have a 1:1 mapping between the flat file columns and the table columns.

D. The upload prevents data type changes when appending data.

正解: C,D

質問 3

Which of the following is a best practice in calculation views?

A. Apply a static filter on a projection node.

B. Change an attribute to a measure.

C. Push calculations down to the attribute views.

D. Combine analytic views with a join node.

正解: A

質問 4

You want to create a custom attribute in addition to your data model. How can you achieve this?

A. Create the attribute as a calculated measure within the attribute view.

B. Create the attribute and add it to the appropriate system table manually.

C. Create the attribute as a calculated attribute within the analytic view.

D. Create the attribute as a restricted attribute within the calculation view.

正解: C

質問 5

What is the behavior of a Text Table Join where language column SPRAS is available?

A. Right Outer Join

B. Left Outer Join

C. Referential Join

D. Inner Join

正解: B

質問 6

Which of the following tools can you use to monitor the query time from SAP HANA?

A. Performance tab of the System Monitor

B. Central Management Console

C. SQL Trace

D. Event Viewer

正解: C

質問 7

A new user has implemented an SAP HANA data model.
Which technical user requires select rights on the new user's schema?

A. _SYS_SECURITY

B. _SYS_BIC

C. _SYS_BI

D. _SYS_REPO

正解: D

質問 8

Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA?

A. The sizing of your current SAP BW application servers remains valid.

B. It allows co-deployment of the SAP BW application server on the SAP HANA database hardware.

C. It allows re-use of your available SAP BW application servers.

D. It eliminates the need to upgrade to the latest SAP BW application version.

E. The system usage is the same as an equivalent SAP BW on non-SAP databases.

正解: A,C,E

質問 9

What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA?

A. You can load unstructured data into SAP HAN

B. You can merge data streams.

C. You can perform real-time data replication.

D. You can use the same hardware.

E. You can use BI Content extractors or function modules.

正解: A,B,E

質問 10

What does SAP HANA smart data integration use for data provisioning?

A. Database triggers

B. Database logs

C. SAP HANA smart data streaming

D. SAP HANA smart data access

E. Real-time adapters

正解: B,D,E

質問 11

Which new connection type is available as of SAP BusinessObjects Data Services 4.0?

A. IDOCs

B. BAPI function calls

C. Operational Data Provider

D. Read table via ABAP data flows

正解: C

質問 12

Company needs to load external data from a flat file into SAP HANA. How can you do this?

A. SAP HANA Direct Extractor Connection (DXC)

B. SAP HANA SQL Import statement

C. SAP System Landscape Transformation (SLT)

D. SAP BusinessObjects Data Services

正解: B,D

質問 13

Union can be performed only at...

A. Analytic / Calculation

B. Calculation

C. Analytic

D. Attribute

正解: B

質問 14

For which SAP HANA data types is a FULLTEXT index created automatically during table creation?

A. NCLOB

B. SHORTTEXT

C. TEXT

D. VARCHAR

正解: B,C

SAP Certified Application Associate - SAP HANA (Edition 2015) - C-HANAIMP151 模擬練習