Exam PL-300 topic 2 question 72 discussion

Please be responsible. Comment and vote carefully. The answer is A&E. To choose reference or duplicate or copy, the points are: 1: Reference, duplicate, copy queries will all make the file bigger to a similar size. 2: Choose Reference if you want the referenced queries to change when the original query changes. Choose Duplicate or Copy if you don’t want that. Reference queries is more common in many real-world scenarios because the fact table is always changing. 3: Copy and Duplicate copy the transformation steps but reference not. Disable the load for the Sales Data query will : (1) It will be cleaner in Power BI desktop because you won’t see the Sales data query. (2) improve performance. The star schema is normally the best in Power Bi modelling because of the performance. And this is the reason why we need to separate the main table into different tables(Normalization). The main table itself should not be included in a star scheme.

Agreed, A & E are correct

A. Reference the Sales Data query to create the new queries. • Referencing the Sales Data query allows you to create new queries (Product Dimension and Sales Fact) that are based on the original data without duplicating it. E. Disable the load for the Sales Data query. Disabling the load for the Sales Data query ensures that the data from this query is not loaded into the data model, which helps minimize the size of the dataset. The Product Dimension and Sales Fact queries will still have access to the data, but the original Sales Data query won't consume additional resources by being loaded into the model.

The correct answer is AE because: In Power BI, "reference" means creating a new query that is linked to an original query, so any changes made to the original query will automatically update the reference query, while "duplicate" creates a completely independent copy of a query, where modifications to the duplicate won't affect the original query; essentially, a reference keeps the queries connected, while a duplicate separates them completely.

I would vote for A and E.

ITS A and B in my opinion . If you choose E. Disable the load for the Sales Data query, here’s what would happen: No Access to Sales Data: By disabling the load for the Sales Data query, it will not be available in the data model. This means that you won’t be able to use it directly for analysis or in relationships with other tables. Impact on Referenced Queries: If you reference Sales Data for the Product Dimension and Sales Fact queries, those references would not function properly because the source data (Sales Data) is not loaded into the model.

A & E is correct

A, E is the correct one

Reference queries and Disable Sales Data Query works as per real-world scenarios.

A&E is correct

To create two queries named Product Dimension and Sales Fact based on the Sales Data query in Power Query Editor, while minimizing maintenance effort and the size of the dataset, you should perform the following two actions: Reference the Sales Data query to create the new queries: This allows you to reuse the loaded data without the need for additional storage or processing. You will not be duplicating data, which helps to keep the dataset size down and maintenance effort low. Disable the load for the Sales Data query: This step prevents the original Sales Data query from being loaded into the model, which minimizes the size of the dataset since only the necessary tables (Product Dimension and Sales Fact) will be loaded. These steps are recommended practices in scenarios where dimension tables need to be dynamic and are derived from fact tables within Power Query Editor, as they avoid unnecessary duplication of data and keep the dataset optimized.

I think A et C

I'm not sure 100%

I think A & C is correct answer.

A & C are correct. A. Referencing the sales data query ensures that the new queries use the same data source and structure, minimizing maintenance effort. C. Duplicate the sales data query creates copies of the data in separate queries. This allows you to work with the data independently for Product Dimension and Sales Fact without impacting the original sales data query.

I think it's A and C.

The correct answer should be A and C