Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 32 discussion

Actual exam question from Microsoft's 70-779

Question #: 32
Topic #: 1

DRAG DROP -
You use a workbook query to import a table named Customers that contains a column named CustomerName. CustomerName has names in the format of
Lastname, Firstname.
You need the CustomerName column to contain names in the format of Firstname Lastname. A space must separate Firstname and Lastname.
Which two commands should you use? To answer, drag the appropriate fields to the correct areas. Each field may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

by Samewiss at Oct. 22, 2019, 9:44 a.m.

Comments

Submit Cancel

mohroshdy

Highly Voted 5 years, 7 months ago

The correct answer is 1- "Split Column by Delimter" 2- "Merge Columns"

upvoted 42 times

cs3122

5 years, 5 months ago

I agree with this answer as well.

upvoted 2 times

...

hfgirona

4 years, 8 months ago

It´s ok but when you select the 2 columns to merge, first select Firstname and second SecondName and then merge.

upvoted 1 times

...

FrdFrd

4 years, 5 months ago

Definitely correct. Tips to replicate yourself if you want to be sure: 1st: When splitting the column by delimiter, enter a two-char custom delimiter of comma followed by space. This way you will get rid of the space before FirstName. 2nd: prior to clicking on "merge columns" select the FirstName column and then LastName column (hold the ctrl key while clicking column headers). 3rd: on "Merge Column" dialog, select the space separator so that the required space is added between first and last names.

upvoted 1 times

...

mikecraig

Most Recent 4 years, 8 months ago

It's 100% Split by Delimiter then Merge Columns. 1st step is Split by Delimiter - in the step options you can account for the ", " using custom delimiter ", " and split at the right-most delimiter - check you're splitting into 2 columns (your two expected name components). 2nd step, Merge Columns, merge and as an option include the space when combining columns (don't forget to select First Name then Last Name before using the Merge Columns action).

upvoted 4 times

Robc79

4 years, 7 months ago

tested this also, Mikecraig is correct

upvoted 1 times

...

CDL

4 years, 8 months ago

Tested, go with HiJaak, 1. split column by delimiter (comma); 2. change the order of the columns (L+F --> F+L) 3. Merge the columns (F+L --> F(space)L). 4. load to table.

upvoted 2 times

...

Sober

4 years, 9 months ago

I don't have the command "Merge columns", only Concatenate. I will go with Split and Move to beginning

upvoted 1 times

...

hroumani

4 years, 10 months ago

The correct answer is 1- "Split Column by Delimter" 2- "Merge Columns" Once you split the columns, the comma isn't there anymore, then you merge both columns and change the order

upvoted 3 times

yassine70

4 years, 6 months ago

Tested it and that's the correct ansewer

upvoted 1 times

...

Agustin

4 years, 12 months ago

I Tested this by myself. As many have said, the correct answers are: 1. Split column by delimiter 2. Merge columns (of couse, selecting first Firstname column and then Lastname)

upvoted 4 times

...

Faresbb007

5 years, 2 months ago

First of all, we have to remove the comma, so we can use "replace values" to remove the comma, then "split by Delimiter" and finally "Append columns". The answer given is right

upvoted 1 times

SPG

5 years, 2 months ago

No need to remove the comma, you split by Delimiter and use comma as delimiter. 1. Split column by delimiter 2. Merge columns, selecting first Firstname column and then Lastname

upvoted 4 times

...

Agustin

4 years, 12 months ago

There is no "Append Column" options

upvoted 1 times

...

Mar_tin

5 years, 2 months ago

The confusion continues. I agree to HiJaak.

upvoted 1 times

...

Samewiss

5 years, 8 months ago

This cant be correct. Lastname, Firstname needs to become Firstname Lastname, so you need to change the order

upvoted 3 times

HiJaak

5 years, 8 months ago

You are right. To obtain the requested form the steps should be: 1. Split by Delimiter, 2, Change the order of the columns, 3. Merge the columns. There are only the first two steps that should be mentioned. Unfotunately I don't know if "reordering columns" could be the "move to beginning"... Also it could be Replace Value then Spli, even the "replace" as first step is not necesary - in this case would be 4 steps to complete the solution and usually Microsoft is looking for "less effort".

upvoted 4 times

imran

5 years, 8 months ago

one split by comma then you can select the 2nd column first then select first column then click column merge no need for move to beginning.......

upvoted 14 times

HiJaak

5 years, 8 months ago

Correct, so the answer should be: 1. Split by delimiter, 2. Merge columns

upvoted 22 times

ammu

5 years, 7 months ago

Yes I agree answer is Split by delimiter and then Merge Columns. Merger Columns will by default push the 2nd column as left most value. So first name will by default be at first.

upvoted 6 times

...