Microsoft Power BI Data Analyst — Question 104
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?
Answer options
- A. Yes
- B. No
Correct answer: A
Explanation
Adding a WHERE clause to the SQL statement is an effective way to filter data, allowing you to import only the relevant subset from the Order table. This approach helps manage performance and reduces the amount of data processed, while the option 'No' is incorrect because it implies that filtering data wouldn't achieve the goal.