70-473 · Question #9
You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?
The correct answer is D. Export a data-tier application (DAC).. To create a comprehensive backup solution for a SQL Server database, exporting a data-tier application (DAC) to a BACPAC file is recommended as it includes both the database schema and its data.
Question
Options
- AExtract a data-tier application (DAC).
- BUse the bcp command.
- CUse the SQL Server Migration Assistant (SSMA).
- DExport a data-tier application (DAC).
How the community answered
(24 responses)- A8% (2)
- B4% (1)
- D88% (21)
Why each option
To create a comprehensive backup solution for a SQL Server database, exporting a data-tier application (DAC) to a BACPAC file is recommended as it includes both the database schema and its data.
Extracting a data-tier application (DAC) creates a DACPAC file, which contains only the database schema and objects but does not include any user data, making it unsuitable as a complete backup solution.
The bcp command is used for bulk copying data in or out of individual tables and is not designed to create a complete backup of an entire SQL Server database, including its schema and all data, in a single operation.
SQL Server Migration Assistant (SSMA) is a tool used for migrating databases from other database platforms to SQL Server or Azure SQL Database, not for performing regular backups of an existing SQL Server database.
Exporting a data-tier application (DAC) creates a BACPAC file, which is a self-contained, compressed file that includes both the full database schema and all the data. This BACPAC file can then be used to restore the database to a new instance or as a complete logical backup for recovery purposes.
Concept tested: SQL Server Database Backup - Data-tier Application Export
Source: https://learn.microsoft.com/sql/relational-databases/data-tier-applications/export-a-data-tier-application
Topics
Community Discussion
No community discussion yet for this question.