Exam 70-761 topic 1 question 133 discussion

DRAG DROP -
You have a database that contains a table named Users. The table is defined as follows:

You have the following Comma Separated Values (CSV) file:

You need to load data from the CSV file into the Users table while meeting the following requirements:
✑ If a field value is not provided in the file, insert a NULL value for the corresponding column
✑ Load all records into the table with the correct UserId from the file
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-
SQL segments to the answer area and arrange them in the correct order.
Select and Place:

Suggested Answer:
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-2017