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

Exam DP-900 All Questions

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

Exam DP-900 topic 1 question 8 discussion

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

HOTSPOT -
You are reviewing the data model 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 graphic.
NOTE: Each correct selection is worth one point
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: star schema -
In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.
Example:

Incorrect Answers:
The data in the question is not normalized.
The snowflake schema is a variation of the star schema, featuring normalization of dimension tables. Example:

Note: A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.[citation needed]. "Snowflaking" is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.

Box 2: dimension -
The star schema consists of one or more fact tables referencing any number of dimension tables.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview https://en.wikipedia.org/wiki/Star_schema https://en.wikipedia.org/wiki/Snowflake_schema https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/
by chaudha4 at April 9, 2021, 4:05 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
chaudha4
Highly Voted 3 years, 6 months ago
Seems like this question is outside the scope of DP-900 exam. It is not covered in Azure training for DP-900 exam.
upvoted 28 times
Merci93
1 year, 7 months ago
The answer is correct. https://learn.microsoft.com/en-us/training/modules/explore-fundamentals-data-visualization/3-data-modeling
upvoted 4 times
...
CyLa
3 years, 1 month ago
There was a question similar to this. That is it will be questioned.
upvoted 4 times
...
AVP_Riga
3 years, 4 months ago
But, anyway. It's good to know to be in same page with other colleagues when working with DB.
upvoted 2 times
...
DrCloud
3 years, 4 months ago
Correct Answer. https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview#column-family-databases Under "Data analytics" section: Data type Usually denormalized in a "star" or "snowflake" schema, consisting of fact and dimension tables.
upvoted 6 times
...
Load full discussion...
...
yeanlingmedal71
Highly Voted 3 years, 5 months ago
Star Schema in data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. It is known as star schema as its structure resembles a star. Dimension tables describe business entities—the things you model. Entities can include products, people, places, and concepts including time itself. Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc. A fact table contains dimension key columns that relate to dimension tables, and numeric measure columns. https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
upvoted 23 times
...
AGTraining
Most Recent 8 months ago
Star Dimension
upvoted 3 times
...
chiiiweiii
1 year, 7 months ago
Correct Answer.
upvoted 2 times
...
xRiot007
2 years, 3 months ago
Star schema - you have multiple dimension tables linked by a fact table. Customer is one of the dimension tables.
upvoted 7 times
...
Eltooth
2 years, 3 months ago
Star Dimension
upvoted 1 times
...
cj_kuo
2 years, 7 months ago
Answer was correct due to https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
upvoted 3 times
...
CyLa
3 years, 1 month ago
Fact --> Dimensions Then Dimensions become Facts and break into more Dimensions to form Snowflakes, then more of these snowflakes to become Galaxy.
upvoted 2 times
...
Armandoo
3 years, 4 months ago
Model: Star Schema Customer: Dimension
upvoted 6 times
...
mar765
3 years, 4 months ago
What is it that tells us that this is not a Transactional Model?
upvoted 1 times
BertieT
3 years, 3 months ago
An application may further normalize a sales transaction into header and lines. There may also be a status. This lacks a status -- so is merely expressing the sales of a Product to a Customer by Sales Person at a Warehouse -- that is, more like a statement of a "fact" after it has already occurred.
upvoted 1 times
...
...
DeepMoon
3 years, 5 months ago
Customer is the Root Object. Address is an object inside the Customer; so it a nested object. Social media is an array with two elements inside of it (twitter/linkedin info). So the answer is correct.
upvoted 3 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