From Power BI Desktop, you create a query that imports the following table. You need to configure the table to appear as shown in the following table: What should you do?
A.
From the Format menu, click Trim.
B.
From the Extract menu, click Last Characters.
C.
From the Split Column menu, click By Delimiter.
D.
From the Extract menu, click Text After Delimiter.
Is a really tricky question, if you use split columns by delimiter, you will get two columns (one for the city and the other for the country) according to the question, they ask change the same column "City" for the city values. So the correct opcion is D.
D For sure. You need to end with one column. You need to remove the part you are not interested in. The "Text Delimited" option in the Extract Menu (Yes, there is a extract menu) is the right choice.
Thank you very much. I tried it and by the extract option it deletes the cities name, only leaving you with the country names, not recommended but it does meet the goal.
I tried and Slip Columns works. And is there such a thing as "Extract Menu" ?
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.70-778 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.
Rafa
Highly Voted 5 years, 5 months agoCDL
Most Recent 4 years, 6 months agocromastro
4 years, 8 months agoAgustin
4 years, 11 months agomirzotti
5 years, 6 months agoBrunobsv
5 years, 6 months agoBrunobsv
5 years, 7 months ago