You need to determine the results of a query against an Azure Cosmos DB that uses the SQL data model. You execute the following query:
FROM Invoices i
WHERE i.id =1
What should you expect the query to produce?
You should expect JSON-formatted data. SELECT queries against a Cosmos SQL database return data in a JSON format.
You should not expect XML-formatted data. None of the APIs supported by Cosmos DB default to returning data formatted as XML.
You should not expect a table structured as rows and columns. You would expect this result when using the Table API.
You should not expect a syntax error. The SQL API uses standard SQL syntax and the query does not include any syntax errors.