Knowledge check

Completed

1.

You have an Azure Cosmos DB for NoSQL account and an Azure Synapse Analytics workspace. What must you do first to enable HTAP integration with Azure Synapse Analytics?

Configure global replication in Azure Cosmos DB.

Create a dedicated SQL pool in Azure Synapse Analytics.

Enable Azure Synapse Link in Azure Cosmos DB.

2.

You have an existing container in a Cosmos DB core (SQL) database. What must you do to enable analytical queries over Azure Synapse Link from Azure Synapse Analytics?

Delete and recreate the container.

Enable Azure Synapse Link in the container to create an analytical store.

Add an item to the container.

3.

You plan to use a Spark pool in Azure Synapse Analytics to query an existing analytical store in Azure Cosmos DB. What must you do?

Create a linked service for the Azure Cosmos DB database where the analytical store enabled container is defined.

Disable automatic pausing for the Spark pool in Azure Synapse Analytics.

Install the Azure Cosmos DB SDK for Python package in the Spark pool.

4.

You're writing PySpark code to load data from an Azure Cosmos DB analytical store into a dataframe. What format should you specify?

cosmos.json

cosmos.olap

cosmos.sql

5.

You're writing a SQL code in a serverless SQL pool to query an analytical store in Azure Cosmos DB. What function should you use?

OPENDATASET

ROW

OPENROWSET

You must answer all questions before checking your work.