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

出題：1

Which of the following are restrictions of the SAP HANA flat file upload? (Choose two)

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

B. The upload does not allow changes to the column names of new tables.

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

D. A new table always has a 1:1 mapping between the flat file columns and the table columns.

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

出題：2

In a graphical calculation view, you specify the default client to be dynamic.
How is the client value determined when the view is used?

A. By executing a procedure in the user's own schema.

B. By checking the session client of the user accessing the view.

C. By reading the client of the tables in the view.

D. By applying the filtering conditions on the client field.

正解：B 解答を投票する

出題：3

What is the minimum requirement for a valid analytic view?

A. One attribute view

B. One fact table and one attribute view

C. One fact table and two attribute views

D. One fact table

正解：D 解答を投票する

出題：4

A company wants to use SAP BusinessObjects reporting tools. They cannot use Adobe Flash. They require scheduled, ready-made reports.
Which reporting tool do you recommend? (Choose two)

A. Explorer

B. Crystal Reports

C. Web Intelligence

D. Dashboards

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

出題：5

Two attribute views in the same analytic view contain the same column name (ID from attribute view Customer and ID from attribute view Product). In the output, the system automatically renamed one column to ID_1.
Which of the following can you do to indicate that ID_1 originated from attribute view Product?

A. Create a derived attribute view with an alias for ID_1.

B. Update the alias in the properties of ID_1.

C. Change the label of ID_1.

D. Create a restricted column with a different name based on ID_1.

正解：B 解答を投票する

出題：6

A customer wants to report on large amounts of SAP HANA data. The users want to drill from the top aggregation level to the lowest granularity and try different types of graphical representations of the data on the fly.
Which SAP BusinessObjects reporting tool would you recommend?

A. SAP BusinessObjects Dashboards

B. SAP BusinessObjects Crystal Reports for Enterprise

C. SAP BusinessObjects Explorer

D. SAP BusinessObjects Web Intelligence

正解：C 解答を投票する

出題：7

How can you define conditions and actions in a decision table? (Choose three)

A. Use mathematical operations

B. Use conditional expressions

C. Use date operations

D. Use CE functions

E. Use ABAP routines

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

出題：8

In a left outer join, the left table has one record and the right table has three records. What is the maximum number of records that you expect in the join result?

A. 1

B. 4

C. 0

D. 3

正解：D 解答を投票する

出題：9

Which reporting tool can you use to display native parent-child hierarchies from SAP HANA?

A. SAP BusinessObjects Analysis, edition for Microsoft Office

B. SAP BusinessObjects Analysis, edition for OLAP

C. SAP BusinessObjects WebIntelligence

D. Microsoft Excel

正解：D 解答を投票する

出題：10

Which best practices should you apply when you use SQL script in SAP HANA? (Choose three)

A. Use CE functions.

B. Use dynamic SQL with variables.

C. Use the WHERE clause for updates.

D. Use UNION ALL instead of UNION.

E. Use cursors.

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

出題：11

Which of the following are characteristics of a referential join? (Choose two)

A. It assumes referential integrity between right and left tables.

B. If a field is selected from the right table, it acts similar to a left outer join.

C. It requires referential integrity between right and left tables.

D. If a field is selected from the right table, it acts similar to an inner join.

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

出題：12

You have an SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on SAP HANA system installed on multiple nodes.
Which of the following information objects are stored on the master node?

A. SAP NetWeaver BW master data tables

B. DataStore Objects (DSOs)

C. Persistent Staging Area (PSA) tables

D. ABAP system tables

正解：D 解答を投票する

出題：13

When you load data from SAP ECC using SAP BusinessObjects Data Services, where would you create an ABAP data flow?

A. In the Job overview (transaction SM37)

B. In a query transformation

C. In the ABAP editor (transaction SE38)

D. In a batch job

正解：D 解答を投票する

出題：14

Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?

A. Define an RFC connection from SLT to SAP HANA.

B. Define the number of background work processes in SLT.

C. Define the number of jobs to be used for data replication.

D. Define a DB connection from SLT to the source system.

正解：C 解答を投票する

出題：15

Your SAP BusinessObjects report runs slowly.
Which of the following actions could improve the performance? (Choose two)

A. Move calculated measures from the information model to the report.

B. Tune the Array Fetch Size parameter of the universe.

C. Restrict data by using variables in the information model.

D. Join all the analytic views with each other in the business layer.

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

出題：16

What are benefits of using a business layer on top of SAP HANA? (Choose two)

A. Improved database calculation speed

B. Users can use business names instead of technical names

C. An extra layer of granular security

D. Fast throughput via BICS connectivity

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

出題：17

Your data models use hierarchies.
In which of the following front end tools can you access these hierarchies? (Choose three)

A. SAP BusinessObjects Dashboards

B. SAP BusinessObjects Analysis, edition for Microsoft Office

C. SAP Crystal Reports 2011

D. SAP BusinessObjects Analysis, edition for OLAP

E. SAP Lumira

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

出題：18

You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?

A. Use table indexing

B. Use L programming

C. Use SQL statements

D. Use CE functions

正解：D 解答を投票する

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