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.
Click on the arrows to vote for the correct answer
A. B. C. D. E.BCE
You can export to a BACPAC file using the Azure portal.
You can export to a BACPAC file using SQL Server Management Studio (SSMS). The newest versions of SQL Server Management Studio provide a wizard to export an Azure SQL database to a BACPAC file.
You can export to a BACPAC file using the SQLPackage utility.
Incorrect Answers:
D: You can export to a BACPAC file using PowerShell. Use the New-AzSqlDatabaseExport cmdlet to submit an export database request to the Azure SQL
Database service. Depending on the size of your database, the export operation may take some time to complete. However, the file is not stored locally.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-exportTo create an offline export copy of an Azure SQL Database that includes last year's sales, you can use the BACPAC export method. BACPAC is a file format that contains both the schema and the data from the SQL database.
There are different ways to export an Azure SQL Database to a BACPAC file, and some of them are listed as options in the exam question. Let's go through each option and see if it provides a complete solution.
Option A: Export to a BACPAC file by using Azure Cloud Shell, and save the file to an Azure storage account This option involves using Azure Cloud Shell, which is a browser-based command-line interface that provides access to Azure resources. You can use the SqlPackage utility in the Cloud Shell to export the SQL database to a BACPAC file and save it to an Azure storage account. This option provides a complete solution as it covers both the export process and the storage of the BACPAC file.
Option B: Export to a BACPAC file by using SQL Server Management Studio. Save the file to an Azure storage account SQL Server Management Studio (SSMS) is a graphical user interface that you can use to manage SQL databases. You can use the Export Data-tier Application wizard in SSMS to export the SQL database to a BACPAC file and save it to an Azure storage account. This option provides a complete solution as it covers both the export process and the storage of the BACPAC file.
Option C: Export to a BACPAC file by using the Azure portal The Azure portal is a web-based interface that you can use to manage Azure resources. You can use the Export function in the SQL database resource in the Azure portal to export the database to a BACPAC file. However, this option does not provide a complete solution as it does not cover the storage of the BACPAC file. You would need to manually download the file and save it to an Azure storage account.
Option D: Export to a BACPAC file by using Azure PowerShell and save the file locally Azure PowerShell is a command-line interface that you can use to manage Azure resources. You can use the Export-AzSqlDatabase cmdlet in PowerShell to export the SQL database to a BACPAC file and save it locally. However, this option does not provide a complete solution as it does not cover the storage of the BACPAC file. You would need to manually upload the file to an Azure storage account.
Option E: Export to a BACPAC file by using the SqlPackage utility The SqlPackage utility is a command-line tool that you can use to export SQL databases to BACPAC files. You can run the SqlPackage command to export the SQL database to a BACPAC file and save it locally or upload it to an Azure storage account. This option does not provide a complete solution as it does not cover the storage of the BACPAC file.
Based on the above analysis, the three options that provide a complete solution are:
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