DBS-C01 (Page 14)

A company has a hybrid environment in which a VPC connects to an on-premises network through an AWS Site-to-Site VPN connection.The VPC contains an application that is hosted on Amazon EC2 instances.The EC2 instances run in private subnets behind an Application Load Balancer (ALB) that is associated with multiple public subnets.The EC2 instances need to securely access an Amazon DynamoDB table.Which solution will meet these requirements?Read More →

A web-based application uses Amazon DocumentDB (with MongoDB compatibility) as its underlying data store.Sufficient access control is in place, but a database specialist wants to be able to review logs if the primary DocumentDB database is deleted.Which combination of steps should the database specialist take to meet this requirement? (Choose two.)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 →

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 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 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 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 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 →

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 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 →