DBS-C01 (Page 28)

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 →

A company uses an Amazon Aurora MySQL DB cluster.A database specialist has configured the DB cluster to use the automated backup feature with a 10-day retention period.The company wants the database specialist to reduce the cost of the database backup storage as much as possible without causing downtime.It is more important for the company to optimize costs than it is to retain a large set of database backups.Which set of actions should the database specialist take on the DB cluster to meet these requirements?Read More →

A financial services company is using AWS Database Migration Service (AWS DMS) to migrate its databases from on-premises to AWS.A database administrator is working on replicating a database to AWS from on-premises using full load and change data capture (CDC).During the CDC replication, the database administrator observed that the target latency was high and slowly increasing.What could be the root causes for this high target latency? (Choose two.)Read More →

An online retailer uses Amazon DynamoDB for its product catalog and order data.Some popular items have led to frequently accessed keys in the data, and the company is using DynamoDB Accelerator (DAX) as the caching solution to cater to the frequently accessed keys.As the number of popular products is growing, the company realizes that more items need to be cached.The company observes a high cache miss rate and needs a solution to address this issue.What should a database specialist do to accommodate the changing requirements for DAX?Read More →

A database specialist observes several idle connections in an Amazon RDS for MySQL DB instance.The DB instance is using RDS Proxy.An application is configured to connect to the proxy endpoint.What should the database specialist do to control the idle connections in the database?Read More →