Microsoft Exam Questions

Which five Transact-SQL segments should you use to deve…

DRAG DROP
You are creating a stored procedure which will insert data into the table shown in the Database schema exhibit.
(Click the exhibit button.)

You need to insert a new customer record into the tables as a single unit of work.
Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments to the answer area and arrange the, in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders
you select.
Select and Place:

Answer:

Explanation:
The entities on the many side, of the 1-many relations, must be added before we add the entities on the 1-side.We must insert new rows into BusinessEntityContact and BusinessEntityAddress tables, before we insert the
corresponding rows into the BusinessEntity and AddressType tables.