ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 17 - VMCE_V12 discussion

Report
Export

An engineer wants to make sure that a single SQL Database can be recovered in a consistent manner with an RPO that will offer the least impact on the production environment during production hours. Granular restores should be performed with the Veeam console as the company does not have a DBA and is not using SQL Management Studio (SSMS).

The engineer took the following steps:

* Created a separate job for the MS SQL VMs

* At guest processing, enabled application-aware processing and provide the credentials with sufficient permissions

* Schedule the job to run every 24 hours

Which other change can the engineer make for this job to achieve the proposed goals?

A.
Schedule transaction log processing every 30 minutes
Answers
A.
Schedule transaction log processing every 30 minutes
B.
Remove the VM and add only the SQL Databases in the job
Answers
B.
Remove the VM and add only the SQL Databases in the job
C.
Set the backup job to perform recovery using Veeam Explorer for SQL
Answers
C.
Set the backup job to perform recovery using Veeam Explorer for SQL
D.
Schedule the job to run every 30 minutes
Answers
D.
Schedule the job to run every 30 minutes
Suggested answer: A

Explanation:

To achieve the goal of recovering a single SQL Database in a consistent manner with minimal impact on the production environment during production hours, while allowing for granular restores through the Veeam console, the engineer should A: Schedule transaction log processing every 30 minutes. By enabling application-aware processing for the SQL VM and scheduling the main backup job to run every 24 hours, the base image of the SQL database is protected. However, to achieve a more granular Recovery Point Objective (RPO) and ensure the ability to restore to specific points in time, transaction log backups must be performed more frequently. Configuring the backup job to process transaction logs every 30 minutes captures the SQL database changes more frequently without the overhead of a full backup, allowing for point-in-time restores directly from the Veeam console without the need for SQL Management Studio (SSMS) or a Database Administrator (DBA). This setup aligns with the goals of maintaining operational efficiency and minimizing the impact on production while ensuring robust data protection capabilities.

asked 23/09/2024
Sai Janani Ravishankar
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first