Which three actions should you perform in sequence?

DRAG DROP

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.

The environments that you manage are shown in the following table.

You need to implement a process for importing data into WingDB.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

Step 1: Perform a full backup of the database and enable the bulk-logged recovery model.

Not: Simple recovery model. With the Simple recovery model we cannot minimize data loss.

Step 2: Import the data

Step 3: Backup the tail of the transaction log. For databases that use full and bulk-logged recovery, database backups are necessary but not sufficient. Transaction log backups are also required.

Note: Three recovery models exist: simple, full, and bulk-logged. Typically, a database uses the full recovery model or simple recovery model. A database can be switched to another recovery model at any time.

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models­sql-server