Exam DP-700 topic 2 question 24 discussion

Actual exam question from Microsoft's DP-700

Question #: 24
Topic #: 2

HOTSPOT
-

You have a Fabric warehouse named DW1 that contains four staging tables named ProductCategory, ProductSubcategory, Product, and SalesOrder. ProductCategory, ProductSubcategory, and Product are used often in analytical queries.

You need to implement a star schema for DW1. The solution must minimize development effort.

Which design approach should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by zxc01 at April 10, 2025, 12:48 a.m.

Comments

Submit Cancel

zxc01

Highly Voted 2 months, 3 weeks ago

second one should be "The unique system generated identifier"

upvoted 17 times

...

DarioReymago

Most Recent 3 weeks, 3 days ago

Request is minimize effort with start schema: 1: combine in one products table 2: ProductID

upvoted 1 times

...

kim32

1 month, 2 weeks ago

2. The joining key must be: ✅ The unique system generated identifier Why? Data integrity: Use ProductID (or similar surrogate key) as the primary key for the product dimension table. Efficient joins: Surrogate keys improve join performance between fact and dimension tables. Why Not Other Options? Product name/date: Names can change, and dates are not unique. Product category name: Not a stable or unique identifier.

upvoted 4 times

...

DataConsultant

1 month, 2 weeks ago

The unique system generated identifier

upvoted 1 times

...