DBS-C01 (Page 3)

A database specialist is working on an Amazon RDS for PostgreSQL DB instance that is experiencing application performance issues due to the addition of new workloads.The database has 5 ׀¢׀’ of storage space with Provisioned IOPS.Amazon CloudWatch metrics show that the average disk queue depth is greater than200 and that the disk I/O response time is significantly higher than usual.What should the database specialist do to improve the performance of the application immediately?Read More →

A company is developing an application that performs intensive in-memory operations on advanced data structures such as sorted sets.The application requires sub-millisecond latency for reads and writes.The application occasionally must run a group of commands as an ACID-compliant operation.A database specialist is setting up the database for this application.The database specialist needs the ability to create a new database cluster from the latest backup of the production cluster.Which type of cluster should the database specialist create to meet these requirements?Read More →

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS.The source RDS OracleDB instance is in a VPC in the us-east-1 Region.The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.Where should the AWS DMS replication instance be placed for the MOST optimal performance?Read More →

An ecommerce company is running AWS Database Migration Service (AWS DMS) to replicate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server.The company has set up an AWS Direct Connect connection from its on-premises data center to AWS.During the migration, the company’s security team receives an alarm that is related to the migration.The security team mandates that the DMS replication instance must not be accessible from publicIP addresses.What should a database specialist do to meet this requirement?Read More →

A database specialist needs to reduce the cost of an application’s database.The database is running on a Multi-AZ deployment of an Amazon RDS for Microsoft SQL Server DB instance.The application requires the database to support stored procedures, SQL Server Wire Protocol (TDS), and T-SQL.The database must also be highly available.The database specialist is using AWS Database Migration Service (AWS DMS) to migrate the database to a new data store.Which solution will reduce the cost of the database with the LEAST effort?Read More →

A company has more than 100 AWS accounts that need Amazon RDS instances.The company wants to build an automated solution to deploy the RDS instances with specific compliance parameters.The data does not need to be replicated.The company needs to create the databases within 1 day.Which solution will meet these requirements in the MOST operationally efficient way?Read More →

A social media company recently launched a new feature that gives users the ability to share live feeds of their daily activities with their followers.The company has an Amazon RDS for MySQL DB instance that stores data about follower engagement.After the new feature launched, the company noticed high CPU utilization and high database latency during reads and writes.The company wants to implement a solution that will identify the source of the high CPU utilization.Which solution will meet these requirements with the LEAST administrative oversight?Read More →

A company has an application environment that deploys Amazon Aurora PostgreSQL databases as part of its CI/CD process that uses AWS CloudFormation.The company’s database administrator has received reports of performance issues from the resulting database but has no way to investigate the issues.Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data? (Choose two.)Read More →

A company uses a large, growing, and high performance on-premises Microsoft SQL Server instance with an Always On availability group cluster size of 120 TiB.The company uses a third-party backup product that requires system-level access to the databases.The company will continue to use this third-party backup product in the future.The company wants to move the DB cluster to AWS with the least possible downtime and data loss.The company needs a 2 Gbps connection to sustain Always On asynchronous data replication between the company’s data center and AWS.Which combination of actions should a database specialist take to meet these requirements? (Choose three.)Read More →

A marketing company is developing an application to track responses to email message campaigns.The company needs a database storage solution that is optimized to work with highly connected data.The database needs to limit connections and programmatic access to the data by using IAM policies.Which solution will meet these requirements?Read More →