You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.

However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

• A.You already mapped the input parameters in another calculation view.
• B.The names of the input parameters do not match.
• C.You selected the wrong parameter mapping TYPE.
• D.Your source calculation view is of type DIMENSION.

Comment: *

Name: *

Email: *

Verification: *

You want to join two tables in a calculation view.Why do you use a non-equi join?

• A.Join columns need to be ignored when NOT requested by the query.
• B.The number of joined columns is different in each table.
• C.Join columns have different data types.
• D.The join condition is not represented by matching values.

Comment: *

Name: *

Email: *

Verification: *

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

• A.US for P1 and P2, and GE for P1 and P2
• B.US for P1
• C.US for P1 and P2, and GE for P2
• D.US for P1 and GE for P1

Comment: *

Name: *

Email: *

Verification: *

In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

• A.To warn developers that the calculation view is no longer supported
• B.To indicate that it should not be used as a data source to other calculation views
• C.To ensure it is not exposed to reporting tools for consumption
• D.To lock the calculation view from further modifications

Comment: *

Name: *

Email: *

Verification: *

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

• A.To benefit from additional SQL optimizations
• B.Column engine language is not supported.
• C.Incorrect aggregations may be generated
• D.To define limits for query unfolding

Comment: *

Name: *

Email: *

Verification: *