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

PL-300 Exam - Question 48

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the query.

Does this meet the goal?

Show Answer
Correct Answer: B

When you import a table and then apply a filter in Power Query Editor, the entire table is initially imported before the filter is applied. This means that all 100 million records from the Order table will be loaded into Power Query Editor initially, which is inefficient and time-consuming. To import only a sample of the data, it's better to add a WHERE clause directly in the SQL query used for importing the data. This way, the filtering happens at the database level before the data is brought into Power BI, reducing the volume of data transferred and processed.

Discussion

17 comments
Sign in to comment
simplex06Option: B
Sep 4, 2022

I agree with the answer. B. No

Denjarus
Oct 29, 2022

B is correct. This will load the entire table in the first step when you import. Instead add a WHERE clause to the SQL statement

Shalaleh
Mar 28, 2023

It seems the correct answer is A, "Yes". because the question said importing in POWER QUERY and not POWER DESKTOP. and before importing POWER DESKTOP it uses filter step and filters the data. it means it will import only part of the table into power bi desktop. Although it is not recommended but still it works. please let me know if I am wrong.

BiLearn
Apr 11, 2023

A, should be correct. We have concept of Query Folding. If we apply the steps and it can be converted to Native Query then it will execute as is. By development process it might mean by building Power BI Report, the view might be production view and as it is having 100 Million record. We cannot update the view for Power BI development.

BiLearn
Apr 11, 2023

Great Explanation by Sana Correct Answer A Yes, when you use Power Query Editor to import a table with a filter in Power BI, only the filtered data is imported into the data model. The Power Query Editor is used to transform and shape the data before it is loaded into the data model. When you apply a filter step to the query in Power Query Editor, it will only select the records that meet the filter criteria, and exclude the records that do not. This filtered data is then loaded into the data model.

LouStar2
Jun 3, 2023

So from: https://learn.microsoft.com/en-us/power-query/power-query-folding If the View Native Query option isn't enabled (greyed out), this is evidence that not all query steps can be folded. However, it could mean that a subset of steps can still be folded. Working backwards from the last step, you can check each step to see if the View Native Query option is enabled. So is that enabled by default?

JudT
Mar 26, 2024

Tested - The correct answer is A - So how you will apply the filter? Load your data in Power query. Create a "new parameter" from "Manage Parameters Menu" and assign your sample "start date" in "current value" field and reach ok. Filter your Datekey column by the created "new parameter" to get your sample in the model.Hope this will help.

hypersam
May 10, 2024

but before you apply the filter, you need to load the entire data in full to query editor, then you apply the filter, which turns into native query. It's best when you just add a where clause in sql query when importing

H_E_ZOption: A
Sep 12, 2022

I think query folding can push the filter into the query so A yes

yordiye
Jan 14, 2023

I agree

Remko_K
Jan 17, 2023

Query folding is only possible when using Direct Query. However, the exercise states import, so query folding cannot be used and as a consequence the filter cannot be pushed into the query.

Remko_K
Jan 17, 2023

Correction: For a DirectQuery or Dual storage mode table, the Power Query query must achieve query folding. For an Import table, it may be possible to achieve query folding.

LanTodakOption: B
Oct 15, 2023

Exam: 15/10/2023 Score: 948/1000 Answer: B

Amitex
Nov 12, 2023

I am always looking for your response as you just took the exam, and mine is scheduled for 30/11/2023. I am so impressed with your score.

0f9d831
Mar 29, 2024

what did u get?

8b24250
Dec 12, 2023

Thank you i am always looking for your response

Manikumarbroly17
Mar 29, 2024

same i always look for your comment

DANIELOption: B
Feb 28, 2024

proposed solution states : Import THEN apply a filter --> meaning applying a filter on a 100miio records table -> valid ? hello no!

Usm_9
Mar 6, 2024

WAS ON THE EXAM 02/03/2024

1d41aaa
Mar 9, 2024

And what was the answer? That would be more beneficial for the community..

bingomutantOption: A
Oct 5, 2023

the question is ambiguous. The requirement is to import a SAMPLE to PowerBI. Not the whole database. However importing the whole database into PQE and THEN filtering so as to import a sample into Power BI seems to satisfy the question so answer is yes. Unfortunate phrasing .

Clemzy96Option: A
Feb 9, 2024

The Answer should be A. Yes because the question simply asks if the solution works, its not asking for the most optimal one which would be to add a 'WHERE' clause in SQL before importing

TareqkOption: A
Apr 19, 2024

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

rajae_1234
Jun 13, 2024

what is the duration of the exam and how many questions,please ?

SessizOption: B
Oct 16, 2023

B is correct

SHENOOOOOption: B
Jan 22, 2024

B is correct, if you are thinking to add a filter later after you load the data, then PowerBI is still Loading the whole table first before getting into the filter step. The appropriate action is to add a where section in the SQL Query.

CookieMingkeeOption: B
Jan 28, 2024

Importing without a filter will bring all the 100 million records before you apply a filter. Using the native query language with "where" clause will filter the data even before importing it into Power BI Desktop.

Elektrolite
Mar 11, 2024

When you first import, it only selects the first few rows in the table, it doesn't load the whole table into memory

CookieMingkee
May 21, 2024

You might be referring to the Table View not the Power Query. The Table View displays only 1000 records.

FlorinucaOption: B
Feb 16, 2024

The answer is No because you firstly import the entire data source (that it takes time to load) and after that you apply a filter step in Power Query Editor.

Elektrolite
Mar 11, 2024

When you first import, it only selects the first few rows in the table, it doesn't load the whole table into memory

DANIELOption: B
Feb 20, 2024

Importing 10millions+ and then adding a filter ??? To get a sample just use a Select Top N statement where N is the number of records you want to upload

GiudittaOption: B
Mar 12, 2024

Power Bi is not that smart. even if you have a step that filters data away, it will FIRST import all the data AND THEN apply the filter. you must operate on the first step: import, so a query can do the magic here

greenleverOption: B
Apr 26, 2024

B is correct

SmyrolOption: B
Jun 27, 2024

I think this is B as the question says: 'During the development process, you need to import a sample of the data from the Order table.' so it means only a part must be imported - this is to be achieved by where clause. I mporting and filtering will still import all and then filter

ak0017
Jul 18, 2024

Hello Guys, Can you explain me this line. , once we start this section, we cannot go back? "After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen." Thanks