Which two actions should you perform?

You are designing a star schema for a dataset that contains records of online orders. Each record includes an order date, an order due date, and an order ship date.

You need to ensure that the design provides the fastest query times of the records when querying for arbitrary date ranges and aggregating by fiscal calendar attributes.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . Create a date dimension table that has a DateTime key.
B . Create a date dimension table that has an integer key in the format of YYYYMMD
D . Use built-in SQL functions to extract date attributes.
E . Use integer columns for the date fields.
F . Use DateTime columns for the date fields.

View Answer

Answer: B,D

Explanation:

Reference: https://community.idera.com/database-tools/blog/b/community_blog/posts/why-use-a-date-dimension-table-ina-data-warehouse