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

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

Comment: *

Name: *

Email: *

Verification: *

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

• A.To generate a calculated column
• B.To convert currencies
• C.To generate a restricted column
• D.To generate hierarchies
• E.To define a filter

Comment: *

Name: *

Email: *

Verification: *

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

• A.To improve response time when multiple users access the same table
• B.To overcome the 2 billion record limit
• C.To improve query performance when accessing large column tables
• D.To improve data replication performance on large row tables

Comment: *

Name: *

Email: *

Verification: *

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this?

• A.The cache data retention period has expired.
• B.You did not define a filter in the cache setting.
• C.The query requests only a subset of the cached results.
• D.You did not define any columns in the cache setting.

Comment: *

Name: *

Email: *

Verification: *