SAP Certified Application Associate - SAP HANA 2.0 (SPS01)

Question 1

What SQL construct do you use to return multiple result sets from a single SQL statement?
There are 2 correct answers to this question.
Response:

A. GROUPING SETS

B. JOIN

C. UNION

D. SELECT subquery

Correct Answer: B,C

Question 2

Which of the following database terms are used when providing OLAP data with hierarchies?
There are 3 correct answers to this question.
Response:

A. JDBC

B. BICS

C. MDX

D. ODBC

E. ODBO

Correct Answer: B,C,E

Question 3

The SAP HANA Direct Extractor Connection (DXC) provides SAP HANA with out-of-the- box foundational data models based on SAP Business Suite entities.
Which are the following characteristics match with SAP HANA DXC?
There are 3 correct answers to this question
Response:

A. Provides a mechanism to properly handle data from all landscape processing

B. Reduces complexity of data modeling tasks

C. Scale down the timelines for SAP HANA implementation projects

D. Batch-driven data acquisition and considered as a form of extraction

E. No additional server or application needed in system landscape

Correct Answer: B,D,E

Question 4

What feature is similar between an attribute view and a calculation view of type dimension?
Please choose the correct answer.
Response:

A. Fuzzy text search attributes

B. Full outer join

C. Derived views

D. Left outer join

Correct Answer: D

Question 5

You want to build a hierarchy on a time-based data structure. What type of hierarchy do you use?
Please choose the correct answer.
Response:

A. Parent-child hierarchy

B. Ragged hierarchy

C. Unbalanced hierarchy

D. Level hierarchy

Correct Answer: A

Question 6

What must be installed for PAL to work?
Please choose the correct answer.
Response:

A. SAP HANA AFL

B. SAP HANA SINA

C. SAP HANA AFM

D. SAP HANA BFL

Correct Answer: A

Question 7

Which data provisioning tools can use SAP HANA adapters?
There are 2 correct answers to this question.

A. SDI
SRS

B. SDS

C. SDA

Correct Answer: A,C

Question 8

What can you use to limit users to see only 2016 data?
There are 2 correct answers to this question.
Response:

A. A view with a filter

B. A SQL analytic privilege

C. A view with a restricted column

D. An object privilege

Correct Answer: A,B

Question 9

For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
Response:

A. Calculated data

B. Materialized cube data

C. Master data

D. Transactional data

Correct Answer: C

Question 10

What issue do you have to address after you have migrated your old views to calculation views?
Please choose the correct answer.

A. Change filters on table columns to filter expressions

B. Check the analytic privileges for star join situations

C. Manually migrate the base view for derived views

D. Unhide the hidden fields in the semantics node

Correct Answer: B

Question 11

Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 3 correct answers to this question.
Response:

A. Backups

B. High availability

C. Partitioning

D. Disaster recovery

E. Failover

Correct Answer: B,C,E

Question 12

You want to rename an information view with the SAP HANA Modeler without losing its existing behavior. What are the next steps after the renaming utility has finished?
There are 2 correct answers to this question.
Response:

A. Adjust references to the information view in graphical calculation views.

B. Adjust references to the information view in procedures.

C. Adjust references to the information view in analytic views.

D. Adjust references to the information view in table functions.

Correct Answer: B,D

Question 13

Which development tools are available for creating SAP HANA information models?
There are 2 correct answers to this question.
Response:

A. Java-based Eclipse tool

B. Web-based development tool

C. Java applet in the browser

D. iPad app for development

Correct Answer: A,B

SAP Certified Application Associate - SAP HANA 2.0 (SPS01) - C-HANAIMP-13 Exam Practice Test

Latest Update

Useful Links

Contact Us