Exam DP-300 topic 7 question 3 discussion

1.URL : SQLMI is paas on cloud, so backup must stored on blob storage 2.COPY_ONLY: SQLMI has "managed" everything, includes backup chain, so user can not break it's chain by using different method than COPY_ONLY.

Option 2 is wrong because in Azure SQL PaaS you don't have any access to any disk or the operating system at all

Shown answer is correct 1) Backup to blob (https:url.....) 2) copy_only because it's a SQL managed instance. NOT SQL PAAS

TO URL = ‘https://storage1.blob.core.windows.net/blob1/Sales.bak’ COPY_ONLY

The given answer is correct Box 1: TO URL = 'https://storage1.blob.core.windows.net/blob1/Sales.bak' Box 2: COPY_ONLY https://techcommunity.microsoft.com/t5/azure-database-support-blog/automate-native-database-backup-of-azure-sql-managed-instance-to/ba-p/3067092

The provided answer is correct. A good explanation about why COPY_ONLY is necessary: https://dba.stackexchange.com/questions/45876/difference-between-full-backup-and-copy-only-full-backup

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server SQL Managed Instance has automatic backups, so users can create full database COPY_ONLY backups. Differential, log, and file snapshot backups aren't supported. With a SQL Managed Instance, you can back up an instance database only to an Azure Blob storage account: Only BACKUP TO URL is supported. FILE, TAPE, and backup devices aren't supported. Most of the general WITH options are supported. COPY_ONLY is mandatory. FILE_SNAPSHOT isn't supported. Tape options: REWIND, NOREWIND, UNLOAD, and NOUNLOAD aren't supported. Log-specific options: NORECOVERY, STANDBY, and NO_TRUNCATE aren't supported.

The only mandatory property is COPY_ONLY. Azure SQL Managed Instance owns the backup chain. This means that you cannot perform database backup that breaks the backup chain. Azure SQL Managed Instance allows you to perform only COPY_ONLY backups.

https://techcommunity.microsoft.com/t5/azure-sql-database/native-database-backup-in-azure-sql-managed-instance/ba-p/386154 Managed Instance will support native BACKUP like SQL Server. In the beginning, only backup to URL/Azure Blob Storage will be supported. In this post you will see how to backup database to Azure Blob Storage using Managed Instance.

https://argonsys.com/microsoft-cloud/library/native-database-backup-in-azure-sql-managed-instance/#:~:text=The%20only%20mandatory%20property%20is,to%20perform%20only%20COPY_ONLY%20backups.

why option 2 is wrong> to disk = X:\