nerdexam
Microsoft

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.

Implement business continuity

Question

You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?

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)
  • A
    8% (2)
  • B
    4% (1)
  • D
    88% (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.

AExtract a data-tier application (DAC).

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.

BUse the bcp command.

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.

CUse the SQL Server Migration Assistant (SSMA).

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.

DExport a data-tier application (DAC).Correct

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

#Database backup#Data-tier application (DAC)#Azure SQL Database

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice