What do you use a hierarchy function for? Note: There are 3 correct answers.

A. Calculate distance between root and each hierarchy node

B. Identify hierarchy nodes that have no parent

C. Count the number of siblings for each hierarchy node

D. Determine the shortest path between each pair of nodes

E. Describe the relationship between nodes using attributes

What restrictions apply to a Graph node that you include in a calculation view?

A. It must be the first node in the dataflow.

B. It must be the final node in the dataflow.

C. Its data source must be provided by a projection node.

D. It cannot be included in a calculation view of type dimension.

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

Why do you create a multi store table?

A. To improve read performance when accessed by simultaneous applications

B. To have the opt on to partition the table across different storage tiers

C. To evenly distribute the data across all available server nodes

D. To have a table that combines the characteristics of row and column stores

You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?

A. Define a union node as the start of the parallelization block.

B. Define a projection node as the end of the parallelization block.

C. Assign tables as the only data sources in the nodes that start the parallelization block.

D. Define a source column as partitioning value in the start node of the parallelization block.

Why might you use the Keep Flag property in an aggregation node?

A. To cache the results of the aggregation node for drill-down

B. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

C. To include columns that are NOT requested by a query but are essential for the correct result

D. To retain the correct aggregation behavior in stacked views.

Why do we support SQL development in SAP HANA data modeling projects?

A. To provide access to your data model to additional client tools.

B. To support development of custom logic within calculation views.

C. To make changes to the runtime objects of your calculation view with SQL.

D. As an alternative to developing calculation views when high performance is essential.

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

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

After importing a project in the workspace of the Web IDE, you try to build the HDB module. The build fails. What could be the reason?

Note: There are 2 correct answers.

A. The HDB module references a user-provided service that does not exist.

B. You have assigned the project to a space that you do not have developer authorizations for.

C. You have not built the project.

D. The project is not assigned to a space.