Administering a SQL Database Infrastructure — Question 53

You need to recommend a solution to meet the recovery requirements for the manufacturing database.
Your solution must minimize costs.
What should you recommend?

Answer options

• A. Database snapshots
• B. Transaction log backups
• C. Differential backups
• D. SQL Server Failover Clustering
• E. Peer-to-peer replication

Correct answer: A

Explanation

Database snapshots provide a cost-effective way to capture the state of the database at a specific point in time without the need for extensive storage resources. Transaction log backups and differential backups are also valid recovery methods but may require more management and storage, while SQL Server Failover Clustering and peer-to-peer replication are more complex and costly solutions that do not align with the requirement to minimize costs.