Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam PL-300 Topic 15 Question 27 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 27
Topic #: 15
[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?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

Art
2 days ago
A) Yes, but adding a filter step can help reduce the amount of data being imported.
upvoted 0 times
...
Breana
4 days ago
B) No, I think importing the entire table would be more efficient.
upvoted 0 times
...
Art
6 days ago
A) Yes, that sounds like a good approach.
upvoted 0 times
...
Renay
8 days ago
A) Yes, because filtering the data before importing will reduce the amount of data being loaded into Power BI.
upvoted 0 times
...
Kimberlie
14 days ago
B) No, because importing the entire table first before filtering would be more efficient.
upvoted 0 times
...
Olga
19 days ago
A) Yes, because adding a filter step will help in importing a sample of the data.
upvoted 0 times
...

Save Cancel