Q57 — AWS SAP-C02 Ch.2

Question 57 of 75 | ← Chapter 2

Q207. 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?

Correct Answer: 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.

Explanation

Option B suggests creating an Amazon FSx for Windows File Server Single-AZ file system within the VPC and writing nightly database exports to an SMB file share on it, but it may incur additional costs for storage and backups compared to using an S3 bucket. Option C suggests creating an Amazon FSx for Windows File Server Multi-AZ system and writing nightly database exports to an SMB file share on it, but it may not be necessary to have such a high level of availability for this use case, which would add to the overall cost. Option D suggests deploying an AWS Storage Gateway volume gateway within the VPC and writing nightly database exports to an SMB file share on it, but it would require additional setup and management compared to using a file gateway with an S3 bucket. Therefore, option A provides the most cost-effective solution as it involves creating a new S3 bucket and deploying an AWS Storage Gateway file gateway within the VPC that is connected to the Direct Connect connection. The company can then create a new SMB file share and write nightly database exports to it. This approach eliminates the need for managing additional hardware (such as an FSx server or a storage gateway volume) and reduces costs by leveraging S3's scalability and durability.