Exam-Answer

Home / Microsoft / AZ-300 / Question 106

Prev Question
Next Question

Question 106

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:

SELECT *

FROM Invoices i

WHERE i.id =1

What should you expect the query to produce?

Answers


Advertisement

Explanation

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.

References

Comments

Load more
Prev Question
Next Question