Why might you use the Keep Flag property in an aggregation node?

• A.To include columns that are NOT requested by a query but are essential for the correct result
• B.To exclude columns that are NOT requested by a query to avoid incorrect results
• C.To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• D.To retain the correct aggregation behavior in stacked views

Comment: *

Name: *

Email: *

Verification: *

In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?

• A.Procedure
• B.Anonymous block
• C.Table function
• D.Scalar function

Comment: *

Name: *

Email: *

Verification: *

You deleted the design-time file of a calculation view in your HDB module. What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

• A.Execute the refactor function for the calculation view.
• B.Deploy the folder that contained the deleted design-time file.
• C.Deploy the project that contained the deleted design-time file.
• D.Execute a DROP statement in an SQL Console connected to the HDI container.

Comment: *

Name: *

Email: *

Verification: *

Why would you create calculation views of data category DIMENSION with type TIME?

• A.To provide the time intervals required by time-dependent parent-child hierarchies
• B.To store historical versions of attributes
• C.To add a temporal condition to a join to find matching records from two tables based on a date
• D.To provide additional time-related navigation possibilities

Comment: *

Name: *

Email: *

Verification: *

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

• A.Joins
• B.Data sources of unions
• C.Calculated columns
• D.Filters

Comment: *

Name: *

Email: *

Verification: *