Design and implement operational analytics on Azure Cosmos DB
Unlock the complete study guide + 25 practice exams totaling 1,500 questions.
Bundled into the existing Building AI Applications with Azure Cosmos DB premium course — no separate purchase.
14-day refund guarantee on one-time purchases and your first subscription charge.
Included in this chapter:
- Two operational homes and one OneLake copy
- Choosing between a Cosmos DB in Fabric database and mirroring
- Moving an application to Cosmos DB in Fabric
- Autoscale throughput limits in Cosmos DB in Fabric
- Paying for Cosmos DB in Fabric through Fabric capacity
- Requirements that rule out Cosmos DB in Fabric
- Mirroring prerequisites for an Azure Cosmos DB account
- How mirroring replicates a database
- Creating a mirror and choosing what it covers
- Mirroring an account behind network restrictions
- What a mirror costs and who can reach the source
- Securing the OneLake copy of a mirrored database
- Monitoring mirror replication
- Troubleshooting and recovering a mirror
- How JSON items become mirrored columns
- Querying mirrored tables with T-SQL
- Expanding nested JSON with OPENJSON
- Spark over the OneLake copy with a Lakehouse shortcut
- Setting up the Cosmos DB Spark connector in Fabric
- Reading operational data with the connector
- Using the Spark catalog for Spark SQL and containers
- Writing results back with the connector
- Choosing the connector write strategy
- Matching operational analytics requirements to options
Azure Cosmos DB vs Cosmos DB in Fabric for an operational workload
| Requirement | Azure Cosmos DB | Cosmos DB in Fabric |
|---|---|---|
| How usage is billed | Request units (RUs) on the Azure account | Fabric capacity units (CUs), converted from RUs |
| Throughput options | Serverless, manual, or autoscale | Autoscale only |
| Authentication | Microsoft Entra ID or account keys | Microsoft Entra ID only, no account keys |
| SDK connection mode | Direct mode or Gateway mode | Gateway mode only |
| Regions | One or many regions | Single region of the workspace |
| Stored procedures, triggers, UDFs | Supported | Not supported |
| Customer-managed keys | Available | Not available |
| Copy in OneLake | Mirroring you configure (continuous backup required) | Automatic and cannot be disabled |
| Vector, full-text, and hybrid search | Built in | Built in |
Decision tree
Cheat sheet
Unlock with Premium — includes all practice exams and the complete study guide.
Also tested in
References
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db
- https://learn.microsoft.com/en-us/fabric/database/cosmos-db/overview
- https://learn.microsoft.com/en-us/fabric/database/cosmos-db/faq
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db-faq
- https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-overview
- https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts
- https://learn.microsoft.com/en-us/fabric/database/cosmos-db/how-to-use-spark-notebooks
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db-tutorial
- https://learn.microsoft.com/en-us/fabric/database/cosmos-db/limitations
- https://learn.microsoft.com/en-us/fabric/enterprise/licenses
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db-limitations
- https://learn.microsoft.com/en-us/azure/cosmos-db/analytical-store-introduction
- https://learn.microsoft.com/en-us/azure/cosmos-db/synapse-link
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db-troubleshooting
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db-private-network
- https://learn.microsoft.com/en-us/fabric/mirroring/monitor
- https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db-how-to-query-nested
- https://learn.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql
- https://learn.microsoft.com/en-us/fabric/mirroring/azure-cosmos-db-lakehouse-notebooks
- https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/tutorial-spark-connector