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

• A.To include columns that are NOT requested by a query but are essential for the correct result
• B.To exclude columns that are NOT requested by a query to avoid incorrect results
• C.To retain the correct aggregation behavior in stacked views
• D.To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

Comment: *

Name: *

Email: *

Verification: *

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

• A.The hierarchy must be a local hierarchy.
• B.The hierarchy must be a parent-child hierarchy.
• C.The hierarchy must be a shared hierarchy.
• D.The hierarchy must be exposed by a calculation view of type CUBE with star join.

Comment: *

Name: *

Email: *

Verification: *

What are some of the restrictions that apply when defining parallelization blocks in calculation views?
Note: There are 2 correct answers to this question.

• A.Only one block can be defined across a stack of calculation views.
• B.Multiple blocks can only be defined within a single calculation view.
• C.The block must start with a node that defines a table as a data source.
• D.The block must only have one start node.

Comment: *

Name: *

Email: *

Verification: *

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.

• A.Pre-calculated aggregates
• B.Stored procedures
• C.Table partitions
• D.Indexes

Comment: *

Name: *

Email: *

Verification: *

Why would you choose an HDI-shared service plan instead of a schema service plan?Note: There are 3 correct answers to this question.

• A.You want to use SAP Business Application Studio.
• B.You want to develop calculation views.
• C.You want to create database objects using source files.
• D.You want to use containers to isolate objects.
• E.You want to use synonyms to access external data.

Comment: *

Name: *

Email: *

Verification: *