nerdexam
Microsoft

DP-203 · Question #141

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…

The correct answer is C. Create a date dimension table that has an integer key in the format of YYYYMMDD. D. In the fact table, use integer columns for the date fields. We are designing a star schema so we need a dimension table.

Submitted by carlos_mx· Mar 30, 2026Design and implement data storage

Question

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.

Options

  • ACreate a date dimension table that has a DateTime key.
  • BUse built-in SQL functions to extract date attributes.
  • CCreate a date dimension table that has an integer key in the format of YYYYMMDD.
  • DIn the fact table, use integer columns for the date fields.
  • EUse DateTime columns for the date fields.

How the community answered

(25 responses)
  • A
    16% (4)
  • B
    4% (1)
  • C
    76% (19)
  • E
    4% (1)

Explanation

We are designing a star schema so we need a dimension table.

Topics

#star schema design#date dimension#integer surrogate key#fiscal calendar

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-203 Practice