Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam DA-100 topic 1 question 22 discussion

Actual exam question from Microsoft's DA-100
Question #: 22
Topic #: 1
[All DA-100 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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Kentsegee
Highly Voted 3 years, 2 months ago
The question says "you need to update the query" so creating a new query is not correct. The answer is NO
upvoted 52 times
mirzotti
2 years, 4 months ago
On exam 21-12-2021. I answered NO
upvoted 3 times
...
...
MachineGunSquirrel
Highly Voted 2 years, 11 months ago
"You need to update the query..." "Solution: You create a new query..." *facepalm* Didn't know reading comprehension was going to be on my PowerBI test.
upvoted 32 times
...
w0mz
Most Recent 2 years ago
Selected Answer: B
It's B because the question requires us to update the existing query and not create a new one
upvoted 1 times
...
Ashley090521
2 years, 1 month ago
on exam 3/1/2022
upvoted 1 times
...
Sudhansu21
2 years, 1 month ago
On Exam Feb, 2022
upvoted 1 times
...
altAzhar17
2 years, 2 months ago
Selected Answer: B
I think the answer is NO
upvoted 3 times
...
Prat12
2 years, 2 months ago
Since working on the same query, Managing Parameters will not work.
upvoted 1 times
...
PatrickStr
2 years, 4 months ago
on exam 12/10/2021
upvoted 2 times
...
asia2301
2 years, 5 months ago
No. 13-11-21
upvoted 2 times
...
MinhNT
2 years, 9 months ago
NO. Because the question already mentioned "need to update the query"
upvoted 1 times
...
elly
3 years ago
The answer is NO.
upvoted 2 times
...
jerryl
3 years, 3 months ago
can anyone further explain the answer? i dont know what's different in the answers between this and the previous question, thanks (as i think this answer is just a very high level way of describing the solution which looks similar to the previous answer)
upvoted 3 times
mynameistaken
3 years ago
I think it's because the previous solution was: "update the source" instead of the current solution - "create a new query". If you already has a path to load your data, you will have to modify the source path to the new parameter created and not create a new query.
upvoted 7 times
...
...
Tiago10
3 years, 3 months ago
correct answer!
upvoted 3 times
...
chaki
3 years, 3 months ago
correct answer?
upvoted 1 times
...
Jem12124321423
3 years, 3 months ago
Does this answer assume you dont delete the old one or am i dumb?
upvoted 2 times
fe
3 years, 3 months ago
"You need to update the query..."
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 ...