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

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

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.SELECT privileges and Analytic Privileges (Country = United States) on both views
• B.A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• C.A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
• 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: *

You have generated a calculation view properties file.What does it contain?

• A.All settings defined in a calculation view
• B.Descriptions of all objects defined in a calculation view
• C.Documentation to support the calculation view
• D.Dependencies between calculation views

Comment: *

Name: *

Email: *

Verification: *

When is the first column store compression executed?

• A.When partitions are regenerated
• B.When the table is created
• C.When a delta merge is triggered
• D.When a backup is started
• E.Question

Comment: *

Name: *

Email: *

Verification: *

What are the key steps to implement currency conversion in a calculation view?

• A.Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Deploy the conversion rule
• B.Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Assign the conversion rule to your calculation view
• C.Assign semantic type Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type
• D.Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column

Comment: *

Name: *

Email: *

Verification: *