A Machine Learning Specialist Must Build Out a Process to Query

question 159

Multiple Choice

A Machine Learning Specialist must build out a process to query a dataset on Amazon S3 using Amazon Athena. The dataset contains more than 800,000 records stored as plaintext CSV files. Each record contains 200 columns and is approximately 1.5 MB in size. Most queries will span 5 to 10 columns only. How should the Machine Learning Specialist transform the dataset to minimize query runtime?

• A) Convert the records to Apache Parquet format.
• B) Convert the records to JSON format.
• C) Convert the records to GZIP CSV format.
• D) Convert the records to XML format.

---

Definitions:

Acquisition Method

An accounting method for business combinations where the acquirer is required to measure and recognize the assets acquired, liabilities assumed, and any noncontrolling interest at their fair values at the acquisition date.

Stock Issuance Costs

Expenses directly incurred by a company when it issues new shares of stock, such as legal and underwriting fees.

Direct Combination Costs

Expenses directly associated with merging or acquiring another company, such as legal fees and consultancy charges.