SAP Certified Application Associate - SAP HANA (Edition 2014)

QUESTION NO: 1
In which of the following can you use a FOR loop over your data?

A. Monitoring View B. Attribute View C. Analytic View D. Calculation View

Correct Answer: D

QUESTION NO: 2
Which connection method that is listed on the left can you use with the tools that are available in the dropdown box on the right?

A. BICS B. ODBC/JDBC C. ODBO D. RFC

Correct Answer: A,B,C,D

QUESTION NO: 3
You want to use a UNION to combine two information objects in a calculation view.
Which steps do you have to perform? (Choose two)

A. Define the mapping of columns of the information objects. B. Define a constant column in the target. C. Connect the information objects to the UNION node. D. Sort the columns in the output structure.

Correct Answer: A,C

QUESTION NO: 4
Which SAP HANA privileges are used for administration tasks, such as creating schemas?

A. System privileges B. Analytic privileges C. Application privileges D. Package privileges

Correct Answer: A

QUESTION NO: 5
What is the advantage of creating analytic views in SAP HANA over reporting directly from column tables? (Choose two)

A. Shifting of complex calculations and logic to SAP HAN B. Eliminating the need for additional modeling. C. Reporting directly from SAP BusinessObjects Web Intelligence. D. Supporting analytical privileges.

Correct Answer: A,D

QUESTION NO: 6
---
You have created an analytic view and an analytic privilege that filters on 3 attributes:
Sales region = "West"
Sales channel = "Online", "Retail"
Product category = "Electronics".
After granting the analytic privilege to a user, what data can the user see?
A)

B)

C)

D)

A. Exhibit D B. Exhibit A C. Exhibit C D. Exhibit B

Correct Answer: D

QUESTION NO: 7
For what purpose do you use SQL Script in SAP HAN? (Choose two)

A. To combine two analytic views B. To achieve very high performance on SELECT statements C. To transfer a large amount of data between engines D. To shift complex calculations and logic to the client side E. To create database procedures

Correct Answer: A,E

QUESTION NO: 8
When you try to delete an attribute view you receive the error message, "One or more objects are dependent upon this object".
Which of the following functions can you use to find out which objects depend on this view? (Choose two)

A. History function B. Where-used function C. Auto Documentation function D. Display XML function

Correct Answer: B,C

QUESTION NO: 9
When you use SAP Landscape Transformation (SLT) replication, which of the following can you do in the advanced replication settings? (Choose two)

A. Change the length of a character field of a table. B. Assign a specific mass transfer ID to a table. C. Add a field to a table. D. Change the target table for specific records of a table.

Correct Answer: A,C

QUESTION NO: 10
When you activate an analytic view, a column view is created. In which schema is this column view stored?

A. _SYS_BIC B. _SYS C. _SYS_BI D. _SYS_REPO

Correct Answer: A

QUESTION NO: 11
You have to do reverse pivot transformations on large data tables before loading the data into SAP HANA.
Which of the following do you recommend to use?

A. SAP System Landscape Directory (SLD) B. SAP Landscape Transformation (SLT) C. SAP HANA Direct Extractor Connection (DXC) D. SAP BusinessObjects Data Services 4.0

Correct Answer: D

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

A. In the INVALID_CONNECT_ATTEMPS view B. In the user-specific schema C. In the SQL Console D. In the user properties in the SAP HANA studio

Correct Answer: C,D

QUESTION NO: 13
Your data models use hierarchies.
In which of the following front end tools can you access these hierarchies? (Choose three)

A. SAP Crystal Reports 2011 B. SAP BusinessObjects Analysis, edition for Microsoft Office C. SAP BusinessObjects Analysis, edition for OLAP D. SAP BusinessObjects Dashboards E. SAP Lumira

Correct Answer: B,C,E

QUESTION NO: 14
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 2014) - C-HANAIMP142 Exam Questions