DBS-C01 (Page 14)

A company wants to improve its ecommerce website on AWS.A database specialist decides to add Amazon ElastiCache for Redis in the implementation stack to ease the workload off the database and shorten the website response times.The database specialist must also ensure the ecommerce website is highly available within the company’s AWS Region.How should the database specialist deploy ElastiCache to meet this requirement?Read More →

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.Which combination of actions should the database specialist take to meet this requirement? (Choose three.)Read More →

A software company is conducting a security audit of its three-node Amazon Aurora MySQL DB cluster.Which finding is a security concern that needs to be addressed?Read More →

A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project.A database specialist has configured automated database snapshots.As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.Which of the following are possible reasons why the snapshot was not created? (Choose two.)Read More →

An advertising company is developing a backend for a bidding platform.The company needs a cost-effective datastore solution that will accommodate a sudden increase in the volume of write transactions.The database also needs to make data changes available in a near real-time data stream.Which solution will meet these requirements?Read More →

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.How should the company identify the source of the problem?Read More →

A database specialist is designing the database for a software-as-a-service (SaaS) version of an employee information application.In the current architecture, the change history of employee records is stored in a single table in an Amazon RDS for Oracle database.Triggers on the employee table populate the history table with historical records.This architecture has two major challenges.First, there is no way to guarantee that the records have not been changed in the history table.Second, queries on the history table are slow because of the large size of the table and the need to run the queries against a large subset of data in the table.The database specialist must design a solution that prevents modification of the historical records.The solution also must maximize the speed of the queries.Which solution will meet these requirements?Read More →

A company wants to move its on-premises Oracle database to an Amazon Aurora PostgreSQL DB cluster.The source database includes 500 GB of data.900 stored procedures and functions, and application source code with embedded SQL statements.The company understands there are some database code objects and custom features that may not be automatically converted and may need some manual intervention.Management would like to complete this migration as fast as possible with minimal downtime.Which tools and approach should be used to meet these requirements?Read More →

A large IT hardware manufacturing company wants to deploy a MySQL database solution in the AWS Cloud.The solution should quickly create copies of the company’s production databases for test purposes.The solution must deploy the test databases in minutes, and the test data should match the latest production data as closely as possible.Developers must also be able to make changes in the test database and delete the instances afterward.Which solution meets these requirements?Read More →

A retail company runs its production database on Amazon RDS for SOL Server.The company wants more flexibility in backing up and restoring the database.A database specialist needs to create a native backup and restore strategy.The solution must take native SQL Server backups and store them in a highly scalable manner.Which combination of stops should the database specialist take to meet those requirements? (Choose three.)Read More →