Exam PL-300 topic 1 question 5 discussion

Correct - Append Queries as New - Disable loading the query to the data model

Answer is correct. However just Append is also valid. Its just that due to the two part answer box's given and needing an answer, then it means the first box must be using Append (as new)

I have a different view point, what if the two table has the same row data from 2 different table database users, the combine option "append query" may lead to duplication of records ! The Question statement does not state anything about Field as Unique CUST_ID or other, User may need to use Trim function for (ID Field Name), the merge table option as New table may avoid duplicates and can generate clean table ! with minimum size

Since the second is: - Disable loading the query to the data model then we need to append (same structure) as new - Append Queries as New

Correct

I think the answer is right because if you use "Append Queries" you will have issues with the second option "Disable loading into the model", because this action must be performed in both table. That is why I think.

Whenever you read that the tables have same structure use append. Append as new or not depends on if you want to keep the original table or not. Generally you don't want to keep it in the data model. This will not increase the data model size so you should not load it in the data model.

Interesting

Append is also Correct. Its just that due to the two part answer box's given and needing an answer, then it means the first box must be using Append

Taking into account the fact that it is strictly about 2 tables to append that have exactly the same structure (number of columns, their names) why would you do "as new"? Why do "disable loading to the data model" for 2 tables, when you can only do it for one? We also notice "query" in the answers. And in the documentation, the example for "Append queries as new" is used when more than 3 tables are involved in the query and which do not have the same structure (number of columns, names). I think the correct answer is : - Append Queries - Disable loading the query to the data model

what is the need to retain the original two queries after we have created a new query by appending them ? Wouldn't append as new create a standalone query ?

Given answer is correct. You must Append as New and then disable load from the original tables.

By default, all queries from Query Editor are loaded into the memory of the Power BI model. However, you have the option to disable loading for specific queries, particularly those used as intermediate transformations to generate the final query for the model. Disabling the load does not mean the query won't be refreshed; it simply prevents the query from being loaded into memory. Even if a query is marked as "Disable Load," it will still be refreshed when you manually click "Refresh model" in Power BI or during a scheduled refresh. However, the data from these queries will be utilized as intermediate sources for other queries, instead of being loaded directly into the model. This performance tuning tip is particularly valuable as your Power BI model grows larger.

There are different ways to come to the same conclusion BUT the answer is correct in this case based on the need to disable the TWO ORIGINAL QUERIES. The only way that you can ended up with three queries (two originals and one new, thus need to disable two original queries) was if the APPEND AS NEW was selected in the first step.

The correct Answers are: * Append Queries: because it is used to combine the Customer table into as single table. This will stack the data from both tables on top of each other, creating a unified Customer Table. * Disable loading the query to the query to the data model: since we want to minimize the size of the data model and avoid duplicating the data from the SQL databases, we should prevent these queries from being loaded into the Power BI data model.

The answer is correct because when you use "Append query" the original queries will no longer be there. but it is only when you use "append query as new" that you will need to perform the next question that has to do with disabling the loading of queries

Appending 2 Queries (Query-B to Query-A) , and Disable Loading Query-B is same size with Appending 2 Queries as New (Query-C) and Disable Loading Queries-A and Query-B. Because Answer says "Disable loading the query" , not "Queries", It is : Append Queries and Disable Loading the Query