This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The database has a container of products with JSON documents that contain a string property named name. The JSON documents also all contain a property named tags that's an array of string values. The team is tasked with authoring a SQL query that creates a cross-product of the document names and tags. Which SQL query should be used?
SELECT p.name, t.tags[0] FROM products p
SELECT p.name, t.tags FROM products p
SELECT p.name, t FROM products p JOIN t IN p.tags
Which method of the Microsoft.Azure.Cosmos.Container class takes in a SQL query as a string parameter and returns an iterator that can be used to iterate over the query results as deserialized C# objects?
GetItemQueryStreamIterator<>
GetItemQueryIterator<>
GetItemLinqQueryable<>
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?