DBS-C01 · Question #250
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…
The correct answer is C. Download the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored. Amazon Web Service (AWS) recently announced a new feature of its Relational Database Service (RDS) for SQL Server. This feature allows a native integration between Amazon RDS SQL Server and Amazon S3. With this integration, it's now possible to import files from an Amazon S3…
Question
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?
Options
- ACreate an Amazon S3 event to invoke an AWS Lambda function. Configure the Lambda function
- BWrite a custom .NET app that is hosted on Amazon EC2. Configure the .NET app to load the .csv
- CDownload the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored
- DCreate an Amazon S3 event to invoke AWS Step Functions to parse the .csv file and call the
How the community answered
(35 responses)- A9% (3)
- B6% (2)
- C71% (25)
- D14% (5)
Explanation
Amazon Web Service (AWS) recently announced a new feature of its Relational Database Service (RDS) for SQL Server. This feature allows a native integration between Amazon RDS SQL Server and Amazon S3. With this integration, it's now possible to import files from an Amazon S3 bucket into a local folder of the RDS instance. Similarly, files from that folder can be exported to S3. The RDS local folder path is D:\S3.
Topics
Community Discussion
No community discussion yet for this question.