Multiple Choice
Once a month, a company receives a 100 MB .csv file compressed with gzip. The file contains 50,000 property listing records and is stored in Amazon S3 Glacier. The company needs its data analyst to query a subset of the data for a specific vendor. What is the most cost-effective solution?
A) Load the data into Amazon S3 and query it with Amazon S3 Select.
B) Query the data from Amazon S3 Glacier directly with Amazon Glacier Select.
C) Load the data to Amazon S3 and query it with Amazon Athena.
D) Load the data to Amazon S3 and query it with Amazon Redshift Spectrum.
Correct Answer:

Verified
Correct Answer:
Verified
Q54: A large retailer has successfully migrated to
Q55: A company hosts an on-premises PostgreSQL database
Q56: A company wants to use an automatic
Q57: An education provider's learning management system (LMS)
Q58: A company wants to optimize the cost
Q60: A market data company aggregates external data
Q61: A marketing company is storing its campaign
Q62: A mobile gaming company wants to capture
Q63: An insurance company has raw data in
Q64: A company wants to run analytics on