ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Machine Learning - Specialty All Questions

View all questions & answers for the AWS Certified Machine Learning - Specialty exam
Go to Exam

Exam AWS Certified Machine Learning - Specialty topic 1 question 66 discussion

Exam question from Amazon's AWS Certified Machine Learning - Specialty
Question #: 66
Topic #: 1
[All AWS Certified Machine Learning - Specialty Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Erso at April 30, 2020, 2:03 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Erso
Highly Voted 2 years, 8 months ago
Answer A seems correct...
upvoted 12 times
Erso
2 years, 8 months ago
sorry, the link https://aws.amazon.com/blogs/big-data/prepare-data-for-model-training-and-invoke-machine-learning-models-with-amazon-athena/
upvoted 1 times
...
...
sonalev419
Highly Voted 2 years, 8 months ago
A ( Most queries will span 5 to 10 columns only)
upvoted 5 times
...
Mickey321
Most Recent 10 months, 1 week ago
Selected Answer: A
Option A
upvoted 1 times
...
exam_prep
2 years, 1 month ago
clue is: most queries will span 5 to 10 column while there are 200 columns. Indicating Data Warehouse means columner storage. Option A is correct.
upvoted 2 times
...
edvardo
2 years, 7 months ago
Selected Answer: A
A. See https://aws.amazon.com/blogs/big-data/analyzing-data-in-s3-using-amazon-athena/
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel