Synapse Spark and SQL Queries Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Analytical Workloads

What you'll be asked

  1. Which feature enables near real-time analytics on Azure Cosmos DB data without impacting the performance of your transactional workloads?
  2. When using Azure Synapse Link, how do you query data from the Cosmos DB analytical store using Spark?
  3. You need to perform a cross-container join in Azure Synapse using Serverless SQL pools. What is the correct approach?
  4. What is the primary benefit of using the analytical store over the transactional store for heavy aggregation queries?
  5. You have a Cosmos DB container with a large amount of nested JSON data. You are using Synapse Spark to query it. Why might your query performance be suboptimal when using the default schema inference?

Answers and explanations come after you submit.