Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 1 question 19 discussion

Actual exam question from Microsoft's DA-100

Question #: 19
Topic #: 1

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

Suggested Answer: A 🗳️

by chaki at Jan. 5, 2021, 8:13 p.m.

Comments

Submit Cancel

chaki

Highly Voted 4 years, 5 months ago

Yes, correct answer

upvoted 77 times

...

priyaraja

Highly Voted 4 years, 2 months ago

tested it , WHERE works , so YES is the correct answer

upvoted 14 times

...

Mad0701

Most Recent 3 years ago

Selected Answer: A

A is correct answer

upvoted 1 times

...

w0mz

3 years, 2 months ago

Selected Answer: A

It's A because the sample data in created within SQL Server by using the WHERE clause and then imported into Power BI

upvoted 1 times

...

PowerBIAddict

3 years, 2 months ago

Selected Answer: A

Where is part of the SQL query so will work as a filter.

upvoted 1 times

...

TechDiva

3 years, 3 months ago

I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.

upvoted 2 times

IsmailGO1996

3 years, 3 months ago

what was your answer in the exam? I will pass the exam on 03/23/2022

upvoted 2 times

...

Ashley090521

3 years, 3 months ago

on exam 3/1/2022

upvoted 1 times

...

kcwood94

3 years, 8 months ago

On exam 10/14/21

upvoted 4 times

Diginomad

3 years, 7 months ago

got this today 25/10

upvoted 2 times

...

ezinap

3 years, 9 months ago

Question, where in Power Bi can you edit SQL statements?

upvoted 3 times

Chinmoy98

3 years ago

If you source supports Query Folding, Right click on Applied Steps--> Native Query

upvoted 1 times

...

mbilal079

3 years, 10 months ago

seems correct

upvoted 3 times

yusufuthman57

3 years, 9 months ago

This is correct! Where Clause Filters the table as required before import.

upvoted 2 times

...

elly

4 years ago

Which is correct A or B? I think adding the WHERE clause to the SQL statement is correct.

upvoted 3 times

...

fhqhfhqh

4 years ago

This question was in the exam.

upvoted 2 times

...

DeathCaliberKnight

4 years, 3 months ago

B is the correct answer

upvoted 4 times

...

gcsilva83

4 years, 3 months ago

B, query folding and view native query. If it was with MySQL, WHERE is the best option, but once the DB is SQL, so you should use power query to filter the query. But only for transformation that exists in PQ and SQL.

upvoted 1 times

mynameistaken

4 years, 2 months ago

I don't think so. First of all, they want to import from Microsoft SQL Server, which is relational database using SQL, "WHERE" is completely fine (given the fact you have your indices). Second, import all data and do filters in Power BI will also cause performance problems if the dataset is too big.

upvoted 9 times

...