
Ultimate access to all questions.
You are designing a star schema for a dataset containing online order records. Each record has an order date, an order due date, and an order ship date. You need to ensure the design provides the fastest query times 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.