{"id":736,"date":"2022-12-17T13:12:35","date_gmt":"2022-12-17T13:12:35","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/aws-certified-data-analytics-specialty-das-c01-question050\/"},"modified":"2022-12-17T13:12:35","modified_gmt":"2022-12-17T13:12:35","slug":"aws-certified-data-analytics-specialty-das-c01-question050","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/aws-certified-data-analytics-specialty-das-c01-question050\/","title":{"rendered":"AWS Certified Data Analytics &#8211; Specialty DAS-C01 &#8211; Question050"},"content":{"rendered":"<div class=\"question\">A large company receives files from external parties in Amazon EC2 throughout the day. At the end of the day, the files are combined into a single file, compressed into a gzip file, and uploaded to Amazon S3. The total size of all the files is close to 100 GB daily. Once the files are uploaded to Amazon S3, an AWS Batch program executes a COPY command to load the files into an Amazon Redshift cluster.<br \/>\nWhich program modification will accelerate the COPY process?<br \/><strong><br \/>A.<\/strong> Upload the individual files to Amazon S3 and run the COPY command as soon as the files become available.<br \/><strong>B.<\/strong> Split the number of files so they are equal to a multiple of the number of slices in the Amazon Redshift cluster. Gzip and upload the files to Amazon S3. Run the COPY command on the files.<br \/><strong>C.<\/strong> Split the number of files so they are equal to a multiple of the number of compute nodes in the Amazon Redshift cluster. Gzip and upload the files to Amazon S3. Run the COPY command on the files.<br \/><strong>D.<\/strong> Apply sharding by breaking up the files so the distkey columns with the same values go to the same file. Gzip and upload the sharded files to Amazon S3. Run the COPY command on the files.<\/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:\/\/docs.aws.amazon.com\/redshift\/latest\/dg\/t_splitting-data-files.html\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/docs.aws.amazon.com\/redshift\/latest\/dg\/t_splitting-data-files.html<\/a><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A large company receives files from external parties in Amazon EC2 throughout the day. At the end of the day, the files are combined into a single file, compressed into a gzip file, and uploaded to Amazon S3. The total size of all the files is close to 100 GB daily. Once the files are [&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,217],"class_list":["post-736","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-050"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/posts\/736","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=736"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/posts\/736\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/media?parent=736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/categories?post=736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Data_Analytics-Specialty_DAS-C01\/wp-json\/wp\/v2\/tags?post=736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}