ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 16 discussion

Actual exam question from Microsoft's PL-300
Question #: 16
Topic #: 2
[All PL-300 Questions]

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?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by simplex06 at Sept. 4, 2022, 10:36 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
simplex06
Highly Voted 2 years, 8 months ago
I agree with the answer. B. No
upvoted 79 times
BiLearn
2 years ago
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.
upvoted 28 times
Seda_
9 months, 1 week ago
If you import the entire table, you will increase memory usage and may experience performance issues. Applying a filter only affects the visibility of the data, while still keeping the entire table in memory. Therefore, a more effective method is to sample or filter directly on the data source.
upvoted 12 times
signofanopeneye
9 months ago
haklisin seda
upvoted 3 times
...
...
hypersam
11 months, 4 weeks ago
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
upvoted 4 times
...
BiLearn
2 years ago
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.
upvoted 16 times
JudT
1 year, 1 month ago
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.
upvoted 1 times
...
LouStar2
1 year, 11 months ago
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?
upvoted 1 times
...
...
...
Denjarus
2 years, 6 months ago
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
upvoted 14 times
Shalaleh
2 years, 1 month ago
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.
upvoted 8 times
...
...
...
H_E_Z
Highly Voted 2 years, 7 months ago
I think query folding can push the filter into the query so A yes
upvoted 32 times
yordiye
2 years, 3 months ago
I agree
upvoted 1 times
...
Remko_K
2 years, 3 months ago
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.
upvoted 5 times
Remko_K
2 years, 3 months ago
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.
upvoted 8 times
...
...
...
Curious236
Most Recent 2 months ago
Selected Answer: A
"During the development process, you need to import a sample of the data from the Order table.". This approach meets this goal thanks to query folding, as after the filtering step, the native query sent to the data source will be modified to import only the rows that meet the condition.
upvoted 1 times
...
ee0625a
2 months, 2 weeks ago
Selected Answer: A
Filtering ensures that we select only a manageable number of rows such as 100, 000 that will help test what we want to analyze rather than having 100 million rows
upvoted 1 times
...
kinlee
2 months, 3 weeks ago
Selected Answer: B
B. It stated "From Power Query Editor, you import the table and then add a filter step to the query." Can't do this. If imported through and SQL and not the table, then it is probably a Yes.
upvoted 1 times
...
ee0625a
2 months, 4 weeks ago
Selected Answer: A
Power Query Editor allows filtering data at the query level, which means only the filtered data will be imported into Power BI, reducing the data load
upvoted 1 times
...
SilBri_830
3 months ago
Selected Answer: A
In Power Query Editor, when you add a filter step to the query, only the filtered subset of data is loaded into the Power BI model. This approach allows you to work with a smaller sample of the data during development while maintaining the ability to later remove or adjust the filter for the full dataset.
upvoted 1 times
...
485307a
3 months, 1 week ago
Selected Answer: A
A is correct same results chat gpt returned me
upvoted 1 times
...
RRconnect
3 months, 2 weeks ago
Selected Answer: B
you can select the required data in the sql query itself instead of importing all data and then apply filter in power query
upvoted 2 times
...
SUNNYDEPS
3 months, 2 weeks ago
Selected Answer: A
B is correct as to minimize the data size while in the development phase
upvoted 1 times
...
SylUK
3 months, 3 weeks ago
Selected Answer: B
B is the answer you can only apply the filter at the source through SQL for example no after loading the entire table.
upvoted 1 times
...
Peggym
3 months, 3 weeks ago
Selected Answer: B
During the development process, you need to import a sample of the data from the Order table.: if you choose A you import the whole table and then filter it, so you should adjust the sql statement
upvoted 1 times
...
Odidepse
3 months, 3 weeks ago
Selected Answer: A
Correct answer is Yes , this solution works because adding a filter step in Power Query Editor limits the data imported, allowing you to work with a sample of the table during development.
upvoted 1 times
Pitxunet
2 months, 4 weeks ago
In the question it is stated that the filter is applied after importing the data... it's too late. So the answer is B.
upvoted 1 times
...
...
YuanQingTan
4 months, 2 weeks ago
Selected Answer: A
When the data is imported to power query, then filtered, query folding is possible, hence the filtering is done by the source before retrieving it back to power query. I tested this 1) import a table from SQL to power query. 2) saved the PBIX file. 3) Checked the size of the PBIX file. 4) Open power query and add a filter step to the table. 5) Save the PBIX file. 6) Checked the size of the PBIX file and noticed that the file size actually decreased. This shows that only the required data is imported If the entire data from the SQL is imported to power query, then only filtered by power query, i would imagine that the file size will remain unchanged.
upvoted 1 times
...
rules169
5 months ago
Selected Answer: A
Yes, that approach meets the goal. By importing the table into Power Query Editor and then applying a filter step to the query, you can create a manageable sample of the data from the large Order table. This method ensures you have a representative subset of the data to work with during development without needing to load all 100 million records
upvoted 1 times
...
Mo_Suhail
5 months, 1 week ago
Selected Answer: A
This solution meets the goal because adding a filter step in the Power Query Editor effectively limits the amount of data imported during the development process. This approach allows you to work with a sample of the data from the Order table while reducing resource usage and improving performance.
upvoted 1 times
...
jaume
5 months, 2 weeks ago
Selected Answer: B
Filtering data once it has been imported could improve further calculations, but data has been already imported..... so I don't think a DAX expression would prevent the entire table import into the model
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago