SAP Certified Development Associate - SAP HANA 2.0 SPS02 (C-HANADEV-14) Free Practice Test

Question 1

Which advantages does the SAP HANA Deployment
Infrastructure provide?

A. Supports service generation based on the OData standard

B. Provides version control and lifecycle management services

C. Allows concurrent deployment of different versions of
the same application

D. Provides a declarative approach for defining database
objects

Correct Answer: C,D

Question 2

You modify an existing view. How can you determine which
models are affected by this change?

A. Use the History feature for the changed model.

B. Use the "Where-Used List" feature for the changed model.

C. Use the audit trail.

D. Use the "Auto Documentation" to compare the object version
of the changed model.

Correct Answer: B

Question 3

You want to allow another developer to access the information
models in one of your packages. What privilege do you have to
assign to this user to allow access?

A. SELECT on _SYS_REPO

B. REPO.MAINTAIN_NATIVE_PACKAGES for the package

C. SELECT on _SYS_REPO with the grant option

D. REPO.READ for the package

Correct Answer: D

Question 4

In an analytic view, you need two different logical joins
from the data foundation to an attribute view. The analytic
View already contains the attribute view but you have to use
the attribute view again. To which of the following do you
connect the second join

A. To a shared attribute view

B. To a derived attribute view

C. To a copy of the attribute view

D. To a new instance of the attribute view

Correct Answer: B,C

Question 5

To connect Microsoft Excel to HANA Modeling views,
which of the below can be used for direct connectivity to
create reports?

A. Name server

B. SQL provider

C. MDX provider

D. XS Engine

Correct Answer: C

Question 6

Which of the below is used to handle queries and
manipulates multidimensional data stored in OLAP cubes?

A. MDX Processor

B. Name Serve

C. XS Engine

D. SQL Processor

Correct Answer: A

Question 7

SAP HANA 2.0 offers new functionalities for

A. Database management

B. Data management

C. All the above

D. Analytical intelligence and application development

Correct Answer: C

Question 8

You want to retrieve data from SAP HANA and restrict access
to certain data columns for specific user groups. Where can you
implement this?

A. In the business layer

B. In the data foundation

C. In the analytic privileges

D. In the SQL privileges

Correct Answer: A

Welcome to TestSimulate

SAP Certified Development Associate - SAP HANA 2.0 SPS02 (C-HANADEV-14) Free Practice Test