In SAP HANA Cloud, which tasks are handled by the cloud provider? Note: There are 3 correct answers to this question.

• A.Tuning the database to run optimally on the underlying operating system, and hardware
• B.Backing up and restoring, and recovering the database software
• C.Installing, configuring, and upgrading the operating system
• D.Managing users, roles, and permissions in the database
• E.Sizing, provisioning, and monitoring the database

Comment: *

Name: *

Email: *

Verification: *

What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.

• A.Generate additional root nodes.
• B.Assign them to a level below the root.
• C.Assign them to a node at the root level.
• D.Define an expression to determine a parent.

Comment: *

Name: *

Email: *

Verification: *

Why would you create shared hierarchies? Note: There are 2 correct answers to this question.

• A.To access hierarchies created in external schemas
• B.To enable SQL SELECT statements to access hierarchies
• C.To provide reusable hierarchies for drilldown in a CUBE with star schema
• D.To provide reusable hierarchies for drilldown in a CUBE without star schema

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.To define limits for query unfolding
• D.Incorrect aggregations may be generated

Comment: *

Name: *

Email: *

Verification: *

Why would an SQL developer work with SQLScript? Note: There are 3 correct answers to this question.

• A.To include ABAP syntax in the code
• B.To automate the generation of the code
• C.To exploit additional data types
• D.To implement conditional logic
• E.To pass parameters from calculation views

Comment: *

Name: *

Email: *

Verification: *