DBS-C01 (Page 31)

A company is running Amazon RDS for MySQL for its workloads.There is downtime when AWS operating system patches are applied during the Amazon RDS- specified maintenance window.What is the MOST cost-effective action that should be taken to avoid downtime?Read More →

A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load data from Amazon S3 into the Neptune DB cluster using theNeptune bulk loader API.The Database Specialist receives the following error:`Unable to connect to s3 endpoint.Provided source = s3://mybucket/graphdata/ and region = us-east-1.Please verify yourS3 configuration.`Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)Read More →

A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting.These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency.System users run ad-hoc queries sporadically throughout the week.Cost is a primary concern for the company, and a solution that does not require significant rework is needed.Which solution meets these requirements?Read More →

A company is using Amazon Aurora with Aurora Replicas.A database specialist needs to split up two read-only applications so that each application connects to a different set of DB instances.The database specialist wants to implement load balancing and high availability for the read-only applications.Which solution meets these requirements?Read More →

A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance.The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company.This change has been approved for a specific maintenance window to help minimize the impact on users.How should the Database Specialist apply the parameter group change for the DB instance?Read More →

A finance company needs to make sure that its MySQL database backups are available for the most recent 90 days.All of the MySQL databases are hosted onAmazon RDS for MySQL DB instances.A database specialist must implement a solution that meets the backup retention requirement with the least possible development effort.Which approach should the database specialist take?Read More →

A company is running its customer feedback application on Amazon Aurora MySQL.The company runs a report every day to extract customer feedback, and a team reads the feedback to determine if the customer comments are positive or negative.It sometimes takes days before the company can contact unhappy customers and take corrective measures.The company wants to use machine learning to automate this workflow.Which solution meets this requirement with the LEAST amount of effort?Read More →

A startup company in the travel industry wants to create an application that includes a personal travel assistant to display information for nearby airports based on user location.The application will use Amazon DynamoDB and must be able to access and display attributes such as airline names, arrival times, and flight numbers.However, the application must not be able to access or display pilot names or passenger counts.Which solution will meet these requirements MOST cost-effectively?Read More →

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.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.How can a Database Specialist address these requirements with minimal user involvement?Read More →

A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application.As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity.The company does not want to make any code changes for this activity.What should the company do to achieve this in the shortest amount of time?Read More →