Date Table Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Design and Implement a Data Model

What you'll be asked

  1. Why is it considered a best practice to create a dedicated Date table in a data model rather than using the auto-generated date hierarchies?
  2. What is the primary requirement for a column to be marked as a 'Date table' in tools like Power BI?
  3. When working with multiple fact tables (e.g., Sales and Inventory) that share a common Date dimension, what is the best practice for establishing the relationship?
  4. If your business follows a fiscal year starting on July 1st, what is the most efficient way to handle this in your Date table?
  5. You have a Date table and a Sales table. You need to analyze sales by 'Order Date' and 'Ship Date'. How should you implement this in the model?

Answers and explanations come after you submit.