SAP Certified Application Associate - SAP HANA (Edition 2015)

QUESTION NO: 1
Which technologies use trigger-based replication?

A. ABAP extractors B. Test Data Migration Server (TDMS) C. Standard SQL database replication D. Near Zero Downtime

Correct Answer: B,D

QUESTION NO: 2
What is features available in Project Creation Wizard

A. New option to auto-share an XS Server - side Project to the SAP HANA Repository during the project creation wizard B. New option to auto-share an XS client - side Project to the SAP HANA Repository during the project creation wizard C. New option to auto-share an XS Server - side secure Project to the SAP HANA Repository during the project creation wizard D. New option to auto-share an XS Project to the SAP HANA Repository during the project creation wizard

Correct Answer: D

QUESTION NO: 3
Which of the following tools can you use to monitor the query time from SAP HANA?

A. SQL Trace B. Event Viewer C. Central Management Console D. Performance tab of the System Monitor

Correct Answer: A

QUESTION NO: 4
What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA?

A. You can execute ad-hoc business analytics quickly. B. You do not need to create your own queries to access information. C. You can easily create an IDT business layer. D. You can access information for data discovery intuitively. E. You can easily create your own queries to access information.

Correct Answer: A,B,D

QUESTION NO: 5
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 an analytic view. B. Load the calculation view into memory. C. Turn the calculation view into a simple calculation view. D. Load the calculation view into the _SYS_BI schema.

Correct Answer: A

QUESTION NO: 6
In which View, client queries can be less optimized and could significantly be slower compare to other models

A. Analytic B. Calculation (SQL) C. Calculation (CE Functions) D. Attribute

Correct Answer: B

QUESTION NO: 7
Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators with simu-lations?

A. Analysis, edition for OLAP B. Web Intelligence C. Explorer D. Dashboards

Correct Answer: D

QUESTION NO: 8
Which CE function do you use to implement an inner join between two tables on a list of join attributes?

A. CE_JOIN B. CE_OLAP_VIEW C. CE_COLUMN_TABLE D. CE_JOIN_VIEW

Correct Answer: A

QUESTION NO: 9
Your customer wants to implement a SAP product that: Provides near real-time replication to SAP HANA Connects SAP HANA to a non-SAP source system and SAP BW Uses SAP extractors What do you recommend?

A. Sybase Replication Server B. SAP Landscape Transformation (SLT) C. SAP Legacy System Migration Workbench (LSMW) D. SAP BusinessObjects Data Services 4.0

Correct Answer: D

QUESTION NO: 10
Which information model can you use with measures from multiple fact tables?

A. Attribute view B. Analytic privilege C. Analytic view D. Calculation view

Correct Answer: D

QUESTION NO: 11
Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?

A. Decluster table classes into a transparent format. B. Ensure that replicated changes are kept within the logging tables. C. Include only relevant tables for DB recording. D. Record relevant changes in logging tables.

Correct Answer: C,D

QUESTION NO: 12
You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatoryfor this task?

A. Write an SQL script. B. Define a projection. C. Save and activate the view. D. Define output fields. E. Choose a data source.

Correct Answer: C,D,E

QUESTION NO: 13
Union can be performed only at...

A. Calculation B. Analytic C. Attribute D. Analytic / Calculation

Correct Answer: A

QUESTION NO: 14
Which of the following must an analytic view contain?

A. A hierarchy B. An attribute view C. A calculated measure D. A measure

Correct Answer: D

QUESTION NO: 15
You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

A. In the Web Intelligence report B. In the universe C. In the analytic view D. In the calculation view using an attribute value variable

Correct Answer: C

SAP Certified Application Associate - SAP HANA (Edition 2015) - C_HANAIMP151 Exam Questions