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: 
Should be
Select c.Name, c.contacts.givenName, c.contacts.surName from Companies c where c.contacts.regions.regionName = ‘South’
4
0
Agreed with Sandy
https://docs.microsoft.com/en-us/azure/cosmos-db/documentdb-sql-query
0
0
Agreed with Sandy
0
0