Exam DP-200 topic 2 question 17 discussion

Shouldn't the solution be C, D and E ? All tools are valid way to create the BACPAC file, but A and B store it online to Azure Storage, so it cannot be accessed offline

Correct Answer : B , C and E

its B,D,E - according to Whizlabs

Azure SQL Managed Instance does not currently support exporting a database to a BACPAC file using Azure PowerShell. To export a managed instance into a BACPAC file, use SQL Server Management Studio or SQLPackage.

C,D,E because A,B are save data to Azure storage account

Correct answer is B, C, E. I came to this conclusion by eliminating incorrect ones. There are 4 ways to export an SQL Database to a BACPAC file: 1. Export using Azure Portal -> only to Storage Account 2. Export using SQLPackage command-line utility -> to local destination 3. Export using SQL Server Management Studio -> to local or to Storage Account 4. Export using PowerShell -> only to Storage Account So, answer A is incorrect because you cannot export a BACPAC file by using Cloud Shell. Answer D is incorrect because you cannot save a BACPAC file locally using PowerShell, but only to Storage account. Another thing to note is that I think it is assumed that people will download BACPAC file from Azure Storage Account right after it is saved there and have them locally when the Internet breaks.

answer should be C, D & E. moreover Option A & B are itself saying to save the file to Azure Storage Account and getting the file from Azure Storage Account is practically impossible with internet connection.

"Field sales employees need an offline copy of the database that includes last yearג€™s sales on their laptops when there is no internet connection available." -> The BACPAC file contains only metadata, no data. How is it possible to include the last year sales?

CDE are the appropriate answers

CDE: https://www.sqlshack.com/how-to-perform-azure-sql-database-import-export-operations-using-powershell/

It should be C,D,E

the key is here "on their laptops when there is no internet connection available" If you don't have an internet connection, how do you access a blob storage? I think C, D and E

B, D, E. Azure Portal cannot be an option. please see link below. https://docs.microsoft.com/en-us/azure/azure-sql/database/database-export

I expect the issue with the PowerShell option is that while it can be used to export the BACPAC it is not exported to local storage. From the wording of that choice it seems to imply it is a direct export to local storage which is not possible.

Option B , D & E , since even though you can create a backup using the Azure Portal, the backup won’t be available locally. Export to a BACPAC file by using SQL Server Management Studio. Save the file to an Azure storage account Export to a BACPAC file by using Azure PowerShell and save the file locally Export to a BACPAC file by using the SqlPackage utility

I would go for BCE as the link provided supports it

As far as I have searched - Export to a BACPAC file by using Azure Cloud Shell is not possible - Cannot save the BACPAC file locally via a straight forward Azure powershell command So, the answers given are correct in the sense that they can produce a BACPAC file for consumption.