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

How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

A. Call the SAP-provided PAL decision tree procedure from the table function

B. Use dynamic SQL in the table function to generate the SQL code

C. Copy and adapt the SQL code generated by a flow graph into the table function

D. Build a flow graph and call it from the table function using input parameters

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

Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question.

A. Use an inner join.

B. Limit the number of joined columns.

C. Implement pruning rules.

D. Specify the join cardinality.

What are the key steps to implement currency conversion in a calculation view?

A. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Build the conversion rule

B. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view

C. Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column

D. Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type

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 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 of the following allows data replication?

A. SAP HANA smart data access

B. SAP HANA streaming analytics

C. SAP HANA smart data integration

D. SAP HANA smart data quality

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.