Exam DP203 Hybrid Transactional Analytical

From MillerSql.com
Revision as of 20:16, 20 November 2024 by NeilM (talk | contribs)

Hybrid Transactional / Analytical Processing (HTAP). This is where Azure Synapse Link replicates transactional data into an analysis data store.

From CosmosDB: Azure Synapse Link for CosmosDB

For Azure SQL Database or a SQL Server instance: Azure Synapse Link for SQL (to a dedicated pool, and a spark pool can connect to that dedicated pool).

Azure Synapse Link for Dataverse. Where Dataverse (the Power Platform database) is the OLTP database. Note that here the data goes into Gen2, not a dedicated pool for some reason.

CosmosDB

First need to Enable Azure Synapse Link in CosmosDB in the Portal.

Alternatively this can be done in the Azure CLI by running:

Retrieved from ‘https://wiki.millersql.com/wiki/index.php?title=Exam_DP203_Hybrid_Transactional_Analytical&oldid=1272’