{"id":56013,"date":"2023-04-25T02:48:23","date_gmt":"2023-04-25T02:48:23","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=56013"},"modified":"2023-04-25T02:48:29","modified_gmt":"2023-04-25T02:48:29","slug":"aws-certified-database-specialty-dbs-c01-exam-introduction","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/aws-certified-database-specialty-dbs-c01-exam-introduction.html","title":{"rendered":"AWS Certified Database &#8211; Specialty (DBS-C01) Exam Introduction"},"content":{"rendered":"\n<p>The AWS Certified Database &#8211; Specialty (DBS-C01) exam is designed for database practitioners who have at least two years of hands-on experience with AWS database services and solutions. The exam is a multiple-choice and multiple-answer test that lasts 180 minutes. You can take the exam online or at a testing center. The exam fee is $300 USD. You need to score at least 750 out of 1000 to pass the exam. It is intended for individuals who perform a database-focused role. This exam validates your comprehensive understanding of databases, including the concepts of design, migration, deployment, access, maintenance, automation, monitoring, security, and troubleshooting.<\/p>\n<h2>AWS Certified Database &#8211; Specialty <em><span style=\"background-color: #99cc00;\">DBS-C01 Free Demo<\/span><\/em> Below<\/h2>\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=\"submittingExam7155\" 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-7155\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-7155\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-260382'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected. <br \/>\r<br>What is the MOST likely reason that the items are not being deleted?<\/div><input type='hidden' name='question_id[]' id='qID_1' value='260382' \/><input type='hidden' id='answerType260382' 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-260382[]' id='answer-id-1027394' class='answer   answerof-260382 ' value='1027394'   \/><label for='answer-id-1027394' id='answer-label-1027394' class=' answer'><span>The TTL attribute's value is set as a Number data type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260382[]' id='answer-id-1027395' class='answer   answerof-260382 ' value='1027395'   \/><label for='answer-id-1027395' id='answer-label-1027395' class=' answer'><span>The TTL attribute's value is set as a Binary data type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260382[]' id='answer-id-1027396' class='answer   answerof-260382 ' value='1027396'   \/><label for='answer-id-1027396' id='answer-label-1027396' class=' answer'><span>The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260382[]' id='answer-id-1027397' class='answer   answerof-260382 ' value='1027397'   \/><label for='answer-id-1027397' id='answer-label-1027397' class=' answer'><span>The TTL attribute's value is set with an expiration of 1 year.<\/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-260383'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>A financial organization must ensure that the most current 90 days of MySQL database backups are accessible. Amazon RDS for MySQL DB instances are used to host all MySQL databases. A database expert must create a solution that satisfies the criteria for backup retention with the least amount of development work feasible. <br \/>\r<br>Which strategy should the database administrator take?<\/div><input type='hidden' name='question_id[]' id='qID_2' value='260383' \/><input type='hidden' id='answerType260383' 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-260383[]' id='answer-id-1027398' class='answer   answerof-260383 ' value='1027398'   \/><label for='answer-id-1027398' id='answer-label-1027398' class=' answer'><span>Use AWS Backup to build a backup plan for the required retention period. Assign the DB instances to the backup plan.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260383[]' id='answer-id-1027399' class='answer   answerof-260383 ' value='1027399'   \/><label for='answer-id-1027399' id='answer-label-1027399' class=' answer'><span>Modify the DB instances to enable the automated backup option. Select the required backup retention period.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260383[]' id='answer-id-1027400' class='answer   answerof-260383 ' value='1027400'   \/><label for='answer-id-1027400' id='answer-label-1027400' class=' answer'><span>Automate a daily cron job on an Amazon EC2 instance to create MySQL dumps, transfer to Amazon S3, and implement an S3 Lifecycle policy to meet the retention requirement.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260383[]' id='answer-id-1027401' class='answer   answerof-260383 ' value='1027401'   \/><label for='answer-id-1027401' id='answer-label-1027401' class=' answer'><span>Use AWS Lambda to schedule a daily manual snapshot of the DB instances. Delete snapshots that exceed the retention requirement.<\/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-260384'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>A business that specializes in internet advertising is developing an application that will show adverts to its customers. The program stores data in an Amazon DynamoDB database. Additionally, the application caches its reads using a DynamoDB Accelerator (DAX) cluster. The majority of reads come via the GetItem and BatchGetItem queries. The application does not need consistency of readings. <br \/>\r<br>The application cache does not behave as intended after deployment. Specific extremely consistent queries to the DAX cluster are responding in several milliseconds rather than microseconds. <br \/>\r<br>How can the business optimize cache behavior in order to boost application performance?<\/div><input type='hidden' name='question_id[]' id='qID_3' value='260384' \/><input type='hidden' id='answerType260384' 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-260384[]' id='answer-id-1027402' class='answer   answerof-260384 ' value='1027402'   \/><label for='answer-id-1027402' id='answer-label-1027402' class=' answer'><span>Increase the size of the DAX cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260384[]' id='answer-id-1027403' class='answer   answerof-260384 ' value='1027403'   \/><label for='answer-id-1027403' id='answer-label-1027403' class=' answer'><span>Configure DAX to be an item cache with no query cache<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260384[]' id='answer-id-1027404' class='answer   answerof-260384 ' value='1027404'   \/><label for='answer-id-1027404' id='answer-label-1027404' class=' answer'><span>Use eventually consistent reads instead of strongly consistent reads.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260384[]' id='answer-id-1027405' class='answer   answerof-260384 ' value='1027405'   \/><label for='answer-id-1027405' id='answer-label-1027405' class=' answer'><span>Create a new DAX cluster with a higher TTL for the item cache.<\/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-260385'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>A business need a data warehouse system that stores data consistently and in a highly organized fashion. The organization demands rapid response times for end-user inquiries including current-year data, and users must have access to the whole 15-year dataset when necessary. Additionally, this solution must be able to manage a variable volume of incoming inquiries. Costs associated with storing the 100 TB of data must be maintained to a minimum. <br \/>\r<br>Which solution satisfies these criteria?<\/div><input type='hidden' name='question_id[]' id='qID_4' value='260385' \/><input type='hidden' id='answerType260385' 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-260385[]' id='answer-id-1027406' class='answer   answerof-260385 ' value='1027406'   \/><label for='answer-id-1027406' id='answer-label-1027406' class=' answer'><span>Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260385[]' id='answer-id-1027407' class='answer   answerof-260385 ' value='1027407'   \/><label for='answer-id-1027407' id='answer-label-1027407' class=' answer'><span>Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260385[]' id='answer-id-1027408' class='answer   answerof-260385 ' value='1027408'   \/><label for='answer-id-1027408' id='answer-label-1027408' class=' answer'><span>Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260385[]' id='answer-id-1027409' class='answer   answerof-260385 ' value='1027409'   \/><label for='answer-id-1027409' id='answer-label-1027409' class=' answer'><span>Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.<\/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-260386'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>A company is releasing a new mobile game featuring a team play mode. As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table. Periodically, the other users\u2019 devices read the latest statuses of their teammates from the table using the BatchGetltemn operation. <br \/>\r<br>Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date. The developers are unable to replicate this issue and have asked a database specialist for a recommendation. <br \/>\r<br>Which recommendation would resolve this issue?<\/div><input type='hidden' name='question_id[]' id='qID_5' value='260386' \/><input type='hidden' id='answerType260386' 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-260386[]' id='answer-id-1027410' class='answer   answerof-260386 ' value='1027410'   \/><label for='answer-id-1027410' id='answer-label-1027410' class=' answer'><span>Ensure the DynamoDB table is configured to be always consistent.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260386[]' id='answer-id-1027411' class='answer   answerof-260386 ' value='1027411'   \/><label for='answer-id-1027411' id='answer-label-1027411' class=' answer'><span>Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to false.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260386[]' id='answer-id-1027412' class='answer   answerof-260386 ' value='1027412'   \/><label for='answer-id-1027412' id='answer-label-1027412' class=' answer'><span>Enable a stream on the DynamoDB table and subscribe each device to the stream to ensure all devices receive up-to-date status information.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260386[]' id='answer-id-1027413' class='answer   answerof-260386 ' value='1027413'   \/><label for='answer-id-1027413' id='answer-label-1027413' class=' answer'><span>Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.<\/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-260387'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions. <br \/>\r<br>Which solution would meet these requirements and deploy the DynamoDB tables?<\/div><input type='hidden' name='question_id[]' id='qID_6' value='260387' \/><input type='hidden' id='answerType260387' 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-260387[]' id='answer-id-1027414' class='answer   answerof-260387 ' value='1027414'   \/><label for='answer-id-1027414' id='answer-label-1027414' class=' answer'><span>Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260387[]' id='answer-id-1027415' class='answer   answerof-260387 ' value='1027415'   \/><label for='answer-id-1027415' id='answer-label-1027415' class=' answer'><span>Create an AWS CloudFormation template and deploy the template to all the Regions.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260387[]' id='answer-id-1027416' class='answer   answerof-260387 ' value='1027416'   \/><label for='answer-id-1027416' id='answer-label-1027416' class=' answer'><span>Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260387[]' id='answer-id-1027417' class='answer   answerof-260387 ' value='1027417'   \/><label for='answer-id-1027417' id='answer-label-1027417' class=' answer'><span>Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-by- step guide for future deployments.<\/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-260388'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>A database specialist deployed an Amazon RDS DB instance in Dev-VPC1 used by their development team. Dev-VPC1 has a peering connection with Dev-VPC2 that belongs to a different development team in the same department. The networking team confirmed that the routing between VPCs is correct; however, the database engineers in Dev-VPC2 are getting a timeout connections error when trying to connect to the database in Dev- VPC1. <br \/>\r<br>What is likely causing the timeouts?<\/div><input type='hidden' name='question_id[]' id='qID_7' value='260388' \/><input type='hidden' id='answerType260388' 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-260388[]' id='answer-id-1027418' class='answer   answerof-260388 ' value='1027418'   \/><label for='answer-id-1027418' id='answer-label-1027418' class=' answer'><span>The database is deployed in a VPC that is in a different Region.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260388[]' id='answer-id-1027419' class='answer   answerof-260388 ' value='1027419'   \/><label for='answer-id-1027419' id='answer-label-1027419' class=' answer'><span>The database is deployed in a VPC that is in a different Availability Zone.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260388[]' id='answer-id-1027420' class='answer   answerof-260388 ' value='1027420'   \/><label for='answer-id-1027420' id='answer-label-1027420' class=' answer'><span>The database is deployed with misconfigured security groups.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260388[]' id='answer-id-1027421' class='answer   answerof-260388 ' value='1027421'   \/><label for='answer-id-1027421' id='answer-label-1027421' class=' answer'><span>The database is deployed with the wrong client connect timeout configuration.<\/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-260389'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. <br \/>\r<br>The Developers sometimes need to wait hours to the restores to complete. <br \/>\r<br>Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake. <br \/>\r<br>Which approach should the Database Specialist take to reduce downtime?<\/div><input type='hidden' name='question_id[]' id='qID_8' value='260389' \/><input type='hidden' id='answerType260389' 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-260389[]' id='answer-id-1027422' class='answer   answerof-260389 ' value='1027422'   \/><label for='answer-id-1027422' id='answer-label-1027422' class=' answer'><span>Deploy multiple read replicas and have the team members make changes to separate replica instances<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260389[]' id='answer-id-1027423' class='answer   answerof-260389 ' value='1027423'   \/><label for='answer-id-1027423' id='answer-label-1027423' class=' answer'><span>Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260389[]' id='answer-id-1027424' class='answer   answerof-260389 ' value='1027424'   \/><label for='answer-id-1027424' id='answer-label-1027424' class=' answer'><span>Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260389[]' id='answer-id-1027425' class='answer   answerof-260389 ' value='1027425'   \/><label for='answer-id-1027425' id='answer-label-1027425' class=' answer'><span>Enable the Amazon RDS for MySQL Backtrack feature<\/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-260390'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed. <br \/>\r<br>What is the MOST operationally efficient and cost-effective solution?<\/div><input type='hidden' name='question_id[]' id='qID_9' value='260390' \/><input type='hidden' id='answerType260390' 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-260390[]' id='answer-id-1027426' class='answer   answerof-260390 ' value='1027426'   \/><label for='answer-id-1027426' id='answer-label-1027426' class=' answer'><span>Configure RDS Storage Auto Scaling.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260390[]' id='answer-id-1027427' class='answer   answerof-260390 ' value='1027427'   \/><label for='answer-id-1027427' id='answer-label-1027427' class=' answer'><span>Configure RDS instance Auto Scaling.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260390[]' id='answer-id-1027428' class='answer   answerof-260390 ' value='1027428'   \/><label for='answer-id-1027428' id='answer-label-1027428' class=' answer'><span>Modify the DB instance allocated storage to meet the forecasted requirements.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260390[]' id='answer-id-1027429' class='answer   answerof-260390 ' value='1027429'   \/><label for='answer-id-1027429' id='answer-label-1027429' class=' answer'><span>Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.<\/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-260391'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>A vehicle insurance company needs to choose a highly available database to track vehicle owners and their insurance details. The persisted data should be immutable in the database, including the complete and sequenced history of changes over time with all the owners and insurance transfer details for a vehicle. <br \/>\r<br>The data should be easily verifiable for the data lineage of an insurance claim. <br \/>\r<br>Which approach meets these requirements with MINIMAL effort?<\/div><input type='hidden' name='question_id[]' id='qID_10' value='260391' \/><input type='hidden' id='answerType260391' 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-260391[]' id='answer-id-1027430' class='answer   answerof-260391 ' value='1027430'   \/><label for='answer-id-1027430' id='answer-label-1027430' class=' answer'><span>Create a blockchain to store the insurance details. Validate the data using a hash function to verify the data lineage of an insurance claim.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260391[]' id='answer-id-1027431' class='answer   answerof-260391 ' value='1027431'   \/><label for='answer-id-1027431' id='answer-label-1027431' class=' answer'><span>Create an Amazon DynamoDB table to store the insurance details. Validate the data using AWS DMS validation by moving the data to Amazon S3 to verify the data lineage of an insurance claim.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260391[]' id='answer-id-1027432' class='answer   answerof-260391 ' value='1027432'   \/><label for='answer-id-1027432' id='answer-label-1027432' class=' answer'><span>Create an Amazon QLDB ledger to store the insurance details. Validate the data by choosing the ledger name in the digest request to verify the data lineage of an insurance claim.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260391[]' id='answer-id-1027433' class='answer   answerof-260391 ' value='1027433'   \/><label for='answer-id-1027433' id='answer-label-1027433' class=' answer'><span>Create an Amazon Aurora database to store the insurance details. Validate the data using AWS DMS validation by moving the data to Amazon S3 to verify the data lineage of an insurance claim.<\/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-260392'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>A small startup company is looking to migrate a 4 TB on-premises MySQL database to AWS using an Amazon RDS for MySQL DB instance. <br \/>\r<br>Which strategy would allow for a successful migration with the LEAST amount of downtime?<\/div><input type='hidden' name='question_id[]' id='qID_11' value='260392' \/><input type='hidden' id='answerType260392' 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-260392[]' id='answer-id-1027434' class='answer   answerof-260392 ' value='1027434'   \/><label for='answer-id-1027434' id='answer-label-1027434' class=' answer'><span>Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance utilizing the MySQL utilities running on an Amazon EC2 instance. Immediately point the application to the DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260392[]' id='answer-id-1027435' class='answer   answerof-260392 ' value='1027435'   \/><label for='answer-id-1027435' id='answer-label-1027435' class=' answer'><span>Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into the EC2 instance and restore it into the EC2 MySQL instance. Use AWS DMS to migrate data into a new RDS for MySQL DB instance. Point the application to the DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260392[]' id='answer-id-1027436' class='answer   answerof-260392 ' value='1027436'   \/><label for='answer-id-1027436' id='answer-label-1027436' class=' answer'><span>Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into an Amazon S3 bucket and import the snapshot into a new RDS for MySQL DB instance using the MySQL utilities running on an EC2 instance. Point the application to the DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260392[]' id='answer-id-1027437' class='answer   answerof-260392 ' value='1027437'   \/><label for='answer-id-1027437' id='answer-label-1027437' class=' answer'><span>Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance using the MySQL utilities running on an Amazon EC2 instance. Establish replication into the new DB instance using MySQL replication. Stop application access to the on-premises MySQL server and let the remaining transactions replicate over. Point the application to the DB instance.<\/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-260393'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update. <br \/>\r<br>The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a <br \/>\r<br>cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster. <br \/>\r<br>Which solution meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_12' value='260393' \/><input type='hidden' id='answerType260393' 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-260393[]' id='answer-id-1027438' class='answer   answerof-260393 ' value='1027438'   \/><label for='answer-id-1027438' id='answer-label-1027438' class=' answer'><span>Turn on the serverless option in the DB cluster so it can automatically scale based on demand.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260393[]' id='answer-id-1027439' class='answer   answerof-260393 ' value='1027439'   \/><label for='answer-id-1027439' id='answer-label-1027439' class=' answer'><span>Provision a clone of the existing DB cluster for the new Application team.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260393[]' id='answer-id-1027440' class='answer   answerof-260393 ' value='1027440'   \/><label for='answer-id-1027440' id='answer-label-1027440' class=' answer'><span>Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260393[]' id='answer-id-1027441' class='answer   answerof-260393 ' value='1027441'   \/><label for='answer-id-1027441' id='answer-label-1027441' class=' answer'><span>Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.<\/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-260394'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>A company is using an Amazon RDS for MySQL DB instance for its internal applications. A security audit shows that the DB instance is not encrypted at rest. The company\u2019s application team needs to encrypt the DB instance. <br \/>\r<br>What should the team do to meet this requirement?<\/div><input type='hidden' name='question_id[]' id='qID_13' value='260394' \/><input type='hidden' id='answerType260394' 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-260394[]' id='answer-id-1027442' class='answer   answerof-260394 ' value='1027442'   \/><label for='answer-id-1027442' id='answer-label-1027442' class=' answer'><span>Stop the DB instance and modify it to enable encryption. Apply this setting immediately without waiting for the next scheduled RDS maintenance window.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260394[]' id='answer-id-1027443' class='answer   answerof-260394 ' value='1027443'   \/><label for='answer-id-1027443' id='answer-label-1027443' class=' answer'><span>Stop the DB instance and create an encrypted snapshot. Restore the encrypted snapshot to a new encrypted DB instance. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260394[]' id='answer-id-1027444' class='answer   answerof-260394 ' value='1027444'   \/><label for='answer-id-1027444' id='answer-label-1027444' class=' answer'><span>Stop the DB instance and create a snapshot. Copy the snapshot into another encrypted snapshot. Restore the encrypted snapshot to a new encrypted DB instance. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260394[]' id='answer-id-1027445' class='answer   answerof-260394 ' value='1027445'   \/><label for='answer-id-1027445' id='answer-label-1027445' class=' answer'><span>Create an encrypted read replica of the DB instance. Promote the read replica to master. Delete the original DB instance, and update the applications to point to the new encrypted DB instance.<\/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-260395'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>A database professional maintains a fleet of Amazon RDS database instances that are configured to utilize the default database parameter group. A database expert must connect a custom parameter group with certain database instances. <br \/>\r<br>When will the instances be allocated to this new parameter group once the database specialist performs this change?<\/div><input type='hidden' name='question_id[]' id='qID_14' value='260395' \/><input type='hidden' id='answerType260395' 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-260395[]' id='answer-id-1027446' class='answer   answerof-260395 ' value='1027446'   \/><label for='answer-id-1027446' id='answer-label-1027446' class=' answer'><span>Instantaneously after the change is made to the parameter group<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260395[]' id='answer-id-1027447' class='answer   answerof-260395 ' value='1027447'   \/><label for='answer-id-1027447' id='answer-label-1027447' class=' answer'><span>In the next scheduled maintenance window of the DB instances<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260395[]' id='answer-id-1027448' class='answer   answerof-260395 ' value='1027448'   \/><label for='answer-id-1027448' id='answer-label-1027448' class=' answer'><span>After the DB instances are manually rebooted<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260395[]' id='answer-id-1027449' class='answer   answerof-260395 ' value='1027449'   \/><label for='answer-id-1027449' id='answer-label-1027449' class=' answer'><span>Within 24 hours after the change is made to the parameter group<\/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-260396'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database. <br \/>\r<br>Which solution meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_15' value='260396' \/><input type='hidden' id='answerType260396' 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-260396[]' id='answer-id-1027450' class='answer   answerof-260396 ' value='1027450'   \/><label for='answer-id-1027450' id='answer-label-1027450' class=' answer'><span>Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260396[]' id='answer-id-1027451' class='answer   answerof-260396 ' value='1027451'   \/><label for='answer-id-1027451' id='answer-label-1027451' class=' answer'><span>Use AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260396[]' id='answer-id-1027452' class='answer   answerof-260396 ' value='1027452'   \/><label for='answer-id-1027452' id='answer-label-1027452' class=' answer'><span>Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260396[]' id='answer-id-1027453' class='answer   answerof-260396 ' value='1027453'   \/><label for='answer-id-1027453' id='answer-label-1027453' class=' answer'><span>Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.<\/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-260397'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company\u2019s disaster recovery policies, the database backup needs to be copied into another Region. The company requires the solution to be cost-effective and operationally efficient. <br \/>\r<br>What should a Database Specialist do to copy the database backup into a different Region?<\/div><input type='hidden' name='question_id[]' id='qID_16' value='260397' \/><input type='hidden' id='answerType260397' 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-260397[]' id='answer-id-1027454' class='answer   answerof-260397 ' value='1027454'   \/><label for='answer-id-1027454' id='answer-label-1027454' class=' answer'><span>Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260397[]' id='answer-id-1027455' class='answer   answerof-260397 ' value='1027455'   \/><label for='answer-id-1027455' id='answer-label-1027455' class=' answer'><span>Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260397[]' id='answer-id-1027456' class='answer   answerof-260397 ' value='1027456'   \/><label for='answer-id-1027456' id='answer-label-1027456' class=' answer'><span>Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260397[]' id='answer-id-1027457' class='answer   answerof-260397 ' value='1027457'   \/><label for='answer-id-1027457' id='answer-label-1027457' class=' answer'><span>Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica<\/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-260398'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora: <br \/>\r<br>ERROR: cloud not write block 7507718 of temporary file: No space left on device <br \/>\r<br>What is the cause of this error and what should the Database Specialist do to resolve this issue?<\/div><input type='hidden' name='question_id[]' id='qID_17' value='260398' \/><input type='hidden' id='answerType260398' 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-260398[]' id='answer-id-1027458' class='answer   answerof-260398 ' value='1027458'   \/><label for='answer-id-1027458' id='answer-label-1027458' class=' answer'><span>The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to modify the workload to load the data slowly.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260398[]' id='answer-id-1027459' class='answer   answerof-260398 ' value='1027459'   \/><label for='answer-id-1027459' id='answer-label-1027459' class=' answer'><span>The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260398[]' id='answer-id-1027460' class='answer   answerof-260398 ' value='1027460'   \/><label for='answer-id-1027460' id='answer-label-1027460' class=' answer'><span>The local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260398[]' id='answer-id-1027461' class='answer   answerof-260398 ' value='1027461'   \/><label for='answer-id-1027461' id='answer-label-1027461' class=' answer'><span>The local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.<\/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-260399'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>A company is running an Amazon RDS for MySQL Multi-AZ DB instance for a business-critical workload. RDS encryption for the DB instance is disabled. A recent security audit concluded that all business-critical applications must encrypt data at rest. The company has asked its database specialist to formulate a plan to accomplish this for the DB instance. <br \/>\r<br>Which process should the database specialist recommend?<\/div><input type='hidden' name='question_id[]' id='qID_18' value='260399' \/><input type='hidden' id='answerType260399' 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-260399[]' id='answer-id-1027462' class='answer   answerof-260399 ' value='1027462'   \/><label for='answer-id-1027462' id='answer-label-1027462' class=' answer'><span>Create an encrypted snapshot of the unencrypted DB instance. Copy the encrypted snapshot to Amazon S3. Restore the DB instance from the encrypted snapshot using Amazon S3.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260399[]' id='answer-id-1027463' class='answer   answerof-260399 ' value='1027463'   \/><label for='answer-id-1027463' id='answer-label-1027463' class=' answer'><span>Create a new RDS for MySQL DB instance with encryption enabled. Restore the unencrypted snapshot to this DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260399[]' id='answer-id-1027464' class='answer   answerof-260399 ' value='1027464'   \/><label for='answer-id-1027464' id='answer-label-1027464' class=' answer'><span>Create a snapshot of the unencrypted DB instance. Create an encrypted copy of the snapshot. Restore the DB instance from the encrypted snapshot.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260399[]' id='answer-id-1027465' class='answer   answerof-260399 ' value='1027465'   \/><label for='answer-id-1027465' id='answer-label-1027465' class=' answer'><span>Temporarily shut down the unencrypted DB instance. Enable AWS KMS encryption in the AWS Management Console using an AWS managed CM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260399[]' id='answer-id-1027466' class='answer   answerof-260399 ' value='1027466'   \/><label for='answer-id-1027466' id='answer-label-1027466' class=' answer'><span>Restart the DB instance in an encrypted state.<\/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-260400'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully. <br \/>\r<br>What could be the reason for this?<\/div><input type='hidden' name='question_id[]' id='qID_19' value='260400' \/><input type='hidden' id='answerType260400' 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-260400[]' id='answer-id-1027467' class='answer   answerof-260400 ' value='1027467'   \/><label for='answer-id-1027467' id='answer-label-1027467' class=' answer'><span>When stopping the DB instance, the option to create a snapshot should have been selected.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260400[]' id='answer-id-1027468' class='answer   answerof-260400 ' value='1027468'   \/><label for='answer-id-1027468' id='answer-label-1027468' class=' answer'><span>When stopping the DB instance, the duration for stopping the DB instance should have been selected.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260400[]' id='answer-id-1027469' class='answer   answerof-260400 ' value='1027469'   \/><label for='answer-id-1027469' id='answer-label-1027469' class=' answer'><span>Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260400[]' id='answer-id-1027470' class='answer   answerof-260400 ' value='1027470'   \/><label for='answer-id-1027470' id='answer-label-1027470' class=' answer'><span>Stopped DB instances will automatically restart if the instance is not manually started after 7 days.<\/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-260401'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>An ecommerce company is running AWS Database Migration Service (AWS DMS) to replicate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The company has set up an AWS Direct Connect connection from its on-premises data center to AWS. During the migration, the company's security team receives an alarm that is related to the migration. The security team mandates that the DMS replication instance must not be accessible from public IP addresses. <br \/>\r<br>What should a database specialist do to meet this requirement?<\/div><input type='hidden' name='question_id[]' id='qID_20' value='260401' \/><input type='hidden' id='answerType260401' 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-260401[]' id='answer-id-1027471' class='answer   answerof-260401 ' value='1027471'   \/><label for='answer-id-1027471' id='answer-label-1027471' class=' answer'><span>Set up a VPN connection to encrypt the traffic over the Direct Connect connection.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260401[]' id='answer-id-1027472' class='answer   answerof-260401 ' value='1027472'   \/><label for='answer-id-1027472' id='answer-label-1027472' class=' answer'><span>Modify the DMS replication instance by disabling the publicly accessible option.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260401[]' id='answer-id-1027473' class='answer   answerof-260401 ' value='1027473'   \/><label for='answer-id-1027473' id='answer-label-1027473' class=' answer'><span>Delete the DMS replication instance. Recreate the DMS replication instance with the publicly accessible option disabled.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260401[]' id='answer-id-1027474' class='answer   answerof-260401 ' value='1027474'   \/><label for='answer-id-1027474' id='answer-label-1027474' class=' answer'><span>Create a new replication VPC subnet group with private subnets. Modify the DMS replication instance by selecting the newly created VPC subnet group.<\/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-260402'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data. <br \/>\r<br>How can this solution be implemented?<\/div><input type='hidden' name='question_id[]' id='qID_21' value='260402' \/><input type='hidden' id='answerType260402' 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-260402[]' id='answer-id-1027475' class='answer   answerof-260402 ' value='1027475'   \/><label for='answer-id-1027475' id='answer-label-1027475' class=' answer'><span>Use Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260402[]' id='answer-id-1027476' class='answer   answerof-260402 ' value='1027476'   \/><label for='answer-id-1027476' id='answer-label-1027476' class=' answer'><span>Use AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260402[]' id='answer-id-1027477' class='answer   answerof-260402 ' value='1027477'   \/><label for='answer-id-1027477' id='answer-label-1027477' class=' answer'><span>Use the AWS CLI to update the DynamoDB table and modify the partition key.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260402[]' id='answer-id-1027478' class='answer   answerof-260402 ' value='1027478'   \/><label for='answer-id-1027478' id='answer-label-1027478' class=' answer'><span>Use the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.<\/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-260403'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>A significant automotive manufacturer is switching a mission-critical finance application's database to Amazon DynamoDB. According to the company's risk and compliance policy, any update to the database must be documented as a log entry for auditing purposes. Each minute, the system anticipates about 500,000 log entries. Log entries should be kept in Apache Parquet files in batches of at least 100,000 records per file. <br \/>\r<br>How could a database professional approach these needs while using DynamoDB?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='260403' \/><input type='hidden' id='answerType260403' 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-260403[]' id='answer-id-1027479' class='answer   answerof-260403 ' value='1027479'   \/><label for='answer-id-1027479' id='answer-label-1027479' class=' answer'><span>Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon S3 object.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260403[]' id='answer-id-1027480' class='answer   answerof-260403 ' value='1027480'   \/><label for='answer-id-1027480' id='answer-label-1027480' class=' answer'><span>Create a backup plan in AWS Backup to back up the DynamoDB table once a day. Create an AWS Lambda function that restores the backup in another table and compares both tables for changes. Generate the log entries and write them to an Amazon S3 object.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260403[]' id='answer-id-1027481' class='answer   answerof-260403 ' value='1027481'   \/><label for='answer-id-1027481' id='answer-label-1027481' class=' answer'><span>Enable AWS CloudTrail logs on the table. Create an AWS Lambda function that reads the log files once an hour and filters DynamoDB API actions. Write the filtered log files to Amazon S3.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260403[]' id='answer-id-1027482' class='answer   answerof-260403 ' value='1027482'   \/><label for='answer-id-1027482' id='answer-label-1027482' class=' answer'><span>Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon Kinesis Data Firehose delivery stream with buffering and Amazon S3 as the destination.<\/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-260404'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy. <br \/>\r<br>Which backup methodology should the database specialist use to MINIMIZE management overhead?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='260404' \/><input type='hidden' id='answerType260404' 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-260404[]' id='answer-id-1027483' class='answer   answerof-260404 ' value='1027483'   \/><label for='answer-id-1027483' id='answer-label-1027483' class=' answer'><span>Install the AWS CLI on an Amazon EC2 instance. Write a CLI command that creates a backup of the DynamoDB table. Create a scheduled job or task that executes the command on a nightly basis.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260404[]' id='answer-id-1027484' class='answer   answerof-260404 ' value='1027484'   \/><label for='answer-id-1027484' id='answer-label-1027484' class=' answer'><span>Create an AWS Lambda function that creates a backup of the DynamoDB table. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260404[]' id='answer-id-1027485' class='answer   answerof-260404 ' value='1027485'   \/><label for='answer-id-1027485' id='answer-label-1027485' class=' answer'><span>Create a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260404[]' id='answer-id-1027486' class='answer   answerof-260404 ' value='1027486'   \/><label for='answer-id-1027486' id='answer-label-1027486' class=' answer'><span>Configure DynamoDB backup and restore for an on-demand backup frequency of every \r\n24 hours.<\/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-260405'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>A business just transitioned from an on-premises Oracle database to Amazon Aurora PostgreSQL. Following the move, the organization observed that every day around 3:00 PM, the application's response time is substantially slower. The firm has determined that the problem is with the database, not the application. <br \/>\r<br>Which set of procedures should the Database Specialist do to locate the erroneous PostgreSQL query most efficiently?<\/div><input type='hidden' name='question_id[]' id='qID_24' value='260405' \/><input type='hidden' id='answerType260405' 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-260405[]' id='answer-id-1027487' class='answer   answerof-260405 ' value='1027487'   \/><label for='answer-id-1027487' id='answer-label-1027487' class=' answer'><span>Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260405[]' id='answer-id-1027488' class='answer   answerof-260405 ' value='1027488'   \/><label for='answer-id-1027488' id='answer-label-1027488' class=' answer'><span>Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260405[]' id='answer-id-1027489' class='answer   answerof-260405 ' value='1027489'   \/><label for='answer-id-1027489' id='answer-label-1027489' class=' answer'><span>Modify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260405[]' id='answer-id-1027490' class='answer   answerof-260405 ' value='1027490'   \/><label for='answer-id-1027490' id='answer-label-1027490' class=' answer'><span>Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.<\/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-260406'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster. A recent audit showed that no log files contained database administrator activity. A database specialist needs to recommend a solution to provide database access and activity logs. The solution should use the least amount of effort and have a minimal impact on performance. <br \/>\r<br>Which solution should the database specialist recommend?<\/div><input type='hidden' name='question_id[]' id='qID_25' value='260406' \/><input type='hidden' id='answerType260406' 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-260406[]' id='answer-id-1027491' class='answer   answerof-260406 ' value='1027491'   \/><label for='answer-id-1027491' id='answer-label-1027491' class=' answer'><span>Enable Aurora Database Activity Streams on the database in synchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Kinesis Data Firehose destination to an Amazon S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260406[]' id='answer-id-1027492' class='answer   answerof-260406 ' value='1027492'   \/><label for='answer-id-1027492' id='answer-label-1027492' class=' answer'><span>Create an AWS CloudTrail trail in the Region where the database runs. Associate the database activity logs with the trail.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260406[]' id='answer-id-1027493' class='answer   answerof-260406 ' value='1027493'   \/><label for='answer-id-1027493' id='answer-label-1027493' class=' answer'><span>Enable Aurora Database Activity Streams on the database in asynchronous mode. Connect the Amazon Kinesis data stream to Kinesis Data Firehose. Set the Firehose destination to an Amazon S3 bucket.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260406[]' id='answer-id-1027494' class='answer   answerof-260406 ' value='1027494'   \/><label for='answer-id-1027494' id='answer-label-1027494' class=' answer'><span>Allow connections to the DB cluster through a bastion host only. Restrict database access to the bastion host and application servers. Push the bastion host logs to Amazon CloudWatch Logs using the CloudWatch Logs agent.<\/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-260407'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to <br \/>\r<br>load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. <br \/>\r<br>The Database Specialist receives the following error: <br \/>\r<br>\u201cUnable to connect to s3 endpoint. Provided source = s3:\/\/mybucket\/graphdata\/ and region = us-east-1. Please verify your S3 configuration.\u201d <br \/>\r<br>Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_26' value='260407' \/><input type='hidden' id='answerType260407' 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-260407[]' id='answer-id-1027495' class='answer   answerof-260407 ' value='1027495'   \/><label for='answer-id-1027495' id='answer-label-1027495' class=' answer'><span>Check that Amazon S3 has an IAM role granting read access to Neptune<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260407[]' id='answer-id-1027496' class='answer   answerof-260407 ' value='1027496'   \/><label for='answer-id-1027496' id='answer-label-1027496' class=' answer'><span>Check that an Amazon S3 VPC endpoint exists<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260407[]' id='answer-id-1027497' class='answer   answerof-260407 ' value='1027497'   \/><label for='answer-id-1027497' id='answer-label-1027497' class=' answer'><span>Check that a Neptune VPC endpoint exists<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260407[]' id='answer-id-1027498' class='answer   answerof-260407 ' value='1027498'   \/><label for='answer-id-1027498' id='answer-label-1027498' class=' answer'><span>Check that Amazon EC2 has an IAM role granting read access to Amazon S3<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260407[]' id='answer-id-1027499' class='answer   answerof-260407 ' value='1027499'   \/><label for='answer-id-1027499' id='answer-label-1027499' class=' answer'><span>Check that Neptune has an IAM role granting read access to Amazon S3<\/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-260408'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>The website of a manufacturing firm makes use of an Amazon Aurora PostgreSQL database cluster. <br \/>\r<br>Which settings will result in the LEAST amount of downtime for the application during failover? (Select three.)<\/div><input type='hidden' name='question_id[]' id='qID_27' value='260408' \/><input type='hidden' id='answerType260408' 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-260408[]' id='answer-id-1027500' class='answer   answerof-260408 ' value='1027500'   \/><label for='answer-id-1027500' id='answer-label-1027500' class=' answer'><span>Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260408[]' id='answer-id-1027501' class='answer   answerof-260408 ' value='1027501'   \/><label for='answer-id-1027501' id='answer-label-1027501' class=' answer'><span>Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260408[]' id='answer-id-1027502' class='answer   answerof-260408 ' value='1027502'   \/><label for='answer-id-1027502' id='answer-label-1027502' class=' answer'><span>Edit and enable Aurora DB cluster cache management in parameter groups.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260408[]' id='answer-id-1027503' class='answer   answerof-260408 ' value='1027503'   \/><label for='answer-id-1027503' id='answer-label-1027503' class=' answer'><span>Set TCP keepalive parameters to a high value.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260408[]' id='answer-id-1027504' class='answer   answerof-260408 ' value='1027504'   \/><label for='answer-id-1027504' id='answer-label-1027504' class=' answer'><span>Set JDBC connection string timeout variables to a low value.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260408[]' id='answer-id-1027505' class='answer   answerof-260408 ' value='1027505'   \/><label for='answer-id-1027505' id='answer-label-1027505' class=' answer'><span>Set Java DNS caching timeouts to a high value.<\/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-260409'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>Recently, a financial institution created a portfolio management service. The application's backend is powered by Amazon Aurora, which supports MySQL. <br \/>\r<br>The firm demands a response time of five minutes and a response time of five minutes. A database professional must create a disaster recovery system that is both efficient and has a low replication latency. <br \/>\r<br>How should the database professional tackle these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_28' value='260409' \/><input type='hidden' id='answerType260409' 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-260409[]' id='answer-id-1027506' class='answer   answerof-260409 ' value='1027506'   \/><label for='answer-id-1027506' id='answer-label-1027506' class=' answer'><span>Configure AWS Database Migration Service (AWS DMS) and create a replica in a different AWS Region.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260409[]' id='answer-id-1027507' class='answer   answerof-260409 ' value='1027507'   \/><label for='answer-id-1027507' id='answer-label-1027507' class=' answer'><span>Configure an Amazon Aurora global database and add a different AWS Region.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260409[]' id='answer-id-1027508' class='answer   answerof-260409 ' value='1027508'   \/><label for='answer-id-1027508' id='answer-label-1027508' class=' answer'><span>Configure a binlog and create a replica in a different AWS Region.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260409[]' id='answer-id-1027509' class='answer   answerof-260409 ' value='1027509'   \/><label for='answer-id-1027509' id='answer-label-1027509' class=' answer'><span>Configure a cross-Region read replica.<\/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-260410'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>A company has an application that uses an Amazon DynamoDB table to store user data. Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management. A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time. <br \/>\r<br>A database specialist needs to improve the performance of the process. The database specialist notes that, when the process is running, 15% of the table\u2019s provisioned read capacity units (RCUs) are being used. <br \/>\r<br>What should the database specialist do?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='260410' \/><input type='hidden' id='answerType260410' 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-260410[]' id='answer-id-1027510' class='answer   answerof-260410 ' value='1027510'   \/><label for='answer-id-1027510' id='answer-label-1027510' class=' answer'><span>Enable auto scaling for the DynamoDB table.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260410[]' id='answer-id-1027511' class='answer   answerof-260410 ' value='1027511'   \/><label for='answer-id-1027511' id='answer-label-1027511' class=' answer'><span>Use four threads and parallel DynamoDB API Scan operations.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260410[]' id='answer-id-1027512' class='answer   answerof-260410 ' value='1027512'   \/><label for='answer-id-1027512' id='answer-label-1027512' class=' answer'><span>Double the table\u2019s provisioned RCUs.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260410[]' id='answer-id-1027513' class='answer   answerof-260410 ' value='1027513'   \/><label for='answer-id-1027513' id='answer-label-1027513' class=' answer'><span>Set the Limit and Offset parameters before every call to the AP<\/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-260411'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>A gaming company is designing a mobile gaming app that will be accessed by many users across the globe. The company wants to have replication and full support for multi-master writes. The company also wants to ensure low latency and consistent performance for app users. <br \/>\r<br>Which solution meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_30' value='260411' \/><input type='hidden' id='answerType260411' 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-260411[]' id='answer-id-1027514' class='answer   answerof-260411 ' value='1027514'   \/><label for='answer-id-1027514' id='answer-label-1027514' class=' answer'><span>Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260411[]' id='answer-id-1027515' class='answer   answerof-260411 ' value='1027515'   \/><label for='answer-id-1027515' id='answer-label-1027515' class=' answer'><span>Use Amazon Aurora for storage and enable cross-Region Aurora Replicas<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260411[]' id='answer-id-1027516' class='answer   answerof-260411 ' value='1027516'   \/><label for='answer-id-1027516' id='answer-label-1027516' class=' answer'><span>Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260411[]' id='answer-id-1027517' class='answer   answerof-260411 ' value='1027517'   \/><label for='answer-id-1027517' id='answer-label-1027517' class=' answer'><span>Use Amazon Neptune for storage<\/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-260412'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/span>An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy load, the database experiences performance degradation. A database specialist needs to improve the database performance. <br \/>\r<br>What should the database specialist do to meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_31' value='260412' \/><input type='hidden' id='answerType260412' 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-260412[]' id='answer-id-1027518' class='answer   answerof-260412 ' value='1027518'   \/><label for='answer-id-1027518' id='answer-label-1027518' class=' answer'><span>Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260412[]' id='answer-id-1027519' class='answer   answerof-260412 ' value='1027519'   \/><label for='answer-id-1027519' id='answer-label-1027519' class=' answer'><span>Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260412[]' id='answer-id-1027520' class='answer   answerof-260412 ' value='1027520'   \/><label for='answer-id-1027520' id='answer-label-1027520' class=' answer'><span>Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260412[]' id='answer-id-1027521' class='answer   answerof-260412 ' value='1027521'   \/><label for='answer-id-1027521' id='answer-label-1027521' class=' answer'><span>Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.<\/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-260413'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/span>A company has an AWS CloudFormation stack that defines an Amazon RDS DB instance. The company accidentally deletes the stack and loses recent data from the DB instance. A database specialist must change the CloudFormation template for the RDS resource to reduce the chance of accidental data loss from the DB instance in the future. <br \/>\r<br>Which combination of actions should the database specialist take to meet this requirement? (Choose three.)<\/div><input type='hidden' name='question_id[]' id='qID_32' value='260413' \/><input type='hidden' id='answerType260413' 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-260413[]' id='answer-id-1027522' class='answer   answerof-260413 ' value='1027522'   \/><label for='answer-id-1027522' id='answer-label-1027522' class=' answer'><span>Set the DeletionProtection property to True.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260413[]' id='answer-id-1027523' class='answer   answerof-260413 ' value='1027523'   \/><label for='answer-id-1027523' id='answer-label-1027523' class=' answer'><span>Set the MultiAZ property to True.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260413[]' id='answer-id-1027524' class='answer   answerof-260413 ' value='1027524'   \/><label for='answer-id-1027524' id='answer-label-1027524' class=' answer'><span>Set the TerminationProtection property to True.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260413[]' id='answer-id-1027525' class='answer   answerof-260413 ' value='1027525'   \/><label for='answer-id-1027525' id='answer-label-1027525' class=' answer'><span>Set the DeleteAutomatedBackups property to False.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260413[]' id='answer-id-1027526' class='answer   answerof-260413 ' value='1027526'   \/><label for='answer-id-1027526' id='answer-label-1027526' class=' answer'><span>Set the DeletionPolicy attribute to No.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260413[]' id='answer-id-1027527' class='answer   answerof-260413 ' value='1027527'   \/><label for='answer-id-1027527' id='answer-label-1027527' class=' answer'><span>Set the DeletionPolicy attribute to Retain.<\/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-260414'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/span>A corporation is transitioning from an IBM Informix database to an Amazon RDS for SQL Server Multi-AZ implementation with Always On Availability Groups (AGs). SQL Server Agent tasks are scheduled to execute at 5-minute intervals on the Always On AG listener to synchronize data between the Informix and SQL Server databases. After a successful failover to the backup node with minimum delay, users endure hours of stale data. <br \/>\r<br>How can a database professional guarantee that consumers view the most current data after a failover?<\/div><input type='hidden' name='question_id[]' id='qID_33' value='260414' \/><input type='hidden' id='answerType260414' 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-260414[]' id='answer-id-1027528' class='answer   answerof-260414 ' value='1027528'   \/><label for='answer-id-1027528' id='answer-label-1027528' class=' answer'><span>Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260414[]' id='answer-id-1027529' class='answer   answerof-260414 ' value='1027529'   \/><label for='answer-id-1027529' id='answer-label-1027529' class=' answer'><span>Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260414[]' id='answer-id-1027530' class='answer   answerof-260414 ' value='1027530'   \/><label for='answer-id-1027530' id='answer-label-1027530' class=' answer'><span>Set the databases on the secondary node to read-only mode.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260414[]' id='answer-id-1027531' class='answer   answerof-260414 ' value='1027531'   \/><label for='answer-id-1027531' id='answer-label-1027531' class=' answer'><span>Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.<\/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-260415'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers. <br \/>\r<br>Which approach meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_34' value='260415' \/><input type='hidden' id='answerType260415' 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-260415[]' id='answer-id-1027532' class='answer   answerof-260415 ' value='1027532'   \/><label for='answer-id-1027532' id='answer-label-1027532' class=' answer'><span>Set the max_connections parameter to 16,000 in the instance-level parameter group.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260415[]' id='answer-id-1027533' class='answer   answerof-260415 ' value='1027533'   \/><label for='answer-id-1027533' id='answer-label-1027533' class=' answer'><span>Modify the client connection timeout to 300 seconds.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260415[]' id='answer-id-1027534' class='answer   answerof-260415 ' value='1027534'   \/><label for='answer-id-1027534' id='answer-label-1027534' class=' answer'><span>Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260415[]' id='answer-id-1027535' class='answer   answerof-260415 ' value='1027535'   \/><label for='answer-id-1027535' id='answer-label-1027535' class=' answer'><span>Enable the query cache at the instance level.<\/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-260416'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>35. <\/span>A company\u2019s Security department established new requirements that state internal users must connect to an existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials. A Database Specialist must make the modifications needed to fulfill this requirement. <br \/>\r<br>Which combination of actions should the Database Specialist take? (Choose three.)<\/div><input type='hidden' name='question_id[]' id='qID_35' value='260416' \/><input type='hidden' id='answerType260416' 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-260416[]' id='answer-id-1027536' class='answer   answerof-260416 ' value='1027536'   \/><label for='answer-id-1027536' id='answer-label-1027536' class=' answer'><span>Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260416[]' id='answer-id-1027537' class='answer   answerof-260416 ' value='1027537'   \/><label for='answer-id-1027537' id='answer-label-1027537' class=' answer'><span>Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Create appropriate new logins.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260416[]' id='answer-id-1027538' class='answer   answerof-260416 ' value='1027538'   \/><label for='answer-id-1027538' id='answer-label-1027538' class=' answer'><span>Use the AWS Management Console to create an AWS Managed Microsoft A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260416[]' id='answer-id-1027539' class='answer   answerof-260416 ' value='1027539'   \/><label for='answer-id-1027539' id='answer-label-1027539' class=' answer'><span>Create a trust relationship with the corporate A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260416[]' id='answer-id-1027540' class='answer   answerof-260416 ' value='1027540'   \/><label for='answer-id-1027540' id='answer-label-1027540' class=' answer'><span>Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and start it again. Create appropriate new logins.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260416[]' id='answer-id-1027541' class='answer   answerof-260416 ' value='1027541'   \/><label for='answer-id-1027541' id='answer-label-1027541' class=' answer'><span>Use the AWS Management Console to create an AD Connector. Create a trust relationship with the corporate A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260416[]' id='answer-id-1027542' class='answer   answerof-260416 ' value='1027542'   \/><label for='answer-id-1027542' id='answer-label-1027542' class=' answer'><span>Configure the AWS Managed Microsoft AD domain controller Security Group.<\/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-260417'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>36. <\/span>A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A Database Specialist needs to configure monitoring so that all data definition language (DDL) statements performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to enabled in the cluster parameter group. <br \/>\r<br>What should the Database Specialist do to automatically collect the database logs for the Administrator?<\/div><input type='hidden' name='question_id[]' id='qID_36' value='260417' \/><input type='hidden' id='answerType260417' 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-260417[]' id='answer-id-1027543' class='answer   answerof-260417 ' value='1027543'   \/><label for='answer-id-1027543' id='answer-label-1027543' class=' answer'><span>Enable DocumentDB to export the logs to Amazon CloudWatch Logs<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260417[]' id='answer-id-1027544' class='answer   answerof-260417 ' value='1027544'   \/><label for='answer-id-1027544' id='answer-label-1027544' class=' answer'><span>Enable DocumentDB to export the logs to AWS CloudTrail<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260417[]' id='answer-id-1027545' class='answer   answerof-260417 ' value='1027545'   \/><label for='answer-id-1027545' id='answer-label-1027545' class=' answer'><span>Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260417[]' id='answer-id-1027546' class='answer   answerof-260417 ' value='1027546'   \/><label for='answer-id-1027546' id='answer-label-1027546' class=' answer'><span>Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operation and store the logs in Amazon S3<\/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-260418'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>37. <\/span>A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region. <br \/>\r<br>Where should the AWS DMS replication instance be placed for the MOST optimal performance?<\/div><input type='hidden' name='question_id[]' id='qID_37' value='260418' \/><input type='hidden' id='answerType260418' 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-260418[]' id='answer-id-1027547' class='answer   answerof-260418 ' value='1027547'   \/><label for='answer-id-1027547' id='answer-label-1027547' class=' answer'><span>In the same Region and VPC of the source DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260418[]' id='answer-id-1027548' class='answer   answerof-260418 ' value='1027548'   \/><label for='answer-id-1027548' id='answer-label-1027548' class=' answer'><span>In the same Region and VPC as the target DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260418[]' id='answer-id-1027549' class='answer   answerof-260418 ' value='1027549'   \/><label for='answer-id-1027549' id='answer-label-1027549' class=' answer'><span>In the same VPC and Availability Zone as the target DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260418[]' id='answer-id-1027550' class='answer   answerof-260418 ' value='1027550'   \/><label for='answer-id-1027550' id='answer-label-1027550' class=' answer'><span>In the same VPC and Availability Zone as the source DB instance<\/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-260419'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>38. <\/span>Amazon Aurora MySQL is being used by an ecommerce business to migrate its main <br \/>\r<br>application database. The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing. <br \/>\r<br>Examining the Amazon CloudWatch stats for the Aurora DB cluster revealed a CPU usage of 90%. <br \/>\r<br>Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively? (Select two.)<\/div><input type='hidden' name='question_id[]' id='qID_38' value='260419' \/><input type='hidden' id='answerType260419' 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-260419[]' id='answer-id-1027551' class='answer   answerof-260419 ' value='1027551'   \/><label for='answer-id-1027551' id='answer-label-1027551' class=' answer'><span>Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260419[]' id='answer-id-1027552' class='answer   answerof-260419 ' value='1027552'   \/><label for='answer-id-1027552' id='answer-label-1027552' class=' answer'><span>Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I\/<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260419[]' id='answer-id-1027553' class='answer   answerof-260419 ' value='1027553'   \/><label for='answer-id-1027553' id='answer-label-1027553' class=' answer'><span>Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260419[]' id='answer-id-1027554' class='answer   answerof-260419 ' value='1027554'   \/><label for='answer-id-1027554' id='answer-label-1027554' class=' answer'><span>Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260419[]' id='answer-id-1027555' class='answer   answerof-260419 ' value='1027555'   \/><label for='answer-id-1027555' id='answer-label-1027555' class=' answer'><span>Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.<\/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-260420'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>39. <\/span>A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times. <br \/>\r<br>What could be causing these slow response times?<\/div><input type='hidden' name='question_id[]' id='qID_39' value='260420' \/><input type='hidden' id='answerType260420' 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-260420[]' id='answer-id-1027556' class='answer   answerof-260420 ' value='1027556'   \/><label for='answer-id-1027556' id='answer-label-1027556' class=' answer'><span>New volumes created from snapshots load lazily in the background<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260420[]' id='answer-id-1027557' class='answer   answerof-260420 ' value='1027557'   \/><label for='answer-id-1027557' id='answer-label-1027557' class=' answer'><span>Long-running statements on the master<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260420[]' id='answer-id-1027558' class='answer   answerof-260420 ' value='1027558'   \/><label for='answer-id-1027558' id='answer-label-1027558' class=' answer'><span>Insufficient resources on the master<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260420[]' id='answer-id-1027559' class='answer   answerof-260420 ' value='1027559'   \/><label for='answer-id-1027559' id='answer-label-1027559' class=' answer'><span>Overload of a single replication thread by excessive writes on the master<\/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-260421'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>40. <\/span>A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB instance goes live. <br \/>\r<br>What change should the Database Specialist make to enable the migration?<\/div><input type='hidden' name='question_id[]' id='qID_40' value='260421' \/><input type='hidden' id='answerType260421' 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-260421[]' id='answer-id-1027560' class='answer   answerof-260421 ' value='1027560'   \/><label for='answer-id-1027560' id='answer-label-1027560' class=' answer'><span>Configure the on-premises application database to act as a source for an AWS DMS full load with ongoing change data capture (CDC)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260421[]' id='answer-id-1027561' class='answer   answerof-260421 ' value='1027561'   \/><label for='answer-id-1027561' id='answer-label-1027561' class=' answer'><span>Configure the AWS DMS replication instance to allow both full load and ongoing change data capture (CDC)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260421[]' id='answer-id-1027562' class='answer   answerof-260421 ' value='1027562'   \/><label for='answer-id-1027562' id='answer-label-1027562' class=' answer'><span>Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260421[]' id='answer-id-1027563' class='answer   answerof-260421 ' value='1027563'   \/><label for='answer-id-1027563' id='answer-label-1027563' class=' answer'><span>Configure the AWS DMS connections to allow two-way communication to allow for ongoing change data capture (CDC)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-41' style=';'><div id='questionWrap-41'  class='   watupro-question-id-260422'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>41. <\/span>A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort. <br \/>\r<br>Which solution meets these requirements in the MOST efficient way?<\/div><input type='hidden' name='question_id[]' id='qID_41' value='260422' \/><input type='hidden' id='answerType260422' 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-260422[]' id='answer-id-1027564' class='answer   answerof-260422 ' value='1027564'   \/><label for='answer-id-1027564' id='answer-label-1027564' class=' answer'><span>Use Amazon RDS for MySQL as the database and use Amazon ElastiCache<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260422[]' id='answer-id-1027565' class='answer   answerof-260422 ' value='1027565'   \/><label for='answer-id-1027565' id='answer-label-1027565' class=' answer'><span>Use Amazon DynamoDB as the database and use DynamoDB Accelerator<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260422[]' id='answer-id-1027566' class='answer   answerof-260422 ' value='1027566'   \/><label for='answer-id-1027566' id='answer-label-1027566' class=' answer'><span>Use Amazon Aurora MySQL as the database and use Aurora\u2019s buffer cache<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260422[]' id='answer-id-1027567' class='answer   answerof-260422 ' value='1027567'   \/><label for='answer-id-1027567' id='answer-label-1027567' class=' answer'><span>Use Amazon DynamoDB as the database and use Amazon API Gateway<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-42' style=';'><div id='questionWrap-42'  class='   watupro-question-id-260423'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>42. <\/span>A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application experiences more traffic during the morning and evening hours. <br \/>\r<br>This application has two parts: <br \/>\r<br>&#10001; An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users. <br \/>\r<br>&#10001; A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data. <br \/>\r<br>A database specialist needs to design a cost-effective database solution to handle this workload. <br \/>\r<br>Which solution meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_42' value='260423' \/><input type='hidden' id='answerType260423' 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-260423[]' id='answer-id-1027568' class='answer   answerof-260423 ' value='1027568'   \/><label for='answer-id-1027568' id='answer-label-1027568' class=' answer'><span>Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260423[]' id='answer-id-1027569' class='answer   answerof-260423 ' value='1027569'   \/><label for='answer-id-1027569' id='answer-label-1027569' class=' answer'><span>Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260423[]' id='answer-id-1027570' class='answer   answerof-260423 ' value='1027570'   \/><label for='answer-id-1027570' id='answer-label-1027570' class=' answer'><span>Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260423[]' id='answer-id-1027571' class='answer   answerof-260423 ' value='1027571'   \/><label for='answer-id-1027571' id='answer-label-1027571' class=' answer'><span>Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CR<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-43' style=';'><div id='questionWrap-43'  class='   watupro-question-id-260424'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>43. <\/span>A company uses the Amazon DynamoDB table contractDB in us-east-1 for its contract system with the following schema: <br \/>\r<br>orderID (primary key) timestamp (sort key) contract (map) createdBy (string) <br \/>\r<br>customerEmail (string) <br \/>\r<br>After a problem in production, the operations team has asked a database specialist to provide an IAM policy to read items from the database to debug the application. In addition, the developer is not allowed to access the value of the customerEmail field to stay compliant. <br \/>\r<br>Which IAM policy should the database specialist use to achieve these requirements? <br \/>\r<br>A) <br \/>\r<br><br><img decoding=\"async\" width=650 height=672 id=\"\u56fe\u7247 46\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2023\/04\/image001-27.jpg\"><br><br \/>\r<br>B) <br \/>\r<br><br><img decoding=\"async\" width=649 height=595 id=\"\u56fe\u7247 48\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2023\/04\/image002-28.jpg\"><br><br \/>\r<br>C) <br \/>\r<br><br><img decoding=\"async\" width=650 height=605 id=\"\u56fe\u7247 50\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2023\/04\/image003-26.jpg\"><br><br \/>\r<br>D) <br \/>\r<br><br><img decoding=\"async\" width=649 height=670 id=\"\u56fe\u7247 52\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2023\/04\/image004-27.jpg\"><br><\/div><input type='hidden' name='question_id[]' id='qID_43' value='260424' \/><input type='hidden' id='answerType260424' 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-260424[]' id='answer-id-1027572' class='answer   answerof-260424 ' value='1027572'   \/><label for='answer-id-1027572' id='answer-label-1027572' class=' answer'><span>Option A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260424[]' id='answer-id-1027573' class='answer   answerof-260424 ' value='1027573'   \/><label for='answer-id-1027573' id='answer-label-1027573' class=' answer'><span>Option B<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260424[]' id='answer-id-1027574' class='answer   answerof-260424 ' value='1027574'   \/><label for='answer-id-1027574' id='answer-label-1027574' class=' answer'><span>Option C<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260424[]' id='answer-id-1027575' class='answer   answerof-260424 ' value='1027575'   \/><label for='answer-id-1027575' id='answer-label-1027575' class=' answer'><span>Option C<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-44' style=';'><div id='questionWrap-44'  class='   watupro-question-id-260425'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>44. <\/span>A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB. To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts. The company expects more than 10,000 users. <br \/>\r<br>How should a database specialist implement access control with the LEAST operational effort?<\/div><input type='hidden' name='question_id[]' id='qID_44' value='260425' \/><input type='hidden' id='answerType260425' 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-260425[]' id='answer-id-1027576' class='answer   answerof-260425 ' value='1027576'   \/><label for='answer-id-1027576' id='answer-label-1027576' class=' answer'><span>Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoD<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260425[]' id='answer-id-1027577' class='answer   answerof-260425 ' value='1027577'   \/><label for='answer-id-1027577' id='answer-label-1027577' class=' answer'><span>Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoD<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260425[]' id='answer-id-1027578' class='answer   answerof-260425 ' value='1027578'   \/><label for='answer-id-1027578' id='answer-label-1027578' class=' answer'><span>Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an AP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260425[]' id='answer-id-1027579' class='answer   answerof-260425 ' value='1027579'   \/><label for='answer-id-1027579' id='answer-label-1027579' class=' answer'><span>Use a single IAM user on the mobile app to access DynamoD<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-45' style=';'><div id='questionWrap-45'  class='   watupro-question-id-260426'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>45. <\/span>A company uses Microsoft SQL Server on Amazon RDS in a Multi-AZ deployment as the database engine for its application. The company was recently acquired by another company. A database specialist must rename the database to follow a new naming standard. <br \/>\r<br>Which combination of steps should the database specialist take to rename the database? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_45' value='260426' \/><input type='hidden' id='answerType260426' 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-260426[]' id='answer-id-1027580' class='answer   answerof-260426 ' value='1027580'   \/><label for='answer-id-1027580' id='answer-label-1027580' class=' answer'><span>Turn off automatic snapshots for the DB instance. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on the automatic snapshots.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260426[]' id='answer-id-1027581' class='answer   answerof-260426 ' value='1027581'   \/><label for='answer-id-1027581' id='answer-label-1027581' class=' answer'><span>Turn off Multi-AZ for the DB instance. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on Multi-AZ Mirroring.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260426[]' id='answer-id-1027582' class='answer   answerof-260426 ' value='1027582'   \/><label for='answer-id-1027582' id='answer-label-1027582' class=' answer'><span>Delete all existing snapshots for the DB instance. Use the rdsadmin.dbo.rds_modify_db_name stored procedure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260426[]' id='answer-id-1027583' class='answer   answerof-260426 ' value='1027583'   \/><label for='answer-id-1027583' id='answer-label-1027583' class=' answer'><span>Update the application with the new database connection string.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260426[]' id='answer-id-1027584' class='answer   answerof-260426 ' value='1027584'   \/><label for='answer-id-1027584' id='answer-label-1027584' class=' answer'><span>Update the DNS record for the DB instance.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-46' style=';'><div id='questionWrap-46'  class='   watupro-question-id-260427'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>46. <\/span>A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort. <br \/>\r<br>What should the Database Specialist do to meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_46' value='260427' \/><input type='hidden' id='answerType260427' 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-260427[]' id='answer-id-1027585' class='answer   answerof-260427 ' value='1027585'   \/><label for='answer-id-1027585' id='answer-label-1027585' class=' answer'><span>Restore a snapshot from the production cluster into test clusters<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260427[]' id='answer-id-1027586' class='answer   answerof-260427 ' value='1027586'   \/><label for='answer-id-1027586' id='answer-label-1027586' class=' answer'><span>Create logical dumps of the production cluster and restore them into new test clusters<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260427[]' id='answer-id-1027587' class='answer   answerof-260427 ' value='1027587'   \/><label for='answer-id-1027587' id='answer-label-1027587' class=' answer'><span>Use database cloning to create clones of the production cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260427[]' id='answer-id-1027588' class='answer   answerof-260427 ' value='1027588'   \/><label for='answer-id-1027588' id='answer-label-1027588' class=' answer'><span>Add an additional read replica to the production cluster and use that node for testing<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-47' style=';'><div id='questionWrap-47'  class='   watupro-question-id-260428'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>47. <\/span>A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas. This new website will replace an on-premises website connected to a legacy relational database. Due to stability issues in the legacy database, the company would like to test the resiliency of Aurora. <br \/>\r<br>Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?<\/div><input type='hidden' name='question_id[]' id='qID_47' value='260428' \/><input type='hidden' id='answerType260428' 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-260428[]' id='answer-id-1027589' class='answer   answerof-260428 ' value='1027589'   \/><label for='answer-id-1027589' id='answer-label-1027589' class=' answer'><span>Stop the DB cluster and analyze how the website responds<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260428[]' id='answer-id-1027590' class='answer   answerof-260428 ' value='1027590'   \/><label for='answer-id-1027590' id='answer-label-1027590' class=' answer'><span>Use Aurora fault injection to crash the master DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260428[]' id='answer-id-1027591' class='answer   answerof-260428 ' value='1027591'   \/><label for='answer-id-1027591' id='answer-label-1027591' class=' answer'><span>Remove the DB cluster endpoint to simulate a master DB instance failure<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260428[]' id='answer-id-1027592' class='answer   answerof-260428 ' value='1027592'   \/><label for='answer-id-1027592' id='answer-label-1027592' class=' answer'><span>Use Aurora Backtrack to crash the DB cluster<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-48' style=';'><div id='questionWrap-48'  class='   watupro-question-id-260429'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>48. <\/span>A huge gaming firm is developing a centralized method for storing the status of various online games' user sessions. The workload requires low-latency key-value storage and will consist of an equal number of reads and writes. Across the games' geographically dispersed user base, data should be written to the AWS Region nearest to the user. The design should reduce the burden associated with managing data replication across Regions. <br \/>\r<br>Which solution satisfies these criteria?<\/div><input type='hidden' name='question_id[]' id='qID_48' value='260429' \/><input type='hidden' id='answerType260429' 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-260429[]' id='answer-id-1027593' class='answer   answerof-260429 ' value='1027593'   \/><label for='answer-id-1027593' id='answer-label-1027593' class=' answer'><span>Amazon RDS for MySQL with multi-Region read replicas<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260429[]' id='answer-id-1027594' class='answer   answerof-260429 ' value='1027594'   \/><label for='answer-id-1027594' id='answer-label-1027594' class=' answer'><span>Amazon Aurora global database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260429[]' id='answer-id-1027595' class='answer   answerof-260429 ' value='1027595'   \/><label for='answer-id-1027595' id='answer-label-1027595' class=' answer'><span>Amazon RDS for Oracle with GoldenGate<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260429[]' id='answer-id-1027596' class='answer   answerof-260429 ' value='1027596'   \/><label for='answer-id-1027596' id='answer-label-1027596' class=' answer'><span>Amazon DynamoDB global tables<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-49' style=';'><div id='questionWrap-49'  class='   watupro-question-id-260430'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>49. <\/span>A company is running a finance application on an Amazon RDS for MySQL DB instance. The application is governed by multiple financial regulatory agencies. The RDS DB instance is set up with security groups to allow access to certain Amazon EC2 servers only. AWS KMS is used for encryption at rest. <br \/>\r<br>Which step will provide additional security?<\/div><input type='hidden' name='question_id[]' id='qID_49' value='260430' \/><input type='hidden' id='answerType260430' 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-260430[]' id='answer-id-1027597' class='answer   answerof-260430 ' value='1027597'   \/><label for='answer-id-1027597' id='answer-label-1027597' class=' answer'><span>Set up NACLs that allow the entire EC2 subnet to access the DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260430[]' id='answer-id-1027598' class='answer   answerof-260430 ' value='1027598'   \/><label for='answer-id-1027598' id='answer-label-1027598' class=' answer'><span>Disable the master user account<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260430[]' id='answer-id-1027599' class='answer   answerof-260430 ' value='1027599'   \/><label for='answer-id-1027599' id='answer-label-1027599' class=' answer'><span>Set up a security group that blocks SSH to the DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260430[]' id='answer-id-1027600' class='answer   answerof-260430 ' value='1027600'   \/><label for='answer-id-1027600' id='answer-label-1027600' class=' answer'><span>Set up RDS to use SSL for data in transit<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-50' style=';'><div id='questionWrap-50'  class='   watupro-question-id-260431'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>50. <\/span>An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources. <br \/>\r<br>What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?<\/div><input type='hidden' name='question_id[]' id='qID_50' value='260431' \/><input type='hidden' id='answerType260431' 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-260431[]' id='answer-id-1027601' class='answer   answerof-260431 ' value='1027601'   \/><label for='answer-id-1027601' id='answer-label-1027601' class=' answer'><span>Increase the size of the DB instance storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260431[]' id='answer-id-1027602' class='answer   answerof-260431 ' value='1027602'   \/><label for='answer-id-1027602' id='answer-label-1027602' class=' answer'><span>Change the underlying EBS storage type to General Purpose SSD (gp2)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260431[]' id='answer-id-1027603' class='answer   answerof-260431 ' value='1027603'   \/><label for='answer-id-1027603' id='answer-label-1027603' class=' answer'><span>Disable EBS optimization on the DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260431[]' id='answer-id-1027604' class='answer   answerof-260431 ' value='1027604'   \/><label for='answer-id-1027604' id='answer-label-1027604' class=' answer'><span>Change the DB instance to an instance class with a higher maximum bandwidth<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-51' style=';'><div id='questionWrap-51'  class='   watupro-question-id-260432'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>51. <\/span>A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost- effective and able to handle unpredictable application traffic. <br \/>\r<br>What should a Database Specialist recommend for this user?<\/div><input type='hidden' name='question_id[]' id='qID_51' value='260432' \/><input type='hidden' id='answerType260432' 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-260432[]' id='answer-id-1027605' class='answer   answerof-260432 ' value='1027605'   \/><label for='answer-id-1027605' id='answer-label-1027605' class=' answer'><span>Create an Amazon DynamoDB table with provisioned capacity mode<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260432[]' id='answer-id-1027606' class='answer   answerof-260432 ' value='1027606'   \/><label for='answer-id-1027606' id='answer-label-1027606' class=' answer'><span>Create an Amazon DocumentDB cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260432[]' id='answer-id-1027607' class='answer   answerof-260432 ' value='1027607'   \/><label for='answer-id-1027607' id='answer-label-1027607' class=' answer'><span>Create an Amazon DynamoDB table with on-demand capacity mode<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260432[]' id='answer-id-1027608' class='answer   answerof-260432 ' value='1027608'   \/><label for='answer-id-1027608' id='answer-label-1027608' class=' answer'><span>Create an Amazon Aurora Serverless DB cluster<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-52' style=';'><div id='questionWrap-52'  class='   watupro-question-id-260433'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>52. <\/span>A company has a production environment running on Amazon RDS for SQL Server with an in-house web application as the front end. During the last application maintenance window, new functionality was added to the web application to enhance the reporting capabilities for management. Since the update, the application is slow to respond to some reporting queries. <br \/>\r<br>How should the company identify the source of the problem?<\/div><input type='hidden' name='question_id[]' id='qID_52' value='260433' \/><input type='hidden' id='answerType260433' 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-260433[]' id='answer-id-1027609' class='answer   answerof-260433 ' value='1027609'   \/><label for='answer-id-1027609' id='answer-label-1027609' class=' answer'><span>Install and configure Amazon CloudWatch Application Insights for Microsoft .NET and Microsoft SQL Server. Use a CloudWatch dashboard to identify the root cause.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260433[]' id='answer-id-1027610' class='answer   answerof-260433 ' value='1027610'   \/><label for='answer-id-1027610' id='answer-label-1027610' class=' answer'><span>Enable RDS Performance Insights and determine which query is creating the problem. \r\nRequest changes to the query to address the problem.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260433[]' id='answer-id-1027611' class='answer   answerof-260433 ' value='1027611'   \/><label for='answer-id-1027611' id='answer-label-1027611' class=' answer'><span>Use AWS X-Ray deployed with Amazon RDS to track query system traces.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260433[]' id='answer-id-1027612' class='answer   answerof-260433 ' value='1027612'   \/><label for='answer-id-1027612' id='answer-label-1027612' class=' answer'><span>Create a support request and work with AWS Support to identify the source of the issue.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-53' style=';'><div id='questionWrap-53'  class='   watupro-question-id-260434'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>53. <\/span>A company has applications running on Amazon EC2 instances in a private subnet with no internet connectivity. The company deployed a new application that uses Amazon DynamoDB, but the application cannot connect to the DynamoDB tables. A developer already checked that all permissions are set correctly. <br \/>\r<br>What should a database specialist do to resolve this issue while minimizing access to external resources?<\/div><input type='hidden' name='question_id[]' id='qID_53' value='260434' \/><input type='hidden' id='answerType260434' 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-260434[]' id='answer-id-1027613' class='answer   answerof-260434 ' value='1027613'   \/><label for='answer-id-1027613' id='answer-label-1027613' class=' answer'><span>Add a route to an internet gateway in the subnet\u2019s route table.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260434[]' id='answer-id-1027614' class='answer   answerof-260434 ' value='1027614'   \/><label for='answer-id-1027614' id='answer-label-1027614' class=' answer'><span>Add a route to a NAT gateway in the subnet\u2019s route table.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260434[]' id='answer-id-1027615' class='answer   answerof-260434 ' value='1027615'   \/><label for='answer-id-1027615' id='answer-label-1027615' class=' answer'><span>Assign a new security group to the EC2 instances with an outbound rule to ports 80 and 443.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260434[]' id='answer-id-1027616' class='answer   answerof-260434 ' value='1027616'   \/><label for='answer-id-1027616' id='answer-label-1027616' class=' answer'><span>Create a VPC endpoint for DynamoDB and add a route to the endpoint in the subnet\u2019s route table.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-54' style=';'><div id='questionWrap-54'  class='   watupro-question-id-260435'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>54. <\/span>A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue. <br \/>\r<br>Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)<\/div><input type='hidden' name='question_id[]' id='qID_54' value='260435' \/><input type='hidden' id='answerType260435' 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-260435[]' id='answer-id-1027617' class='answer   answerof-260435 ' value='1027617'   \/><label for='answer-id-1027617' id='answer-label-1027617' class=' answer'><span>Grant least privilege to groups, users, and roles<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260435[]' id='answer-id-1027618' class='answer   answerof-260435 ' value='1027618'   \/><label for='answer-id-1027618' id='answer-label-1027618' class=' answer'><span>Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260435[]' id='answer-id-1027619' class='answer   answerof-260435 ' value='1027619'   \/><label for='answer-id-1027619' id='answer-label-1027619' class=' answer'><span>Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260435[]' id='answer-id-1027620' class='answer   answerof-260435 ' value='1027620'   \/><label for='answer-id-1027620' id='answer-label-1027620' class=' answer'><span>Use policy conditions to restrict access to selective IP addresses<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260435[]' id='answer-id-1027621' class='answer   answerof-260435 ' value='1027621'   \/><label for='answer-id-1027621' id='answer-label-1027621' class=' answer'><span>Use AccessList Controls policy type to restrict users for database instance deletion<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260435[]' id='answer-id-1027622' class='answer   answerof-260435 ' value='1027622'   \/><label for='answer-id-1027622' id='answer-label-1027622' class=' answer'><span>Enable AWS CloudTrail logging and Enhanced Monitoring<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-55' style=';'><div id='questionWrap-55'  class='   watupro-question-id-260436'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>55. <\/span>A database professional is developing an application that will respond to single-instance requests. The program will query large amounts of client data and offer end users with results. <br \/>\r<br>These reports may include a variety of fields. The database specialist want to enable users to query the database using any of the fields offered. <br \/>\r<br>During peak periods, the database's traffic volume will be significant yet changeable. <br \/>\r<br>However, the database will see little activity over the rest of the day. <br \/>\r<br>Which approach will be the most cost-effective in meeting these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_55' value='260436' \/><input type='hidden' id='answerType260436' 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-260436[]' id='answer-id-1027623' class='answer   answerof-260436 ' value='1027623'   \/><label for='answer-id-1027623' id='answer-label-1027623' class=' answer'><span>Amazon DynamoDB with provisioned capacity mode and auto scaling<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260436[]' id='answer-id-1027624' class='answer   answerof-260436 ' value='1027624'   \/><label for='answer-id-1027624' id='answer-label-1027624' class=' answer'><span>Amazon DynamoDB with on-demand capacity mode<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260436[]' id='answer-id-1027625' class='answer   answerof-260436 ' value='1027625'   \/><label for='answer-id-1027625' id='answer-label-1027625' class=' answer'><span>Amazon Aurora with auto scaling enabled<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260436[]' id='answer-id-1027626' class='answer   answerof-260436 ' value='1027626'   \/><label for='answer-id-1027626' id='answer-label-1027626' class=' answer'><span>Amazon Aurora in a serverless mode<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-56' style=';'><div id='questionWrap-56'  class='   watupro-question-id-260437'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>56. <\/span>A manufacturing company\u2019s website uses an Amazon Aurora PostgreSQL DB cluster. <br \/>\r<br>Which configurations will result in the LEAST application downtime during a failover? (Choose three.)<\/div><input type='hidden' name='question_id[]' id='qID_56' value='260437' \/><input type='hidden' id='answerType260437' 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-260437[]' id='answer-id-1027627' class='answer   answerof-260437 ' value='1027627'   \/><label for='answer-id-1027627' id='answer-label-1027627' class=' answer'><span>Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260437[]' id='answer-id-1027628' class='answer   answerof-260437 ' value='1027628'   \/><label for='answer-id-1027628' id='answer-label-1027628' class=' answer'><span>Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260437[]' id='answer-id-1027629' class='answer   answerof-260437 ' value='1027629'   \/><label for='answer-id-1027629' id='answer-label-1027629' class=' answer'><span>Edit and enable Aurora DB cluster cache management in parameter groups.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260437[]' id='answer-id-1027630' class='answer   answerof-260437 ' value='1027630'   \/><label for='answer-id-1027630' id='answer-label-1027630' class=' answer'><span>Set TCP keepalive parameters to a high value.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260437[]' id='answer-id-1027631' class='answer   answerof-260437 ' value='1027631'   \/><label for='answer-id-1027631' id='answer-label-1027631' class=' answer'><span>Set JDBC connection string timeout variables to a low value.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260437[]' id='answer-id-1027632' class='answer   answerof-260437 ' value='1027632'   \/><label for='answer-id-1027632' id='answer-label-1027632' class=' answer'><span>Set Java DNS caching timeouts to a high value.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-57' style=';'><div id='questionWrap-57'  class='   watupro-question-id-260438'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>57. <\/span>A company is using Amazon Redshift as its data warehouse solution. <br \/>\r<br>The Redshift cluster handles the following types of workloads: <br \/>\r<br>* Real-time inserts through Amazon Kinesis Data Firehose <br \/>\r<br>* Bulk inserts through COPY commands from Amazon S3 <br \/>\r<br>* Analytics through SQL queries <br \/>\r<br>Recently, the cluster has started to experience performance issues. <br \/>\r<br>Which combination of actions should a database specialist take to improve the cluster's performance? (Choose three.)<\/div><input type='hidden' name='question_id[]' id='qID_57' value='260438' \/><input type='hidden' id='answerType260438' 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-260438[]' id='answer-id-1027633' class='answer   answerof-260438 ' value='1027633'   \/><label for='answer-id-1027633' id='answer-label-1027633' class=' answer'><span>Modify the Kinesis Data Firehose delivery stream to stream the data to Amazon S3 with a high buffer size and to load the data into Amazon Redshift by using the COPY command.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260438[]' id='answer-id-1027634' class='answer   answerof-260438 ' value='1027634'   \/><label for='answer-id-1027634' id='answer-label-1027634' class=' answer'><span>Stream real-time data into Redshift temporary tables before loading the data into permanent tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260438[]' id='answer-id-1027635' class='answer   answerof-260438 ' value='1027635'   \/><label for='answer-id-1027635' id='answer-label-1027635' class=' answer'><span>For bulk inserts, split input files on Amazon S3 into multiple files to match the number of slices on Amazon Redshift. Then use the COPY command to load data into Amazon Redshift.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260438[]' id='answer-id-1027636' class='answer   answerof-260438 ' value='1027636'   \/><label for='answer-id-1027636' id='answer-label-1027636' class=' answer'><span>For bulk inserts, use the parallel parameter in the COPY command to enable multi-threading.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260438[]' id='answer-id-1027637' class='answer   answerof-260438 ' value='1027637'   \/><label for='answer-id-1027637' id='answer-label-1027637' class=' answer'><span>Optimize analytics SQL queries to use sort keys.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260438[]' id='answer-id-1027638' class='answer   answerof-260438 ' value='1027638'   \/><label for='answer-id-1027638' id='answer-label-1027638' class=' answer'><span>Avoid using temporary tables in analytics SQL queries.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-58' style=';'><div id='questionWrap-58'  class='   watupro-question-id-260439'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>58. <\/span>A company has multiple applications serving data from a secure on-premises database. The company is migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as the migration target, and leveraging the Advanced Auditing feature in Aurora. <br \/>\r<br>Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing requirements? (Choose three.)<\/div><input type='hidden' name='question_id[]' id='qID_58' value='260439' \/><input type='hidden' id='answerType260439' 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-260439[]' id='answer-id-1027639' class='answer   answerof-260439 ' value='1027639'   \/><label for='answer-id-1027639' id='answer-label-1027639' class=' answer'><span>CONNECT<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260439[]' id='answer-id-1027640' class='answer   answerof-260439 ' value='1027640'   \/><label for='answer-id-1027640' id='answer-label-1027640' class=' answer'><span>QUERY_DCL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260439[]' id='answer-id-1027641' class='answer   answerof-260439 ' value='1027641'   \/><label for='answer-id-1027641' id='answer-label-1027641' class=' answer'><span>QUERY_DDL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260439[]' id='answer-id-1027642' class='answer   answerof-260439 ' value='1027642'   \/><label for='answer-id-1027642' id='answer-label-1027642' class=' answer'><span>QUERY_DML<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260439[]' id='answer-id-1027643' class='answer   answerof-260439 ' value='1027643'   \/><label for='answer-id-1027643' id='answer-label-1027643' class=' answer'><span>TABLE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260439[]' id='answer-id-1027644' class='answer   answerof-260439 ' value='1027644'   \/><label for='answer-id-1027644' id='answer-label-1027644' class=' answer'><span>QUERY<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-59' style=';'><div id='questionWrap-59'  class='   watupro-question-id-260440'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>59. <\/span>A business's production databases are housed on a 3 TB Amazon Aurora MySQL DB cluster. The database cluster is installed in the region us-east-1. For disaster recovery (DR) requirements, the company's database expert needs to fast deploy the DB cluster in another AWS Region to handle the production load with an RTO of less than two hours. <br \/>\r<br>Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_59' value='260440' \/><input type='hidden' id='answerType260440' 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-260440[]' id='answer-id-1027645' class='answer   answerof-260440 ' value='1027645'   \/><label for='answer-id-1027645' id='answer-label-1027645' class=' answer'><span>Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Region. Restore the snapshot to an appropriately sized DB cluster in the DR Region.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260440[]' id='answer-id-1027646' class='answer   answerof-260440 ' value='1027646'   \/><label for='answer-id-1027646' id='answer-label-1027646' class=' answer'><span>Add a cross-Region read replica in the DR Region with the same instance type as the current primary instance. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260440[]' id='answer-id-1027647' class='answer   answerof-260440 ' value='1027647'   \/><label for='answer-id-1027647' id='answer-label-1027647' class=' answer'><span>Create a smaller DB cluster in the DR Region. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260440[]' id='answer-id-1027648' class='answer   answerof-260440 ' value='1027648'   \/><label for='answer-id-1027648' id='answer-label-1027648' class=' answer'><span>Create an Aurora global database that spans two Regions. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-60' style=';'><div id='questionWrap-60'  class='   watupro-question-id-260441'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>60. <\/span>A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company\u2019s main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second. <br \/>\r<br>Which solution meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_60' value='260441' \/><input type='hidden' id='answerType260441' 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-260441[]' id='answer-id-1027649' class='answer   answerof-260441 ' value='1027649'   \/><label for='answer-id-1027649' id='answer-label-1027649' class=' answer'><span>Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap- northeast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to cache application data from the replica to generate the dashboards.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260441[]' id='answer-id-1027650' class='answer   answerof-260441 ' value='1027650'   \/><label for='answer-id-1027650' id='answer-label-1027650' class=' answer'><span>Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1 Region. Use Amazon QuickSight for displaying dashboard results.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260441[]' id='answer-id-1027651' class='answer   answerof-260441 ' value='1027651'   \/><label for='answer-id-1027651' id='answer-label-1027651' class=' answer'><span>Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260441[]' id='answer-id-1027652' class='answer   answerof-260441 ' value='1027652'   \/><label for='answer-id-1027652' id='answer-label-1027652' class=' answer'><span>Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-61' style=';'><div id='questionWrap-61'  class='   watupro-question-id-260442'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>61. <\/span>A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload. <br \/>\r<br>The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise. <br \/>\r<br>How can a Database Specialist address these requirements with minimal user involvement?<\/div><input type='hidden' name='question_id[]' id='qID_61' value='260442' \/><input type='hidden' id='answerType260442' 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-260442[]' id='answer-id-1027653' class='answer   answerof-260442 ' value='1027653'   \/><label for='answer-id-1027653' id='answer-label-1027653' class=' answer'><span>Split up the DB cluster into two different clusters: one for OLTP and the other for reporting. Monitor and set up replication between the two clusters to keep data consistent.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260442[]' id='answer-id-1027654' class='answer   answerof-260442 ' value='1027654'   \/><label for='answer-id-1027654' id='answer-label-1027654' class=' answer'><span>Review all evaluate the peak combined workload. Ensure that utilization of the DB cluster node is at an acceptable level. Adjust the number of instances, if necessary.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260442[]' id='answer-id-1027655' class='answer   answerof-260442 ' value='1027655'   \/><label for='answer-id-1027655' id='answer-label-1027655' class=' answer'><span>Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workload. The cluster can be restarted again depending on the workload at the time.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260442[]' id='answer-id-1027656' class='answer   answerof-260442 ' value='1027656'   \/><label for='answer-id-1027656' id='answer-label-1027656' class=' answer'><span>Set up automatic scaling on the DB cluster. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-62' style=';'><div id='questionWrap-62'  class='   watupro-question-id-260443'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>62. <\/span>A company\u2019s database specialist disabled TLS on an Amazon DocumentDB cluster to perform benchmarking tests. A few days after this change was implemented, a database specialist trainee accidentally deleted multiple tables. The database specialist restored the database from available snapshots. An hour after restoring the cluster, the database specialist is still unable to connect to the new cluster endpoint. <br \/>\r<br>What should the database specialist do to connect to the new, restored Amazon DocumentDB cluster?<\/div><input type='hidden' name='question_id[]' id='qID_62' value='260443' \/><input type='hidden' id='answerType260443' 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-260443[]' id='answer-id-1027657' class='answer   answerof-260443 ' value='1027657'   \/><label for='answer-id-1027657' id='answer-label-1027657' class=' answer'><span>Change the restored cluster\u2019s parameter group to the original cluster\u2019s custom parameter group.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260443[]' id='answer-id-1027658' class='answer   answerof-260443 ' value='1027658'   \/><label for='answer-id-1027658' id='answer-label-1027658' class=' answer'><span>Change the restored cluster\u2019s parameter group to the Amazon DocumentDB default parameter group.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260443[]' id='answer-id-1027659' class='answer   answerof-260443 ' value='1027659'   \/><label for='answer-id-1027659' id='answer-label-1027659' class=' answer'><span>Configure the interface VPC endpoint and associate the new Amazon DocumentDB cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260443[]' id='answer-id-1027660' class='answer   answerof-260443 ' value='1027660'   \/><label for='answer-id-1027660' id='answer-label-1027660' class=' answer'><span>Run the syncInstances command in AWS DataSync.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-63' style=';'><div id='questionWrap-63'  class='   watupro-question-id-260444'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>63. <\/span>A company stores session history for its users in an Amazon DynamoDB table. The company has a large user base and generates large amounts of session data. <br \/>\r<br>Teams analyze the session data for 1 week, and then the data is no longer needed. A database specialist needs to design an automated solution to purge session data that is more than 1 week old. <br \/>\r<br>Which strategy meets these requirements with the MOST operational efficiency?<\/div><input type='hidden' name='question_id[]' id='qID_63' value='260444' \/><input type='hidden' id='answerType260444' 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-260444[]' id='answer-id-1027661' class='answer   answerof-260444 ' value='1027661'   \/><label for='answer-id-1027661' id='answer-label-1027661' class=' answer'><span>Create an AWS Step Functions state machine with a DynamoDB DeleteItem operation that uses the ConditionExpression parameter to delete items older than a week. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that runs the Step Functions state machine on a weekly basis.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260444[]' id='answer-id-1027662' class='answer   answerof-260444 ' value='1027662'   \/><label for='answer-id-1027662' id='answer-label-1027662' class=' answer'><span>Create an AWS Lambda function to delete items older than a week from the DynamoDB table. Create an Amazon EventBridge (Amazon CloudWatch Events) scheduled rule that triggers the Lambda function on a weekly basis.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260444[]' id='answer-id-1027663' class='answer   answerof-260444 ' value='1027663'   \/><label for='answer-id-1027663' id='answer-label-1027663' class=' answer'><span>Enable Amazon DynamoDB Streams on the table. Use a stream to invoke an AWS Lambda function to delete items older than a week from the DynamoDB table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260444[]' id='answer-id-1027664' class='answer   answerof-260444 ' value='1027664'   \/><label for='answer-id-1027664' id='answer-label-1027664' class=' answer'><span>Enable TTL on the DynamoDB table and set a Number data type as the TTL attribute. DynamoDB will automatically delete items that have a TTL that is less than the current time.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-64' style=';'><div id='questionWrap-64'  class='   watupro-question-id-260445'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>64. <\/span>A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors. <br \/>\r<br>Which of the following will resolve this issue?<\/div><input type='hidden' name='question_id[]' id='qID_64' value='260445' \/><input type='hidden' id='answerType260445' 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-260445[]' id='answer-id-1027665' class='answer   answerof-260445 ' value='1027665'   \/><label for='answer-id-1027665' id='answer-label-1027665' class=' answer'><span>Edit the my.cnf file for the DB cluster to increase max_connections<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260445[]' id='answer-id-1027666' class='answer   answerof-260445 ' value='1027666'   \/><label for='answer-id-1027666' id='answer-label-1027666' class=' answer'><span>Increase the instance size of the DB cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260445[]' id='answer-id-1027667' class='answer   answerof-260445 ' value='1027667'   \/><label for='answer-id-1027667' id='answer-label-1027667' class=' answer'><span>Change the DB cluster to Multi-AZ<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260445[]' id='answer-id-1027668' class='answer   answerof-260445 ' value='1027668'   \/><label for='answer-id-1027668' id='answer-label-1027668' class=' answer'><span>Increase the number of Aurora Replicas<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-65' style=';'><div id='questionWrap-65'  class='   watupro-question-id-260446'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>65. <\/span>A company is writing a new survey application to be used with a weekly televised game show. The application will be available for 2 hours each week. The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user. A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle he anticipated volume. <br \/>\r<br>Which AWS services should the Database Specialist consider? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_65' value='260446' \/><input type='hidden' id='answerType260446' 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-260446[]' id='answer-id-1027669' class='answer   answerof-260446 ' value='1027669'   \/><label for='answer-id-1027669' id='answer-label-1027669' class=' answer'><span>Amazon DynamoDB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260446[]' id='answer-id-1027670' class='answer   answerof-260446 ' value='1027670'   \/><label for='answer-id-1027670' id='answer-label-1027670' class=' answer'><span>Amazon Redshift<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260446[]' id='answer-id-1027671' class='answer   answerof-260446 ' value='1027671'   \/><label for='answer-id-1027671' id='answer-label-1027671' class=' answer'><span>Amazon Neptune<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260446[]' id='answer-id-1027672' class='answer   answerof-260446 ' value='1027672'   \/><label for='answer-id-1027672' id='answer-label-1027672' class=' answer'><span>Amazon Elasticsearch Service<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260446[]' id='answer-id-1027673' class='answer   answerof-260446 ' value='1027673'   \/><label for='answer-id-1027673' id='answer-label-1027673' class=' answer'><span>Amazon ElastiCache<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-66' style=';'><div id='questionWrap-66'  class='   watupro-question-id-260447'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>66. <\/span>A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective. <br \/>\r<br>Which approach should the Database Specialist take?<\/div><input type='hidden' name='question_id[]' id='qID_66' value='260447' \/><input type='hidden' id='answerType260447' 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-260447[]' id='answer-id-1027674' class='answer   answerof-260447 ' value='1027674'   \/><label for='answer-id-1027674' id='answer-label-1027674' class=' answer'><span>Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp). Run data transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260447[]' id='answer-id-1027675' class='answer   answerof-260447 ' value='1027675'   \/><label for='answer-id-1027675' id='answer-label-1027675' class=' answer'><span>Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RD<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260447[]' id='answer-id-1027676' class='answer   answerof-260447 ' value='1027676'   \/><label for='answer-id-1027676' id='answer-label-1027676' class=' answer'><span>Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260447[]' id='answer-id-1027677' class='answer   answerof-260447 ' value='1027677'   \/><label for='answer-id-1027677' id='answer-label-1027677' class=' answer'><span>Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-67' style=';'><div id='questionWrap-67'  class='   watupro-question-id-260448'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>67. <\/span>A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL. <br \/>\r<br>The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop. <br \/>\r<br>How should the Database Specialist edit the script to fix this issue?<\/div><input type='hidden' name='question_id[]' id='qID_67' value='260448' \/><input type='hidden' id='answerType260448' 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-260448[]' id='answer-id-1027678' class='answer   answerof-260448 ' value='1027678'   \/><label for='answer-id-1027678' id='answer-label-1027678' class=' answer'><span>Stop the source instances before stopping their read replicas<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260448[]' id='answer-id-1027679' class='answer   answerof-260448 ' value='1027679'   \/><label for='answer-id-1027679' id='answer-label-1027679' class=' answer'><span>Delete each read replica before stopping its corresponding source instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260448[]' id='answer-id-1027680' class='answer   answerof-260448 ' value='1027680'   \/><label for='answer-id-1027680' id='answer-label-1027680' class=' answer'><span>Stop the read replicas before stopping their source instances<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260448[]' id='answer-id-1027681' class='answer   answerof-260448 ' value='1027681'   \/><label for='answer-id-1027681' id='answer-label-1027681' class=' answer'><span>Use the AWS CLI to stop each read replica and source instance at the same time<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-68' style=';'><div id='questionWrap-68'  class='   watupro-question-id-260449'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>68. <\/span>A company has a on-premises Oracle Real Application Clusters (RAC) database. The company wants to migrate the database to AWS and reduce licensing costs. The company's application team wants to store JSON payloads that expire after 28 hours. The company has development capacity if code changes are required. <br \/>\r<br>Which solution meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_68' value='260449' \/><input type='hidden' id='answerType260449' 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-260449[]' id='answer-id-1027682' class='answer   answerof-260449 ' value='1027682'   \/><label for='answer-id-1027682' id='answer-label-1027682' class=' answer'><span>Use Amazon DynamoDB and leverage the Time to Live (TTL) feature to automatically expire the data.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260449[]' id='answer-id-1027683' class='answer   answerof-260449 ' value='1027683'   \/><label for='answer-id-1027683' id='answer-label-1027683' class=' answer'><span>Use Amazon RDS for Oracle with Multi-A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260449[]' id='answer-id-1027684' class='answer   answerof-260449 ' value='1027684'   \/><label for='answer-id-1027684' id='answer-label-1027684' class=' answer'><span>Create an AWS Lambda function to purge the expired data. Schedule the Lambda function to run daily using Amazon EventBridge.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260449[]' id='answer-id-1027685' class='answer   answerof-260449 ' value='1027685'   \/><label for='answer-id-1027685' id='answer-label-1027685' class=' answer'><span>Use Amazon DocumentDB with a read replica in a different Availability Zone. Use DocumentDB change streams to expire the data.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260449[]' id='answer-id-1027686' class='answer   answerof-260449 ' value='1027686'   \/><label for='answer-id-1027686' id='answer-label-1027686' class=' answer'><span>Use Amazon Aurora PostgreSQL with Multi-AZ and leverage the Time to Live (TTL) feature to automatically expire the data.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-69' style=';'><div id='questionWrap-69'  class='   watupro-question-id-260450'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>69. <\/span>AWS CloudFormation stack including an Amazon RDS database instance was mistakenly removed, resulting in the loss of recent data. A Database Specialist must apply RDS parameters to the CloudFormation template in order to minimize the possibility of future inadvertent instance data loss. <br \/>\r<br>Which settings will satisfy this criterion? (Select three.)<\/div><input type='hidden' name='question_id[]' id='qID_69' value='260450' \/><input type='hidden' id='answerType260450' 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-260450[]' id='answer-id-1027687' class='answer   answerof-260450 ' value='1027687'   \/><label for='answer-id-1027687' id='answer-label-1027687' class=' answer'><span>Set DeletionProtection to True<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260450[]' id='answer-id-1027688' class='answer   answerof-260450 ' value='1027688'   \/><label for='answer-id-1027688' id='answer-label-1027688' class=' answer'><span>Set MultiAZ to True<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260450[]' id='answer-id-1027689' class='answer   answerof-260450 ' value='1027689'   \/><label for='answer-id-1027689' id='answer-label-1027689' class=' answer'><span>Set TerminationProtection to True<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260450[]' id='answer-id-1027690' class='answer   answerof-260450 ' value='1027690'   \/><label for='answer-id-1027690' id='answer-label-1027690' class=' answer'><span>Set DeleteAutomatedBackups to False<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260450[]' id='answer-id-1027691' class='answer   answerof-260450 ' value='1027691'   \/><label for='answer-id-1027691' id='answer-label-1027691' class=' answer'><span>Set DeletionPolicy to Delete<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260450[]' id='answer-id-1027692' class='answer   answerof-260450 ' value='1027692'   \/><label for='answer-id-1027692' id='answer-label-1027692' class=' answer'><span>Set DeletionPolicy to Retain<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-70' style=';'><div id='questionWrap-70'  class='   watupro-question-id-260451'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>70. <\/span>A company with 500,000 employees needs to supply its employee list to an application used by human resources. Every 30 minutes, the data is exported using the LDAP service to load into a new Amazon DynamoDB table. The data model has a base table with Employee ID for the partition key and a global secondary index with Organization ID as the partition key. <br \/>\r<br>While importing the data, a database specialist receives ProvisionedThroughputExceededException errors. After increasing the provisioned write capacity units (WCUs) to 50,000, the specialist receives the same errors. Amazon CloudWatch metrics show a consumption of 1,500 WCUs. <br \/>\r<br>What should the database specialist do to address the issue?<\/div><input type='hidden' name='question_id[]' id='qID_70' value='260451' \/><input type='hidden' id='answerType260451' 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-260451[]' id='answer-id-1027693' class='answer   answerof-260451 ' value='1027693'   \/><label for='answer-id-1027693' id='answer-label-1027693' class=' answer'><span>Change the data model to avoid hot partitions in the global secondary index.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260451[]' id='answer-id-1027694' class='answer   answerof-260451 ' value='1027694'   \/><label for='answer-id-1027694' id='answer-label-1027694' class=' answer'><span>Enable auto scaling for the table to automatically increase write capacity during bulk imports.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260451[]' id='answer-id-1027695' class='answer   answerof-260451 ' value='1027695'   \/><label for='answer-id-1027695' id='answer-label-1027695' class=' answer'><span>Modify the table to use on-demand capacity instead of provisioned capacity.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260451[]' id='answer-id-1027696' class='answer   answerof-260451 ' value='1027696'   \/><label for='answer-id-1027696' id='answer-label-1027696' class=' answer'><span>Increase the number of retries on the bulk loading application.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-71' style=';'><div id='questionWrap-71'  class='   watupro-question-id-260452'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>71. <\/span>A company's database specialist is building an Amazon RDS for Microsoft SQL Server DB instance to store hundreds of records in CSV format. A customer service tool uploads the records to an Amazon S3 bucket. <br \/>\r<br>An employee who previously worked at the company already created a custom stored procedure to map the necessary CSV fields to the database tables. The database specialist needs to implement a solution that reuses this previous work and minimizes operational overhead. <br \/>\r<br>Which solution will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_71' value='260452' \/><input type='hidden' id='answerType260452' 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-260452[]' id='answer-id-1027697' class='answer   answerof-260452 ' value='1027697'   \/><label for='answer-id-1027697' id='answer-label-1027697' class=' answer'><span>Create an Amazon S3 event to invoke an AWS Lambda function. Configure the Lambda function to parse the .csv file and use a SQL client library to run INSERT statements to load the data into the tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260452[]' id='answer-id-1027698' class='answer   answerof-260452 ' value='1027698'   \/><label for='answer-id-1027698' id='answer-label-1027698' class=' answer'><span>Write a custom .NET app that is hosted on Amazon EC2. Configure the .NET app to load the .csv file and call the custom stored procedure to insert the data into the tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260452[]' id='answer-id-1027699' class='answer   answerof-260452 ' value='1027699'   \/><label for='answer-id-1027699' id='answer-label-1027699' class=' answer'><span>Download the .csv file from Amazon S3 to the RDS D drive by using an AWS msdb stored procedure. Call the custom stored procedure to insert the data from the RDS D drive into the tables.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260452[]' id='answer-id-1027700' class='answer   answerof-260452 ' value='1027700'   \/><label for='answer-id-1027700' id='answer-label-1027700' class=' answer'><span>Create an Amazon S3 event to invoke AWS Step Functions to parse the .csv file and call the custom stored procedure to insert the data into the tables.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-72' style=';'><div id='questionWrap-72'  class='   watupro-question-id-260453'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>72. <\/span>A corporation wishes to move a 1 TB Oracle database from its current location to an Amazon Aurora PostgreSQL DB cluster. The database specialist at the firm noticed that the Oracle database stores 100 GB of large binary objects (LOBs) across many tables. The Oracle database supports LOBs up to 500 MB in size and an average of 350 MB. AWS DMS was picked by the Database Specialist to transfer the data with the most replication instances. <br \/>\r<br>How should the database specialist improve the transfer of the database to AWS DMS?<\/div><input type='hidden' name='question_id[]' id='qID_72' value='260453' \/><input type='hidden' id='answerType260453' 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-260453[]' id='answer-id-1027701' class='answer   answerof-260453 ' value='1027701'   \/><label for='answer-id-1027701' id='answer-label-1027701' class=' answer'><span>Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260453[]' id='answer-id-1027702' class='answer   answerof-260453 ' value='1027702'   \/><label for='answer-id-1027702' id='answer-label-1027702' class=' answer'><span>Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260453[]' id='answer-id-1027703' class='answer   answerof-260453 ' value='1027703'   \/><label for='answer-id-1027703' id='answer-label-1027703' class=' answer'><span>Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260453[]' id='answer-id-1027704' class='answer   answerof-260453 ' value='1027704'   \/><label for='answer-id-1027704' id='answer-label-1027704' class=' answer'><span>Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-73' style=';'><div id='questionWrap-73'  class='   watupro-question-id-260454'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>73. <\/span>Amazon RDS for Oracle with Transparent Data Encryption is used by a financial services organization (TDE). At all times, the organization is obligated to encrypt its data at rest. The decryption key must be widely distributed, and access to the key must be restricted. The organization must be able to rotate the encryption key on demand to comply with regulatory requirements. If any possible security vulnerabilities are discovered, the organization must be able to disable the key. Additionally, the company's overhead must be kept to a minimal. <br \/>\r<br>What method should the database administrator use to configure the encryption to fulfill these specifications?<\/div><input type='hidden' name='question_id[]' id='qID_73' value='260454' \/><input type='hidden' id='answerType260454' 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-260454[]' id='answer-id-1027705' class='answer   answerof-260454 ' value='1027705'   \/><label for='answer-id-1027705' id='answer-label-1027705' class=' answer'><span>AWS CloudHSM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260454[]' id='answer-id-1027706' class='answer   answerof-260454 ' value='1027706'   \/><label for='answer-id-1027706' id='answer-label-1027706' class=' answer'><span>AWS Key Management Service (AWS KMS) with an AWS managed key<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260454[]' id='answer-id-1027707' class='answer   answerof-260454 ' value='1027707'   \/><label for='answer-id-1027707' id='answer-label-1027707' class=' answer'><span>AWS Key Management Service (AWS KMS) with server-side encryption<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260454[]' id='answer-id-1027708' class='answer   answerof-260454 ' value='1027708'   \/><label for='answer-id-1027708' id='answer-label-1027708' class=' answer'><span>AWS Key Management Service (AWS KMS) CMK with customer-provided material<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-74' style=';'><div id='questionWrap-74'  class='   watupro-question-id-260455'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>74. <\/span>A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync. <br \/>\r<br>What should the company do to resolve these performance issues?<\/div><input type='hidden' name='question_id[]' id='qID_74' value='260455' \/><input type='hidden' id='answerType260455' 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-260455[]' id='answer-id-1027709' class='answer   answerof-260455 ' value='1027709'   \/><label for='answer-id-1027709' id='answer-label-1027709' class=' answer'><span>Add an Aurora Replica to scale the read traffic.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260455[]' id='answer-id-1027710' class='answer   answerof-260455 ' value='1027710'   \/><label for='answer-id-1027710' id='answer-label-1027710' class=' answer'><span>Scale up the DB instance class.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260455[]' id='answer-id-1027711' class='answer   answerof-260455 ' value='1027711'   \/><label for='answer-id-1027711' id='answer-label-1027711' class=' answer'><span>Modify applications to commit transactions in batches.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260455[]' id='answer-id-1027712' class='answer   answerof-260455 ' value='1027712'   \/><label for='answer-id-1027712' id='answer-label-1027712' class=' answer'><span>Modify applications to avoid conflicts by taking locks.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-75' style=';'><div id='questionWrap-75'  class='   watupro-question-id-260456'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>75. <\/span>A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account. The template configures provisioned throughput capacity using hard-coded values. The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned. <br \/>\r<br>Which solution will enable this change?<\/div><input type='hidden' name='question_id[]' id='qID_75' value='260456' \/><input type='hidden' id='answerType260456' 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-260456[]' id='answer-id-1027713' class='answer   answerof-260456 ' value='1027713'   \/><label for='answer-id-1027713' id='answer-label-1027713' class=' answer'><span>Add values for the rcuCount and wcuCount parameters to the Mappings section of the template. Configure DynamoDB to provision throughput capacity using the stack\u2019s mappings.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260456[]' id='answer-id-1027714' class='answer   answerof-260456 ' value='1027714'   \/><label for='answer-id-1027714' id='answer-label-1027714' class=' answer'><span>Add values for two Number parameters, rcuCount and wcuCount, to the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260456[]' id='answer-id-1027715' class='answer   answerof-260456 ' value='1027715'   \/><label for='answer-id-1027715' id='answer-label-1027715' class=' answer'><span>Add values for the rcuCount and wcuCount parameters as outputs of the template. \r\nConfigure DynamoDB to provision throughput capacity using the stack outputs.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260456[]' id='answer-id-1027716' class='answer   answerof-260456 ' value='1027716'   \/><label for='answer-id-1027716' id='answer-label-1027716' class=' answer'><span>Add values for the rcuCount and wcuCount parameters to the Mappings section of the template. Replace the hard-coded values with calls to the Ref intrinsic function, referencing the new parameters.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-76' style=';'><div id='questionWrap-76'  class='   watupro-question-id-260457'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>76. <\/span>A global company is developing an application across multiple AWS Regions. The company needs a database solution with low latency in each Region and automatic disaster recovery. The database must be deployed in an active-active configuration with automatic data synchronization between Regions. <br \/>\r<br>Which solution will meet these requirements with the LOWEST latency?<\/div><input type='hidden' name='question_id[]' id='qID_76' value='260457' \/><input type='hidden' id='answerType260457' 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-260457[]' id='answer-id-1027717' class='answer   answerof-260457 ' value='1027717'   \/><label for='answer-id-1027717' id='answer-label-1027717' class=' answer'><span>Amazon RDS with cross-Region read replicas<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260457[]' id='answer-id-1027718' class='answer   answerof-260457 ' value='1027718'   \/><label for='answer-id-1027718' id='answer-label-1027718' class=' answer'><span>Amazon DynamoDB global tables<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260457[]' id='answer-id-1027719' class='answer   answerof-260457 ' value='1027719'   \/><label for='answer-id-1027719' id='answer-label-1027719' class=' answer'><span>Amazon Aurora global database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260457[]' id='answer-id-1027720' class='answer   answerof-260457 ' value='1027720'   \/><label for='answer-id-1027720' id='answer-label-1027720' class=' answer'><span>Amazon Athena and Amazon S3 with S3 Cross Region Replication<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-77' style=';'><div id='questionWrap-77'  class='   watupro-question-id-260458'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>77. <\/span>A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries are executed. Amazon CloudWatch metrics indicate that the instance requires more I\/O capacity. <br \/>\r<br>Which actions can a database specialist perform to resolve this issue? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_77' value='260458' \/><input type='hidden' id='answerType260458' 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-260458[]' id='answer-id-1027721' class='answer   answerof-260458 ' value='1027721'   \/><label for='answer-id-1027721' id='answer-label-1027721' class=' answer'><span>Restart the application tool used to execute queries.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260458[]' id='answer-id-1027722' class='answer   answerof-260458 ' value='1027722'   \/><label for='answer-id-1027722' id='answer-label-1027722' class=' answer'><span>Change to a database instance class with higher throughput.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260458[]' id='answer-id-1027723' class='answer   answerof-260458 ' value='1027723'   \/><label for='answer-id-1027723' id='answer-label-1027723' class=' answer'><span>Convert from Single-AZ to Multi-A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260458[]' id='answer-id-1027724' class='answer   answerof-260458 ' value='1027724'   \/><label for='answer-id-1027724' id='answer-label-1027724' class=' answer'><span>Increase the I\/O parameter in Amazon RDS Enhanced Monitoring.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260458[]' id='answer-id-1027725' class='answer   answerof-260458 ' value='1027725'   \/><label for='answer-id-1027725' id='answer-label-1027725' class=' answer'><span>Convert from General Purpose to Provisioned IOPS (PIOPS).<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-78' style=';'><div id='questionWrap-78'  class='   watupro-question-id-260459'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>78. <\/span>A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system. New compliance requirements specify that the database must be encrypted at rest. <br \/>\r<br>Which action will meet these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_78' value='260459' \/><input type='hidden' id='answerType260459' 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-260459[]' id='answer-id-1027726' class='answer   answerof-260459 ' value='1027726'   \/><label for='answer-id-1027726' id='answer-label-1027726' class=' answer'><span>Create an encrypted copy of manual snapshot of the DB instance. Restore a new DB instance from the encrypted snapshot.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260459[]' id='answer-id-1027727' class='answer   answerof-260459 ' value='1027727'   \/><label for='answer-id-1027727' id='answer-label-1027727' class=' answer'><span>Modify the DB instance and enable encryption.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260459[]' id='answer-id-1027728' class='answer   answerof-260459 ' value='1027728'   \/><label for='answer-id-1027728' id='answer-label-1027728' class=' answer'><span>Restore a DB instance from the most recent automated snapshot and enable encryption.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260459[]' id='answer-id-1027729' class='answer   answerof-260459 ' value='1027729'   \/><label for='answer-id-1027729' id='answer-label-1027729' class=' answer'><span>Create an encrypted read replica of the DB instance. Promote the read replica to a standalone instance.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-79' style=';'><div id='questionWrap-79'  class='   watupro-question-id-260460'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>79. <\/span>A database specialist is designing an enterprise application for a large company. The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX). <br \/>\r<br>The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads. <br \/>\r<br>What should the database specialist review first to improve the utility of DAX?<\/div><input type='hidden' name='question_id[]' id='qID_79' value='260460' \/><input type='hidden' id='answerType260460' 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-260460[]' id='answer-id-1027730' class='answer   answerof-260460 ' value='1027730'   \/><label for='answer-id-1027730' id='answer-label-1027730' class=' answer'><span>The DynamoDB ConsumedReadCapacityUnits metric<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260460[]' id='answer-id-1027731' class='answer   answerof-260460 ' value='1027731'   \/><label for='answer-id-1027731' id='answer-label-1027731' class=' answer'><span>The trust relationship to perform the DynamoDB API calls<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260460[]' id='answer-id-1027732' class='answer   answerof-260460 ' value='1027732'   \/><label for='answer-id-1027732' id='answer-label-1027732' class=' answer'><span>The DAX cluster's TTL setting<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260460[]' id='answer-id-1027733' class='answer   answerof-260460 ' value='1027733'   \/><label for='answer-id-1027733' id='answer-label-1027733' class=' answer'><span>The validity of customer-specified AWS Key Management Service (AWS KMS) keys for DAX encryption at rest<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-80' style=';'><div id='questionWrap-80'  class='   watupro-question-id-260461'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>80. <\/span>The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB. A database engineer must increase the local storage available in the Aurora DB instance. <br \/>\r<br>How should the database engineer meet this requirement?<\/div><input type='hidden' name='question_id[]' id='qID_80' value='260461' \/><input type='hidden' id='answerType260461' 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-260461[]' id='answer-id-1027734' class='answer   answerof-260461 ' value='1027734'   \/><label for='answer-id-1027734' id='answer-label-1027734' class=' answer'><span>Modify the DB instance to use an instance class that provides more local SSD storage.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260461[]' id='answer-id-1027735' class='answer   answerof-260461 ' value='1027735'   \/><label for='answer-id-1027735' id='answer-label-1027735' class=' answer'><span>Modify the Aurora DB cluster to enable automatic volume resizing.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260461[]' id='answer-id-1027736' class='answer   answerof-260461 ' value='1027736'   \/><label for='answer-id-1027736' id='answer-label-1027736' class=' answer'><span>Increase the local storage by upgrading the database engine version.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260461[]' id='answer-id-1027737' class='answer   answerof-260461 ' value='1027737'   \/><label for='answer-id-1027737' id='answer-label-1027737' class=' answer'><span>Modify the DB instance and configure the required storage volume in the configuration section.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-81' style=';'><div id='questionWrap-81'  class='   watupro-question-id-260462'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>81. <\/span>A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read\/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table. <br \/>\r<br>To prepare the new table with identical settings, which steps should be performed? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_81' value='260462' \/><input type='hidden' id='answerType260462' 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-260462[]' id='answer-id-1027738' class='answer   answerof-260462 ' value='1027738'   \/><label for='answer-id-1027738' id='answer-label-1027738' class=' answer'><span>Re-create global secondary indexes in the new table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260462[]' id='answer-id-1027739' class='answer   answerof-260462 ' value='1027739'   \/><label for='answer-id-1027739' id='answer-label-1027739' class=' answer'><span>Define IAM policies for access to the new table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260462[]' id='answer-id-1027740' class='answer   answerof-260462 ' value='1027740'   \/><label for='answer-id-1027740' id='answer-label-1027740' class=' answer'><span>Define the TTL settings<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260462[]' id='answer-id-1027741' class='answer   answerof-260462 ' value='1027741'   \/><label for='answer-id-1027741' id='answer-label-1027741' class=' answer'><span>Encrypt the table from the AWS Management Console or use the update-table command<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260462[]' id='answer-id-1027742' class='answer   answerof-260462 ' value='1027742'   \/><label for='answer-id-1027742' id='answer-label-1027742' class=' answer'><span>Set the provisioned read and write capacity<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-82' style=';'><div id='questionWrap-82'  class='   watupro-question-id-260463'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>82. <\/span>A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas. <br \/>\r<br>How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application?<\/div><input type='hidden' name='question_id[]' id='qID_82' value='260463' \/><input type='hidden' id='answerType260463' 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-260463[]' id='answer-id-1027743' class='answer   answerof-260463 ' value='1027743'   \/><label for='answer-id-1027743' id='answer-label-1027743' class=' answer'><span>Set the TCP keepalive parameters low<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260463[]' id='answer-id-1027744' class='answer   answerof-260463 ' value='1027744'   \/><label for='answer-id-1027744' id='answer-label-1027744' class=' answer'><span>Call the AWS CLI failover-db-cluster command<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260463[]' id='answer-id-1027745' class='answer   answerof-260463 ' value='1027745'   \/><label for='answer-id-1027745' id='answer-label-1027745' class=' answer'><span>Enable Enhanced Monitoring on the DB cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260463[]' id='answer-id-1027746' class='answer   answerof-260463 ' value='1027746'   \/><label for='answer-id-1027746' id='answer-label-1027746' class=' answer'><span>Start a database activity stream on the DB cluster<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-83' style=';'><div id='questionWrap-83'  class='   watupro-question-id-260464'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>83. <\/span>A clothing company uses a custom ecommerce application and a PostgreSQL database to sell clothes to thousands of users from multiple countries. The company is migrating its application and database from its on- premises data center to the AWS Cloud. The company has selected Amazon EC2 for the application and Amazon RDS for PostgreSQL for the database. The company requires database passwords to be changed every 60 days. A Database Specialist needs to ensure that the credentials used by the web application to connect to the database are managed securely. <br \/>\r<br>Which approach should the Database Specialist take to securely manage the database credentials?<\/div><input type='hidden' name='question_id[]' id='qID_83' value='260464' \/><input type='hidden' id='answerType260464' 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-260464[]' id='answer-id-1027747' class='answer   answerof-260464 ' value='1027747'   \/><label for='answer-id-1027747' id='answer-label-1027747' class=' answer'><span>Store the credentials in a text file in an Amazon S3 bucket. Restrict permissions on the bucket to the IAM role associated with the instance profile only. Modify the application to download the text file and retrieve the credentials on start up. Update the text file every 60 days.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260464[]' id='answer-id-1027748' class='answer   answerof-260464 ' value='1027748'   \/><label for='answer-id-1027748' id='answer-label-1027748' class=' answer'><span>Configure IAM database authentication for the application to connect to the database. \r\nCreate an IAM user and map it to a separate database user for each ecommerce user. \r\nRequire users to update their passwords every 60 days.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260464[]' id='answer-id-1027749' class='answer   answerof-260464 ' value='1027749'   \/><label for='answer-id-1027749' id='answer-label-1027749' class=' answer'><span>Store the credentials in AWS Secrets Manager. Restrict permissions on the secret to only the IAM role associated with the instance profile. Modify the application to retrieve the credentials from Secrets Manager on start up. Configure the rotation interval to 60 days.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260464[]' id='answer-id-1027750' class='answer   answerof-260464 ' value='1027750'   \/><label for='answer-id-1027750' id='answer-label-1027750' class=' answer'><span>Store the credentials in an encrypted text file in the application AM<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260464[]' id='answer-id-1027751' class='answer   answerof-260464 ' value='1027751'   \/><label for='answer-id-1027751' id='answer-label-1027751' class=' answer'><span>Use AWS KMS to \r\nstore the key for decrypting the text file. Modify the application to decrypt the text file and retrieve the credentials on start up. Update the text file and publish a new AMI every 60 days.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-84' style=';'><div id='questionWrap-84'  class='   watupro-question-id-260465'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>84. <\/span>A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made. <br \/>\r<br>What should the database specialist do to meet these requirements? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_84' value='260465' \/><input type='hidden' id='answerType260465' 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-260465[]' id='answer-id-1027752' class='answer   answerof-260465 ' value='1027752'   \/><label for='answer-id-1027752' id='answer-label-1027752' class=' answer'><span>Create an RDS event subscription to the audit event type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260465[]' id='answer-id-1027753' class='answer   answerof-260465 ' value='1027753'   \/><label for='answer-id-1027753' id='answer-label-1027753' class=' answer'><span>Enable auditing of CONNECT and QUERY_DML events.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260465[]' id='answer-id-1027754' class='answer   answerof-260465 ' value='1027754'   \/><label for='answer-id-1027754' id='answer-label-1027754' class=' answer'><span>SSH to the DB instance and review the database logs.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260465[]' id='answer-id-1027755' class='answer   answerof-260465 ' value='1027755'   \/><label for='answer-id-1027755' id='answer-label-1027755' class=' answer'><span>Publish the database logs to Amazon CloudWatch Logs.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260465[]' id='answer-id-1027756' class='answer   answerof-260465 ' value='1027756'   \/><label for='answer-id-1027756' id='answer-label-1027756' class=' answer'><span>Enable Enhanced Monitoring on the DB instance.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-85' style=';'><div id='questionWrap-85'  class='   watupro-question-id-260466'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>85. <\/span>A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time- consuming, so it is not an option. <br \/>\r<br>How should the Database Specialist satisfy this new requirement?<\/div><input type='hidden' name='question_id[]' id='qID_85' value='260466' \/><input type='hidden' id='answerType260466' 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-260466[]' id='answer-id-1027757' class='answer   answerof-260466 ' value='1027757'   \/><label for='answer-id-1027757' id='answer-label-1027757' class=' answer'><span>Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260466[]' id='answer-id-1027758' class='answer   answerof-260466 ' value='1027758'   \/><label for='answer-id-1027758' id='answer-label-1027758' class=' answer'><span>Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260466[]' id='answer-id-1027759' class='answer   answerof-260466 ' value='1027759'   \/><label for='answer-id-1027759' id='answer-label-1027759' class=' answer'><span>Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260466[]' id='answer-id-1027760' class='answer   answerof-260466 ' value='1027760'   \/><label for='answer-id-1027760' id='answer-label-1027760' class=' answer'><span>Create an encrypted read replica of the RDS DB instance. Promote it the master.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-86' style=';'><div id='questionWrap-86'  class='   watupro-question-id-260467'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>86. <\/span>A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when survey responses are being collected, a Database Specialist sees the ProvisionedThroughputExceededException error. <br \/>\r<br>What can the Database Specialist do to resolve this error? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_86' value='260467' \/><input type='hidden' id='answerType260467' 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-260467[]' id='answer-id-1027761' class='answer   answerof-260467 ' value='1027761'   \/><label for='answer-id-1027761' id='answer-label-1027761' class=' answer'><span>Change the table to use Amazon DynamoDB Streams<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260467[]' id='answer-id-1027762' class='answer   answerof-260467 ' value='1027762'   \/><label for='answer-id-1027762' id='answer-label-1027762' class=' answer'><span>Purchase DynamoDB reserved capacity in the affected Region<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260467[]' id='answer-id-1027763' class='answer   answerof-260467 ' value='1027763'   \/><label for='answer-id-1027763' id='answer-label-1027763' class=' answer'><span>Increase the write capacity units for the specific table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260467[]' id='answer-id-1027764' class='answer   answerof-260467 ' value='1027764'   \/><label for='answer-id-1027764' id='answer-label-1027764' class=' answer'><span>Change the table capacity mode to on-demand<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260467[]' id='answer-id-1027765' class='answer   answerof-260467 ' value='1027765'   \/><label for='answer-id-1027765' id='answer-label-1027765' class=' answer'><span>Change the table type to throughput optimized<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-87' style=';'><div id='questionWrap-87'  class='   watupro-question-id-260468'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>87. <\/span>A small startup firm wishes to move a 4 TB MySQL database from on-premises to AWS through an Amazon RDS for MySQL DB instance. <br \/>\r<br>Which migration approach would result in the LEAST amount of downtime?<\/div><input type='hidden' name='question_id[]' id='qID_87' value='260468' \/><input type='hidden' id='answerType260468' 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-260468[]' id='answer-id-1027766' class='answer   answerof-260468 ' value='1027766'   \/><label for='answer-id-1027766' id='answer-label-1027766' class=' answer'><span>Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance utilizing the MySQL utilities running on an Amazon EC2 instance. Immediately point the application to the DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260468[]' id='answer-id-1027767' class='answer   answerof-260468 ' value='1027767'   \/><label for='answer-id-1027767' id='answer-label-1027767' class=' answer'><span>Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into the EC2 instance and restore it into the EC2 MySQL instance. Use AWS DMS to migrate data into a new RDS for MySQL DB instance. Point the application to the DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260468[]' id='answer-id-1027768' class='answer   answerof-260468 ' value='1027768'   \/><label for='answer-id-1027768' id='answer-label-1027768' class=' answer'><span>Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into an Amazon S3 bucket and import the snapshot into a new RDS for MySQL DB instance using the MySQL utilities running on an EC2 instance. Point the application to the DB instance.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260468[]' id='answer-id-1027769' class='answer   answerof-260468 ' value='1027769'   \/><label for='answer-id-1027769' id='answer-label-1027769' class=' answer'><span>Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data center. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance using the MySQL utilities running on an Amazon EC2 instance. Establish replication into the new DB instance using MySQL replication. Stop application access to the on-premises MySQL server and let the remaining transactions replicate over. Point the application to the DB instance.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-88' style=';'><div id='questionWrap-88'  class='   watupro-question-id-260469'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>88. <\/span>A financial company is running an Amazon Redshift cluster for one of its data warehouse solutions. The company needs to generate connection logs, user logs, and user activity logs. The company also must make these logs available for future analysis. <br \/>\r<br>Which combination of steps should a database specialist take to meet these requirements? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_88' value='260469' \/><input type='hidden' id='answerType260469' 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-260469[]' id='answer-id-1027770' class='answer   answerof-260469 ' value='1027770'   \/><label for='answer-id-1027770' id='answer-label-1027770' class=' answer'><span>Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified log group in Amazon CloudWatch Logs.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260469[]' id='answer-id-1027771' class='answer   answerof-260469 ' value='1027771'   \/><label for='answer-id-1027771' id='answer-label-1027771' class=' answer'><span>Edit the database configuration of the cluster by enabling audit logging. Direct the logging to a specified Amazon S3 bucket<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260469[]' id='answer-id-1027772' class='answer   answerof-260469 ' value='1027772'   \/><label for='answer-id-1027772' id='answer-label-1027772' class=' answer'><span>Modify the cluster by enabling continuous delivery of AWS CloudTrail logs to Amazon S3.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260469[]' id='answer-id-1027773' class='answer   answerof-260469 ' value='1027773'   \/><label for='answer-id-1027773' id='answer-label-1027773' class=' answer'><span>Create a new parameter group with the enable_user_activity_logging parameter set to true. Configure the cluster to use the new parameter group.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260469[]' id='answer-id-1027774' class='answer   answerof-260469 ' value='1027774'   \/><label for='answer-id-1027774' id='answer-label-1027774' class=' answer'><span>Modify the system table to enable logging for each user.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-89' style=';'><div id='questionWrap-89'  class='   watupro-question-id-260470'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>89. <\/span>On a single Amazon RDS DB instance, a business hosts a MySQL database for its ecommerce application. Automatically saving application purchases to the database results in high-volume writes. Employees routinely create purchase reports for the company. The organization wants to boost database performance and minimize downtime associated with upgrade patching. <br \/>\r<br>Which technique will satisfy these criteria with the LEAST amount of operational overhead?<\/div><input type='hidden' name='question_id[]' id='qID_89' value='260470' \/><input type='hidden' id='answerType260470' 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-260470[]' id='answer-id-1027775' class='answer   answerof-260470 ' value='1027775'   \/><label for='answer-id-1027775' id='answer-label-1027775' class=' answer'><span>Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260470[]' id='answer-id-1027776' class='answer   answerof-260470 ' value='1027776'   \/><label for='answer-id-1027776' id='answer-label-1027776' class=' answer'><span>Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and set up replication to a MySQL DB instance running on Amazon EC2.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260470[]' id='answer-id-1027777' class='answer   answerof-260470 ' value='1027777'   \/><label for='answer-id-1027777' id='answer-label-1027777' class=' answer'><span>Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260470[]' id='answer-id-1027778' class='answer   answerof-260470 ' value='1027778'   \/><label for='answer-id-1027778' id='answer-label-1027778' class=' answer'><span>Add a read replica and promote it to an Amazon Aurora MySQL DB cluster master. \r\nThen enable Amazon Aurora Serverless.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-90' style=';'><div id='questionWrap-90'  class='   watupro-question-id-260471'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>90. <\/span>A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL. <br \/>\r<br>How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?<\/div><input type='hidden' name='question_id[]' id='qID_90' value='260471' \/><input type='hidden' id='answerType260471' 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-260471[]' id='answer-id-1027779' class='answer   answerof-260471 ' value='1027779'   \/><label for='answer-id-1027779' id='answer-label-1027779' class=' answer'><span>Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260471[]' id='answer-id-1027780' class='answer   answerof-260471 ' value='1027780'   \/><label for='answer-id-1027780' id='answer-label-1027780' class=' answer'><span>Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260471[]' id='answer-id-1027781' class='answer   answerof-260471 ' value='1027781'   \/><label for='answer-id-1027781' id='answer-label-1027781' class=' answer'><span>Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260471[]' id='answer-id-1027782' class='answer   answerof-260471 ' value='1027782'   \/><label for='answer-id-1027782' id='answer-label-1027782' class=' answer'><span>Create the maintenance job using the Amazon CloudWatch job scheduling plugin.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-91' style=';'><div id='questionWrap-91'  class='   watupro-question-id-260472'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>91. <\/span>A company's application development team wants to share an automated snapshot of its Amazon RDS database with another team. The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the &quot;WeShare&quot; AWS account. The application development team needs to share the DB snapshot under the &quot;WeReceive&quot; AWS account. <br \/>\r<br>Which combination of actions must the application development team take to meet these requirements? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_91' value='260472' \/><input type='hidden' id='answerType260472' 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-260472[]' id='answer-id-1027783' class='answer   answerof-260472 ' value='1027783'   \/><label for='answer-id-1027783' id='answer-label-1027783' class=' answer'><span>Add access from the &quot;WeReceive&quot; account to the custom AWS KMS key policy of the sharing team.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260472[]' id='answer-id-1027784' class='answer   answerof-260472 ' value='1027784'   \/><label for='answer-id-1027784' id='answer-label-1027784' class=' answer'><span>Make a copy of the DB snapshot, and set the encryption option to disable.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260472[]' id='answer-id-1027785' class='answer   answerof-260472 ' value='1027785'   \/><label for='answer-id-1027785' id='answer-label-1027785' class=' answer'><span>Share the DB snapshot by setting the DB snapshot visibility option to public.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260472[]' id='answer-id-1027786' class='answer   answerof-260472 ' value='1027786'   \/><label for='answer-id-1027786' id='answer-label-1027786' class=' answer'><span>Make a copy of the DB snapshot, and set the encryption option to enable.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260472[]' id='answer-id-1027787' class='answer   answerof-260472 ' value='1027787'   \/><label for='answer-id-1027787' id='answer-label-1027787' class=' answer'><span>Share the DB snapshot by using the default AWS KMS encryption key.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-92' style=';'><div id='questionWrap-92'  class='   watupro-question-id-260473'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>92. <\/span>A large company has a variety of Amazon DB clusters. Each of these clusters has various configurations that adhere to various requirements. Depending on the team and use case, these configurations can be organized into broader categories. <br \/>\r<br>A database administrator wants to make the process of storing and modifying these parameters more systematic. The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required. <br \/>\r<br>Which AWS service or feature will help automate and achieve this objective?<\/div><input type='hidden' name='question_id[]' id='qID_92' value='260473' \/><input type='hidden' id='answerType260473' 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-260473[]' id='answer-id-1027788' class='answer   answerof-260473 ' value='1027788'   \/><label for='answer-id-1027788' id='answer-label-1027788' class=' answer'><span>AWS Systems Manager Parameter Store<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260473[]' id='answer-id-1027789' class='answer   answerof-260473 ' value='1027789'   \/><label for='answer-id-1027789' id='answer-label-1027789' class=' answer'><span>DB parameter group<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260473[]' id='answer-id-1027790' class='answer   answerof-260473 ' value='1027790'   \/><label for='answer-id-1027790' id='answer-label-1027790' class=' answer'><span>AWS Config<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260473[]' id='answer-id-1027791' class='answer   answerof-260473 ' value='1027791'   \/><label for='answer-id-1027791' id='answer-label-1027791' class=' answer'><span>AWS Secrets Manager<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-93' style=';'><div id='questionWrap-93'  class='   watupro-question-id-260474'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>93. <\/span>An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application. The <br \/>\r<br>steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs. The company wants to control these costs without significant development efforts. <br \/>\r<br>How should a Database Specialist address these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_93' value='260474' \/><input type='hidden' id='answerType260474' 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-260474[]' id='answer-id-1027792' class='answer   answerof-260474 ' value='1027792'   \/><label for='answer-id-1027792' id='answer-label-1027792' class=' answer'><span>Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260474[]' id='answer-id-1027793' class='answer   answerof-260474 ' value='1027793'   \/><label for='answer-id-1027793' id='answer-label-1027793' class=' answer'><span>Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into Amazon Redshift<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260474[]' id='answer-id-1027794' class='answer   answerof-260474 ' value='1027794'   \/><label for='answer-id-1027794' id='answer-label-1027794' class=' answer'><span>Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260474[]' id='answer-id-1027795' class='answer   answerof-260474 ' value='1027795'   \/><label for='answer-id-1027795' id='answer-label-1027795' class=' answer'><span>Use DynamoDB Accelerator to offload the reads<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-94' style=';'><div id='questionWrap-94'  class='   watupro-question-id-260475'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>94. <\/span>A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case. <br \/>\r<br>A database administrator wishes to streamline the process of storing and updating these settings. Additionally, the database administrator want to guarantee that changes to certain configuration categories are automatically implemented to all instances as necessary. <br \/>\r<br>Which AWS service or functionality will assist in automating and achieving this goal?<\/div><input type='hidden' name='question_id[]' id='qID_94' value='260475' \/><input type='hidden' id='answerType260475' 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-260475[]' id='answer-id-1027796' class='answer   answerof-260475 ' value='1027796'   \/><label for='answer-id-1027796' id='answer-label-1027796' class=' answer'><span>AWS Systems Manager Parameter Store<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260475[]' id='answer-id-1027797' class='answer   answerof-260475 ' value='1027797'   \/><label for='answer-id-1027797' id='answer-label-1027797' class=' answer'><span>DB parameter group<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260475[]' id='answer-id-1027798' class='answer   answerof-260475 ' value='1027798'   \/><label for='answer-id-1027798' id='answer-label-1027798' class=' answer'><span>AWS Config<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260475[]' id='answer-id-1027799' class='answer   answerof-260475 ' value='1027799'   \/><label for='answer-id-1027799' id='answer-label-1027799' class=' answer'><span>AWS Secrets Manager<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-95' style=';'><div id='questionWrap-95'  class='   watupro-question-id-260476'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>95. <\/span>A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists. <br \/>\r<br>Which step should be taken to troubleshoot this issue?<\/div><input type='hidden' name='question_id[]' id='qID_95' value='260476' \/><input type='hidden' id='answerType260476' 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-260476[]' id='answer-id-1027800' class='answer   answerof-260476 ' value='1027800'   \/><label for='answer-id-1027800' id='answer-label-1027800' class=' answer'><span>Ensure that the database option group for the RDS DB instance allows ingress from the Developer machine\u2019s IP address<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260476[]' id='answer-id-1027801' class='answer   answerof-260476 ' value='1027801'   \/><label for='answer-id-1027801' id='answer-label-1027801' class=' answer'><span>Ensure that the RDS DB instance\u2019s subnet group includes a public subnet to allow the Developer to connect<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260476[]' id='answer-id-1027802' class='answer   answerof-260476 ' value='1027802'   \/><label for='answer-id-1027802' id='answer-label-1027802' class=' answer'><span>Ensure that the RDS DB instance has not reached its maximum connections limit<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260476[]' id='answer-id-1027803' class='answer   answerof-260476 ' value='1027803'   \/><label for='answer-id-1027803' id='answer-label-1027803' class=' answer'><span>Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-96' style=';'><div id='questionWrap-96'  class='   watupro-question-id-260477'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>96. <\/span>A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging. <br \/>\r<br>Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)<\/div><input type='hidden' name='question_id[]' id='qID_96' value='260477' \/><input type='hidden' id='answerType260477' 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-260477[]' id='answer-id-1027804' class='answer   answerof-260477 ' value='1027804'   \/><label for='answer-id-1027804' id='answer-label-1027804' class=' answer'><span>Update the log_connections parameter in the default parameter group<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260477[]' id='answer-id-1027805' class='answer   answerof-260477 ' value='1027805'   \/><label for='answer-id-1027805' id='answer-label-1027805' class=' answer'><span>Create a custom parameter group, update the log_connections parameter, and associate the parameter with the DB instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260477[]' id='answer-id-1027806' class='answer   answerof-260477 ' value='1027806'   \/><label for='answer-id-1027806' id='answer-label-1027806' class=' answer'><span>Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to 180 days<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260477[]' id='answer-id-1027807' class='answer   answerof-260477 ' value='1027807'   \/><label for='answer-id-1027807' id='answer-label-1027807' class=' answer'><span>Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260477[]' id='answer-id-1027808' class='answer   answerof-260477 ' value='1027808'   \/><label for='answer-id-1027808' id='answer-label-1027808' class=' answer'><span>Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-97' style=';'><div id='questionWrap-97'  class='   watupro-question-id-260478'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>97. <\/span>A business is operating an on-premises application that is divided into three tiers: web, application, and MySQL database. The database is predominantly accessed during business hours, with occasional bursts of activity throughout the day. As part of the company's shift to AWS, a database expert wants to increase the availability and minimize the cost of the MySQL database tier. <br \/>\r<br>Which MySQL database choice satisfies these criteria?<\/div><input type='hidden' name='question_id[]' id='qID_97' value='260478' \/><input type='hidden' id='answerType260478' 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-260478[]' id='answer-id-1027809' class='answer   answerof-260478 ' value='1027809'   \/><label for='answer-id-1027809' id='answer-label-1027809' class=' answer'><span>Amazon RDS for MySQL with Multi-AZ<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260478[]' id='answer-id-1027810' class='answer   answerof-260478 ' value='1027810'   \/><label for='answer-id-1027810' id='answer-label-1027810' class=' answer'><span>Amazon Aurora Serverless MySQL cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260478[]' id='answer-id-1027811' class='answer   answerof-260478 ' value='1027811'   \/><label for='answer-id-1027811' id='answer-label-1027811' class=' answer'><span>Amazon Aurora MySQL cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260478[]' id='answer-id-1027812' class='answer   answerof-260478 ' value='1027812'   \/><label for='answer-id-1027812' id='answer-label-1027812' class=' answer'><span>Amazon RDS for MySQL with read replica<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-98' style=';'><div id='questionWrap-98'  class='   watupro-question-id-260479'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>98. <\/span>A financial services company is developing a shared data service that supports different applications from throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port 6379. <br \/>\r<br>Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)<\/div><input type='hidden' name='question_id[]' id='qID_98' value='260479' \/><input type='hidden' id='answerType260479' 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-260479[]' id='answer-id-1027813' class='answer   answerof-260479 ' value='1027813'   \/><label for='answer-id-1027813' id='answer-label-1027813' class=' answer'><span>Enable in-transit and at-rest encryption on the ElastiCache cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260479[]' id='answer-id-1027814' class='answer   answerof-260479 ' value='1027814'   \/><label for='answer-id-1027814' id='answer-label-1027814' class=' answer'><span>Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260479[]' id='answer-id-1027815' class='answer   answerof-260479 ' value='1027815'   \/><label for='answer-id-1027815' id='answer-label-1027815' class=' answer'><span>Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound traffic on TCP port 6379 from trusted clients only.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260479[]' id='answer-id-1027816' class='answer   answerof-260479 ' value='1027816'   \/><label for='answer-id-1027816' id='answer-label-1027816' class=' answer'><span>Create an IAM policy to allow the application service roles to access all ElastiCache API actions.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260479[]' id='answer-id-1027817' class='answer   answerof-260479 ' value='1027817'   \/><label for='answer-id-1027817' id='answer-label-1027817' class=' answer'><span>Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22 traffic from the trusted ElastiCache cluster\u2019s security group.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-260479[]' id='answer-id-1027818' class='answer   answerof-260479 ' value='1027818'   \/><label for='answer-id-1027818' id='answer-label-1027818' class=' answer'><span>Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-99' style=';'><div id='questionWrap-99'  class='   watupro-question-id-260480'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>99. <\/span>A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. <br \/>\r<br>The application should be able to identify: <br \/>\r<br>&#10001; The networks and routes affected if a particular component fails. &#10001; The networks that have redundant routes between them. <br \/>\r<br>&#10001; The networks that do not have redundant routes between them. &#10001; The fastest path between two networks. <br \/>\r<br>Which database engine meets these requirements?<\/div><input type='hidden' name='question_id[]' id='qID_99' value='260480' \/><input type='hidden' id='answerType260480' 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-260480[]' id='answer-id-1027819' class='answer   answerof-260480 ' value='1027819'   \/><label for='answer-id-1027819' id='answer-label-1027819' class=' answer'><span>Amazon Aurora MySQL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260480[]' id='answer-id-1027820' class='answer   answerof-260480 ' value='1027820'   \/><label for='answer-id-1027820' id='answer-label-1027820' class=' answer'><span>Amazon Neptune<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260480[]' id='answer-id-1027821' class='answer   answerof-260480 ' value='1027821'   \/><label for='answer-id-1027821' id='answer-label-1027821' class=' answer'><span>Amazon ElastiCache for Redis<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260480[]' id='answer-id-1027822' class='answer   answerof-260480 ' value='1027822'   \/><label for='answer-id-1027822' id='answer-label-1027822' class=' answer'><span>Amazon DynamoDB<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-100' style=';'><div id='questionWrap-100'  class='   watupro-question-id-260481'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>100. <\/span>A business's mission-critical production workload is being operated on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must migrate the workload without causing data loss to a new Amazon Aurora Serverless MySQL DB cluster. <br \/>\r<br>Which approach will result in the LEAST amount of downtime and the LEAST amount of application impact?<\/div><input type='hidden' name='question_id[]' id='qID_100' value='260481' \/><input type='hidden' id='answerType260481' 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-260481[]' id='answer-id-1027823' class='answer   answerof-260481 ' value='1027823'   \/><label for='answer-id-1027823' id='answer-label-1027823' class=' answer'><span>Modify the existing DB cluster and update the Aurora configuration to Serverless.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260481[]' id='answer-id-1027824' class='answer   answerof-260481 ' value='1027824'   \/><label for='answer-id-1027824' id='answer-label-1027824' class=' answer'><span>Create a snapshot of the existing DB cluster and restore it to a new Aurora Serverless DB cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260481[]' id='answer-id-1027825' class='answer   answerof-260481 ' value='1027825'   \/><label for='answer-id-1027825' id='answer-label-1027825' class=' answer'><span>Create an Aurora Serverless replica from the existing DB cluster and promote it to primary when the replica lag is minimal.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-260481[]' id='answer-id-1027826' class='answer   answerof-260481 ' value='1027826'   \/><label for='answer-id-1027826' id='answer-label-1027826' class=' answer'><span>Replicate the data between the existing DB cluster and a new Aurora Serverless DB \r\ncluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-101'>\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=\"watuPROButtons7155\" >\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=\"7155\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-30 11:15:19\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1780139719\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"260382:1027394,1027395,1027396,1027397 | 260383:1027398,1027399,1027400,1027401 | 260384:1027402,1027403,1027404,1027405 | 260385:1027406,1027407,1027408,1027409 | 260386:1027410,1027411,1027412,1027413 | 260387:1027414,1027415,1027416,1027417 | 260388:1027418,1027419,1027420,1027421 | 260389:1027422,1027423,1027424,1027425 | 260390:1027426,1027427,1027428,1027429 | 260391:1027430,1027431,1027432,1027433 | 260392:1027434,1027435,1027436,1027437 | 260393:1027438,1027439,1027440,1027441 | 260394:1027442,1027443,1027444,1027445 | 260395:1027446,1027447,1027448,1027449 | 260396:1027450,1027451,1027452,1027453 | 260397:1027454,1027455,1027456,1027457 | 260398:1027458,1027459,1027460,1027461 | 260399:1027462,1027463,1027464,1027465,1027466 | 260400:1027467,1027468,1027469,1027470 | 260401:1027471,1027472,1027473,1027474 | 260402:1027475,1027476,1027477,1027478 | 260403:1027479,1027480,1027481,1027482 | 260404:1027483,1027484,1027485,1027486 | 260405:1027487,1027488,1027489,1027490 | 260406:1027491,1027492,1027493,1027494 | 260407:1027495,1027496,1027497,1027498,1027499 | 260408:1027500,1027501,1027502,1027503,1027504,1027505 | 260409:1027506,1027507,1027508,1027509 | 260410:1027510,1027511,1027512,1027513 | 260411:1027514,1027515,1027516,1027517 | 260412:1027518,1027519,1027520,1027521 | 260413:1027522,1027523,1027524,1027525,1027526,1027527 | 260414:1027528,1027529,1027530,1027531 | 260415:1027532,1027533,1027534,1027535 | 260416:1027536,1027537,1027538,1027539,1027540,1027541,1027542 | 260417:1027543,1027544,1027545,1027546 | 260418:1027547,1027548,1027549,1027550 | 260419:1027551,1027552,1027553,1027554,1027555 | 260420:1027556,1027557,1027558,1027559 | 260421:1027560,1027561,1027562,1027563 | 260422:1027564,1027565,1027566,1027567 | 260423:1027568,1027569,1027570,1027571 | 260424:1027572,1027573,1027574,1027575 | 260425:1027576,1027577,1027578,1027579 | 260426:1027580,1027581,1027582,1027583,1027584 | 260427:1027585,1027586,1027587,1027588 | 260428:1027589,1027590,1027591,1027592 | 260429:1027593,1027594,1027595,1027596 | 260430:1027597,1027598,1027599,1027600 | 260431:1027601,1027602,1027603,1027604 | 260432:1027605,1027606,1027607,1027608 | 260433:1027609,1027610,1027611,1027612 | 260434:1027613,1027614,1027615,1027616 | 260435:1027617,1027618,1027619,1027620,1027621,1027622 | 260436:1027623,1027624,1027625,1027626 | 260437:1027627,1027628,1027629,1027630,1027631,1027632 | 260438:1027633,1027634,1027635,1027636,1027637,1027638 | 260439:1027639,1027640,1027641,1027642,1027643,1027644 | 260440:1027645,1027646,1027647,1027648 | 260441:1027649,1027650,1027651,1027652 | 260442:1027653,1027654,1027655,1027656 | 260443:1027657,1027658,1027659,1027660 | 260444:1027661,1027662,1027663,1027664 | 260445:1027665,1027666,1027667,1027668 | 260446:1027669,1027670,1027671,1027672,1027673 | 260447:1027674,1027675,1027676,1027677 | 260448:1027678,1027679,1027680,1027681 | 260449:1027682,1027683,1027684,1027685,1027686 | 260450:1027687,1027688,1027689,1027690,1027691,1027692 | 260451:1027693,1027694,1027695,1027696 | 260452:1027697,1027698,1027699,1027700 | 260453:1027701,1027702,1027703,1027704 | 260454:1027705,1027706,1027707,1027708 | 260455:1027709,1027710,1027711,1027712 | 260456:1027713,1027714,1027715,1027716 | 260457:1027717,1027718,1027719,1027720 | 260458:1027721,1027722,1027723,1027724,1027725 | 260459:1027726,1027727,1027728,1027729 | 260460:1027730,1027731,1027732,1027733 | 260461:1027734,1027735,1027736,1027737 | 260462:1027738,1027739,1027740,1027741,1027742 | 260463:1027743,1027744,1027745,1027746 | 260464:1027747,1027748,1027749,1027750,1027751 | 260465:1027752,1027753,1027754,1027755,1027756 | 260466:1027757,1027758,1027759,1027760 | 260467:1027761,1027762,1027763,1027764,1027765 | 260468:1027766,1027767,1027768,1027769 | 260469:1027770,1027771,1027772,1027773,1027774 | 260470:1027775,1027776,1027777,1027778 | 260471:1027779,1027780,1027781,1027782 | 260472:1027783,1027784,1027785,1027786,1027787 | 260473:1027788,1027789,1027790,1027791 | 260474:1027792,1027793,1027794,1027795 | 260475:1027796,1027797,1027798,1027799 | 260476:1027800,1027801,1027802,1027803 | 260477:1027804,1027805,1027806,1027807,1027808 | 260478:1027809,1027810,1027811,1027812 | 260479:1027813,1027814,1027815,1027816,1027817,1027818 | 260480:1027819,1027820,1027821,1027822 | 260481:1027823,1027824,1027825,1027826\" \/>\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 = \"260382,260383,260384,260385,260386,260387,260388,260389,260390,260391,260392,260393,260394,260395,260396,260397,260398,260399,260400,260401,260402,260403,260404,260405,260406,260407,260408,260409,260410,260411,260412,260413,260414,260415,260416,260417,260418,260419,260420,260421,260422,260423,260424,260425,260426,260427,260428,260429,260430,260431,260432,260433,260434,260435,260436,260437,260438,260439,260440,260441,260442,260443,260444,260445,260446,260447,260448,260449,260450,260451,260452,260453,260454,260455,260456,260457,260458,260459,260460,260461,260462,260463,260464,260465,260466,260467,260468,260469,260470,260471,260472,260473,260474,260475,260476,260477,260478,260479,260480,260481\";\nWatuPROSettings[7155] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 7155;\t    \nWatuPRO.post_id = 56013;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.53625600 1780139719\";\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(7155);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[175],"tags":[15595,15596,15598],"class_list":["post-56013","post","type-post","status-publish","format-standard","hentry","category-amazon","tag-dbs-c01","tag-dbs-c01-exam-dumps","tag-dbs-c01-free-demo-2"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/56013","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=56013"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/56013\/revisions"}],"predecessor-version":[{"id":56016,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/56013\/revisions\/56016"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=56013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=56013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=56013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}