Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
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.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: - Fact table: Test Result This table records each administered test (transactional data), making it the central fact table in the star schema. - Surrogate key in Patient table: Patient key This is the unique identifier for each patient and is used as a foreign key in the fact table.
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.
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.