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

Exam DP-203 All Questions

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

Exam DP-203 topic 1 question 75 discussion

Actual exam question from Microsoft's DP-203
Question #: 75
Topic #: 1
[All DP-203 Questions]

HOTSPOT
-

You have an Azure Synapse Analytics serverless SQL pool that contains a database named db1. The data model for db1 is shown in the following exhibit.



Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the exhibit.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by blenau at April 3, 2023, 3:49 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
blenau
Highly Voted 2 years, 4 months ago
Correct answer should be join DimGeography and DimCustomer and 5 tables. You also need to combine ProductLine and Product in order for the schema to be considered a star schema. This would result in 5 remaining tables: DimCustomer (DimCustomer JOIN DimGeography), DimStore, Date, Product (Product JOIN ProductLine) and FactOrders.
upvoted 95 times
7082935
1 year ago
This is true, but we are limited by what possible answers the question provides us. So the ExamTopics selected answers are correct.
upvoted 2 times
...
moneytime
1 year, 6 months ago
It is a conversion of snow flake schema to star schema.All
upvoted 2 times
...
...
Dataminer
Highly Voted 2 years, 3 months ago
Agree with explanation. It will still be snowflake if Product and ProductLine is not combined
upvoted 20 times
...
renan_ineu
Most Recent 11 months ago
I made the exam this week (09/09/2024) and this question was present but slightly different.
upvoted 3 times
...
Nadine_nm
1 year, 1 month ago
We should join the FacOrders with the DimGeography In a star schema we have a fact table and dimensions, and dimensions shouldn't be joined also since we are making a join we are keeping the 6 dimensions + the fact table = 7
upvoted 3 times
...
Alongi
1 year, 3 months ago
I found this question on my exam 30/04/2024, and I put - join dimGeography and dimCustomer - 5 I passed the exam with a high score, but I'm not sure if the answer is correct.
upvoted 1 times
...
dark_one
1 year, 3 months ago
If 2 tables are joined there are still 2 tables, we're not UNIONing them so still 7 tables
upvoted 1 times
...
Monadire
1 year, 4 months ago
Provided answer is correct: why not 5 tables? Please, look at schema, and count once more, how many tables are at all including fact as well :) So Join Geography with Customers = overall 6 tables
upvoted 1 times
chefDE
8 months, 1 week ago
The answer should be "join DimGeography and DimCustomer", as a star schema has no 2nd grade dimensions. The second question is tricky, it asks `Once the data model is converted to a STAR schema..' which insinuates that no 2nd grade dimension tables are left. As said earlier, this means the DimProduct and DimProductCategories should and would also be joined. This would leave us with the 4 dimensions and the fact table, which is 5 tables in total.
upvoted 1 times
...
Monadire
1 year, 4 months ago
Sorry, the correct is 5, bcs question is tricky and we still have to union ProductLine with Product to have at the end star schema
upvoted 2 times
...
...
ChrisGe1234
1 year, 6 months ago
If you design DimGeography as Role Playing Dimension (How its usually done), then join Geography and Fact. Afterwards you could merge the Product Group and Product Table which leads to 6 Tables. So I would argue correct would be A: Join DimGeography and Fact B: 6
upvoted 2 times
Fusejonny1
1 year, 6 months ago
Wrong and wrong
upvoted 3 times
...
...
sdg2844
1 year, 7 months ago
I think maybe we all missed something here. If it's star schema, there is nothing hanging off the outside of the outside tables. DimGeography should be joined to FactSales, with the geography placed in the FactSales Table. However, it doesn't solve the problem of Product and ProductCategory, which need to be combined. So there is just part of the answer missing. Once those two items are done, then there are 5 tables remainin.
upvoted 2 times
s_unsworth
1 year, 5 months ago
There would still be 6 tables
upvoted 2 times
...
...
surajpdh
1 year, 8 months ago
it's a tricky question , it says once we join DimGeography and DimCustomer then how many tables will remain in data model. Answer is 6.
upvoted 2 times
...
matiandal
1 year, 10 months ago
num of tables ( dims + facts) == aka ==> 6
upvoted 4 times
...
ellala
1 year, 10 months ago
Correct would be: 1) join Geography with customer 2) (then join productline and product - this is not in the question, but must be done to transform into a star schema) 3) then we have 5 tables since Geography and ProductLine are no longer needed.
upvoted 8 times
...
hassexat
1 year, 11 months ago
join DimGeography and DimCustomer 5 tables
upvoted 3 times
...
AvSUN
1 year, 11 months ago
shouldn't it be 5 tables?
upvoted 3 times
...
kkk5566
1 year, 11 months ago
1 DimGeography and DimCustomer 2. 5 tables.
upvoted 3 times
...
ccesarrg
1 year, 12 months ago
This question is really messy. It doesn't explicit say that by joining or unioning the tables this means they will be combined into a single table, to be it seems like we'll still have 2 tables (DimGeography and DimCustomer) in both options, besides the fact that just fixing DimGeography and DImCustomer won't generate a Star Schema
upvoted 1 times
...
Deeksha1234
1 year, 12 months ago
join DimGeography and DimCustomer and 5 tables
upvoted 2 times
...
Load full discussion...
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