SAP Certified Application Associate - SAP HANA (Edition 2016) (C-HANAIMP-11) Free Practice Test

Question 1

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

A. SAP HANA SQL Import statement

B. SAP System Landscape Transformation (SLT)

C. SAP BusinessObjects Data Services

D. SAP HANA Direct Extractor Connection (DXC)

Correct Answer: A,C

Question 2

When you use SLT replication, which of the following determines the name of the SAP HANA schema where replicated data is stored?

A. The name of the RFC connection

B. The name of the secondary database connection

C. The name of the source system schema

D. The name of the replication configuration

Correct Answer: D

Question 3

You plan to migrate your existing SAP NetWeaver landscape with a non-SAP HANA database. Which of the following are key considerations for the migration of your database to SAP HANA? (Choose
three)

A. Upgrade all end-user front-end workstations to SUSE Linux (SLES).

B. Plan downtime for the migration of the old database to SAP HANA.

C. Resize application servers to handle incremental data volumes.

D. Provision hardware that runs SUSE Linux (SLES) for SAP HANA.

E. Reuse existing SAP NetWeaver application servers.

Correct Answer: B,D,E

Question 4

You have created an input parameter in an information model. In which of the following can you use the input parameter?

A. The creation of an SAP BEx query reading from the information model

B. The creation of an SAP BusinessObjects Web Intelligence report directly on the information model

C. The definition of an information space that reads from the information model

D. The definition of objects in an SAP BusinessObjects universe

Correct Answer: D

Question 5

You need to run a Web Intelligence report that requires data from SAP HANA filtered for a specific year based on ad hoc user input.
For best performance, how would you achieve this?

A. Use a pre-defined prompt based on a self-join in the business layer.

B. Use a dynamic transformation rule during data provisioning.

C. Use a prompt in the query of the Web Intelligence report.

D. Use input from a Web Intelligence report passed to a variable in an information model.

Correct Answer: D

Question 6

HANA Currency Conversion supported only via__

A. Attribute

B. Analytic

C. Calculation

D. Analytic / Calculation

Correct Answer: D

Question 7

Where can you reactivate a user after too many invalid logon attempts? (Choose two)

A. In the user-specific schema

B. In the user properties in the SAP HANA studio

C. In the INVAUD_CONNECT_ATTEMPS view

D. In the SQL Console

Correct Answer: B,D

Question 8

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

A. SAP BusinessObjects Weblntelligence

B. Microsoft Excel

C. SAP BusinessObjects Analysis, edition for OLAP

D. SAP BusinessObjects Analysis, edition for Microsoft Office

Correct Answer: B

Question 9

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

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

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

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

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

Correct Answer: C,D

Question 10

How can you improve the performance of an information model?

A. Use attribute views wherever possible.

B. Use analytic views wherever possible.

C. Use indexes on all measures.

D. Use generated columns.

E. Use constraint filters.

Correct Answer: B,D,E

Question 11

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 12

What are characteristics of a constraint filter?

A. It is defined during the runtime in the SQL query.

B. It is applied on a table before the query execution.

C. It is defined during the design time on a table.

D. It is applied on the result set of an SQL query.

Correct Answer: B,C

Question 13

When do you set the Calculation Before Aggregation flag in a calculated column?

A. To aggregate measures

B. To filter columns

C. To calculate on line item level

D. To improve the overall runtime

Correct Answer: C

Question 14

You want to model customer master data.
Which of the following must you select?

A. Key attribute

B. Table

C. Filter

D. Hierarchy

Correct Answer: A,B

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA (Edition 2016) (C-HANAIMP-11) Free Practice Test