Which three Transact-SQL segments should you use to dev…

DRAG DROPContoso has an Azure DocumentDB database that contains contact information for customers.
You have a collection named Companies. The collection includes the following data:

You plan to collect the following information for contacts that are located in the South region only:
Company name
Given name
Surname
You need to create the query.
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:

DRAG DROPContoso has an Azure DocumentDB database that contains contact information for customers.
You have a collection named Companies. The collection includes the following data:

You plan to collect the following information for contacts that are located in the South region only:
Company name
Given name
Surname
You need to create the query.
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:

Answer:



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Sandy

Sandy

Should be
Select c.Name, c.contacts.givenName, c.contacts.surName from Companies c where c.contacts.regions.regionName = ‘South’

Arnie

Arnie

Agreed with Sandy