Exam DP-600 topic 1 question 121 discussion

Actual exam question from Microsoft's DP-600

Question #: 121
Topic #: 1

HOTSPOT
-

You have a Fabric tenant that contains a warehouse named WH1.

You have source data in a CSV file that has the following fields:

• SalesTransactionID
• SaleDate
• CustomerCode
• CustomerName
• CustomerAddress
• ProductCode
• ProductName
• Quantity
• UnitPrice

You plan to implement a star schema for the tables in WH1. The dimension tables in WH1 will implement Type 2 slowly changing dimension (SCD) logic.

You need to design the tables that will be used for sales transaction analysis and load the source data.

Which type of target table should you specify for the CustomerName, CustomerCode, and SaleDate fields? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by 6f38739 at Jan. 25, 2025, 5:54 p.m.

Comments

Submit Cancel

abhijitger12

Highly Voted 2 months, 4 weeks ago

Fact tables record the "events" or "transactions" that you want to analyze. SaleDate represents the date of a sales transaction, which is a key aspect of the event itself. Answer : Dim, Dim, Fact

upvoted 10 times

...

6f38739

Highly Voted 3 months ago

Dim, Dim, Fact

upvoted 8 times

...

ba2bfdf

Most Recent 4 weeks, 1 day ago

Answer : Dim, Dim, Fact

upvoted 1 times

...

ba2bfdf

1 month ago

Dim, Dim, Fact

upvoted 1 times

...

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 121 discussion

Comments

abhijitger12

6f38739

ba2bfdf

ba2bfdf

SY0-701