What can you identify using Performance Analysis mode? Note: There are 2 correct answers to this question.

• A.Joins that are defined on calculated columns
• B.Usage statistics of the calculation view
• C.Expected memory consumption
• D.Information about join cardinality

Comment: *

Name: *

Email: *

Verification: *

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.9
• B.5
• C.2
• D.6

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 develop calculation views.
• B.You want to use containers to isolate objects.
• C.You want to use SAP Business Application Studio.
• D.You want to create database objects using source files.
• E.You want to use synonyms to access external data.

Comment: *

Name: *

Email: *

Verification: *

Which of the following techniques can you use to improve the performance of calculation views? Note:
There are 2 correct answers to this question.

• A.Avoid aggregating data early in the data flow.
• B.Partition large tables.
• C.Implement union pruning.
• D.Limit the number of stacked calculation views.

Comment: *

Name: *

Email: *

Verification: *

In a calculation view, your table function node executes a table function that requires input parameters.
How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

• A.Reference the output of a procedure.
• B.Map columns from lower nodes.
• C.Define constant values.
• D.Create and map an input parameter.
• E.Assign a hierarchy node.

Comment: *

Name: *

Email: *

Verification: *