DBS-C01 (Page 27)

A company has a variety of Amazon Aurora DB clusters.Each of these DB clusters has various configurations that meet specific sets of requirements.Depending on the team and the use case, these configurations can be organized into broader categories.A database specialist wants to implement a solution to make the storage and modification of the configuration parameters more systematic.Which AWS service or feature should the database specialist use to meet these requirements?Read More →

A company provisioned a three-tier application by using AWS CloudFormation and an Amazon RDS DB instance.During a test, a database administrator accidentally deleted the CloudFormation stack.The results were a deletion of all the resources, including the DB instance, and a loss of critical data.The company wants to prevent accidental deletion of a DB instance from happening in the future.Which solutions will meet this requirement? (Choose two.)Read More →

A company is using Amazon DocumentDB (with MongoDB compatibility) to manage its complex documents.Users report that an Amazon DocumentDB cluster takes a long time to return query results.A database specialist must investigate and resolve this issue.Which of the following can the database specialist use to investigate the query plan and analyze the query performance?Read More →

An information management services company is storing JSON documents on premises.The company is using a MongoDB 3.6 database but wants to migrate toAWS.The solution must be compatible, scalable, and fully managed.The solution also must result in as little downtime as possible during the migration.Which solution meets these requirements?Read More →

A company plans to migrate a MySQL-based application from an on-premises environment to AWS.The application performs database joins across several tables and uses indexes for faster query response times.The company needs the database to be highly available with automatic failover.Which solution on AWS will meet these requirements with the LEAST operational overhead?Read More →

A company uses Amazon DynamoDB as a data store for multi-tenant data.Approximately 70% of the reads by the company’s application are strongly consistent.The current key schema for the DynamoDB table is as follows:Partition key: OrgID -Sort key: TenantID#Version -Due to a change in design and access patterns, the company needs to support strongly consistent lookups based on the new schema below:Partition key: OrgID#TenantID -Sort key: Version -How can the database specialist implement this change?Read More →

A bike rental company operates an application to track its bikes.The application receives location and condition data from bike sensors.The application also receives rental transaction data from the associated mobile app.The application uses Amazon DynamoDB as its database layer.The company has configured DynamoDB with provisioned capacity set to 20% above the expected peak load of the application.On an average day, DynamoDB used 22 billion read capacity units (RCUs) and 60 billion write capacity units (WCUs).The application is running well.Usage changes smoothly over the course of the day and is generally shaped like a bell curve.The timing and magnitude of peaks vary based on the weather and season, but the general shape is consistent.Which solution will provide the MOST cost optimization of the DynamoDB database layer?Read More →

A global company needs to migrate from an on-premises Microsoft SQL Server database to a highly available database solution on AWS.The company wants to modernize its application and keep operational costs low.The current database includes secondary indexes and stored procedures that need to be included in the migration.The company has limited availability of database specialists to support the migration and wants to automate the process.Which solution will meet these requirements?Read More →

Accompany is using Amazon Redshift for its data warehouse.During review of the last few AWS monthly bills, a database specialist notices charges for Amazon Redshift backup storage.The database specialist needs to decrease the cost of these charges in the future and must create a solution that provides notification if the charges exceed a threshold.Which combination of actions will moot those requirements with the LEAST operational overhead? (Choose two.)Read More →

An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition DB instance.The company expects a spike in read traffic due to an upcoming sale.A database specialist must create a read replica of the DB instance to serve the anticipated read traffic.Which actions should the database specialist take before creating the read replica? (Choose two.)Read More →