Exam PL-300 topic 1 question 42 discussion

Actual exam question from Microsoft's PL-300

Question #: 42
Topic #: 1

HOTSPOT
-

You are designing the data model for a Power BI semantic model.

You have the following tables in the star schema.

Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by 1CY1 at Oct. 1, 2024, 10:59 p.m.

Comments

Submit Cancel

b2775a4

Highly Voted 6 months, 2 weeks ago

Fact Table: Test Result Surrogate Key in Patient Table: Patient Key The fact table is the central table in a star schema and contains measurable data (e.g., metrics, values) and foreign keys to connect to dimension tables. The Test Result table is the fact table because: It contains measurable data like "result value." It includes foreign keys to dimensions like date, test key, and patient key. A surrogate key is a unique identifier for a row in a table, typically used as the primary key in star schemas. The Patient Key is explicitly stated as the unique identifier for rows, making it the surrogate key.

upvoted 5 times

...

Onketsu

Most Recent 6 months, 2 weeks ago

D and C Fact tables contain the content of the data warehouse and store different types of measures like additive, non-additive, and semi-additive measures. Fact tables provide the (usually) additive values that act as independent variables by which dimensional attributes are analyzed.

upvoted 1 times

...

kenyJen

10 months, 1 week ago

Given anwsers are correct.

upvoted 4 times

...

1CY1

10 months, 2 weeks ago

Given answer is what I thought as well. Ans : D, C

upvoted 4 times

...