Synapse Spark and SQL Queries Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Analytical Workloads

Synapse Spark and SQL Queries Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which feature enables near real-time analytics on Azure Cosmos DB data without impacting the performance of your transactional workloads?

  2. 2

    When using Azure Synapse Link, how do you query data from the Cosmos DB analytical store using Spark?

  3. 3

    You need to perform a cross-container join in Azure Synapse using Serverless SQL pools. What is the correct approach?

  4. 4

    What is the primary benefit of using the analytical store over the transactional store for heavy aggregation queries?

  5. 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?