Previous

Next

Knowledge check

Completed

1.

You have 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. You're tasked with authoring a SQL query that will create a cross-product of the document names and tags. Which SQL query should you use?

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

2.

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.

Continue