Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.

• A.Stored procedures
• B.Pre-calculated aggregates
• C.Table partitions
• D.Indexes

Comment: *

Name: *

Email: *

Verification: *

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

• A.Break up large statements by using variables.
• B.Choose declarative language instead of imperative language.
• C.Use dynamic SQL.
• D.Control the flow logic using IF-THEN-ELSE conditions.

Comment: *

Name: *

Email: *

Verification: *

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

• A.Gregorian
• B.Julian
• C.Fiscal
• D.Factory

Comment: *

Name: *

Email: *

Verification: *

You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

• A.<empty string>
• B."0"
• C."?"
• D."Null"

Comment: *

Name: *

Email: *

Verification: *

Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

• A.A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
• B.A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• C.SELECT privileges and Analytic Privileges (Country = United States) on both views
• D.A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

Comment: *

Name: *

Email: *

Verification: *