AWS Certified Database – Specialty — Question 355

A company's database specialist is building an Amazon RDS for Microsoft SQL Server DB instance to store hundreds of records in CSV format. A customer service tool uploads the records to an Amazon S3 bucket.
An employee who previously worked at the company already created a custom stored procedure to map the necessary CSV fields to the database tables. The database specialist needs to implement a solution that reuses this previous work and minimizes operational overhead.
Which solution will meet these requirements?

Answer options

• A. Create an Amazon S3 event to invoke an AWS Lambda function. Configure the Lambda function to parse the .csv file and use a SQL client library to run INSERT statements to load the data into the tables.
• B. Write a custom .NET app that is hosted on Amazon EC2. Configure the .NET app to load the .csv file and call the custom stored procedure to insert the data into the tables.
• C. Download the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored procedure. Call the custom stored procedure to insert the data from the RDS D drive into the tables.
• D. Create an Amazon S3 event to invoke AWS Step Functions to parse the .csv file and call the custom stored procedure to insert the data into the tables.

Correct answer: C

Explanation

Amazon RDS for SQL Server supports native integration with Amazon S3, allowing files to be downloaded directly to the database instance's local D drive using the rds_download_from_s3 stored procedure in the msdb database. This allows the database specialist to easily access the CSV file locally and run the existing custom stored procedure with minimal operational overhead. Options A, B, and D introduce unnecessary architectural complexity and management overhead by requiring the creation and maintenance of external code, EC2 instances, or orchestration workflows.