SAP Certified Application Associate - SAP HANA 1.0

Question 1

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

A. in a query transformation

B. in the Job overview (transaction SM37)

C. in a batch job

D. in the ABAP editor (transaction SE38)

Correct Answer: C

Question 2

Which of the following authentication methods are supported for Single Sign-On for SAP HANA?

A. SAML CAS (Central Authentication Service)

B. Secure Network Communication (SNC)

C. Kerberos

D. LDAP over SSL

Correct Answer: C

Question 3

If you want to create or drop tables in a schema, which privilege type do you need?

A. ANALYTIC

B. SQL

C. PACKAGE

D. SYSTEM

Correct Answer: B

Question 4

What does the following SQL statement do?
SELECT
SCORE() as SCORE, PRODUCT_NAME, *
FROM
PRODUCT_ITEMS
WHERE
CONTAINS(*,'Paper', FUZZY(0.8))
ORDER BY
PRODUCT_NAME

A. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term 'Paper'.

B. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'.

C. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'.

D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.

Correct Answer: D

Question 5

A company needs to load external data from a flat file into SAP HANA.
How can you do this? (Choose two)

A. SAP HANA Direct Extractor Connection (DXC)

B. SAP BusinessObjects Data Services

C. SAP HANA SQL Import statement

D. SAP System Landscape Transformation (SLT)

Correct Answer: B,C

Question 6

Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)? (Choose two)

A. Decluster table classes into a transparent format.

B. Record relevant changes in logging tables.

C. Include only relevant tables for DB recording.

D. Ensure that replicated changes are kept within the logging tables.

Correct Answer: B,C

Question 7

Your customer wants to use SAP BusinessObjects Data Services to migrate and transform large volumes of data to SAP HANA. What do you recommend?

A. Use the RFC_READ_TABLE.

B. Use RFC/BAPI function calls.

C. Use ABAP data flows.

D. Use IDOCs.

Correct Answer: C

Question 8

Which of the following tasks must you perform before you publish a universe within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA? (Choose two)

A. Add information models to the data foundation.

B. Add dimensions and measures to the business layer.

C. Add the INFORMATION_CONSUMER role to the user.

D. Add an information space to the business layer.

Correct Answer: A,B

Question 9

You have loaded data into SAP HANA using SAP BusinessObjects Data Services.
Where can you view that data? (Choose two)

A. In the SAP BusinessObjects Data Services job monitor

B. In the Content node of SAP HANA studio

C. In the Catalog node of SAP HANA studio

D. In the SAP BusinessObjects Data Services table preview

Correct Answer: C,D

Question 10

What outputs can you create in an attribute view? (Choose two)

A. Private Attributes

B. Restricted Measures

C. Key Attributes

D. Calculated Measures

E. Calculated Attributes

Correct Answer: C,E

Question 11

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

A. SAP BusinessObjects Analysis, edition for OLAP

B. SAP BusinessObjects WebIntelligence

C. Microsoft Excel

D. SAP BusinessObjects Analysis, edition for Microsoft Office

Correct Answer: C

Question 12

You want to add a calculated column to an SAP BusinessObjects Web Intelligence report.
In which application do you create the calculation to achieve best report performance?

A. Information Design Tool

B. Web Intelligence

C. Central Management Console

D. SAP HANA Studio

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

SAP Certified Application Associate - SAP HANA 1.0 - C-HANAIMP-1 Exam Practice Test

Latest Update

Useful Links

Contact Us