ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 252 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 252
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by mbar94 at Sept. 8, 2022, 8:01 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

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
Submit Cancel
Usman0506
Highly Voted 2 years, 9 months ago
Selected Answer: D
"The database specialist needs to implement a solution that reuses this previous work". Option D is to reuse previous work.
upvoted 10 times
parle101
2 years, 6 months ago
C is using the previous work
upvoted 4 times
...
...
Sab
Highly Voted 2 years, 7 months ago
Selected Answer: C
exec msdb.dbo.rds_download_from_s3 @s3_arn_of_file='arn:aws:s3:::<bucket_name>/<file_name>', @rds_file_path='D:\S3\<custom_folder_name>\<file_name>', @overwrite_file=1;
upvoted 5 times
ftrimmer
2 years, 6 months ago
Already done really!
upvoted 1 times
...
...
zWarez
Most Recent 1 year, 7 months ago
C is the right answer. D is wrong. S3 event cannot call step function directly. If we need to use AWS STEP we can setup s3 event call lambda and lamdba call step.
upvoted 1 times
...
aviathor
2 years, 1 month ago
Selected Answer: C
The msdb stored procedure in question is msdb.dbo.rds_download_from_s3. The only piece missing is how to trigger the import... https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/User.SQLServer.Options.S3-integration.html#Appendix.SQLServer.Options.S3-integration.using
upvoted 3 times
...
dougporto1988
2 years, 3 months ago
Selected Answer: C
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/User.SQLServer.Options.S3-integration.html#:~:text=RDS%20stored%20procedure-,msdb.dbo.rds_download_from_s3,-with%20the%20following
upvoted 2 times
...
Ddddppp16
2 years, 4 months ago
Selected Answer: C
This solution is the best option as it reuses the custom stored procedure that was previously created and minimizes operational overhead. The data can be downloaded from Amazon S3 to the RDS instance and loaded into the database tables using the custom stored procedure. The use of an AWS msdb stored procedure can automate the downloading of the data to the RDS instance.
upvoted 2 times
...
examineme
2 years, 7 months ago
Selected Answer: C
Download S3 File
upvoted 2 times
...
awsexams
2 years, 7 months ago
Selected Answer: C
Alternative C allows the file to be downloaded to S3 and then a local copy with the stored procedure would work
upvoted 2 times
...
snehilsrcs
2 years, 8 months ago
Step 1: Download S3 Files Amazon RDS for SQL Server comes with several custom stored procedures and functions. These are located in the msdb database. The stored procedure to download files from S3 is "rds_download_from_s3". The syntax for this stored procedure is shown here: exec msdb.dbo.rds_download_from_s3 @s3_arn_of_file='arn:aws:s3:::<bucket_name>/<file_name>', @rds_file_path='D:\S3\<custom_folder_name>\<file_name>', @overwrite_file=1;
upvoted 3 times
...
snehilsrcs
2 years, 8 months ago
Selected Answer: C
https://www.mssqltips.com/sqlservertip/6619/rds-sql-server-data-import-from-amazon-s3/ 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\.
upvoted 3 times
...
DBA_MJF
2 years, 8 months ago
Selected Answer: C
I believe the answer is C based on the following article: https://www.mssqltips.com/sqlservertip/6619/rds-sql-server-data-import-from-amazon-s3/
upvoted 2 times
...
mbar94
2 years, 10 months ago
Selected Answer: A
Minimum operational overhead would be for A.
upvoted 2 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