Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A company has stored 1 0 TB of log files in Apache Parquet format in an Amazon S 3 bucket. The company occasionally needs to
A company has stored TB of log files in Apache Parquet format in an Amazon S bucket. The company occasionally needs to use SQL to analyze the log files.
Which solution will meet these requirements MOST costeffectively?
A Create an Amazon Aurora MySQL database. Migrate the data from the S bucket into Aurora by using AWS Database Migration Service AWS DMS Issue SQL statements to the Aurora database.
B Create an Amazon Redshift cluster. Use Redshift Spectrum to run SQL statements directly on the data in the S bucket.
C Create an AWS Glue crawler to store and retrieve table metadata from the S bucket. Use Amazon Athena to run SQL statements directly on the data in the S bucket.
D Create an Amazon EMR cluster. Use Apache Spark SQL to run SQL statements directly on the data in the S bucket
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started