C_HANAIMP_17 Online Practice Questions and Answers

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

A. To break up complex SQL into smaller steps

B. To pass values between procedures and calculation views

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

D. To provide a dynamic value in a calculated column

You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect? Note: There are 2 correct answers to this question.

A. When the query requests PRODUCT_GROUP and PRODUCT_ID

B. When the query requests only the PRODUCT_ID

C. When the query requests PRODUCT_GROUP

D. When Source A has no records

You have a calculation view which includes nodes as shown in the graphic. You decide to select the "Ignore Multiple Output for Filters" check box on Projection Node 3. What might the effects of this be?

Note: There are 2 correct answers to this question.

A. The view will return the profit calculation for only the US

B. A change to the data that is returned by the view

C. Increased performance

D. Decreased performance

You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?

Note: There are 2 correct answers .

A. The hierarchy must be a local hierarchy.

B. The hierarchy must be exposed by a calculation view of type CUBE with star join.

C. The hierarchy must be defined in a calculation view of type SQL ACCESSONLY.

D. The hierarchy must be a shared hierarchy.

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

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

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

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

D. Your stacked model consists of multiple calculation views.

Which type of join supports a temporal condition in a calculation view?

A. Left outer join

B. Text join

C. Referential join

D. Inner join

In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

A. Table function

B. CDS view

C. Procedure

D. Virtual Table

How can you optimize performance when writing SQL for use with calculation views?

Note: There are 2 correct answers to this question.

A. Use declarative language instead of cursors

B. Use calculation engine (CE) functions instead of plain SQL

C. Control the flow logic using IF-THEN-ELSE conditions

D. Increase parallelization by using variables to break up statements

You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?

Note: There are 2 correct answers to this question.

A. To restrict data access for specific users or roles

B. To hide individual patients in groups of similar records

C. To provide partial value such as #34343#34##

D. To add noise to the data to hide the actual values

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

A. To avoid the generation of the term document matrix

B. To prevent the creation of a fuzzy search index

C. To generate text analysis results in multiple languages

D. To enable a full linguistic search