What should you use to create tables in an HDI container?
There are 2 correct answers to this question.
Response:

• A.SQL Console
• B.SAP Enterprise Architecture Designer
• C.Core Data Services (CDS)
• D.Database Explorer

Comment: *

Name: *

Email: *

Verification: *

What restrictions apply to a graph node that you include in a calculation view?
Please choose the correct answer.
Response:

• A.It must be the final node in the data flow
• B.It must be the first node in the data flow.
• C.Its data sources must be provided by a projection node
• D.It cannot be included in a calculation view of type dimension

Comment: *

Name: *

Email: *

Verification: *

Which of the following node types can you use to build a dimension view?
There are 3 correct answers to this question.
Response:

• A.Data foundation node
• B.Union node
• C.Semantics node
• D.Aggregation node
• E.Star join node

Comment: *

Name: *

Email: *

Verification: *

What is SQLScript?
Please choose the correct answer.
Response:

• A.A subset of standard SQL that is exposed to HANA database procedures.
• B.A subset of standard SQL that is exposed to HANA modelers.
• C.An extension to standard SQL that provides additional expressions, functions and datatypes.
• D.A simplified query language aimed at business users that generates SQL.

Comment: *

Name: *

Email: *

Verification: *

In your calculation view, you CANNOT enable a hierarchy for time dependency. What could be the reason for this?
Response:

• A.You did NOT include a history column table.
• B.You did NOT reference a DIMENSION of the type TIME.
• C.The hierarchy is a parent-child type.
• D.The hierarchy is a level type.

Comment: *

Name: *

Email: *

Verification: *