Plan and implement data platform resources — Microsoft Certified: Azure Database Administrator Associate

The official AZURE documentation our Plan and implement data platform resources practice questions are cited to. Review the primary sources, then practise.

practice 8 questions →

Official references for this objective

Microsoft — Replicate data to Azure SQL Database using Data Export Service - Power Platform | Microsoft Learn

the customer engagement apps and Azure Key Vault services must operate under the same tenant and within the same Microsoft Entra ID
Microsoft — SQL Server to Azure SQL Managed Instance: Migration Guide | Microsoft Learn

The migration of instance-level objects that your application depends on, including logins, credentials, SQL Server Agent jobs and operators, and server-level triggers.
Microsoft — Tutorial: Migrate SQL Server to Azure SQL Database (Offline) - Azure Database Migration Service | Microsoft Learn

For schema migration, minimum permissions on the source SQL Server is db_owner to access the database
Microsoft — Tutorial: Migrate SQL Server to SQL Server on an Azure Virtual Machine with Azure DMS (Offline) - Azure Database Migration Service | Microsoft Learn

copy one of the authentication keys that are provided in the wizard and paste it in Microsoft Integration Runtime Configuration Manager
Microsoft — Tutorial: Migrate SQL Server to SQL Server on an Azure Virtual Machine with Azure DMS (Online) - Azure Database Migration Service | Microsoft Learn

If you're migrating a database protected by transparent data encryption (TDE), migrate the certificate from the source SQL Server instance to SQL Server on an