MENU
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?
Suggested Answer: A
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
AL
Alverta
11 months ago
Agreed, using filters is a smart move for managing big data!
CA
Carmen
11 months ago
Wait, can you really handle 100 million records like that? Sounds risky!
BL
Blondell
11 months ago
Definitely meets the goal! Filtering is key for large datasets.
MA
Malcom
11 months ago
I think it doesn't really meet the goal. You need to limit the rows first.
AR
Arlene
11 months ago
Yes, filtering in Power Query is a solid way to sample data!
AL
Alesia
12 months ago
I’m leaning towards "No" because I recall that filtering after import can still lead to performance issues with such a large table.
MI
Mitzie
12 months ago
I feel like importing the entire table first might not be the best approach. I think we should be able to sample directly without bringing in all those records.
JU
Julio
1 year ago
I remember practicing a similar question where filtering was key, but I wonder if just filtering after importing is enough for a large dataset like this.
LA
Lavera
1 year ago
I think adding a filter step in Power Query should help reduce the amount of data imported, but I'm not entirely sure if it meets the goal of sampling effectively.
TH
Thurman
1 year ago
I'm pretty sure this is asking about how to generate a GUID in code, so I think the answer is probably a call to a JavaScript function.
TU
Tuyet
1 year ago
Hmm, I'm a bit confused about the difference between single and double quotes when using environment variables. I'll need to review that part carefully.
HA
Haley
1 year ago
I vaguely remember something about the percentage of the business value being key to the deferral, but I'm not sure if it's specifically over 50%.
AB
Abel
1 year ago
I seem to recall that composability is about how services work together, so I guess I'm also leaning towards False.
LA
Laurel
1 year ago
This is a no-brainer. Filtering the data in Power Query is the perfect solution. It's like a ninja move to handle that huge table.
PA
Paul
1 year ago
Absolutely, the filter step is the way to go. It's like using a magic wand to summon only the data you need - no more, no less.
AH
Ahmad
1 year ago
Haha, 100 million records? That's a lot of data! This solution definitely beats trying to import the whole thing. Well done, Power BI!
LO
Lorrie
1 year ago
User 4: Power BI for the win!
JE
Jesus
1 year ago
User 3: Agreed, this solution is much more efficient
KR
Kris
1 year ago
User 2: Definitely, importing the whole table would have been a nightmare
MO
Monroe
1 year ago
User 1: Yes
PA
Page
1 year ago
I agree, using a filter step is a smart approach. It allows you to quickly get a sample of the data without having to load the full 100 million records.
JA
Janet
1 year ago
User 3: A) Yes
RE
Remedios
1 year ago
User 2: B) No
LE
Leslee
1 year ago
User 1: A) Yes
MA
Marti
1 year ago
Yes, this solution looks good to me. Filtering the data in the Power Query Editor is a great way to work with a large dataset without bringing in the entire table.
VE
Verona
1 year ago
Yes, this solution looks good to me. Filtering the data in the Power Query Editor is a great way to work with a large dataset without bringing in the entire table.
OL
Olive
1 year ago
A) Yes
AR
Art
1 year ago
A) Yes, but adding a filter step can help reduce the amount of data being imported.
BR
Breana
2 years ago
B) No, I think importing the entire table would be more efficient.
AR
Art
2 years ago
A) Yes, that sounds like a good approach.
RE
Renay
2 years ago
A) Yes, because filtering the data before importing will reduce the amount of data being loaded into Power BI.
KI
Kimberlie
2 years ago
B) No, because importing the entire table first before filtering would be more efficient.
OL
Olga
2 years ago
A) Yes, because adding a filter step will help in importing a sample of the data.