Exam PL-200 topic 5 question 30 discussion

Copilot Sure, here are the selected solutions for each requirement: A table of aggregated data must be created in dataflow storage: Computed Entity: Use a computed entity to perform the necessary calculations and aggregations on the data before storing it in the dataflow storage. A unique identifier must be created for the table: Key Column: Create a key column to serve as the unique identifier for the table. By using a computed entity for aggregation and a key column for unique identification, you can effectively configure your dataflow to meet the specified requirements.

Computed Entity Key Column

correct

Pls refer to the below link. https://learn.microsoft.com/en-us/power-query/dataflows/computed-tables Computed table is used in a dataflow for aggregated data A key column is used as an identifier

in two minds about 'merge queries' and 'computed entities' merge query: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data computed entity: https://learn.microsoft.com/en-us/power-query/dataflows/computed-tables observe the part of the link: /power-bi/connect-data/ /power-query/dataflows/ merge is to bring columns into one table (example of ms retirement data that has the state name and another table associating state code to state name, finally have state code in the retirement table) and compute is to aggregate the numbers (have two table with service calls associated with accounts and list of accounts) first "in-storage computation" to aggregate the number of sevice calls per year per account and then merge this number to the account list. to finally see a list of accounts with (total) service calls per year. answers are correct.

ChatGPT: To meet the requirements of creating a table of aggregated data and generating a unique identifier, you should use the following options: Table of Aggregated Data: Fact Table Explanation: In data warehousing and data modeling, a fact table is typically used to store aggregated numerical measures (facts) that can be analyzed. It is suitable for storing aggregated data. Unique Identifier: Alternate Key Explanation: An alternate key is a candidate key that is unique within the entity and can be used as an identifier. It provides an alternative way to uniquely identify records besides the primary key. This would be suitable for creating a unique identifier for your table. So, the correct options are: For the table of aggregated data: Fact Table For the unique identifier: Alternate Key

I think is correct : https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features