C_HANAIMP_17 Online Practice Questions and Answers

A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018. What is the optimal way to do this?

A. Use a full outer join.

B. Use a union node.

C. Use an left outer join.

D. Use an intersect node

Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the new features are not displayed.

What could be the reason for this?

A. You need to update the project settings to reference the new revision.

B. Your calculation views have not been built in the new version of the Web IDE.

C. The calculation views have not been migrated to the new revision.

D. The .hdiconfig file has not been updated to the latest calculation view build plug-in.

Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

A. They can harm SQL optimization.

B. NOT all reporting tools can consume the results.

C. They introduce potential security risk.

D. They call multiple processing engines

Which of the following are warm tier Solutions? Note: There are 3 correct answers.

A. Active / active read-enabled mode

B. Native Storage Extension

C. Extension Node

D. Dynamic Tiering

E. Persistent Memory

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

When would you develop an SQL procedure instead of a function?

A. You need to implement Data Definition Language (DDL) statements.

B. The code should modify data in the table.

C. Optimal performance is apriority.

D. You need to use conditional logic.

E. You want to create a dynamic analytic privilege.

In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function?

A. Synonym

B. Scalar function

C. Table function

D. Input parameter

You want to join 2 tables in a calculation view. Why do you use a non-equijoin?

A. The number of joined columns is different in both tables.

B. Join columns do not have the same datatype.

C. The join condition is not represented by matching values.

D. The cardinality is impossible to determine.

Why do we use Git when modeling calculation views?

A. Develop conceptual prototypes

B. Enable collaboration between developers

C. Provide access to external schemas

D. Control specifically object versioning

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