SAP Certified Application Associate - SAP HANA (Edition 2014) (C-HANAIMP142) Free Practice Test

Question 1

Which of the following tools use SQL to communicate with SAP HANA? (Choose three)

A. SAP BusinessObjects Information Design Tool

B. SAP BusinessObjects Dashboards

C. SAP BusinessObjects Analysis, edition for OLAP

D. SAP BusinessObjects Web Intelligence

E. SAP Lumira

Correct Answer: A,B,D

Question 2

Which of the following are benefits of implementing SAP HANA? (Choose three)

A. SAP HANA replaces SAP BW.

B. SAP HANA provides pre-configured BI Content.

C. SAP HANA performs much faster than the standard SAP ERP.

D. SAP HANA combines OLTP and OLAP in one system.

E. SAP HANA provides real-time analytics.

Correct Answer: C,D,E

Question 3

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 an information space to the business layer.

B. Add dimensions and measures to the business layer.

C. Add the INFORMATION_CONSUMER role to the user.

D. Add information models to the data foundation.

Correct Answer: B,D

Question 4

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?

A. SAP BW extractors

B. SAP BusinessObjects Data Services

C. SAP Legacy System Migration Workbench (LSMW)

D. SAP Landscape Transformation (SLT)

Correct Answer: B

Question 5

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

A. In a batch job

B. In the Job overview (transaction SM37)

C. In a query transformation

D. In the ABAP editor (transaction SE38)

Correct Answer: A

Question 6

You have two analytic views: one contains actual data and the other contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

A. UNION in a calculation view

B. JOIN in an analytic view

C. JOIN in a graphical calculation view

D. PROJECTION in a calculation view

Correct Answer: A

Question 7

Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)

A. Define an analytic view.

B. Define the data foundation.

C. Choose the type of hierarchy.

D. Define calculated attributes for the nodes of the hierarchy.

E. Define an output structure for the attribute view.

Correct Answer: B,C,E

Question 8

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 data foundation

C. In the analytic privileges

D. In the SQL privileges

Correct Answer: A

Question 9

Which of the following can you use to implement currency conversion in an information model? (Choose two)

A. A calculated column in a calculation view

B. A restricted column in an analytic view

C. A calculated column in an attribute view

D. A calculated column in an analytic view

Correct Answer: A,D

Question 10

You model hierarchies in attribute views. Which of the following technologies do you use to make these hierarchies available for reporting tools?

A. ODBO

B. BICS

C. JDBC

D. ODBC

Correct Answer: A

Question 11

You want to broadcast reports that use data from SAP HANA. Which SAP BusinessObjects tool do you use?

A. Explorer

B. Analysis, edition for OLAP

C. Dashboards

D. Crystal Reports

Correct Answer: D

Question 12

In which of the following can you use a FOR loop over your data?

A. Analytic View

B. Attribute View

C. Monitoring View

D. Calculation View

Correct Answer: D

Question 13

On which of the following servers can you configure SAP HANA Direct Extractor Connection (DXC) data sources? (Choose two)

A. SAP BusinessObjects Data Services server

B. SAP Business Warehouse server

C. SAP HANA server

D. SAP ECC server

Correct Answer: B,D

Question 14

How can you improve the quality of your information model design? (Choose three)

A. Modularize your views.

B. Use 'case' or 'if' statements whenever possible.

C. Design your views to be reusable.

D. Avoid duplications in your modeling.

E. Use row-based database expressions.

Correct Answer: A,C,D

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA (Edition 2014) (C-HANAIMP142) Free Practice Test