Test your knowledge
Let's see whether you can answer the following questions correctly:
- Which of the following queries is valid in the Cosmos DB SQL dialect?
SELECT g.* FROM Games g WHERE g.id == '5'
SELECT g.* FROM Games g WHERE g.id = '5'
SELECT * FROM Games g WHERE g.id = '5'
- The
IS_DEFINED
built-in type-checking function does what exactly?- Returns a Boolean indicating whether the property received as an argument has been assigned a value
- Returns the number of times a property has been assigned a value in the array expression received as an argument
- Returns a Boolean indicating whether the property received as an argument has been defined as required for the collection that contains the document
- Which of the following queries retrieves all the levels flattened into a single array?
SELECT * FROM l IN Games.levels
SELECT FLAT * FROM Games.levels
SELECT * FROM Games.levels[0]
- Which of the following queries returns an array with a single value without a key?
SELECT TOP 1 SUM(ARRAY_LENGTH(g.highestScores...