Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 8 discussion

Actual exam question from Microsoft's DP-900

Question #: 8
Topic #: 1

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

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

Submit Cancel

chaudha4

Highly Voted 3 years, 8 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, 9 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, 3 months ago

There was a question similar to this. That is it will be questioned.

upvoted 4 times

...

AVP_Riga

3 years, 6 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, 6 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, 7 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 9 months, 3 weeks ago

Star Dimension

upvoted 3 times

...

chiiiweiii

1 year, 9 months ago

Correct Answer.

upvoted 2 times

...

xRiot007

2 years, 5 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, 5 months ago

Star Dimension

upvoted 1 times

...

cj_kuo

2 years, 9 months ago

Answer was correct due to https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

upvoted 3 times

...

CyLa

3 years, 3 months 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, 6 months ago

Model: Star Schema Customer: Dimension

upvoted 6 times

...

mar765

3 years, 6 months ago

What is it that tells us that this is not a Transactional Model?

upvoted 1 times

BertieT

3 years, 4 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, 7 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

...