Exam DA-100 topic 1 question 15 discussion

Actual exam question from Microsoft's DA-100

Question #: 15
Topic #: 1

You create the following step by using Power Query Editor.
- Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column.
What will the value be when the step is applied?

A. 1318
B. 1319
C. 21318 Lasalle Street
D. 21319 Lasalle Street

Show Suggested Answer

Suggested Answer: D 🗳️

by stokazz at March 11, 2021, 8:20 p.m.

Comments

Submit Cancel

stokazz

Highly Voted 4 years, 3 months ago

correct

upvoted 56 times

...

Flava

Highly Voted 4 years, 3 months ago

Tested. 'D. 21319 Lasalle Street' is correct

upvoted 36 times

...

CUE

Most Recent 2 years, 2 months ago

Answer is C. 1318 is meant to replace 1319, not Lasalle 21318 Street. When the Replacement step is applied, it did not affect 21318 Lesalle Street but 1318 only

upvoted 1 times

...

RichardOgoma

2 years, 9 months ago

Selected Answer: D

let Source = Table.ReplaceValue( Table.FromRecords({ [a = 1, b = "hello"], [a = 3, b = "wurld"] }), "ur", "or", Replacer.ReplaceText, {"b"} ) in Source

upvoted 1 times

...