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 shoul...
Microsoft AZ-400 Exam
Questions Number: 524 out of 535 Questions
97.94%
Question 524
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?
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
