Once a Month, a Company Receives a 100 MB

question 59

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.

---

Definitions:

Intangible Assets

Non-physical assets that have value, such as intellectual property, trademarks, goodwill, and brand recognition.

Amortization

The gradual reduction or the expensing of an intangible asset's cost over its useful life, similar to depreciation for tangible assets.

Fair Market Value

The price at which an asset would sell in the marketplace between a willing buyer and a willing seller, each having reasonable knowledge of the pertinent facts.

Trade-In Allowance

The amount credited to the buyer of a new item for the value of the old item that is being traded in as part of the transaction.