A company uses Azure SQL Database to store sales transaction data. 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.
You need to create the offline export copy.
Which three options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A . Export to a BACPAC file by using Azure Cloud Shell, and save the file to an Azure storage account
B . Export to a BACPAC file by using SQL Server Management Studio. Save the file to an Azure storage account
C . Export to a BACPAC file by using the Azure portal
D . Export to a BACPAC file by using Azure PowerShell and save the file locally
E . Export to a BACPAC file by using the SqlPackage utility
Answer: B,C,E
Leave a Reply