You plan to deploy a new database environment. The solution must meet the technical requirements.
You need to prepare the database for the deployment.
How should you format the export?

A. NDF

B. BACPAC

C. DACPAC

D. MDF








 

Suggested Answer: B

The initial databases for new environments must contain both schema and reference data.
When you need to export a database for archiving or for moving to another platform, you can export the database schema and data to a BACPAC file. A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from the database. A BACPAC file can be stored in Azure Blob storage or in local storage in an on-premises location and later imported back into Azure SQL Database, Azure SQL Managed Instance, or a SQL Server instance.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/database-export

This question is in AZ-400 Exam
For getting Microsoft DevOps Engineer Expert Certificate


Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.