exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 17 discussion

Actual exam question from Microsoft's PL-300
Question #: 17
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: You write a DAX expression that uses the FILTER function.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
iccent2
Highly Voted 2 years, 6 months ago
Also, common sense, we are trying to import a sample of the data meaning that the data is not yet on Power BI, so where are we going to filter with DAX? On the SQL server? That is not possible hence the answer B is correct.
upvoted 16 times
...
JukMar
Highly Voted 2 years, 5 months ago
answer is NO, we need to add a WHERE clause to the SQL statement.
upvoted 13 times
...
ee0625a
Most Recent 2 months, 3 weeks ago
Selected Answer: B
The FILTER function in DAX operates after data is already loaded into Power BI. Since the Order table has over 100 million records, using DAX filtering does not reduce the dataset size before import, meaning all data would still be loaded into memory, slowing down performance.
upvoted 1 times
...
rules169
5 months ago
Selected Answer: B
No, this solution does not meet the goal. The FILTER function in DAX is used for filtering data within the context of a DAX expression, usually for creating calculated columns, measures, or tables within a Power BI model. It does not help in importing a subset of data from the SQL Server table into Power BI. To import a sample of the data from a large SQL Server table during the development process, you should use Power Query to apply a filter at the query level. This way, only the filtered subset of data is imported into Power BI, making it more manageable and efficient.
upvoted 1 times
...
rcaliandro
8 months, 2 weeks ago
Selected Answer: B
Again, NO because we have to filter by using a WHERE condition
upvoted 2 times
...
Saluk_DE
1 year, 4 months ago
Selected Answer: B
DAX is applicable in the last step only, so it is not useful for preventing a fully load. answer must be NO
upvoted 4 times
...
rainy_255
1 year, 6 months ago
This was in the exam this week.
upvoted 2 times
...
Igetmyrole
1 year, 7 months ago
The answer is B. Writing a DAX expression using the FILTER function alone does not meet the goal of importing a sample of the data into Power BI. The FILTER function in DAX is used for filtering data within a calculated table or a measure, but it does not control the amount of data imported during the data loading process. To import a sample of the data efficiently, you should use Power Query to apply filters during the data loading process, so only the relevant subset of data is imported.
upvoted 3 times
...
mustafaalhnuty
1 year, 8 months ago
Selected Answer: B
B because You can write dax in power bi desktop so it's already load
upvoted 2 times
...
tke44
1 year, 11 months ago
No, sql statement only can solve it
upvoted 1 times
...
Shalaleh
2 years ago
Selected Answer: B
We cannot write DAX expression at this point! DAX expression is in report part.
upvoted 2 times
...
RazaTheLegend
2 years ago
Selected Answer: B
The correct answer is B. This is because all of the data is first loaded into Power BI before being filtered.
upvoted 3 times
...
srikanth923
2 years, 1 month ago
Selected Answer: B
The correct answer is B. This is because all of the data is first loaded into Power BI before being filtered.
upvoted 2 times
...
yordiye
2 years, 3 months ago
B or No because the Data is already loaded. It is good to select the columns we need at source level .eg create view . Other wise we can bring to power query and filter is before we load it . He query folding will send the query back to the data source
upvoted 1 times
...
samad1234
2 years, 6 months ago
The correct answer is B
upvoted 2 times
...
lukelin08
2 years, 6 months ago
Selected Answer: B
B is correct
upvoted 5 times
...
learnazureportal
2 years, 7 months ago
Answer is Correct.
upvoted 1 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago