Microsoft Certified: Azure Database Administrator Associate

0/8 checked

Q_01 domain/d1 · medium single discuss →

A DBA is planning a lift-and-shift migration of an entire on-premises SQL Server instance to Azure SQL Managed Instance. The applications heavily use cross-database queries and instance-level features. Which planning consideration is NOT required because the platform provides it built-in?

A Migrating all databases that need to be collocated on the same instance
B Migrating Always On configuration for high availability
C Migrating logins, credentials, and SQL Server Agent jobs
D Migrating server-level triggers the application depends on

Q_02 domain/d1 · medium single discuss →

A DBA plans to migrate a SQL Server 2019 database to Azure SQL Managed Instance using native backup and restore. What is the correct method for placing the backup into Azure Storage and restoring it to the managed instance for this source version?

A Direct backup using WITH SAS CREDENTIAL, then RESTORE FROM URL with SAS CREDENTIAL
B Direct backup using the deprecated WITH CREDENTIAL syntax, then RESTORE FROM URL
C Upload the .bak file directly to Azure Storage, then RESTORE FROM DISK
D Use the Managed Instance link to replicate the backup, then fail over