{"id":123066,"date":"2026-04-08T03:54:29","date_gmt":"2026-04-08T03:54:29","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=123066"},"modified":"2026-05-08T08:48:51","modified_gmt":"2026-05-08T08:48:51","slug":"updated-aws-certified-data-engineer-associate-dea-c01-exam-guide-v12-02-check-dea-c02-free-dumps-part-1-q1-q40-first","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/updated-aws-certified-data-engineer-associate-dea-c01-exam-guide-v12-02-check-dea-c02-free-dumps-part-1-q1-q40-first.html","title":{"rendered":"Updated AWS Certified Data Engineer &#8211; Associate (DEA-C01) Exam Guide (V12.02) &#8211; Check DEA-C01 Free Dumps (Part 1, Q1-Q40) First"},"content":{"rendered":"\n<p>You can pass the AWS Certified Data Engineer &#8211; Associate (DEA-C01) exam smoothly with the most updated resource. The Amazon DEA-C01 exam guide (V12.02) is available at DumpsBase with 231 practice questions and answers, reflecting the latest AWS Certified Data Engineer &#8211; Associate exam objectives and real-world scenarios. These Q&amp;As are comprehensive, which are available in two highly convenient formats \u2014 downloadable DEA-C01 PDF and a realistic online DEA-C01 practice test engine \u2014 providing maximum flexibility and an authentic exam experience. Whether you prefer studying offline on any device or simulating the real exam environment with timed practice tests, DumpsBase\u2019s latest <strong><em><a href=\"https:\/\/www.dumpsbase.com\/amazon.html\">Amazon<\/a><\/em><\/strong> DEA-C01 exam questions empower you with the knowledge, confidence, and edge needed to achieve success in the AWS Certified Data Engineer \u2013 Associate certification exam. Before downloading this updated guide, you can read our free dumps today to check the quality first.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Below are the Amazon DEA-C01 free dumps (Part 1, Q1-Q40) of V12.02 for reading:<\/h2>\n\n\n<script>\n\t  window.fbAsyncInit = function() {\n\t    FB.init({\n\t      appId            : '622169541470367',\n\t      autoLogAppEvents : true,\n\t      xfbml            : true,\n\t      version          : 'v3.1'\n\t    });\n\t  };\n\t\n\t  (function(d, s, id){\n\t     var js, fjs = d.getElementsByTagName(s)[0];\n\t     if (d.getElementById(id)) {return;}\n\t     js = d.createElement(s); js.id = id;\n\t     js.src = \"https:\/\/connect.facebook.net\/en_US\/sdk.js\";\n\t     fjs.parentNode.insertBefore(js, fjs);\n\t   }(document, 'script', 'facebook-jssdk'));\n\t<\/script><script type=\"text\/javascript\" >\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \nif(!window.jQuery) alert(\"The important jQuery library is not properly loaded in your site. Your WordPress theme is probably missing the essential wp_head() call. You can switch to another theme and you will see that the plugin works fine and this notice disappears. If you are still not sure what to do you can contact us for help.\");\n});\n<\/script>  \n  \n<div  id=\"watupro_quiz\" class=\"quiz-area single-page-quiz\">\n<p id=\"submittingExam11692\" style=\"display:none;text-align:center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\"><\/p>\n\n<div class=\"watupro-exam-description\" id=\"description-quiz-11692\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-11692\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-458716'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>A company is planning to migrate on-premises Apache Hadoop clusters to Amazon EMR. The company also needs to migrate a data catalog into a persistent storage solution. <br \/>\r<br>The company currently stores the data catalog in an on-premises Apache Hive metastore on the Hadoop clusters. The company requires a serverless solution to migrate the data catalog. <br \/>\r<br>Which solution will meet these requirements MOST cost-effectively?<\/div><input type='hidden' name='question_id[]' id='qID_1' value='458716' \/><input type='hidden' id='answerType458716' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773230' class='answer   answerof-458716 ' value='1773230'   \/><label for='answer-id-1773230' id='answer-label-1773230' class=' answer'><span>Use AWS Database Migration Service (AWS DMS) to migrate the Hive metastore into Amazon S3. \r\nConfigure AWS Glue Data Catalog to scan Amazon S3 to produce the data catalog.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773231' class='answer   answerof-458716 ' value='1773231'   \/><label for='answer-id-1773231' id='answer-label-1773231' class=' answer'><span>Configure a Hive metastore in Amazon EM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773232' class='answer   answerof-458716 ' value='1773232'   \/><label for='answer-id-1773232' id='answer-label-1773232' class=' answer'><span>Migrate the existing on-premises Hive metastore into Amazon EM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773233' class='answer   answerof-458716 ' value='1773233'   \/><label for='answer-id-1773233' id='answer-label-1773233' class=' answer'><span>Use AWS Glue Data Catalog to store the company's data catalog as an external data catalog.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773234' class='answer   answerof-458716 ' value='1773234'   \/><label for='answer-id-1773234' id='answer-label-1773234' class=' answer'><span>Configure an external Hive metastore in Amazon EM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773235' class='answer   answerof-458716 ' value='1773235'   \/><label for='answer-id-1773235' id='answer-label-1773235' class=' answer'><span>Migrate the existing on-premises Hive metastore into Amazon EM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773236' class='answer   answerof-458716 ' value='1773236'   \/><label for='answer-id-1773236' id='answer-label-1773236' class=' answer'><span>Use Amazon Aurora MySQL to store the company's data catalog.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773237' class='answer   answerof-458716 ' value='1773237'   \/><label for='answer-id-1773237' id='answer-label-1773237' class=' answer'><span>Configure a new Hive metastore in Amazon EM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773238' class='answer   answerof-458716 ' value='1773238'   \/><label for='answer-id-1773238' id='answer-label-1773238' class=' answer'><span>Migrate the existing on-premises Hive metastore into Amazon EM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458716[]' id='answer-id-1773239' class='answer   answerof-458716 ' value='1773239'   \/><label for='answer-id-1773239' id='answer-label-1773239' class=' answer'><span>Use the new metastore as the company's data catalog.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-458717'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>A company uses AWS Step Functions to orchestrate a data pipeline. The pipeline consists of Amazon EMR jobs that ingest data from data sources and store the data in an Amazon S3 bucket. The pipeline also includes EMR jobs that load the data to Amazon Redshift. <br \/>\r<br>The company's cloud infrastructure team manually built a Step Functions state machine. The cloud infrastructure team launched an EMR cluster into a VPC to support the EMR jobs. However, the deployed Step Functions state machine is not able to run the EMR jobs. <br \/>\r<br>Which combination of steps should the company take to identify the reason the Step Functions state machine is not able to run the EMR jobs? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_2' value='458717' \/><input type='hidden' id='answerType458717' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458717[]' id='answer-id-1773240' class='answer   answerof-458717 ' value='1773240'   \/><label for='answer-id-1773240' id='answer-label-1773240' class=' answer'><span>Use AWS CloudFormation to automate the Step Functions state machine deployment. Create a step to pause the state machine during the EMR jobs that fail. Configure the step to wait for a human user to send approval through an email message. Include details of the EMR task in the email message for further analysis.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458717[]' id='answer-id-1773241' class='answer   answerof-458717 ' value='1773241'   \/><label for='answer-id-1773241' id='answer-label-1773241' class=' answer'><span>Verify that the Step Functions state machine code has all IAM permissions that are necessary to create and run the EMR jobs. Verify that the Step Functions state machine code also includes IAM permissions to access the Amazon S3 buckets that the EMR jobs use. Use Access Analyzer for S3 to check the S3 access properties.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458717[]' id='answer-id-1773242' class='answer   answerof-458717 ' value='1773242'   \/><label for='answer-id-1773242' id='answer-label-1773242' class=' answer'><span>Check for entries in Amazon CloudWatch for the newly created EMR cluster. Change the AWS Step Functions state machine code to use Amazon EMR on EK<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458717[]' id='answer-id-1773243' class='answer   answerof-458717 ' value='1773243'   \/><label for='answer-id-1773243' id='answer-label-1773243' class=' answer'><span>Change the IAM access policies and the security group configuration for the Step Functions state machine code to reflect inclusion of Amazon Elastic Kubernetes Service (Amazon EKS).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458717[]' id='answer-id-1773244' class='answer   answerof-458717 ' value='1773244'   \/><label for='answer-id-1773244' id='answer-label-1773244' class=' answer'><span>Query the flow logs for the VP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458717[]' id='answer-id-1773245' class='answer   answerof-458717 ' value='1773245'   \/><label for='answer-id-1773245' id='answer-label-1773245' class=' answer'><span>Determine whether the traffic that originates from the EMR cluster can successfully reach the data providers. Determine whether any security group that might be attached to the Amazon EMR cluster allows connections to the data source servers on the informed ports.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458717[]' id='answer-id-1773246' class='answer   answerof-458717 ' value='1773246'   \/><label for='answer-id-1773246' id='answer-label-1773246' class=' answer'><span>Check the retry scenarios that the company configured for the EMR jobs. Increase the number of seconds in the interval between each EMR task. Validate that each fallback state has the appropriate catch for each decision state. Configure an Amazon Simple Notification Service (Amazon SNS) topic to store the error messages.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-3' style=';'><div id='questionWrap-3'  class='   watupro-question-id-458718'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>A data engineer must build an extract, transform, and load (ETL) pipeline to process and load data from 10 source systems into 10 tables that are in an Amazon Redshift database. All the source systems generate .csv, JSON, or Apache Parquet files every 15 minutes. The source systems all deliver files into one Amazon S3 bucket. The file sizes range from 10 MB to 20 GB. The ETL pipeline must function correctly despite changes to the data schema. <br \/>\r<br>Which data pipeline solutions will meet these requirements? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_3' value='458718' \/><input type='hidden' id='answerType458718' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458718[]' id='answer-id-1773247' class='answer   answerof-458718 ' value='1773247'   \/><label for='answer-id-1773247' id='answer-label-1773247' class=' answer'><span>Use an Amazon EventBridge rule to run an AWS Glue job every 15 minutes. Configure the AWS Glue job to process and load the data into the Amazon Redshift tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458718[]' id='answer-id-1773248' class='answer   answerof-458718 ' value='1773248'   \/><label for='answer-id-1773248' id='answer-label-1773248' class=' answer'><span>Use an Amazon EventBridge rule to invoke an AWS Glue workflow job every 15 minutes. Configure the AWS Glue workflow to have an on-demand trigger that runs an AWS Glue crawler and then runs an AWS Glue job when the crawler finishes running successfully. Configure the AWS Glue job to process and load the data into the Amazon Redshift tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458718[]' id='answer-id-1773249' class='answer   answerof-458718 ' value='1773249'   \/><label for='answer-id-1773249' id='answer-label-1773249' class=' answer'><span>Configure an AWS Lambda function to invoke an AWS Glue crawler when a file is loaded into the S3 bucket. Configure an AWS Glue job to process and load the data into the Amazon Redshift tables. Create a second Lambda function to run the AWS Glue job. Create an Amazon EventBridge rule to invoke the second Lambda function when the AWS Glue crawler finishes running successfully.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458718[]' id='answer-id-1773250' class='answer   answerof-458718 ' value='1773250'   \/><label for='answer-id-1773250' id='answer-label-1773250' class=' answer'><span>Configure an AWS Lambda function to invoke an AWS Glue workflow when a file is loaded into the S3 bucket. Configure the AWS Glue workflow to have an on-demand trigger that runs an AWS Glue crawler and then runs an AWS Glue job when the crawler finishes running successfully. Configure the AWS Glue job to process and load the data into the Amazon Redshift tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458718[]' id='answer-id-1773251' class='answer   answerof-458718 ' value='1773251'   \/><label for='answer-id-1773251' id='answer-label-1773251' class=' answer'><span>Configure an AWS Lambda function to invoke an AWS Glue job when a file is loaded into the S3 bucket. Configure the AWS Glue job to read the files from the S3 bucket into an Apache Spark DataFrame. Configure the AWS Glue job to also put smaller partitions of the DataFrame into an Amazon Kinesis Data Firehose delivery stream. Configure the delivery stream to load data into the Amazon Redshift tables.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-4' style=';'><div id='questionWrap-4'  class='   watupro-question-id-458719'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>A data engineer needs to create an AWS Lambda function that converts the format of data from .csv to Apache Parquet. The Lambda function must run only if a user uploads a .csv file to an Amazon S3 bucket. <br \/>\r<br>Which solution will meet these requirements with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_4' value='458719' \/><input type='hidden' id='answerType458719' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458719[]' id='answer-id-1773252' class='answer   answerof-458719 ' value='1773252'   \/><label for='answer-id-1773252' id='answer-label-1773252' class=' answer'><span>Create an S3 event notification that has an event type of s3:ObjectCreated:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458719[]' id='answer-id-1773253' class='answer   answerof-458719 ' value='1773253'   \/><label for='answer-id-1773253' id='answer-label-1773253' class=' answer'><span>Create an S3 event notification that has an event type of s3:ObjectTagging:* for objects that have a tag set to .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458719[]' id='answer-id-1773254' class='answer   answerof-458719 ' value='1773254'   \/><label for='answer-id-1773254' id='answer-label-1773254' class=' answer'><span>Create an S3 event notification that has an event type of s3:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458719[]' id='answer-id-1773255' class='answer   answerof-458719 ' value='1773255'   \/><label for='answer-id-1773255' id='answer-label-1773255' class=' answer'><span>Create an S3 event notification that has an event type of s3:ObjectCreated:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set an Amazon Simple Notification Service (Amazon SNS) topic as the destination for the event notification. Subscribe the Lambda function to the SNS topic.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-5' style=';'><div id='questionWrap-5'  class='   watupro-question-id-458720'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>A media company uses software as a service (SaaS) applications to gather data by using third-party tools. The company needs to store the data in an Amazon S3 bucket. The company will use Amazon Redshift to perform analytics based on the data. <br \/>\r<br>Which AWS service or feature will meet these requirements with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_5' value='458720' \/><input type='hidden' id='answerType458720' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458720[]' id='answer-id-1773256' class='answer   answerof-458720 ' value='1773256'   \/><label for='answer-id-1773256' id='answer-label-1773256' class=' answer'><span>Amazon Managed Streaming for Apache Kafka (Amazon MSK)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458720[]' id='answer-id-1773257' class='answer   answerof-458720 ' value='1773257'   \/><label for='answer-id-1773257' id='answer-label-1773257' class=' answer'><span>Amazon AppFlow<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458720[]' id='answer-id-1773258' class='answer   answerof-458720 ' value='1773258'   \/><label for='answer-id-1773258' id='answer-label-1773258' class=' answer'><span>AWS Glue Data Catalog<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458720[]' id='answer-id-1773259' class='answer   answerof-458720 ' value='1773259'   \/><label for='answer-id-1773259' id='answer-label-1773259' class=' answer'><span>Amazon Kinesis<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-458721'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>A company receives .csv files that contain physical address data. The data is in columns that have the following names: Door_No, Street_Name, City, and Zip_Code. <br \/>\r<br>The company wants to create a single column to store these values in the following format: <br \/>\r<br><br><img decoding=\"async\" width=405 height=145 id=\"\u56fe\u7247 7\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/02\/image001-23.jpg\"><br><br \/>\r<br>Which solution will meet this requirement with the LEAST coding effort?<\/div><input type='hidden' name='question_id[]' id='qID_6' value='458721' \/><input type='hidden' id='answerType458721' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458721[]' id='answer-id-1773260' class='answer   answerof-458721 ' value='1773260'   \/><label for='answer-id-1773260' id='answer-label-1773260' class=' answer'><span>Use AWS Glue DataBrew to read the files. Use the NEST TO ARRAY transformation to create the new column.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458721[]' id='answer-id-1773261' class='answer   answerof-458721 ' value='1773261'   \/><label for='answer-id-1773261' id='answer-label-1773261' class=' answer'><span>Use AWS Glue DataBrew to read the files. Use the NEST TO MAP transformation to create the new column.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458721[]' id='answer-id-1773262' class='answer   answerof-458721 ' value='1773262'   \/><label for='answer-id-1773262' id='answer-label-1773262' class=' answer'><span>Use AWS Glue DataBrew to read the files. Use the PIVOT transformation to create the new column.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458721[]' id='answer-id-1773263' class='answer   answerof-458721 ' value='1773263'   \/><label for='answer-id-1773263' id='answer-label-1773263' class=' answer'><span>Write a Lambda function in Python to read the files. Use the Python data dictionary type to create the new column.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-7' style=';'><div id='questionWrap-7'  class='   watupro-question-id-458722'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>A data engineer needs to securely transfer 5 TB of data from an on-premises data center to an Amazon S3 bucket. Approximately 5% of the data changes every day. Updates to the data need to be regularly proliferated to the S3 bucket. The data includes files that are in multiple formats. The data engineer needs to automate the transfer process and must schedule the process to run periodically. <br \/>\r<br>Which AWS service should the data engineer use to transfer the data in the MOST operationally efficient way?<\/div><input type='hidden' name='question_id[]' id='qID_7' value='458722' \/><input type='hidden' id='answerType458722' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458722[]' id='answer-id-1773264' class='answer   answerof-458722 ' value='1773264'   \/><label for='answer-id-1773264' id='answer-label-1773264' class=' answer'><span>AWS DataSync<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458722[]' id='answer-id-1773265' class='answer   answerof-458722 ' value='1773265'   \/><label for='answer-id-1773265' id='answer-label-1773265' class=' answer'><span>AWS Glue<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458722[]' id='answer-id-1773266' class='answer   answerof-458722 ' value='1773266'   \/><label for='answer-id-1773266' id='answer-label-1773266' class=' answer'><span>AWS Direct Connect<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458722[]' id='answer-id-1773267' class='answer   answerof-458722 ' value='1773267'   \/><label for='answer-id-1773267' id='answer-label-1773267' class=' answer'><span>Amazon S3 Transfer Acceleration<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-8' style=';'><div id='questionWrap-8'  class='   watupro-question-id-458723'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>A company's data engineer needs to optimize the performance of table SQL queries. The company stores data in an Amazon Redshift cluster. The data engineer cannot increase the size of the cluster because of budget constraints. <br \/>\r<br>The company stores the data in multiple tables and loads the data by using the EVEN distribution style. Some tables are hundreds of gigabytes in size. Other tables are less than 10 MB in size. <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_8' value='458723' \/><input type='hidden' id='answerType458723' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458723[]' id='answer-id-1773268' class='answer   answerof-458723 ' value='1773268'   \/><label for='answer-id-1773268' id='answer-label-1773268' class=' answer'><span>Keep using the EVEN distribution style for all tables. Specify primary and foreign keys for all tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458723[]' id='answer-id-1773269' class='answer   answerof-458723 ' value='1773269'   \/><label for='answer-id-1773269' id='answer-label-1773269' class=' answer'><span>Use the ALL distribution style for large tables. Specify primary and foreign keys for all tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458723[]' id='answer-id-1773270' class='answer   answerof-458723 ' value='1773270'   \/><label for='answer-id-1773270' id='answer-label-1773270' class=' answer'><span>Use the ALL distribution style for rarely updated small tables. Specify primary and foreign keys for all tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458723[]' id='answer-id-1773271' class='answer   answerof-458723 ' value='1773271'   \/><label for='answer-id-1773271' id='answer-label-1773271' class=' answer'><span>Specify a combination of distribution, sort, and partition keys for all tables.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-458724'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>A company uses Amazon RDS for MySQL as the database for a critical application. The database workload is mostly writes, with a small number of reads. <br \/>\r<br>A data engineer notices that the CPU utilization of the DB instance is very high. The high CPU utilization is slowing down the application. The data engineer must reduce the CPU utilization of the DB Instance. <br \/>\r<br>Which actions should the data engineer take to meet this requirement? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_9' value='458724' \/><input type='hidden' id='answerType458724' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458724[]' id='answer-id-1773272' class='answer   answerof-458724 ' value='1773272'   \/><label for='answer-id-1773272' id='answer-label-1773272' class=' answer'><span>Use the Performance Insights feature of Amazon RDS to identify queries that have high CPU utilization. Optimize the problematic queries.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458724[]' id='answer-id-1773273' class='answer   answerof-458724 ' value='1773273'   \/><label for='answer-id-1773273' id='answer-label-1773273' class=' answer'><span>Modify the database schema to include additional tables and indexes.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458724[]' id='answer-id-1773274' class='answer   answerof-458724 ' value='1773274'   \/><label for='answer-id-1773274' id='answer-label-1773274' class=' answer'><span>Reboot the RDS DB instance once each week.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458724[]' id='answer-id-1773275' class='answer   answerof-458724 ' value='1773275'   \/><label for='answer-id-1773275' id='answer-label-1773275' class=' answer'><span>Upgrade to a larger instance size.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458724[]' id='answer-id-1773276' class='answer   answerof-458724 ' value='1773276'   \/><label for='answer-id-1773276' id='answer-label-1773276' class=' answer'><span>Implement caching to reduce the database query load.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-458725'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>A company is migrating on-premises workloads to AWS. The company wants to reduce overall operational overhead. The company also wants to explore serverless options. <br \/>\r<br>The company's current workloads use Apache Pig, Apache Oozie, Apache Spark, Apache Hbase, and Apache Flink. The on-premises workloads process petabytes of data in seconds. The company must maintain similar or better performance after the migration to AWS. <br \/>\r<br>Which extract, transform, and load (ETL) service will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_10' value='458725' \/><input type='hidden' id='answerType458725' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458725[]' id='answer-id-1773277' class='answer   answerof-458725 ' value='1773277'   \/><label for='answer-id-1773277' id='answer-label-1773277' class=' answer'><span>AWS Glue<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458725[]' id='answer-id-1773278' class='answer   answerof-458725 ' value='1773278'   \/><label for='answer-id-1773278' id='answer-label-1773278' class=' answer'><span>Amazon EMR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458725[]' id='answer-id-1773279' class='answer   answerof-458725 ' value='1773279'   \/><label for='answer-id-1773279' id='answer-label-1773279' class=' answer'><span>AWS Lambda<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458725[]' id='answer-id-1773280' class='answer   answerof-458725 ' value='1773280'   \/><label for='answer-id-1773280' id='answer-label-1773280' class=' answer'><span>Amazon Redshift<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-458726'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>A data engineer needs to build an extract, transform, and load (ETL) job. The ETL job will process daily incoming .csv files that users upload to an Amazon S3 bucket. The size of each S3 object is less than 100 MB. <br \/>\r<br>Which solution will meet these requirements MOST cost-effectively?<\/div><input type='hidden' name='question_id[]' id='qID_11' value='458726' \/><input type='hidden' id='answerType458726' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458726[]' id='answer-id-1773281' class='answer   answerof-458726 ' value='1773281'   \/><label for='answer-id-1773281' id='answer-label-1773281' class=' answer'><span>Write a custom Python application. Host the application on an Amazon Elastic Kubernetes Service (Amazon EKS) cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458726[]' id='answer-id-1773282' class='answer   answerof-458726 ' value='1773282'   \/><label for='answer-id-1773282' id='answer-label-1773282' class=' answer'><span>Write a PySpark ETL script. Host the script on an Amazon EMR cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458726[]' id='answer-id-1773283' class='answer   answerof-458726 ' value='1773283'   \/><label for='answer-id-1773283' id='answer-label-1773283' class=' answer'><span>Write an AWS Glue PySpark job. Use Apache Spark to transform the data.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458726[]' id='answer-id-1773284' class='answer   answerof-458726 ' value='1773284'   \/><label for='answer-id-1773284' id='answer-label-1773284' class=' answer'><span>Write an AWS Glue Python shell job. Use pandas to transform the data.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-12' style=';'><div id='questionWrap-12'  class='   watupro-question-id-458727'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>A company stores petabytes of data in thousands of Amazon S3 buckets in the S3 Standard storage class. The data supports analytics workloads that have unpredictable and variable data access patterns. <br \/>\r<br>The company does not access some data for months. However, the company must be able to retrieve all data within milliseconds. The company needs to optimize S3 storage costs. <br \/>\r<br>Which solution will meet these requirements with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_12' value='458727' \/><input type='hidden' id='answerType458727' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458727[]' id='answer-id-1773285' class='answer   answerof-458727 ' value='1773285'   \/><label for='answer-id-1773285' id='answer-label-1773285' class=' answer'><span>Use S3 Storage Lens standard metrics to determine when to move objects to more cost-optimized storage classes. Create S3 Lifecycle policies for the S3 buckets to move objects to cost-optimized storage classes. Continue to refine the S3 Lifecycle policies in the future to optimize storage costs.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458727[]' id='answer-id-1773286' class='answer   answerof-458727 ' value='1773286'   \/><label for='answer-id-1773286' id='answer-label-1773286' class=' answer'><span>Use S3 Storage Lens activity metrics to identify S3 buckets that the company accesses infrequently. Configure S3 Lifecycle rules to move objects from S3 Standard to the S3 Standard-Infrequent Access (S3 Standard-IA) and S3 Glacier storage classes based on the age of the data.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458727[]' id='answer-id-1773287' class='answer   answerof-458727 ' value='1773287'   \/><label for='answer-id-1773287' id='answer-label-1773287' class=' answer'><span>Use S3 Intelligent-Tiering. Activate the Deep Archive Access tier.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458727[]' id='answer-id-1773288' class='answer   answerof-458727 ' value='1773288'   \/><label for='answer-id-1773288' id='answer-label-1773288' class=' answer'><span>Use S3 Intelligent-Tiering. Use the default access tier.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-458728'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>A company stores its processed data in an S3 bucket. The company has a strict data access policy. The company uses IAM roles to grant teams within the company different levels of access to the S3 bucket. <br \/>\r<br>The company wants to receive notifications when a user violates the data access policy. Each notification must include the username of the user who violated the policy. <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_13' value='458728' \/><input type='hidden' id='answerType458728' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458728[]' id='answer-id-1773289' class='answer   answerof-458728 ' value='1773289'   \/><label for='answer-id-1773289' id='answer-label-1773289' class=' answer'><span>Use AWS Config rules to detect violations of the data access policy. Set up compliance alarms.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458728[]' id='answer-id-1773290' class='answer   answerof-458728 ' value='1773290'   \/><label for='answer-id-1773290' id='answer-label-1773290' class=' answer'><span>Use Amazon CloudWatch metrics to gather object-level metrics. Set up CloudWatch alarms.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458728[]' id='answer-id-1773291' class='answer   answerof-458728 ' value='1773291'   \/><label for='answer-id-1773291' id='answer-label-1773291' class=' answer'><span>Use AWS CloudTrail to track object-level events for the S3 bucket. Forward events to Amazon CloudWatch to set up CloudWatch alarms.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458728[]' id='answer-id-1773292' class='answer   answerof-458728 ' value='1773292'   \/><label for='answer-id-1773292' id='answer-label-1773292' class=' answer'><span>Use Amazon S3 server access logs to monitor access to the bucket. Forward the access logs to an Amazon CloudWatch log group. Use metric filters on the log group to set up CloudWatch alarms.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-14' style=';'><div id='questionWrap-14'  class='   watupro-question-id-458729'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>A company uses Amazon Athena to run SQL queries for extract, transform, and load (ETL) tasks by using Create Table As Select (CTAS). The company must use Apache Spark instead of SQL to generate analytics. <br \/>\r<br>Which solution will give the company the ability to use Spark to access Athena?<\/div><input type='hidden' name='question_id[]' id='qID_14' value='458729' \/><input type='hidden' id='answerType458729' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458729[]' id='answer-id-1773293' class='answer   answerof-458729 ' value='1773293'   \/><label for='answer-id-1773293' id='answer-label-1773293' class=' answer'><span>Athena query settings<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458729[]' id='answer-id-1773294' class='answer   answerof-458729 ' value='1773294'   \/><label for='answer-id-1773294' id='answer-label-1773294' class=' answer'><span>Athena workgroup<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458729[]' id='answer-id-1773295' class='answer   answerof-458729 ' value='1773295'   \/><label for='answer-id-1773295' id='answer-label-1773295' class=' answer'><span>Athena data source<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458729[]' id='answer-id-1773296' class='answer   answerof-458729 ' value='1773296'   \/><label for='answer-id-1773296' id='answer-label-1773296' class=' answer'><span>Athena query editor<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-458730'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3. <br \/>\r<br>Which solution will meet this requirement MOST cost-effectively?<\/div><input type='hidden' name='question_id[]' id='qID_15' value='458730' \/><input type='hidden' id='answerType458730' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458730[]' id='answer-id-1773297' class='answer   answerof-458730 ' value='1773297'   \/><label for='answer-id-1773297' id='answer-label-1773297' class=' answer'><span>Use an Amazon EMR provisioned cluster to read from all sources. Use Apache Spark to join the data and perform the analysis.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458730[]' id='answer-id-1773298' class='answer   answerof-458730 ' value='1773298'   \/><label for='answer-id-1773298' id='answer-label-1773298' class=' answer'><span>Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3. Run Amazon Athena queries directly on the S3 files.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458730[]' id='answer-id-1773299' class='answer   answerof-458730 ' value='1773299'   \/><label for='answer-id-1773299' id='answer-label-1773299' class=' answer'><span>Use Amazon Athena Federated Query to join the data from all data sources.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458730[]' id='answer-id-1773300' class='answer   answerof-458730 ' value='1773300'   \/><label for='answer-id-1773300' id='answer-label-1773300' class=' answer'><span>Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-16' style=';'><div id='questionWrap-16'  class='   watupro-question-id-458731'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>A data engineer maintains custom Python scripts that perform a data formatting process that many AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data engineer must manually update all the Lambda functions. <br \/>\r<br>The data engineer requires a less manual way to update the Lambda functions. <br \/>\r<br>Which solution will meet this requirement?<\/div><input type='hidden' name='question_id[]' id='qID_16' value='458731' \/><input type='hidden' id='answerType458731' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458731[]' id='answer-id-1773301' class='answer   answerof-458731 ' value='1773301'   \/><label for='answer-id-1773301' id='answer-label-1773301' class=' answer'><span>Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458731[]' id='answer-id-1773302' class='answer   answerof-458731 ' value='1773302'   \/><label for='answer-id-1773302' id='answer-label-1773302' class=' answer'><span>Package the custom Python scripts into Lambda layers. Apply the Lambda layers to the Lambda functions.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458731[]' id='answer-id-1773303' class='answer   answerof-458731 ' value='1773303'   \/><label for='answer-id-1773303' id='answer-label-1773303' class=' answer'><span>Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458731[]' id='answer-id-1773304' class='answer   answerof-458731 ' value='1773304'   \/><label for='answer-id-1773304' id='answer-label-1773304' class=' answer'><span>Assign the same alias to each Lambda function. Call reach Lambda function by specifying the function's alias.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-17' style=';'><div id='questionWrap-17'  class='   watupro-question-id-458732'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>A data engineer is configuring Amazon SageMaker Studio to use AWS Glue interactive sessions to prepare data for machine learning (ML) models. <br \/>\r<br>The data engineer receives an access denied error when the data engineer tries to prepare the data by using SageMaker Studio. <br \/>\r<br>Which change should the engineer make to gain access to SageMaker Studio?<\/div><input type='hidden' name='question_id[]' id='qID_17' value='458732' \/><input type='hidden' id='answerType458732' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458732[]' id='answer-id-1773305' class='answer   answerof-458732 ' value='1773305'   \/><label for='answer-id-1773305' id='answer-label-1773305' class=' answer'><span>Add the AWS Glue Service Role managed policy to the data engineer's IAM user.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458732[]' id='answer-id-1773306' class='answer   answerof-458732 ' value='1773306'   \/><label for='answer-id-1773306' id='answer-label-1773306' class=' answer'><span>Add a policy to the data engineer's IAM user that includes the sts:AssumeRole action for the AWS Glue and SageMaker service principals in the trust policy.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458732[]' id='answer-id-1773307' class='answer   answerof-458732 ' value='1773307'   \/><label for='answer-id-1773307' id='answer-label-1773307' class=' answer'><span>Add the AmazonSageMakerFullAccess managed policy to the data engineer's IAM user.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458732[]' id='answer-id-1773308' class='answer   answerof-458732 ' value='1773308'   \/><label for='answer-id-1773308' id='answer-label-1773308' class=' answer'><span>Add a policy to the data engineer's IAM user that allows the sts:AddAssociation action for the AWS Glue and SageMaker service principals in the trust policy.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-458733'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>A financial company wants to use Amazon Athena to run on-demand SQL queries on a petabyte-scale dataset to support a business intelligence (BI) application. An AWS Glue job that runs during non-business hours updates the dataset once every day. The BI application has a standard data refresh frequency of 1 hour to comply with company policies. <br \/>\r<br>A data engineer wants to cost optimize the company's use of Amazon Athena without adding any <br \/>\r<br>additional infrastructure costs. <br \/>\r<br>Which solution will meet these requirements with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_18' value='458733' \/><input type='hidden' id='answerType458733' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458733[]' id='answer-id-1773309' class='answer   answerof-458733 ' value='1773309'   \/><label for='answer-id-1773309' id='answer-label-1773309' class=' answer'><span>Configure an Amazon S3 Lifecycle policy to move data to the S3 Glacier Deep Archive storage class after 1 day<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458733[]' id='answer-id-1773310' class='answer   answerof-458733 ' value='1773310'   \/><label for='answer-id-1773310' id='answer-label-1773310' class=' answer'><span>Use the query result reuse feature of Amazon Athena for the SQL queries.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458733[]' id='answer-id-1773311' class='answer   answerof-458733 ' value='1773311'   \/><label for='answer-id-1773311' id='answer-label-1773311' class=' answer'><span>Add an Amazon ElastiCache cluster between the Bl application and Athena.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458733[]' id='answer-id-1773312' class='answer   answerof-458733 ' value='1773312'   \/><label for='answer-id-1773312' id='answer-label-1773312' class=' answer'><span>Change the format of the files that are in the dataset to Apache Parquet.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-19' style=';'><div id='questionWrap-19'  class='   watupro-question-id-458734'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>A healthcare company uses Amazon Kinesis Data Streams to stream real-time health data from wearable devices, hospital equipment, and patient records. <br \/>\r<br>A data engineer needs to find a solution to process the streaming data. The data engineer needs to store the data in an Amazon Redshift Serverless warehouse. The solution must support near real-time analytics of the streaming data and the previous day's data. <br \/>\r<br>Which solution will meet these requirements with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_19' value='458734' \/><input type='hidden' id='answerType458734' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458734[]' id='answer-id-1773313' class='answer   answerof-458734 ' value='1773313'   \/><label for='answer-id-1773313' id='answer-label-1773313' class=' answer'><span>Load data into Amazon Kinesis Data Firehose. Load the data into Amazon Redshift.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458734[]' id='answer-id-1773314' class='answer   answerof-458734 ' value='1773314'   \/><label for='answer-id-1773314' id='answer-label-1773314' class=' answer'><span>Use the streaming ingestion feature of Amazon Redshift.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458734[]' id='answer-id-1773315' class='answer   answerof-458734 ' value='1773315'   \/><label for='answer-id-1773315' id='answer-label-1773315' class=' answer'><span>Load the data into Amazon S3. Use the COPY command to load the data into Amazon Redshift.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458734[]' id='answer-id-1773316' class='answer   answerof-458734 ' value='1773316'   \/><label for='answer-id-1773316' id='answer-label-1773316' class=' answer'><span>Use the Amazon Aurora zero-ETL integration with Amazon Redshift.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-458735'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>A technology company currently uses Amazon Kinesis Data Streams to collect log data in real time. The company wants to use Amazon Redshift for downstream real-time queries and to enrich the log data. <br \/>\r<br>Which solution will ingest data into Amazon Redshift with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_20' value='458735' \/><input type='hidden' id='answerType458735' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458735[]' id='answer-id-1773317' class='answer   answerof-458735 ' value='1773317'   \/><label for='answer-id-1773317' id='answer-label-1773317' class=' answer'><span>Set up an Amazon Data Firehose delivery stream to send data to a Redshift provisioned cluster table.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458735[]' id='answer-id-1773318' class='answer   answerof-458735 ' value='1773318'   \/><label for='answer-id-1773318' id='answer-label-1773318' class=' answer'><span>Set up an Amazon Data Firehose delivery stream to send data to Amazon S3. Configure a Redshift provisioned cluster to load data every minute.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458735[]' id='answer-id-1773319' class='answer   answerof-458735 ' value='1773319'   \/><label for='answer-id-1773319' id='answer-label-1773319' class=' answer'><span>Configure Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to send data directly to a Redshift provisioned cluster table.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458735[]' id='answer-id-1773320' class='answer   answerof-458735 ' value='1773320'   \/><label for='answer-id-1773320' id='answer-label-1773320' class=' answer'><span>Use Amazon Redshift streaming ingestion from Kinesis Data Streams and to present data as a materialized view.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-21' style=';'><div id='questionWrap-21'  class='   watupro-question-id-458736'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>A company currently stores all of its data in Amazon S3 by using the S3 Standard storage class. <br \/>\r<br>A data engineer examined data access patterns to identify trends. During the first 6 months, most data files are accessed several times each day. Between 6 months and 2 years, most data files are accessed once or twice each month. After 2 years, data files are accessed only once or twice each year. <br \/>\r<br>The data engineer needs to use an S3 Lifecycle policy to develop new data storage rules. The new storage solution must continue to provide high availability. <br \/>\r<br>Which solution will meet these requirements in the MOST cost-effective way?<\/div><input type='hidden' name='question_id[]' id='qID_21' value='458736' \/><input type='hidden' id='answerType458736' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458736[]' id='answer-id-1773321' class='answer   answerof-458736 ' value='1773321'   \/><label for='answer-id-1773321' id='answer-label-1773321' class=' answer'><span>Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months. Transfer objects to S3 Glacier Flexible Retrieval after 2 years.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458736[]' id='answer-id-1773322' class='answer   answerof-458736 ' value='1773322'   \/><label for='answer-id-1773322' id='answer-label-1773322' class=' answer'><span>Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months. Transfer objects to S3 Glacier Flexible Retrieval after 2 years.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458736[]' id='answer-id-1773323' class='answer   answerof-458736 ' value='1773323'   \/><label for='answer-id-1773323' id='answer-label-1773323' class=' answer'><span>Transition objects to S3 Standard-Infrequent Access (S3 Standard-IA) after 6 months. Transfer objects to S3 Glacier Deep Archive after 2 years.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458736[]' id='answer-id-1773324' class='answer   answerof-458736 ' value='1773324'   \/><label for='answer-id-1773324' id='answer-label-1773324' class=' answer'><span>Transition objects to S3 One Zone-Infrequent Access (S3 One Zone-IA) after 6 months. Transfer objects to S3 Glacier Deep Archive after 2 years.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-22' style=';'><div id='questionWrap-22'  class='   watupro-question-id-458737'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>A company needs to partition the Amazon S3 storage that the company uses for a data lake. <br \/>\r<br>The partitioning will use a path of the S3 object keys in the following format: s3:\/\/bucket\/prefix\/year=2023\/month=01\/day=01. <br \/>\r<br>A data engineer must ensure that the AWS Glue Data Catalog synchronizes with the S3 storage when the company adds new partitions to the bucket. <br \/>\r<br>Which solution will meet these requirements with the LEAST latency?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='458737' \/><input type='hidden' id='answerType458737' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458737[]' id='answer-id-1773325' class='answer   answerof-458737 ' value='1773325'   \/><label for='answer-id-1773325' id='answer-label-1773325' class=' answer'><span>Schedule an AWS Glue crawler to run every morning.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458737[]' id='answer-id-1773326' class='answer   answerof-458737 ' value='1773326'   \/><label for='answer-id-1773326' id='answer-label-1773326' class=' answer'><span>Manually run the AWS Glue CreatePartition API twice each day.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458737[]' id='answer-id-1773327' class='answer   answerof-458737 ' value='1773327'   \/><label for='answer-id-1773327' id='answer-label-1773327' class=' answer'><span>Use code that writes data to Amazon S3 to invoke the Boto3 AWS Glue create partition API call.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458737[]' id='answer-id-1773328' class='answer   answerof-458737 ' value='1773328'   \/><label for='answer-id-1773328' id='answer-label-1773328' class=' answer'><span>Run the MSCK REPAIR TABLE command from the AWS Glue console.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-23' style=';'><div id='questionWrap-23'  class='   watupro-question-id-458738'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account. <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='458738' \/><input type='hidden' id='answerType458738' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458738[]' id='answer-id-1773329' class='answer   answerof-458738 ' value='1773329'   \/><label for='answer-id-1773329' id='answer-label-1773329' class=' answer'><span>Create an S3 bucket for each use case. Create an S3 bucket policy that grants permissions to appropriate individual IAM users. Apply the S3 bucket policy to the S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458738[]' id='answer-id-1773330' class='answer   answerof-458738 ' value='1773330'   \/><label for='answer-id-1773330' id='answer-label-1773330' class=' answer'><span>Create an Athena workgroup for each use case. Apply tags to the workgroup. Create an 1AM policy that uses the tags to apply appropriate permissions to the workgroup.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458738[]' id='answer-id-1773331' class='answer   answerof-458738 ' value='1773331'   \/><label for='answer-id-1773331' id='answer-label-1773331' class=' answer'><span>Create an JAM role for each use case. Assign appropriate permissions to the role for each use case. \r\nAssociate the role with Athena.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458738[]' id='answer-id-1773332' class='answer   answerof-458738 ' value='1773332'   \/><label for='answer-id-1773332' id='answer-label-1773332' class=' answer'><span>Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case. Apply the resource policy to the specific tables that Athena uses.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-24' style=';'><div id='questionWrap-24'  class='   watupro-question-id-458739'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file. <br \/>\r<br>Which Step Functions state should the data engineer use to meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_24' value='458739' \/><input type='hidden' id='answerType458739' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458739[]' id='answer-id-1773333' class='answer   answerof-458739 ' value='1773333'   \/><label for='answer-id-1773333' id='answer-label-1773333' class=' answer'><span>Parallel state<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458739[]' id='answer-id-1773334' class='answer   answerof-458739 ' value='1773334'   \/><label for='answer-id-1773334' id='answer-label-1773334' class=' answer'><span>Choice state<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458739[]' id='answer-id-1773335' class='answer   answerof-458739 ' value='1773335'   \/><label for='answer-id-1773335' id='answer-label-1773335' class=' answer'><span>Map state<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458739[]' id='answer-id-1773336' class='answer   answerof-458739 ' value='1773336'   \/><label for='answer-id-1773336' id='answer-label-1773336' class=' answer'><span>Wait state<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-25' style=';'><div id='questionWrap-25'  class='   watupro-question-id-458740'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>A company is planning to upgrade its Amazon Elastic Block Store (Amazon EBS) General Purpose SSD storage from gp2 to gp3. The company wants to prevent any interruptions in its Amazon EC2 instances that will cause data loss during the migration to the upgraded storage. <br \/>\r<br>Which solution will meet these requirements with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_25' value='458740' \/><input type='hidden' id='answerType458740' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458740[]' id='answer-id-1773337' class='answer   answerof-458740 ' value='1773337'   \/><label for='answer-id-1773337' id='answer-label-1773337' class=' answer'><span>Create snapshots of the gp2 volumes. Create new gp3 volumes from the snapshots. Attach the new gp3 volumes to the EC2 instances.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458740[]' id='answer-id-1773338' class='answer   answerof-458740 ' value='1773338'   \/><label for='answer-id-1773338' id='answer-label-1773338' class=' answer'><span>Create new gp3 volumes. Gradually transfer the data to the new gp3 volumes. When the transfer is complete, mount the new gp3 volumes to the EC2 instances to replace the gp2 volumes.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458740[]' id='answer-id-1773339' class='answer   answerof-458740 ' value='1773339'   \/><label for='answer-id-1773339' id='answer-label-1773339' class=' answer'><span>Change the volume type of the existing gp2 volumes to gp3. Enter new values for volume size, IOPS, and throughput.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458740[]' id='answer-id-1773340' class='answer   answerof-458740 ' value='1773340'   \/><label for='answer-id-1773340' id='answer-label-1773340' class=' answer'><span>Use AWS DataSync to create new gp3 volumes. Transfer the data from the original gp2 volumes to the new gp3 volumes.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-26' style=';'><div id='questionWrap-26'  class='   watupro-question-id-458741'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>A company has a production AWS account that runs company workloads. The company's security <br \/>\r<br>team created a security AWS account to store and analyze security logs from the production AWS account. The security logs in the production AWS account are stored in Amazon CloudWatch Logs. <br \/>\r<br>The company needs to use Amazon Kinesis Data Streams to deliver the security logs to the security AWS account. <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_26' value='458741' \/><input type='hidden' id='answerType458741' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458741[]' id='answer-id-1773341' class='answer   answerof-458741 ' value='1773341'   \/><label for='answer-id-1773341' id='answer-label-1773341' class=' answer'><span>Create a destination data stream in the production AWS account. In the security AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the production AWS account.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458741[]' id='answer-id-1773342' class='answer   answerof-458741 ' value='1773342'   \/><label for='answer-id-1773342' id='answer-label-1773342' class=' answer'><span>Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the security AWS account.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458741[]' id='answer-id-1773343' class='answer   answerof-458741 ' value='1773343'   \/><label for='answer-id-1773343' id='answer-label-1773343' class=' answer'><span>Create a destination data stream in the production AWS account. In the production AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the security AWS account.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458741[]' id='answer-id-1773344' class='answer   answerof-458741 ' value='1773344'   \/><label for='answer-id-1773344' id='answer-label-1773344' class=' answer'><span>Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the production AWS account.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-27' style=';'><div id='questionWrap-27'  class='   watupro-question-id-458742'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>A company uses Amazon Redshift for its data warehouse. The company must automate refresh schedules for Amazon Redshift materialized views. <br \/>\r<br>Which solution will meet this requirement with the LEAST effort?<\/div><input type='hidden' name='question_id[]' id='qID_27' value='458742' \/><input type='hidden' id='answerType458742' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458742[]' id='answer-id-1773345' class='answer   answerof-458742 ' value='1773345'   \/><label for='answer-id-1773345' id='answer-label-1773345' class=' answer'><span>Use Apache Airflow to refresh the materialized views.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458742[]' id='answer-id-1773346' class='answer   answerof-458742 ' value='1773346'   \/><label for='answer-id-1773346' id='answer-label-1773346' class=' answer'><span>Use an AWS Lambda user-defined function (UDF) within Amazon Redshift to refresh the materialized views.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458742[]' id='answer-id-1773347' class='answer   answerof-458742 ' value='1773347'   \/><label for='answer-id-1773347' id='answer-label-1773347' class=' answer'><span>Use the query editor v2 in Amazon Redshift to refresh the materialized views.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458742[]' id='answer-id-1773348' class='answer   answerof-458742 ' value='1773348'   \/><label for='answer-id-1773348' id='answer-label-1773348' class=' answer'><span>Use an AWS Glue workflow to refresh the materialized views.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-28' style=';'><div id='questionWrap-28'  class='   watupro-question-id-458743'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>A company stores details about transactions in an Amazon S3 bucket. The company wants to log all writes to the S3 bucket into another S3 bucket that is in the same AWS Region. <br \/>\r<br>Which solution will meet this requirement with the LEAST operational effort?<\/div><input type='hidden' name='question_id[]' id='qID_28' value='458743' \/><input type='hidden' id='answerType458743' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458743[]' id='answer-id-1773349' class='answer   answerof-458743 ' value='1773349'   \/><label for='answer-id-1773349' id='answer-label-1773349' class=' answer'><span>Configure an S3 Event Notifications rule for all activities on the transactions S3 bucket to invoke an AWS Lambda function. Program the Lambda function to write the event to Amazon Kinesis Data Firehose. Configure Kinesis Data Firehose to write the event to the logs S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458743[]' id='answer-id-1773350' class='answer   answerof-458743 ' value='1773350'   \/><label for='answer-id-1773350' id='answer-label-1773350' class=' answer'><span>Create a trail of management events in AWS CloudTrai<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458743[]' id='answer-id-1773351' class='answer   answerof-458743 ' value='1773351'   \/><label for='answer-id-1773351' id='answer-label-1773351' class=' answer'><span>Configure the trail to receive data from the transactions S3 bucket. Specify an empty prefix and write-only events. Specify the logs S3 bucket as the destination bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458743[]' id='answer-id-1773352' class='answer   answerof-458743 ' value='1773352'   \/><label for='answer-id-1773352' id='answer-label-1773352' class=' answer'><span>Configure an S3 Event Notifications rule for all activities on the transactions S3 bucket to invoke an AWS Lambda function. Program the Lambda function to write the events to the logs S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458743[]' id='answer-id-1773353' class='answer   answerof-458743 ' value='1773353'   \/><label for='answer-id-1773353' id='answer-label-1773353' class=' answer'><span>Create a trail of data events in AWS CloudTrai<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458743[]' id='answer-id-1773354' class='answer   answerof-458743 ' value='1773354'   \/><label for='answer-id-1773354' id='answer-label-1773354' class=' answer'><span>Configure the trail to receive data from the transactions S3 bucket. Specify an empty prefix and write-only events. Specify the logs S3 bucket as the destination bucket.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-29' style=';'><div id='questionWrap-29'  class='   watupro-question-id-458744'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>A company stores daily records of the financial performance of investment portfolios in .csv format in an Amazon S3 bucket. A data engineer uses AWS Glue crawlers to crawl the S3 data. <br \/>\r<br>The data engineer must make the S3 data accessible daily in the AWS Glue Data Catalog. <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='458744' \/><input type='hidden' id='answerType458744' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458744[]' id='answer-id-1773355' class='answer   answerof-458744 ' value='1773355'   \/><label for='answer-id-1773355' id='answer-label-1773355' class=' answer'><span>Create an IAM role that includes the AmazonS3FullAccess policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Create a daily schedule to run the crawler. Configure the output destination to a new path in the existing S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458744[]' id='answer-id-1773356' class='answer   answerof-458744 ' value='1773356'   \/><label for='answer-id-1773356' id='answer-label-1773356' class=' answer'><span>Create an IAM role that includes the AWS Glue Service Role policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Create a daily schedule to run the crawler. Specify a database name for the output.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458744[]' id='answer-id-1773357' class='answer   answerof-458744 ' value='1773357'   \/><label for='answer-id-1773357' id='answer-label-1773357' class=' answer'><span>Create an IAM role that includes the AmazonS3FullAccess policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Allocate data processing units (DPUs) to run the crawler every day. Specify a database name for the output.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458744[]' id='answer-id-1773358' class='answer   answerof-458744 ' value='1773358'   \/><label for='answer-id-1773358' id='answer-label-1773358' class=' answer'><span>Create an IAM role that includes the AWS Glue Service Role policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler's data store. Allocate data processing units (DPUs) to run the crawler every day. Configure the output destination to a new path in the existing S3 bucket.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-30' style=';'><div id='questionWrap-30'  class='   watupro-question-id-458745'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>A data engineer must ingest a source of structured data that is in .csv format into an Amazon S3 data lake. The .csv files contain 15 columns. Data analysts need to run Amazon Athena queries on one or two columns of the dataset. The data analysts rarely query the entire file. <br \/>\r<br>Which solution will meet these requirements MOST cost-effectively?<\/div><input type='hidden' name='question_id[]' id='qID_30' value='458745' \/><input type='hidden' id='answerType458745' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458745[]' id='answer-id-1773359' class='answer   answerof-458745 ' value='1773359'   \/><label for='answer-id-1773359' id='answer-label-1773359' class=' answer'><span>Use an AWS Glue PySpark job to ingest the source data into the data lake in .csv format.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458745[]' id='answer-id-1773360' class='answer   answerof-458745 ' value='1773360'   \/><label for='answer-id-1773360' id='answer-label-1773360' class=' answer'><span>Create an AWS Glue extract, transform, and load (ETL) job to read from the .csv structured data source. Configure the job to ingest the data into the data lake in JSON format.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458745[]' id='answer-id-1773361' class='answer   answerof-458745 ' value='1773361'   \/><label for='answer-id-1773361' id='answer-label-1773361' class=' answer'><span>Use an AWS Glue PySpark job to ingest the source data into the data lake in Apache Avro format.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458745[]' id='answer-id-1773362' class='answer   answerof-458745 ' value='1773362'   \/><label for='answer-id-1773362' id='answer-label-1773362' class=' answer'><span>Create an AWS Glue extract, transform, and load (ETL) job to read from the .csv structured data source. Configure the job to write the data into the data lake in Apache Parquet format.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-31' style=';'><div id='questionWrap-31'  class='   watupro-question-id-458746'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/span>A company is building a data stream processing application. The application runs in an Amazon Elastic Kubernetes Service (Amazon EKS) cluster. The application stores processed data in an Amazon DynamoDB table. <br \/>\r<br>The company needs the application containers in the EKS cluster to have secure access to the DynamoDB table. The company does not want to embed AWS credentials in the containers. <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_31' value='458746' \/><input type='hidden' id='answerType458746' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458746[]' id='answer-id-1773363' class='answer   answerof-458746 ' value='1773363'   \/><label for='answer-id-1773363' id='answer-label-1773363' class=' answer'><span>Store the AWS credentials in an Amazon S3 bucket. Grant the EKS containers access to the S3 bucket to retrieve the credentials.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458746[]' id='answer-id-1773364' class='answer   answerof-458746 ' value='1773364'   \/><label for='answer-id-1773364' id='answer-label-1773364' class=' answer'><span>Attach an IAM role to the EKS worker nodes. Grant the IAM role access to DynamoD<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458746[]' id='answer-id-1773365' class='answer   answerof-458746 ' value='1773365'   \/><label for='answer-id-1773365' id='answer-label-1773365' class=' answer'><span>Use the IAM role to set up IAM roles service accounts (IRSA) functionality.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458746[]' id='answer-id-1773366' class='answer   answerof-458746 ' value='1773366'   \/><label for='answer-id-1773366' id='answer-label-1773366' class=' answer'><span>Create an IAM user that has an access key to access the DynamoDB table. Use environment variables in the EKS containers to store the IAM user access key data.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458746[]' id='answer-id-1773367' class='answer   answerof-458746 ' value='1773367'   \/><label for='answer-id-1773367' id='answer-label-1773367' class=' answer'><span>Create an IAM user that has an access key to access the DynamoDB table. Use Kubernetes secrets that are mounted in a volume of the EKS cluster nodes to store the user access key data.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-32' style=';'><div id='questionWrap-32'  class='   watupro-question-id-458747'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/span>A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3. <br \/>\r<br>Which actions will provide the FASTEST queries? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_32' value='458747' \/><input type='hidden' id='answerType458747' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458747[]' id='answer-id-1773368' class='answer   answerof-458747 ' value='1773368'   \/><label for='answer-id-1773368' id='answer-label-1773368' class=' answer'><span>Use gzip compression to compress individual files to sizes that are between 1 GB and 5 G<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458747[]' id='answer-id-1773369' class='answer   answerof-458747 ' value='1773369'   \/><label for='answer-id-1773369' id='answer-label-1773369' class=' answer'><span>Use a columnar storage file format.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458747[]' id='answer-id-1773370' class='answer   answerof-458747 ' value='1773370'   \/><label for='answer-id-1773370' id='answer-label-1773370' class=' answer'><span>Partition the data based on the most common query predicates.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458747[]' id='answer-id-1773371' class='answer   answerof-458747 ' value='1773371'   \/><label for='answer-id-1773371' id='answer-label-1773371' class=' answer'><span>Split the data into files that are less than 10 K<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-458747[]' id='answer-id-1773372' class='answer   answerof-458747 ' value='1773372'   \/><label for='answer-id-1773372' id='answer-label-1773372' class=' answer'><span>Use file formats that are not<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-33' style=';'><div id='questionWrap-33'  class='   watupro-question-id-458748'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/span>A data engineer is using Amazon Athena to analyze sales data that is in Amazon S3. The data engineer writes a query to retrieve sales amounts for 2023 for several products from a table named sales_data. However, the query does not return results for all of the products that are in the sales_data table. The data engineer needs to troubleshoot the query to resolve the issue. <br \/>\r<br>The data engineer's original query is as follows: <br \/>\r<br>SELECT product_name, sum(sales_amount) <br \/>\r<br>FROM sales_data <br \/>\r<br>WHERE year = 2023 <br \/>\r<br>GROUP BY product_name <br \/>\r<br>How should the data engineer modify the Athena query to meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_33' value='458748' \/><input type='hidden' id='answerType458748' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458748[]' id='answer-id-1773373' class='answer   answerof-458748 ' value='1773373'   \/><label for='answer-id-1773373' id='answer-label-1773373' class=' answer'><span>Replace sum(sales amount) with count(*J for the aggregation.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458748[]' id='answer-id-1773374' class='answer   answerof-458748 ' value='1773374'   \/><label for='answer-id-1773374' id='answer-label-1773374' class=' answer'><span>Change WHERE year = 2023 to WHERE extractlyear FROM sales data) = 2023.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458748[]' id='answer-id-1773375' class='answer   answerof-458748 ' value='1773375'   \/><label for='answer-id-1773375' id='answer-label-1773375' class=' answer'><span>Add HAVING sumfsales amount) &gt; 0 after the GROUP BY clause.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458748[]' id='answer-id-1773376' class='answer   answerof-458748 ' value='1773376'   \/><label for='answer-id-1773376' id='answer-label-1773376' class=' answer'><span>Remove the GROUP BY clause<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-34' style=';'><div id='questionWrap-34'  class='   watupro-question-id-458749'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>A company extracts approximately 1 TB of data every day from data sources such as SAP HANA, <br \/>\r<br>Microsoft SQL Server, MongoDB, Apache Kafka, and Amazon DynamoDB. Some of the data sources have undefined data schemas or data schemas that change. <br \/>\r<br>A data engineer must implement a solution that can detect the schema for these data sources. The solution must extract, transform, and load the data to an Amazon S3 bucket. The company has a service level agreement (SLA) to load the data into the S3 bucket within 15 minutes of data creation. <br \/>\r<br>Which solution will meet these requirements with the LEAST operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_34' value='458749' \/><input type='hidden' id='answerType458749' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458749[]' id='answer-id-1773377' class='answer   answerof-458749 ' value='1773377'   \/><label for='answer-id-1773377' id='answer-label-1773377' class=' answer'><span>Use Amazon EMR to detect the schema and to extract, transform, and load the data into the S3 bucket. Create a pipeline in Apache Spark.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458749[]' id='answer-id-1773378' class='answer   answerof-458749 ' value='1773378'   \/><label for='answer-id-1773378' id='answer-label-1773378' class=' answer'><span>Use AWS Glue to detect the schema and to extract, transform, and load the data into the S3 bucket. Create a pipeline in Apache Spark.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458749[]' id='answer-id-1773379' class='answer   answerof-458749 ' value='1773379'   \/><label for='answer-id-1773379' id='answer-label-1773379' class=' answer'><span>Create a PvSpark proqram in AWS Lambda to extract, transform, and load the data into the S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458749[]' id='answer-id-1773380' class='answer   answerof-458749 ' value='1773380'   \/><label for='answer-id-1773380' id='answer-label-1773380' class=' answer'><span>Create a stored procedure in Amazon Redshift to detect the schema and to extract, transform, and load the data into a Redshift Spectrum table. Access the table from Amazon S3.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-35' style=';'><div id='questionWrap-35'  class='   watupro-question-id-458750'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>35. <\/span>A banking company uses an application to collect large volumes of transactional data. The company uses Amazon Kinesis Data Streams for real-time analytics. The company's application uses the PutRecord action to send data to Kinesis Data Streams. <br \/>\r<br>A data engineer has observed network outages during certain times of day. The data engineer wants to configure exactly-once delivery for the entire processing pipeline. <br \/>\r<br>Which solution will meet this requirement?<\/div><input type='hidden' name='question_id[]' id='qID_35' value='458750' \/><input type='hidden' id='answerType458750' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458750[]' id='answer-id-1773381' class='answer   answerof-458750 ' value='1773381'   \/><label for='answer-id-1773381' id='answer-label-1773381' class=' answer'><span>Design the application so it can remove duplicates during processing by embedding a unique ID in each record at the source.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458750[]' id='answer-id-1773382' class='answer   answerof-458750 ' value='1773382'   \/><label for='answer-id-1773382' id='answer-label-1773382' class=' answer'><span>Update the checkpoint configuration of the Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) data collection application to avoid duplicate processing of events.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458750[]' id='answer-id-1773383' class='answer   answerof-458750 ' value='1773383'   \/><label for='answer-id-1773383' id='answer-label-1773383' class=' answer'><span>Design the data source so events are not ingested into Kinesis Data Streams multiple times.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458750[]' id='answer-id-1773384' class='answer   answerof-458750 ' value='1773384'   \/><label for='answer-id-1773384' id='answer-label-1773384' class=' answer'><span>Stop using Kinesis Data Streams. Use Amazon EMR instead. Use Apache Flink and Apache Spark \r\nStreaming in Amazon EM<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-36' style=';'><div id='questionWrap-36'  class='   watupro-question-id-458751'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>36. <\/span>A company stores data from an application in an Amazon DynamoDB table that operates in provisioned capacity mode. The workloads of the application have predictable throughput load on a regular schedule. Every Monday, there is an immediate increase in activity early in the morning. The application has very low usage during weekends. <br \/>\r<br>The company must ensure that the application performs consistently during peak usage times. <br \/>\r<br>Which solution will meet these requirements in the MOST cost-effective way?<\/div><input type='hidden' name='question_id[]' id='qID_36' value='458751' \/><input type='hidden' id='answerType458751' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458751[]' id='answer-id-1773385' class='answer   answerof-458751 ' value='1773385'   \/><label for='answer-id-1773385' id='answer-label-1773385' class=' answer'><span>Increase the provisioned capacity to the maximum capacity that is currently present during peak load times.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458751[]' id='answer-id-1773386' class='answer   answerof-458751 ' value='1773386'   \/><label for='answer-id-1773386' id='answer-label-1773386' class=' answer'><span>Divide the table into two tables. Provision each table with half of the provisioned capacity of the original table. Spread queries evenly across both tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458751[]' id='answer-id-1773387' class='answer   answerof-458751 ' value='1773387'   \/><label for='answer-id-1773387' id='answer-label-1773387' class=' answer'><span>Use AWS Application Auto Scaling to schedule higher provisioned capacity for peak usage times. \r\nSchedule lower capacity during off-peak times.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458751[]' id='answer-id-1773388' class='answer   answerof-458751 ' value='1773388'   \/><label for='answer-id-1773388' id='answer-label-1773388' class=' answer'><span>Change the capacity mode from provisioned to on-demand. Configure the table to scale up and scale down based on the load on the table.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-37' style=';'><div id='questionWrap-37'  class='   watupro-question-id-458752'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>37. <\/span>A company loads transaction data for each day into Amazon Redshift tables at the end of each day. The company wants to have the ability to track which tables have been loaded and which tables still need to be loaded. <br \/>\r<br>A data engineer wants to store the load statuses of Redshift tables in an Amazon DynamoDB table. The data engineer creates an AWS Lambda function to publish the details of the load statuses to DynamoDB. <br \/>\r<br>How should the data engineer invoke the Lambda function to write load statuses to the DynamoDB table?<\/div><input type='hidden' name='question_id[]' id='qID_37' value='458752' \/><input type='hidden' id='answerType458752' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458752[]' id='answer-id-1773389' class='answer   answerof-458752 ' value='1773389'   \/><label for='answer-id-1773389' id='answer-label-1773389' class=' answer'><span>Use a second Lambda function to invoke the first Lambda function based on Amazon CloudWatch events.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458752[]' id='answer-id-1773390' class='answer   answerof-458752 ' value='1773390'   \/><label for='answer-id-1773390' id='answer-label-1773390' class=' answer'><span>Use the Amazon Redshift Data API to publish an event to Amazon EventBridqe. Configure an EventBridge rule to invoke the Lambda function.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458752[]' id='answer-id-1773391' class='answer   answerof-458752 ' value='1773391'   \/><label for='answer-id-1773391' id='answer-label-1773391' class=' answer'><span>Use the Amazon Redshift Data API to publish a message to an Amazon Simple Queue Service (Amazon SQS) queue. Configure the SQS queue to invoke the Lambda function.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458752[]' id='answer-id-1773392' class='answer   answerof-458752 ' value='1773392'   \/><label for='answer-id-1773392' id='answer-label-1773392' class=' answer'><span>Use a second Lambda function to invoke the first Lambda function based on AWS CloudTrail events.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-38' style=';'><div id='questionWrap-38'  class='   watupro-question-id-458753'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>38. <\/span>A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joins across multiple tables. The data must be in Apache Parquet format. The analytics team must store the data in Amazon S3. <br \/>\r<br>Which solution will meet these requirements in the MOST operationally efficient way?<\/div><input type='hidden' name='question_id[]' id='qID_38' value='458753' \/><input type='hidden' id='answerType458753' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458753[]' id='answer-id-1773393' class='answer   answerof-458753 ' value='1773393'   \/><label for='answer-id-1773393' id='answer-label-1773393' class=' answer'><span>Create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create an AWS Glue job that selects the data directly from the view and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458753[]' id='answer-id-1773394' class='answer   answerof-458753 ' value='1773394'   \/><label for='answer-id-1773394' id='answer-label-1773394' class=' answer'><span>Schedule SQL Server Agent to run a daily SQL query that selects the desired data elements from the EC2 instance-based SQL Server databases. Configure the query to direct the output .csv objects to an S3 bucket. Create an S3 event that invokes an AWS Lambda function to transform the output format from .csv to Parquet.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458753[]' id='answer-id-1773395' class='answer   answerof-458753 ' value='1773395'   \/><label for='answer-id-1773395' id='answer-label-1773395' class=' answer'><span>Use a SQL query to create a view in the EC2 instance-based SQL Server databases that contains the required data elements. Create and run an AWS Glue crawler to read the view. Create an AWS Glue job that retrieves the data and transfers the data in Parquet format to an S3 bucket. Schedule the AWS Glue job to run every day.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458753[]' id='answer-id-1773396' class='answer   answerof-458753 ' value='1773396'   \/><label for='answer-id-1773396' id='answer-label-1773396' class=' answer'><span>Create an AWS Lambda function that queries the EC2 instance-based databases by using Java Database Connectivity (JDBC). Configure the Lambda function to retrieve the required data, transform the data into Parquet format, and transfer the data into an S3 bucket. Use Amazon EventBridge to schedule the Lambda function to run every day.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-39' style=';'><div id='questionWrap-39'  class='   watupro-question-id-458754'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>39. <\/span>A retail company is expanding its operations globally. The company needs to use Amazon QuickSight to accurately calculate currency exchange rates for financial reports. The company has an existing dashboard that includes a visual that is based on an analysis of a dataset that contains global currency values and exchange rates. <br \/>\r<br>A data engineer needs to ensure that exchange rates are calculated with a precision of four decimal places. The calculations must be precomputed. The data engineer must materialize results in QuickSight super-fast, parallel, in-memory calculation engine (SPICE). <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_39' value='458754' \/><input type='hidden' id='answerType458754' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458754[]' id='answer-id-1773397' class='answer   answerof-458754 ' value='1773397'   \/><label for='answer-id-1773397' id='answer-label-1773397' class=' answer'><span>Define and create the calculated field in the dataset.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458754[]' id='answer-id-1773398' class='answer   answerof-458754 ' value='1773398'   \/><label for='answer-id-1773398' id='answer-label-1773398' class=' answer'><span>Define and create the calculated field in the analysis.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458754[]' id='answer-id-1773399' class='answer   answerof-458754 ' value='1773399'   \/><label for='answer-id-1773399' id='answer-label-1773399' class=' answer'><span>Define and create the calculated field in the visual.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458754[]' id='answer-id-1773400' class='answer   answerof-458754 ' value='1773400'   \/><label for='answer-id-1773400' id='answer-label-1773400' class=' answer'><span>Define and create the calculated field in the dashboard.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-40' style=';'><div id='questionWrap-40'  class='   watupro-question-id-458755'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>40. <\/span>A data engineering team is using an Amazon Redshift data warehouse for operational reporting. The team wants to prevent performance issues that might result from long- running queries. A data engineer must choose a system table in Amazon Redshift to record anomalies when a query optimizer identifies conditions that might indicate performance issues. <br \/>\r<br>Which table views should the data engineer use to meet this requirement?<\/div><input type='hidden' name='question_id[]' id='qID_40' value='458755' \/><input type='hidden' id='answerType458755' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458755[]' id='answer-id-1773401' class='answer   answerof-458755 ' value='1773401'   \/><label for='answer-id-1773401' id='answer-label-1773401' class=' answer'><span>STL USAGE CONTROL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458755[]' id='answer-id-1773402' class='answer   answerof-458755 ' value='1773402'   \/><label for='answer-id-1773402' id='answer-label-1773402' class=' answer'><span>STL ALERT EVENT LOG<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458755[]' id='answer-id-1773403' class='answer   answerof-458755 ' value='1773403'   \/><label for='answer-id-1773403' id='answer-label-1773403' class=' answer'><span>STL QUERY METRICS<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-458755[]' id='answer-id-1773404' class='answer   answerof-458755 ' value='1773404'   \/><label for='answer-id-1773404' id='answer-label-1773404' class=' answer'><span>STL PLAN INFO<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-41'>\n\t<div class='question-content'>\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading...\" title=\"Loading...\" \/>&nbsp;Loading...\t<\/div>\n<\/div>\n\n<br \/>\n\t\n\t\t\t<div class=\"watupro_buttons flex \" id=\"watuPROButtons11692\" >\n\t\t  <div id=\"prev-question\" style=\"display:none;\"><input type=\"button\" value=\"&lt; Previous\" onclick=\"WatuPRO.nextQuestion(event, 'previous');\"\/><\/div>\t\t  \t\t  \t\t   \n\t\t   \t  \t\t<div><input type=\"button\" name=\"action\" class=\"watupro-submit-button\" onclick=\"WatuPRO.submitResult(event)\" id=\"action-button\" value=\"View Results\"  \/>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<input type=\"hidden\" name=\"quiz_id\" value=\"11692\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-25 04:15:47\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1779682547\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"458716:1773230,1773231,1773232,1773233,1773234,1773235,1773236,1773237,1773238,1773239 | 458717:1773240,1773241,1773242,1773243,1773244,1773245,1773246 | 458718:1773247,1773248,1773249,1773250,1773251 | 458719:1773252,1773253,1773254,1773255 | 458720:1773256,1773257,1773258,1773259 | 458721:1773260,1773261,1773262,1773263 | 458722:1773264,1773265,1773266,1773267 | 458723:1773268,1773269,1773270,1773271 | 458724:1773272,1773273,1773274,1773275,1773276 | 458725:1773277,1773278,1773279,1773280 | 458726:1773281,1773282,1773283,1773284 | 458727:1773285,1773286,1773287,1773288 | 458728:1773289,1773290,1773291,1773292 | 458729:1773293,1773294,1773295,1773296 | 458730:1773297,1773298,1773299,1773300 | 458731:1773301,1773302,1773303,1773304 | 458732:1773305,1773306,1773307,1773308 | 458733:1773309,1773310,1773311,1773312 | 458734:1773313,1773314,1773315,1773316 | 458735:1773317,1773318,1773319,1773320 | 458736:1773321,1773322,1773323,1773324 | 458737:1773325,1773326,1773327,1773328 | 458738:1773329,1773330,1773331,1773332 | 458739:1773333,1773334,1773335,1773336 | 458740:1773337,1773338,1773339,1773340 | 458741:1773341,1773342,1773343,1773344 | 458742:1773345,1773346,1773347,1773348 | 458743:1773349,1773350,1773351,1773352,1773353,1773354 | 458744:1773355,1773356,1773357,1773358 | 458745:1773359,1773360,1773361,1773362 | 458746:1773363,1773364,1773365,1773366,1773367 | 458747:1773368,1773369,1773370,1773371,1773372 | 458748:1773373,1773374,1773375,1773376 | 458749:1773377,1773378,1773379,1773380 | 458750:1773381,1773382,1773383,1773384 | 458751:1773385,1773386,1773387,1773388 | 458752:1773389,1773390,1773391,1773392 | 458753:1773393,1773394,1773395,1773396 | 458754:1773397,1773398,1773399,1773400 | 458755:1773401,1773402,1773403,1773404\" \/>\n\t<input type=\"hidden\" name=\"no_ajax\" value=\"0\">\t\t\t<\/form>\n\t<p>&nbsp;<\/p>\n<\/div>\n\n<script type=\"text\/javascript\">\n\/\/jQuery(document).ready(function(){\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \t\nvar question_ids = \"458716,458717,458718,458719,458720,458721,458722,458723,458724,458725,458726,458727,458728,458729,458730,458731,458732,458733,458734,458735,458736,458737,458738,458739,458740,458741,458742,458743,458744,458745,458746,458747,458748,458749,458750,458751,458752,458753,458754,458755\";\nWatuPROSettings[11692] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 11692;\t    \nWatuPRO.post_id = 123066;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.16596500 1779682547\";\nvar url = \"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/show_exam.php\";\nWatuPRO.examMode = 1;\nWatuPRO.siteURL=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-admin\/admin-ajax.php\";\nWatuPRO.emailIsNotRequired = 0;\nWatuPROIntel.init(11692);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Continue to check the <em><a href=\"https:\/\/www.dumpsbase.com\/freedumps\/current-amazon-dea-c01-dumps-v12-02-are-available-for-your-certification-continue-to-read-dea-c01-free-dumps-part-2-q41-q90-today.html\">Amazon DEA-C01 free dumps (Part 2, Q41-Q90) of V12.02<\/a><\/em> here.<\/strong><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>You can pass the AWS Certified Data Engineer &#8211; Associate (DEA-C01) exam smoothly with the most updated resource. The Amazon DEA-C01 exam guide (V12.02) is available at DumpsBase with 231 practice questions and answers, reflecting the latest AWS Certified Data Engineer &#8211; Associate exam objectives and real-world scenarios. These Q&amp;As are comprehensive, which are available [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[175,18249],"tags":[18538],"class_list":["post-123066","post","type-post","status-publish","format-standard","hentry","category-amazon","category-data-engineer-associate","tag-aws-certified-data-engineer-associate-dea-c01"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/123066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/comments?post=123066"}],"version-history":[{"count":4,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/123066\/revisions"}],"predecessor-version":[{"id":125769,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/123066\/revisions\/125769"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=123066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=123066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=123066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}