exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 1 question 21 discussion

Actual exam question from Microsoft's DA-100
Question #: 21
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 modify the source step of the queries to use DataSourceExcel as the file path.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
AzureRookie
Highly Voted 4 years, 4 months ago
yes, correct
upvoted 37 times
mirzotti
3 years, 4 months ago
On exam 21-12-2021. I answered YES
upvoted 1 times
...
...
Tarek007
Highly Voted 4 years, 3 months ago
the answer is yes https://www.youtube.com/watch?v=ppM-mLckQfs&ab_channel=Curbal
upvoted 11 times
jason69
3 years, 9 months ago
True. The video also mentions that editing via the "Advanced Editor" (see question 20) also works, but is more error prone. Both solutions Q20 and Q21 work, but the solution proposed in Q21 is better practice.
upvoted 3 times
user12345678
2 years, 8 months ago
Do you think MS expects 20 to be No though, because this one is yes and "more" correct?
upvoted 1 times
...
...
...
dmnantilla9
Most Recent 3 years ago
Correct Answer is A. YES
upvoted 1 times
...
Ashley090521
3 years, 2 months ago
on exam 3/1/2022
upvoted 1 times
...
Sudhansu21
3 years, 2 months ago
On Exam Feb, 2022
upvoted 1 times
...
Prat12
3 years, 3 months ago
Correct
upvoted 2 times
...
Marski
3 years, 4 months ago
MS Docs reference should be the #1 reference displayed. Thank you.
upvoted 1 times
...
PatrickStr
3 years, 4 months ago
on exam 12/10/2021
upvoted 2 times
...
asia2301
3 years, 5 months ago
Yes.13-11-21
upvoted 2 times
...
bunilggg
3 years, 9 months ago
what does the "you replace references to the Excel file with DataSourceExcel" mean?
upvoted 3 times
Knoushore1
3 years, 8 months ago
Its parameter name--DataSourceExcel
upvoted 1 times
...
...
test_member
4 years ago
it's true
upvoted 5 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago