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: 
As it was told by Sandy in v4 (http://www.briefmenow.org/microsoft/which-three-transact-sql-segments-should-you-use-to-dev/) first should be Select c.Name, c.contacts.givenName, c.contacts.surName
0
0
Besides, part of the new 254Q 70-532 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfmZSUFFPa0F4WENQMGl3SjhPSkpaTWlzakMwRzF6d2ctUWRTa1V4TTU1c0E
Best Regards!
1
0
Select c.Name, c.contacts.givenName, c.contacts.surName from Companies c where c.contacts.regions.regionName = ‘South’
2
0