Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 13

HOTSPOT -

You have two CSV files named Products and Categories.

The Products file contains the following columns:

✑ ProductID

✑ ProductName

✑ SupplierID

✑ CategoryID

The Categories file contains the following columns:

✑ CategoryID

✑ CategoryName

✑ CategoryDescription

From 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

✑ CategoryDescription

How 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:

    Correct 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

Discussion
GPerez73

Ok for me

mustafaalhnuty

Ok for me too 👍🏻

Nurgul

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

nick0651

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.

Ragmat

Hi does anyone agree with nick0651 sentiments?

9f73003

I can't say if I agree with nick0651, but he sure does chime in a ton with that sentiment...

Tareqk

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

LeeTheRed

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

Igetmyrole

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.

sdaaram

This was on exam yesterday

JohnChung

Totally agree with the given answer

AKUMAR2104

This was on exam Today

rainy_255

This was in the exam this week.

zainq96

this was on 13/06/2024 exam as well

Chellz

On 06/08/2024 exam

thomas_90

answer is correct

ET_phone_home_son

Merge / Disable query load

inejo

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

nmnm22

wish all questions were this simple

DUVANES

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