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.
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.
It is a conversion of snow flake schema to star schema.All
Agree with explanation. It will still be snowflake if Product and ProductLine is not combined
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.
num of tables ( dims + facts) == aka ==> 6
join DimGeography and DimCustomer 5 tables
shouldn't it be 5 tables?
1 DimGeography and DimCustomer 2. 5 tables.
ProductLine and Product also should be joined to switch to a star schema, if not we will be still on Snowflake Schema, so the remained tables should be 5, not 6.
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
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
Wrong and wrong
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.
There would still be 6 tables
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.
join DimGeography and DimCustomer and 5 tables
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.
If 2 tables are joined there are still 2 tables, we're not UNIONing them so still 7 tables
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
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
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