~/azure-dp-420 · Design and implement data distribution ▊
← Microsoft Certified: Azure Cosmos DB Developer Specialty
AZURE · objective · 8% of the exam
Design and implement data distribution — Microsoft Certified: Azure Cosmos DB Developer Specialty
The official AZURE documentation our Design and implement data distribution practice questions are cited to. Review the primary sources, then practise.
Official references for this objective
-
Microsoft — Reporting Across Scaled-Out Cloud Databases - Azure SQL Database | Microsoft Learn
WITH (TYPE = SHARD_MAP_MANAGER, LOCATION = '<fully_qualified_server_name>'
-
Microsoft — Migration guide from elastic query shard map manager mode - Azure SQL Database | Microsoft Learn
Best for: Workloads where sharding was implemented due to storage limitations that Hyperscale overcomes today.
-
Microsoft — Query Across Cloud Databases with Different Schema - Azure SQL Database | Microsoft Learn
CREATE EXTERNAL DATA SOURCE <data_source_name> WITH (TYPE = RDBMS, LOCATION = '<fully_qualified_server_name>', DATABASE_NAME = '<remote_database_name>', CREDENTIAL = <credential_name> )