ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 2 question 12 discussion

Actual exam question from Microsoft's DP-700
Question #: 12
Topic #: 2
[All DP-700 Questions]

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 Hide Answer
Suggested Answer:
by werfragt at Jan. 17, 2025, 12:23 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
4371883
Highly Voted 3 months, 3 weeks ago
Agree with the answers
upvoted 11 times
...
werfragt
Highly Voted 3 months, 4 weeks ago
Is this correct? I would choose >= and <=.
upvoted 7 times
8d6881f
3 months, 2 weeks ago
No, the order has to be *before* the 'new costumer' takes effect. Otherwise it could belong to two customers
upvoted 2 times
DirectX
2 months, 2 weeks 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 1 times
d98a23f
1 month, 3 weeks 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
1 month, 3 weeks ago
I mean, the customer need to be valid To datetime
upvoted 1 times
...
...
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago