SAP Certified Application Associate - SAP HANA 2.0 (SPS04) (C-HANAIMP-16) Free Practice Test

Question 1

Why does query performance decrease when the data volume of the delta storage is large?
Note: There are 2 correct answers to this question.

A. The data is uncompressed.

B. The data is stored in the warm tier.

C. The data is NOT sorted.

D. The data is unstructured.

Correct Answer: A,C

Question 2

What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container?

A. Wrapper

B. Function

C. Database connection

D. Synonym

Correct Answer: B

Question 3

In a calculation view, what is the purpose of a variable?

A. To provide a run-time attribute filter based on a user input

B. To break up complex SQL into smaller steps

C. To pass values between procedures and calculation views

D. To provide a dynamic value in a calculated column

Correct Answer: A,B

Question 4

Why do you build a calculation view of type SQL Access only?

A. To provide a high-performance model when only attributes are required

B. To provide a data source that is only consumed by other calculation views

C. To provide a data source that can only be consumed by a function or procedure

D. To enable SQL access to your hierarchies

Correct Answer: B

Question 5

What type of data is relevant for SAP HANA Graph modeling?

A. Hierarchical data

B. Timeseries

C. Highly-networked

D. Forecast

Correct Answer: C

Question 6

When you create a full text index, why do you specify FAST_PREPROCESS OFF?

A. To generate text analysis results in multiple languages

B. To prevent the creation of a fuzzy search index

C. To enable a full linguistic search

D. To avoid the generation of the term document matrix

Correct Answer: C

Question 7

You import a project that includes an SAP HANA database(HDB) module to your workspace. You need to create a calculation view that uses data from one table located in an external schema. Which of the following items must you build?
Note: There are 2 correct answers to this question.

A. Authorization

B. Project

C. .hdinamespacefile

D. Synonym

Correct Answer: A,D

Question 8

In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

A. Your stacked model consists of multiple calculation views.

B. You have a dedicated table lo generate the lists of help values for an input parameter.

C. You have a large column store table that is consumed in a view with a variable on COUNTRY column.

D. You have a large row store table that is consumed in a view with a variable on COUNTRY column.

Correct Answer: C

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA 2.0 (SPS04) (C-HANAIMP-16) Free Practice Test