試験PL-300J トピック3 問題219 スレッド

Explanation:

A fact table stores the event-level measurements and foreign keys, while a dimension uses a stable unique key to identify each descriptive member. The exhibit ' s transaction table and Patient key should be selected on that basis. The key constraint is to identify the fact table and the Patient table ' s surrogate key in the displayed star schema. The retained answer-area mapping contains the correct selections. The relevant current PL-300 study-guide bullet is " Create fact tables and dimension tables " . Combining descriptive attributes and transactions at mixed grains makes keys and aggregation less predictable than a dimension-to-fact star design.
It also preserves predictable filter context and aggregation behavior when the result is used by several visuals or report pages.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema | PL-300 objective: " Create fact tables and dimension tables " | Study guide: https://learn.microsoft.com/en-us
/credentials/certifications/resources/study-guides/pl-300