Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: A. Yes * Explanation: Adding a WHERE clause to the SQL statement ensures that the filtering happens at the source (SQL Server) before the data is imported into Power BI. This means only the subset of rows that meet the condition will be retrieved, which satisfies the goal of importing a sample of the data during development.
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
For me A