Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 75 discussion

Actual exam question from Microsoft's DP-203

Question #: 75
Topic #: 1

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

Suggested Answer:

by blenau at April 3, 2023, 3:49 p.m.

Comments

Submit Cancel

blenau

Highly Voted 2 years, 2 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

10 months, 2 weeks 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, 4 months ago

It is a conversion of snow flake schema to star schema.All

upvoted 2 times

...

Dataminer

Highly Voted 2 years, 2 months ago

Agree with explanation. It will still be snowflake if Product and ProductLine is not combined

upvoted 20 times

...

renan_ineu

Most Recent 9 months, 1 week ago

I made the exam this week (09/09/2024) and this question was present but slightly different.

upvoted 3 times

...

Nadine_nm

11 months, 2 weeks 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, 1 month 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, 2 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, 2 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

6 months, 2 weeks 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, 2 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, 4 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, 4 months ago

Wrong and wrong

upvoted 3 times

...

sdg2844

1 year, 5 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, 3 months ago

There would still be 6 tables

upvoted 2 times

...

surajpdh

1 year, 7 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, 8 months ago

num of tables ( dims + facts) == aka ==> 6

upvoted 4 times

...

ellala

1 year, 8 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, 9 months ago

join DimGeography and DimCustomer 5 tables

upvoted 3 times

...

AvSUN

1 year, 9 months ago

shouldn't it be 5 tables?

upvoted 3 times

...

kkk5566

1 year, 9 months ago

1 DimGeography and DimCustomer 2. 5 tables.

upvoted 3 times

...

ccesarrg

1 year, 10 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, 10 months ago

join DimGeography and DimCustomer and 5 tables

upvoted 2 times

...

Load full discussion...