Learn how to efficiently move on-premises SQL Server database backups to robust cloud storage on Amazon S3 using Amazon FSx for Windows File Server. Enable nightly backups with automatic scheduling for a secure and cost-effective solution.
Table of Contents
Question
A company has an on-premises Microsoft SQL Server database that writes a nightly 200 GB export to a local drive. The company wants to move the backups to more robust cloud storage on Amazon S3. The company has set up a 10 Gbps AWS Direct Connect connection between the on-premises data center and AWS.
Which solution meets these requirements MOST cost-effectively?
A. Create a new S3 bucket. Deploy an AWS Storage Gateway file gateway within the VPC that is connected to the Direct Connect connection. Create a new SMB file share. Write nightly database exports to the new SMB file share.
B. Create an Amazon FSx for Windows File Server Single-AZ file system within the VPC that is connected to the Direct Connect connection. Create a new SMB file share. Write nightly database exports to an SMB file share on the Amazon FSx file system. Enable nightly backups.
C. Create an Amazon FSx for Windows File Server Multi-AZ file system within the VPC that is connected to the Direct Connect connection. Create a new SMB file share. Write nightly database exports to an SMB file share on the Amazon FSx file system. Enable nightly backups.
D. Create a new S3 bucket. Deploy an AWS Storage Gateway volume gateway within the VPC that is connected to the Direct Connect connection. Create a new SMB file share. Write nightly database exports to the new SMB file share on the volume gateway, and automate copies of this data to an S3 bucket.
Answer
B. Create an Amazon FSx for Windows File Server Single-AZ file system within the VPC that is connected to the Direct Connect connection. Create a new SMB file share. Write nightly database exports to an SMB file share on the Amazon FSx file system. Enable nightly backups.
Explanation
To meet the requirements of moving the nightly 200 GB export from an on-premises Microsoft SQL Server database to more robust cloud storage on Amazon S3 in a cost-effective manner, you should choose option B: Create an Amazon FSx for Windows File Server Single-AZ file system within the VPC connected to the Direct Connect connection.
Here’s why this option is the correct choice:
- Amazon FSx for Windows File Server: Amazon FSx provides fully managed file storage that is compatible with Windows applications. By creating an Amazon FSx file system, you can have a highly available and scalable storage solution for your database backups.
- Single-AZ file system: Choosing a Single-AZ file system ensures cost-effectiveness while still providing the necessary level of redundancy. It will be sufficient for meeting the backup requirements without incurring the additional cost of a Multi-AZ deployment.
- SMB file share: Create an SMB file share within the Amazon FSx file system. This allows you to write the nightly database exports directly to the file share, leveraging the familiar SMB protocol.
- Enable nightly backups: Amazon FSx allows you to enable automatic backups, which can be scheduled on a nightly basis. This ensures that your database exports are regularly backed up without manual intervention.
By implementing Amazon FSx for Windows File Server with a Single-AZ file system, creating an SMB file share, and enabling nightly backups, you can securely and cost-effectively store your nightly database exports on robust cloud storage in Amazon S3.
Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Professional SAP-C02 exam and earn Amazon AWS Certified Solutions Architect – Professional SAP-C02 certification.