Exam DP-700 topic 2 question 12 discussion

Actual exam question from Microsoft's DP-700

Question #: 12
Topic #: 2

HOTSPOT -
You have a Fabric workspace that contains two lakehouses named Lakehouse1 and Lakehouse2. Lakehouse1 contains staging data in a Delta table named Orderlines. Lakehouse2 contains a Type 2 slowly changing dimension (SCD) dimension table named Dim_Customer.
You need to build a query that will combine data from Orderlines and Dim_Customer to create a new fact table named Fact_Orders. The new table must meet the following requirements:
Enable the analysis of customer orders based on historical attributes.
Enable the analysis of customer orders based on the current attributes.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by werfragt at Jan. 17, 2025, 12:23 p.m.

Comments

Submit Cancel

4371883

Highly Voted 5 months, 1 week ago

Agree with the answers

upvoted 13 times

...

werfragt

Highly Voted 5 months, 2 weeks ago

Is this correct? I would choose >= and <=.

upvoted 8 times

8d6881f

5 months ago

No, the order has to be *before* the 'new costumer' takes effect. Otherwise it could belong to two customers

upvoted 2 times

DirectX

4 months, 1 week ago

Of course that's not going to happen. Each order is linked to a customer (o.CustomerId = c.CustomerId). And new customer and old customer has different CustomerId value. The answer is: >= and <=

upvoted 2 times

d98a23f

3 months, 1 week ago

But don't you think, customer table are a dimensional table with a repeated customerId(non unique customerId)? that's why we need these conditions.

upvoted 1 times

d98a23f

3 months, 1 week ago

I mean, the customer need to be valid To datetime

upvoted 1 times

...

DarioReymago

Most Recent 4 weeks, 1 day ago

it is ok

upvoted 1 times

...