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?
DACPAC is primarily focused on database schema deployment and management, while BACPAC includes both the schema and data of a database, making it suitable for data migration and backups. DACPACs are used for controlled schema deployments, while BACPACs are used for transferring entire databases across environments.
BACPAC is correct:
A Dacpac is used to deploy different versions of the database in a life cycle of a database. On the other hand, the Bacpac is used just to import and export data
A DacPac (Data-tier Application Package) is a single file that contains the logical database schema and possibly the database's static data. It doesn't contain the actual user data from the database.
A BacPac (BACPAC) is a single file that contains the database schema, plus the data contained in the database. It's essentially a database backup in a single file.
Requirement is: "The initial databases for new environments must contain both schema and reference data."
the main question is what is reference data? Azure docs says: Reference data is a finite dataset that's static or slowly changing in nature. It's used to perform a lookup or to augment your data streams. Reference data is also known as a lookup table.
https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data
Therefore, I would say answer is DACPAC because we are only interested in schema and some database's static data.
A database deployment must contain schema, but not reference data. Reference data can be added later on in multiple ways, or it might not be added at all, so for most cases a DACPAC will be enough. In this case however, it is specified in the technical requirements that we need schema + reference data, meaning we need a BACPAC (schema + ref data)
There is a Azure pipeline deployment task SqlAzureDacpacDeployment@1 for DACPAC's according to https://learn.microsoft.com/en-us/azure/devops/pipelines/tasks/reference/sql-azure-dacpac-deployment-v1?view=azure-pipelines&viewFallbackFrom=azure-devops
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.
A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from a SQL Server database. It is primarily used to move a database from one server to another, migrate a database from a local server to the cloud, or archive an existing database in an open format ¹.
However, according to the technical requirements stated on the web page context, the initial databases for new environments must contain both schema and reference data. A DACPAC (Data-tier Application Package) is a package that contains the schema and supporting objects for a SQL Server database and can be used to deploy schema and reference data to a new environment. Therefore, based on the technical requirements provided on the web page context, DACPAC would still be the better choice for preparing the database for deployment.
From the qns
"The initial databases for new environments must contain both schema and reference data"
Given answer is correct and supported by provided link and explanation
upvoted 3 times
...
This section is not available anymore. Please use the main Exam Page.AZ-400 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
alexax578
Highly Voted 2 years, 3 months agoShomaV
Highly Voted 1 year, 6 months agovsvaid
Most Recent 11 months, 2 weeks agoFirdous586
1 year agoFirdous586
1 year agomrme0076
1 year, 1 month agoxRiot007
1 year, 4 months agot_j_nl
1 year, 7 months agoFal991l
1 year, 7 months agoFal991l
1 year, 7 months agoFal991l
1 year, 7 months agosyu31svc
2 years, 3 months ago