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 18 discussion

Actual exam question from Microsoft's PL-300
Question #: 18
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 add a WHERE clause to the SQL statement.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by rashjan at Sept. 20, 2022, 8:05 p.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
lukelin08
Highly Voted 2 years, 10 months ago
Selected Answer: A
A is correct
upvoted 19 times
...
kimii1993
Highly Voted 1 year, 9 months ago
Selected Answer: A
This was on the exam today. Passed with 917/1000 - I said: A. Yes
upvoted 9 times
...
jaume
Most Recent 9 months ago
Selected Answer: A
finally, we are filtering the data in the initial step, when connecting data model to the SQL database by using the WHERE clause. This will filter data when connection is set and it will result in a smaller (than the entire table) dataset being imported into our data model My vote here is for solution A
upvoted 2 times
...
Raiist
9 months ago
Selected Answer: A
For me A
upvoted 1 times
...
rcaliandro
12 months ago
Selected Answer: A
A. Yes - In this case we filter from the import the data
upvoted 1 times
...
greenlever
1 year, 3 months ago
B is correct
upvoted 1 times
Seda_
1 year ago
NO. 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 3 times
Seda_
1 year ago
A is correct.
upvoted 1 times
...
...
...
rainy_255
1 year, 10 months ago
This was in the exam this week.
upvoted 4 times
...
Igetmyrole
1 year, 11 months ago
The answer is A. Adding a WHERE clause to the SQL statement used to retrieve data from the Microsoft SQL Serve table named Order can meet the goal of importing a sample of the data into Power BI.
upvoted 1 times
...
tke44
2 years, 2 months ago
A is correct
upvoted 1 times
...
RazaTheLegend
2 years, 4 months ago
Selected Answer: A
The correct answer is A. This means that the data is being filtered at the source database itself, using a SQL query with a WHERE clause.
upvoted 1 times
...
srikanth923
2 years, 5 months ago
Selected Answer: A
The correct answer is A. This means that the data is being filtered at the source database itself, using a SQL query with a WHERE clause.
upvoted 3 times
...
AlexYang_
2 years, 8 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
NuriaIzard
2 years, 8 months ago
As the basis is Microsoft SQL (or OData Feed, for that matter), it is actually possible to achieve the goal without a where clause, since this clause will be added by the Power Query enginge. So I think that indeed, query folding is possible and therefore, the answer should be Yes
upvoted 1 times
...
samad1234
2 years, 10 months ago
Ais the correct Answer
upvoted 2 times
...
rashjan
2 years, 10 months ago
Selected Answer: A
In my opinion the goal can only be met if you for example know the Id of an item and then filter for this. So the goal can be met but it an ugly solution.
upvoted 4 times
yordiye
2 years, 7 months ago
Yes better to use query folding I think. You are talking about indexing the data source right ?
upvoted 1 times
...
lukelin08
2 years, 10 months ago
You are over thinking it. Its asking for a sample of the data in a table with more than 100 million rows. So a simple select statement like the below would return a sample data set of 1000 rows from the Order table. Select TOP (1000) * From [dbo].[Order]
upvoted 3 times
Dovoto
2 years, 10 months ago
But these is no WHERE clause in your statement. It would have been easier if the TOP 1000 was mentioned.
upvoted 1 times
Hoeishetmogelijk
2 years, 8 months ago
In practice you would most probably take a sample of the most recently created rows, using a WHERE clause and filtering on a date column.
upvoted 2 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