PL-300 Exam - Question 13

Question

HOTSPOT -You have two CSV files named Products and Categories. The Products file contains the following columns:✑ ProductID✑ ProductName✑ SupplierID✑ CategoryIDThe Categories file contains the following columns:✑ CategoryID✑ CategoryName✑ CategoryDescriptionFrom Power BI Desktop, you import the files into Power Query Editor. You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:✑ ProductID✑ ProductName✑ SupplierID✑ CategoryID✑ CategoryName✑ CategoryDescriptionHow should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:.

Examice · Accepted Answer

Box 1: Merge -There are two primary ways of combining queries: merging and appending. * When you have one or more columns that you'd like to add to another query, you merge the queries. * When you have additional rows of data that you'd like to add to an existing query, you append the query. Box 2: Disable the query load -Managing loading of queries -In many situations, it makes sense to break down your data transformations in multiple queries. One popular example is merging where you merge two queries into one to essentially do a join. In this type of situations, some queries are not relevant to load into Desktop as they are intermediate steps, while they are still required for your data transformations to work correctly. For these queries, you can make sure they are not loaded in Desktop by un-checking 'Enable load' in the context menu of the query in Desktop or in the Properties screen:Reference:https://docs. microsoft. com/en-us/power-bi/connect-data/desktop-shape-and-combine-data https://docs. microsoft. com/en-us/power-bi/connect-data/refresh-include-in-report-refresh.

GPerez73 · Answer

Ok for me

Nurgul · Answer

The given answer is correct.
Combine the queries by performing a: Merge.
On the Categories query: Disable the query load.

nick0651 · Answer

given exam on 21th Oct 2023 , This Question is in the exam . I scored 79 , No need to take ful version most of the question covern under 24 pages only.

Tareqk · Answer

This is was on the exam today. 2024-04-19

sdaaram · Answer

This was on exam yesterday

Igetmyrole · Answer

Merge & Exclude the query from report refresh are correct answers. 
Use the merge to combine the "Products" and "Categories" queries based on the "CategoryID" column.
Once we have combined the queries, we don't need the standalone "Categories" query because we have merged its data into the "Product" table. We "Exclude the query from report refresh" to ensure it doesn't unnecessarily reload when refreshing the report.

LeeTheRed · Answer

This question was on the exam today 9/12/2023

AKUMAR2104 · Answer

This was on exam Today

JohnChung · Answer

Totally agree with the given answer

rainy_255 · Answer

This was in the exam this week.

DUVANES · Answer

1. Combine las consultas realizando: Merge - Combinar
2. En la consulta Categorías: Deshabilite la carga de consultas.

nmnm22 · Answer

wish all questions were this simple

inejo · Answer

La respuesta es correcta Combinar, pq se requiere complementar la primera tabla y Deshabilitar la carga de la consulta, para mejor rendimiento.

ET_phone_home_son · Answer

Merge / Disable query load

thomas_90 · Answer

answer is correct

Chellz · Answer

On 06/08/2024 exam

zainq96 · Answer

this was on 13/06/2024 exam as well

PL-300 Exam - Question 13

Discussion