SAP Certified Application Associate - SAP HANA (Edition 2016) (C_HANAIMP_11) Free Practice Test

Question 1

Which of the following SAP HANA schemas contains the runtime objects of activated views?

A. _SYS_REPO

B. _SYS BIC

C. _SYS_BI

D. _SYS_STATISTICS

Correct Answer: B

Question 2

You have created two analytic views for actual and planned financial data. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column. How can you model this?

A. Create a calculation view.
Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES.

B. Create an analytic view.
Combine the analytic views in the new analytic view using a referential join.

C. Create a calculation view.
Combine the analytic views in the calculation view using a UNION.

D. Create restricted columns for each year for the actual and planned columns in each analytic view.
Combine the analytic views in a new calculation view using a UNION.

Correct Answer: A

Question 3

Your information model needs real-time access to external data stored in Microsoft SQL Server 2011. How can you implement this scenario in SAP HANA? (Choose two)

A. Create a virtual table and use it in a calculation view

B. Perform replication using SAP Replication Server

C. Create a batch job in SAP Data Services

D. Create a virtual table and use it in attribute view

Correct Answer: A,B

Question 4

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.

A. SAP BusinessObjects Explorer

B. SAP BusinessObjects Dashboards

C. SAP BusinessObjects Web Intelligence

D. SAP BusinessObjects Crystal Reports for Enterprise

Correct Answer: A

Question 5

A corporation with over 15.000 cost centers would like to ensure that only the person responsible for the cost center may view salary information for individuals assigned to their cost center. How can the corporation achieve this in SAP HANA?

A. Create an analytic privilege using the cost center and the salary measure.

B. Create an object privilege on the cost center and employee master data schema.

C. Create an analysis authorization using the cost center and employee master data.

D. Create a dynamic analytic privilege using the cost center and employee master data.

Correct Answer: D

Question 6

Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT. Where in the attribute properties of ID_1 can you change this?

A. In the alias label

B. In the label

C. In the alias name

D. In the name

Correct Answer: A,C

Question 7

Which of the following remote data sources can you access with SAP HANA smart data access? (Choose three)

A. SAP NetWeaver Business Warehouse

B. Apache Hadoop

C. SAP Adaptive Server Enterprise

D. XMLfile

E. Teradata Database

Correct Answer: B,C,E

Question 8

Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Suite?

A. It runs in older versions of the SAP Business Suite

B. It provides real-time replication

C. It allows using generic virtual data models

D. It provides real-time operational reporting

E. It uses the generic capabilities of SAP HANA such as the XS Engine

Correct Answer: C,D,E

Question 9

Which view in SAP HANA studio do you use to add additional users?

A. Console View

B. Navigator View

C. Properties View

D. Quick launch View

Correct Answer: B

Question 10

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. Change the label of ID_1.

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

C. Create a derived attribute view with an alias for ID 1.

D. Update the alias in the properties of ID_1.

Correct Answer: D

Question 11

Which programming language do you use for SAP Landscape Transformation based transformation rules?

A. JavaScript

B. Java

C. SQLScript

D. ABAP

Correct Answer: D

Question 12

A calculation view that joins one fact table with dimension tables performs slowly. Which of the following can you do to improve performance?

A. Turn the calculation view into a simple calculation view.

B. Load the calculation view into the_SYS_Bl schema.

C. Load the calculation view into memory.

D. Turn the calculation view into an analytic view.

Correct Answer: D

Question 13

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

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

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

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

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

Correct Answer: A

Question 14

Which of the following is a best practice in calculation views?

A. Change an attribute to a measure.

B. Push calculations down to the attribute views.

C. Combine analytic views with a join node.

D. Apply a static filter on a projection node.

Correct Answer: D

Question 15

What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA?

A. You can access information for data discovery intuitively.

B. You can easily create your own queries to access information.

C. You can execute ad-hoc business analytics quickly.

D. You can easily create an IDT business layer.

E. You do not need to create your own queries to access information.

Correct Answer: A,C,E

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA (Edition 2016) (C_HANAIMP_11) Free Practice Test