{"id":465,"date":"2023-01-14T11:08:27","date_gmt":"2023-01-14T11:08:27","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/aws-certified-machine-learning-specialty-mls-c01-question066\/"},"modified":"2023-01-14T11:08:27","modified_gmt":"2023-01-14T11:08:27","slug":"aws-certified-machine-learning-specialty-mls-c01-question066","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/aws-certified-machine-learning-specialty-mls-c01-question066\/","title":{"rendered":"AWS Certified Machine Learning &#8211; Specialty MLS-C01 &#8211; Question066"},"content":{"rendered":"<div class=\"question\">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.<br \/>\nHow should the Machine Learning Specialist transform the dataset to minimize query runtime?<br \/><strong><br \/>A.<\/strong> Convert the records to Apache Parquet format.<br \/><strong>B.<\/strong> Convert the records to JSON format.<br \/><strong>C.<\/strong> Convert the records to GZIP CSV format.<br \/><strong>D.<\/strong> Convert the records to XML format.<\/div>\n<p><\/p>\n<style> .hidden-div{ display:none } <\/style>\n<p>\t\t\t\t\t\t\t<button onclick=\"getElementById('hidden-div').style.display = 'block'\"> Show Answer <\/button> <button onclick=\"getElementById('hidden-div').style.display = 'none'\">Hide Answer<\/button><\/p>\n<div class=\"hidden-div\" id=\"hidden-div\"><span style=\"\"><\/p>\n<div class=\"answer\">Correct Answer: <strong>A<\/strong><\/div>\n<p><strong>Explanation:<\/strong> <\/p>\n<div class=\"explanation\">\nExplanation:<br \/>\nUsing compressions will reduce the amount of data scanned by Amazon Athena, and also reduce your S3 bucket storage. It&#8217;s a Win-Win for your AWS bill. Supported formats: GZIP, LZO, SNAPPY (Parquet) and ZLIB.<br \/>\nReference: <a href=\"https:\/\/www.cloudforecast.io\/blog\/using-parquet-on-athena-to-save-money-on-aws\/\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/www.cloudforecast.io\/blog\/using-parquet-on-athena-to-save-m&#8230;<\/a><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[3,69],"class_list":["post-465","post","type-post","status-publish","format-standard","hentry","category-aws-certified-machine-learning-specialty-mls-c01","tag-aws-certified-machine-learning-specialty-mls-c01","tag-question-066"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/posts\/465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/comments?post=465"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/posts\/465\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/media?parent=465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/categories?post=465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Machine_Learning-Specialty_MLS-C01\/wp-json\/wp\/v2\/tags?post=465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}