From a workbook query, you import a table that has the following data. You need to configure the table to appear as shown in the following table. What should you do?
Yes, you must specify Each concurrence of the limiter and 2 columns. = Table.SplitColumn(#"Changed Type", "City", Splitter.SplitTextByDelimiter(",", QuoteStyle.None), {"City.1"})
.Correct is D.
D will do the trick.
row 1&2: City+Country;
row3&4: City+State,
Obviously we should separate them.
After split, then “trim” becoz there is one space in front of the Canada, Washington and Florida.
“Trim” will eliminate spaces at the beginning & end, but it won’t work on the extra inner spaces.
If just a 2 or 3 inner space, just use the “Repace Value”;
If a lot of random inner extra spaces, pls refer to (from 24 min): https://www.youtube.com/watch?v=aIkul71ydvg
The answer is A.
Do not look at the States that is not showing in the 2 display. They are trying to get rid off all the leading spaces that makes the first display looking like the rows height is increased. So when you Trim the you get rows as "normal" height
D is an incomplete answer, as it will create an additional column, but it is the only one that is close to a solution. Obviously you'd have to delete that new column after splitting. I'll still go with that answer on the exam though.
Trim removes only leading and ending empty spaces, it cannot delete whole words. Ideally it should be "From the Extract Menu click Before Delimiter". Since this option is not listed among the possible answers, the closest we can get is D . So CORRECT ANSWER is D.
This is incorrect. When Splitting the column you can specify the number of columns you want. in this case 1. I've tested it and the correct answer is D
Yes, you must specify Each concurrence of the limiter and 2 columns. = Table.SplitColumn(#"Changed Type", "City", Splitter.SplitTextByDelimiter(",", QuoteStyle.None), {"City.1"})
.Correct is D.
upvoted 1 times
...
...
...
This section is not available anymore. Please use the main Exam Page.70-779 Exam Questions
Log in to ExamTopics
Sign in:
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.
imran
Highly Voted 5 years, 9 months agohfgirona
4 years, 8 months agoHiJaak
Highly Voted 5 years, 9 months agoCDL
Most Recent 4 years, 9 months agoPamzi
4 years, 12 months agoWaltmas
5 years agor8d1
5 years agoOutsider
5 years, 1 month agoChikhalsouk
5 years, 3 months agocs3122
5 years, 6 months agoCABREU
5 years, 6 months agonose
5 years, 5 months agomohroshdy
5 years, 8 months agotho
5 years, 8 months agoMuralianil
5 years, 9 months agodinessa
5 years, 8 months agoMelvin11
5 years, 5 months agodreadreaming
5 years, 2 months agohfgirona
4 years, 8 months ago