You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?
Click on the arrows to vote for the correct answer
A. B. C. D.C
https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-linkTo perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics, you should use Synapse Link.
Synapse Link is a cloud-native hybrid transactional and analytical processing (HTAP) capability that allows you to run near real-time analytics over operational data in Azure Cosmos DB without the need to extract, transform, and load (ETL) the data into a separate analytics store.
With Synapse Link, you can directly query your Azure Cosmos DB containers using serverless SQL pool in Azure Synapse Analytics. This enables you to analyze and gain insights from your operational data in near real-time, without impacting the performance of your production workload.
Synapse pipelines are used for ETL processes, which involve extracting data from different sources, transforming it into a specific format, and then loading it into a target system. Therefore, Synapse pipelines are not the correct solution for performing HTAP queries against Azure Cosmos DB data sources.
A Synapse SQL pool is a data warehouse service that allows you to run high-performance analytics on large amounts of data. While it is suitable for analytical queries, it does not provide the capability to perform HTAP queries against Azure Cosmos DB data sources.
Synapse Studio is an integrated development environment (IDE) that allows you to build, manage, and monitor your Synapse workspace resources. While it provides a set of tools for working with data, it does not provide the capability to perform HTAP queries against Azure Cosmos DB data sources.