C_HANAIMP_17 Online Practice Questions and Answers

You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views belong to the same project. Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

A. Export the HDB module -> Export the project

B. Build the HDB module -> Build the project

C. Activate the project -> Build the HDB module

D. Build the project -> Build the HDB module

What does a graph neighborhood search reveal?

A. Edges that contain the same attributes

B. Shortest path between vertices

C. Vertices that are closely connected

D. Vertices that contain the same attributes

In text processing, where do you use the Term Document Matrix?

A. Text mining

B. Linguistic extraction

C. Fuzzy text search

D. Fact and entity extraction

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?

A. 6

B. 9

C. 2

D. 5

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

A. Highly-networked

B. Timeseries

C. Hierarchical data

D. Forecast

Why do you use a hierarchy function node in a calculation view?

A. To display value help using hierarchies

B. To enable hierarchical navigation in reporting tools

C. To generate additional Meta data that can be used for analysis of a hierarchy structure

D. To assist the developer by visualizing hierarchies

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.

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

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

A. To enable SQL access to your hierarchies

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

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

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

What can you use SAP HANA smart data access for?

Note: There are 2 correct answers to this question.

A. To push down queries to data sources

B. To expose data from remote tables

C. To load and harmonize data from disparate sources

D. To replicate remote data sources