Exam PL-300 All QuestionsBrowse all questions from this exam
Go to 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?

    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
simplex06Option: B

I agree with the answer. B. No

Denjarus

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

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

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

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

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

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

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

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

yordiye

I agree

Remko_K

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

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

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

Amitex

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

what did u get?

8b24250

Thank you i am always looking for your response

Manikumarbroly17

same i always look for your comment

Usm_9

WAS ON THE EXAM 02/03/2024

1d41aaa

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

DANIELOption: B

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

TareqkOption: A

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

rajae_1234

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

Clemzy96Option: A

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

bingomutantOption: A

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 .

ak0017

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

SmyrolOption: B

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

greenleverOption: B

B is correct

GiudittaOption: B

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

DANIELOption: B

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

FlorinucaOption: B

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

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

CookieMingkeeOption: B

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

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

CookieMingkee

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

SHENOOOOOption: B

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.

SessizOption: B

B is correct