Online Access Free C-HCMOD-02 Exam Questions

When is the first column store compression executed?

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

Why would you create SQL in calculation views?

• A.To fine-tune performance
• B.To implement custom logic
• C.To provide an alternative to graphical modeling
• D.To enable write capabilities

In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

• A.To ensure it is not exposed to reporting tools for consumption
• B.To indicate that it should not be used as a data source to other calculation views
• C.To warn developers that the calculation view is no longer supported
• D.To lock the calculation view from further modifications

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

• A.Implement union pruning.
• B.Limit the number of stacked calculation views.
• C.Avoid aggregating data early in the data flow.
• D.Partition large tables.

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."?"
• B."0"
• C.<empty string>
• D."Null"