DBS-C01 (Page 21)

A manufacturing company stores its inventory details in an Amazon DynamoDB table in the us-east-2 Region.According to new compliance and regulatory policies, the company is required to back up all of its tables nightly and store these backups in the us-west-2 Region for disaster recovery for 1 year.Read More →

A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months.The connection failure lasted for 5 minutes and corrected itself after that.The Database Specialist reviewed the AmazonRDS events and determined a failover event occurred at that time.The failover process took around 15 seconds to complete.What is the MOST likely cause of the 5-minute connection outage?Read More →

The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago.A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting.The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.Which approach will meet these requirements?Read More →

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.The Database Specialist wrote and ran 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.How should the Database Specialist edit the script to fix this issue?Read More →

An online bookstore recently migrated its database from on-premises Oracle to Amazon Aurora PostgreSQL 13.The bookstore uses scheduled jobs to run customized SQL scripts to administer the Oracle database, running hours-long maintenance tasks, such as partition maintenance and statistics gathering.The bookstore’s application team has reached out to a database specialist seeking an ideal replacement for scheduling jobs with Aurora PostgreSQL.What should the database specialist implement to meet these requirements with MINIMAL operational overhead?Read More →

The Development team recently executed a database script containing several data definition language (DDL) and data manipulation language (DML) statements on an Amazon Aurora MySQL DB cluster.The release accidentally deleted thousands of rows from an important table and broke some application functionality.This was discovered 4 hours after the release.Upon investigation, a Database Specialist tracked the issue to a DELETE command in the script with an incorrectWHERE clause filtering the wrong set of rows.The Aurora DB cluster has Backtrack enabled with an 8-hour backtrack window.The Database Administrator also took a manual snapshot of the DB cluster before the release started.The database needs to be returned to the correct state as quickly as possible to resume full application functionality.Data loss must be minimal.How can the Database Specialist accomplish this?Read More →

A company has deployed an e-commerce web application in a new AWS account.An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306.The company’s Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.When users try to utilize the application hosted in the AWS account, they are presented with a generic error message.The application servers are logging a `could not connect to server: Connection times out` error message to Amazon CloudWatch Logs.What is the cause of this error?Read More →

A company is closing one of its remote data centers.This site runs a 100 TB on-premises data warehouse solution.The company plans to use the AWS SchemaConversion Tool (AWS SCT) and AWS DMS for the migration to AWS.The site network bandwidth is 500 Mbps.A Database Specialist wants to migrate the on- premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse.This move must take place during a 2-week period when source systems are shut down for maintenance.The data should stay encrypted at rest and in transit.Which approach has the least risk and the highest likelihood of a successful data transfer?Read More →

A company uses an Amazon RDS for PostgreSQL database in the us-east-2 Region.The company wants to have a copy of the database available in the us-west-2 Region as part of a new disaster recovery strategy.A database architect needs to create the new database.There can be little to no downtime to the source database.The database architect has decided to use AWS Database Migration Service (AWS DMS) to replicate the database across Regions.The database architect will use full load mode and then will switch to change data capture (CDC) mode.Which parameters must the database architect configure to support CDC mode for the RDS for PostgreSQL database? (Choose three.)Read More →

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.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.)Read More →