exam questions

Exam AWS Certified Solutions Architect - Professional SAP-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional SAP-C02 exam

Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 231 discussion

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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
SkyZeroZx
Highly Voted 1 year, 3 months ago
Selected Answer: A
File Gateway == SMB , NFS Volumes Gateway == iSCSI Tape Gateway = VTL
upvoted 32 times
...
SIJUTHOMASP
Most Recent 3 months, 3 weeks ago
Selected Answer: A
Guys, options B and C are exactly same. :)
upvoted 1 times
...
duriselvan
10 months, 2 weeks ago
Ans D he most cost-effective solution for moving the backups to S3 is D. Deploy an AWS Storage Gateway volume gateway, create an SMB file share, and automate data copies to S3. Here's why: Cost-effectiveness: Volume gateways use Amazon EBS volumes for local storage, which is typically more cost-effective than Amazon FSx for Windows File Server for storing large amounts of data. Additionally, this approach avoids the need for additional backups within Amazon FSx, further reducing costs. Direct Connect utilization: Leveraging the existing Direct Connect connection optimizes network bandwidth for transferring data to S3, minimizing latency and potential data transfer charges. Automated backups: Automating copies of the nightly exports to S3 ensures reliable backups and minimizes manual intervention.
upvoted 1 times
...
career360guru
11 months, 1 week ago
Selected Answer: A
Option A
upvoted 2 times
...
yorkicurke
11 months, 4 weeks ago
Selected Answer: A
if you read the end of the following link's paragraph, its right there in documentation; https://aws.amazon.com/storagegateway/features/#Gateway_Types under " Amazon S3 File Gateway " Customers can use Amazon S3 File Gateway to back up on-premises file data as objects in Amazon S3 (including Microsoft SQL Server and Oracle databases and logs), and for hybrid cloud workflows using data generated by on-premises applications for processing by AWS services such as machine learning or big data analytics.
upvoted 1 times
NolaHOla
11 months, 3 weeks ago
But the answer A never mentions S3 file gateway?
upvoted 2 times
...
...
SK_Tyagi
1 year, 2 months ago
Selected Answer: A
https://aws.amazon.com/storagegateway/features/
upvoted 1 times
...
rafael796
1 year, 2 months ago
Selected Answer: A
file gateway = most cheap
upvoted 1 times
...
NikkyDicky
1 year, 3 months ago
Selected Answer: A
A - SMB mount = file gwy
upvoted 2 times
...
RockyLeon
1 year, 4 months ago
Selected Answer: A
file gateway -> used to store file inside s3 volume gateway -> used to store file in on-premises using iSCSI connectivity
upvoted 2 times
...
Jackhemo
1 year, 4 months ago
Using Olabiba.ai to learn not to find an answer: Jack: Labiba, what is the Microsoft SQL Server database export is it block or file? oLabiba: The Microsoft SQL Server database export is typically a block-level backup. It captures the data at the database level, including the schema, tables, and records, and stores it in a binary format. This allows for efficient backup and restoration of the database. In summary, if you primarily need file-level access to your backups, File Gateway is a better choice. If you require block-level storage and want to optimize for low-latency access, Volume Gateway is a better fit. Let me know if you know the answer now.
upvoted 2 times
...
Maria2023
1 year, 4 months ago
Selected Answer: A
File Gateway could be mapped as SMB file share and used by the database or other automation to transfer database backups. Volume Gateway is more used to perform volume snapshots on the on-premise system so I don't believe it's a sustainable approach here.
upvoted 3 times
...
SmileyCloud
1 year, 4 months ago
Selected Answer: A
It's A (file gateway). Volume gateway is iSCSI.
upvoted 2 times
...
Jackhemo
1 year, 4 months ago
Selected Answer: D
olabiba.ai says D Option D: Using an AWS Storage Gateway volume gateway allows you to write the nightly database exports to an SMB file share on the volume gateway, which can be stored locally and automatically backed up to an S3 bucket. This solution is cost-effective as it utilizes the existing Direct Connect connection and requires minimal additional infrastructure.
upvoted 2 times
...
easytoo
1 year, 4 months ago
d-d-d-d-d-d By deploying an AWS Storage Gateway volume gateway within the VPC connected to the Direct Connect connection, the company can leverage the high-speed, low-latency connection to transfer the nightly database exports to the SMB file share on the volume gateway. This allows for efficient and reliable data transfer. Automating copies of this data from the SMB file share to an S3 bucket provides a cost-effective solution for storing the backups in more robust cloud storage on Amazon S3. The company can take advantage of the durability, scalability, and cost-effectiveness of S3 for long-term storage.
upvoted 2 times
...
nexus2020
1 year, 4 months ago
Selected Answer: A
Between A and D: write to local drive can also be a network drive mapped to the windows server. therefore SME file share is enough (A), D is Block level, for sure will cost more. the File Gateway is designed for file-level access and presents Amazon S3 storage as a file share, while the Volume Gateway provides block-level access and appears as local block storage volumes. The choice between the two depends on the specific needs and requirements of your applications and data access patterns.
upvoted 2 times
bjexamprep
10 months, 1 week ago
The backend of storage gateway is actually S3 storage, which means both volume gateway and file gateway share the same cost for storage. And the gateway cost is the same according to aws pricing: https://aws.amazon.com/storagegateway/pricing/. so where did you get the "D is Block level, for sure will cost more"?
upvoted 1 times
...
...
bhanus
1 year, 4 months ago
I am between A and D. ChatGpt says A. But The reason why I think D is because, the question says backups are written to local drive(which means its a volume on onpremises machine). So I thought a volume can be attached to volume gateway. But ChatGPT says In terms of cost-effectiveness and simplicity, option A is a better choice. It involves using an AWS Storage Gateway file gateway, which directly stores the data as objects in Amazon S3 without the need for on-premises storage. This eliminates the complexity and costs associated with maintaining an on-premises volume gateway.
upvoted 1 times
bhanus
1 year, 3 months ago
I might be wrong with my theory. Going with A
upvoted 1 times
...
Jackhemo
1 year, 4 months ago
Use olabiba.ai. It is better.
upvoted 1 times
PhuocT
1 year, 4 months ago
Q: are you using openAI as your AI engine? olabiba.com: Yes, I am powered by OpenAI's advanced AI technology. It allows me to understand and respond to your messages in a conversational manner. OpenAI provides the foundation for my capabilities, but the Olabiba team has also customized and trained me to better suit your needs. So, feel free to ask me anything or share your thoughts!
upvoted 2 times
...
...
gd1
1 year, 4 months ago
Volume will iSCSI so hat is out. Therefor A is correct
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago