{"id":718,"date":"2022-12-17T13:12:16","date_gmt":"2022-12-17T13:12:16","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/aws-certified-data-analytics-specialty-das-c01-question032\/"},"modified":"2022-12-17T13:12:16","modified_gmt":"2022-12-17T13:12:16","slug":"aws-certified-data-analytics-specialty-das-c01-question032","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/aws-certified-data-analytics-specialty-das-c01-question032\/","title":{"rendered":"AWS Certified Data Analytics &#8211; Specialty DAS-C01 &#8211; Question032"},"content":{"rendered":"<div class=\"question\">A company has 10-15 TB of uncompressed .csv files in Amazon S3. The company is evaluating Amazon Athena as a one-time query engine. The company wants to transform the data to optimize query runtime and storage costs.<br \/>\nWhich option for data format and compression meets these requirements?<br \/><strong><br \/>A.<\/strong> CSV compressed with zip<br \/><strong>B.<\/strong> JSON compressed with bzip2<br \/><strong>C.<\/strong> Apache Parquet compressed with Snappy<br \/><strong>D.<\/strong> Apache Avro compressed with LZO<\/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>B<\/strong><\/div>\n<p><strong>Explanation:<\/strong> <\/p>\n<div class=\"explanation\">\nReference: <a href=\"https:\/\/aws.amazon.com\/blogs\/big-data\/top-10-performance-tuning-tips-for-amazon-athena\/\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/aws.amazon.com\/blogs\/big-data\/top-10-performance-tuning-tips-for-amazon-athena\/<\/a><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A company has 10-15 TB of uncompressed .csv files in Amazon S3. The company is evaluating Amazon Athena as a one-time query engine. The company wants to transform the data to optimize query runtime and storage costs. Which option for data format and compression meets these requirements?A. CSV compressed with zipB. JSON compressed with bzip2C. [&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,199],"class_list":["post-718","post","type-post","status-publish","format-standard","hentry","category-aws-certified-data-analytics-specialty-das-c01","tag-aws-certified-data-analytics-specialty-das-c01","tag-question-032"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/posts\/718","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/comments?post=718"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/posts\/718\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/media?parent=718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/categories?post=718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/tags?post=718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}