When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

• A.Association
• B.Synonym
• C.Virtual Table
• D.Alias

Comment: *

Name: *

Email: *

Verification: *

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.What could be the problem?

Note: There are 2 correct answers to this question.

• A.Integrity constraint is set to RIGHT.
• B.Join cardinality is set :1.
• C.The Keep flag is activated for the Customer column.
• D.The Country column is requested.

Comment: *

Name: *

Email: *

Verification: *

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

• A.The first build is successful.The second build fails.
• B.The first build is successful.The second build is successful.
• C.The first build fails.The second build is successful.
• D.The first build fails.The second build fails.

Comment: *

Name: *

Email: *

Verification: *

Why would you enable Debug Query mode in a calculation view?

• A.To set breakpoints and step through the execution
• B.To understand how tables are partitioned
• C.To check which database engines are invoked
• D.To identify data sources that are not accessed by a query

Comment: *

Name: *

Email: *

Verification: *

You are building a new calculation view A that uses calculation view B, as shown in the diagram. When you preview the calculation view A, the Account Number is not masked.

What could be the reason?

• A.You previewed the data with the technical user in SAP Web IDE for SAP HANA.
• B.You did not define masking in calculation view A.
• C.The UNMASKED privilege for calculation view A has been granted.
• D.Analytic privilege _SYS_BI_CP_ALL has been assigned.

Comment: *

Name: *

Email: *

Verification: *