DEA-C01 · Question #73
DEA-C01 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joins across multiple tables. The data must be in Apache Parquet format. The analytics team must store the data in Amazon S3. Which solution will meet these requirements in the MOST operationally efficient way?
Options
- ACreate a view in the EC2 instance-based SQL Server databases that contains the required data
- BSchedule SQL Server Agent to run a daily SQL query that selects the desired data elements from
- CUse a SQL query to create a view in the EC2 instance-based SQL Server databases that
- DCreate an AWS Lambda function that queries the EC2 instance-based databases by using Java
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.