SAP Certified Application Associate - SAP HANA (Edition 2015) (C_HANAIMP151) Free Practice Test

Question 1

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 Explorer

B. SAP BusinessObjects Dashboards

C. SAP BusinessObjects Web Intelligence

D. SAP BusinessObjects Crystal Reports for Enterprise

Correct Answer: A

Question 2

Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA?

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 3

Which of the following is used to make hierarchies available to reporting tools?

A. MDX

B. CE Functions

C. SQLScript

D. SQL

Correct Answer: A

Question 4

You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view?

A. Analytic views

B. Join types

C. Attribute views

D. User privileges

E. Tables

Correct Answer: B,C,E

Question 5

What are new Code templates for File Creation Wizard

A. XSJOBT

B. XSSQLCT

C. XSHTTPDEST

D. XSACCESS

Correct Answer: C,D

Question 6

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 SQL statements

B. Use CE functions

C. Use table indexing

D. Use L programming

Correct Answer: B

Question 7

Which of the following can you use as a source for a graphical calculation view?

A. Decision table

B. Table

C. Calculation view

D. Procedure

E. SQL view

Correct Answer: A,B,C

Question 8

Which of the following objects can you use when you build an analytic view?

A. Analytic views

B. Variables

C. Projections

D. Attribute views

E. Hierarchies

Correct Answer: B,D,E

Question 9

You modified an active analytic view in the SAP HANA studio and saved it without activating it.
What is the consequence?

A. The active view is in "Read Only" mode.

B. The inactive view is not available.

C. The active view is not available.

D. The inactive view is in "Read Only" mode.

Correct Answer: A

Question 10

What happens when you turn on replication of an SAP ERP source system using SAP Landscape Transformation (SLT)?

A. SLT creates database triggers in the ERP system that write to logging tables.

B. SLT creates database triggers in the ERP system that write to application tables.

C. SLT creates ABAP code in the ERP system that writes to application tables.

D. SLT creates ABAP code in the ERP system that writes to logging tables.

Correct Answer: A

Question 11

When must you create a calculation view in SAP HANA?

A. When you need calculations before aggregations.

B. When you need to perform join operations.

C. When key figures span across tables.

D. When you need to perform a union of base tables.

Correct Answer: C,D

Question 12

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?

A. Explorer

B. WebIntelligence

C. Dashboards

D. Crystal Reports

Correct Answer: B

Question 13

Which of the following CE functions can you use to query an analytic view directly?

A. CE_OLAP_VIEW

B. CE_AGGREGATION

C. CE_CALC

D. CE_JOIN_VIEW

Correct Answer: A

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA (Edition 2015) (C_HANAIMP151) Free Practice Test