DBS-C01 Question Bank · Latest 50 Questions Free Preview (Page 5/5)

A company's application team needs to select an AWS managed database service to store application and user data. The application team is familiar with MySQL but is open to new solutions. The application and user data is stored in 10 tables and is de-normalized. The application will access this data through an API layer using a unique ID in each table. The company expects the traffic to be light at first, but the traffic will increase to thousands of transactions each second within the first year. The database service must support active reads and writes in multiple AWS Regions at the same time. Query response times need to be less than 100 ms. Which AWS database solution will meet these requirements?

• A. Deploy an Amazon RDS for MySQL environment in each Region and leverage AWS Database Migration Service (AWS DMS) to set up a multi-Region bidirectional replication.
• B. Deploy an Amazon Aurora MySQL global database with write forwarding turned on.
• C. Deploy an Amazon DynamoDB database with global tables.
• D. Deploy an Amazon DocumentDB global cluster across multiple Regions.

Answer: C

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?

• A. Use AWS Database Migration Service (DMS) to migrate to an RDS for MySQL Multi-AZ database. Update the application code to use the features of MySQL that correspond to SQL Server. Update the application to use the MySQL port.
• B. Use AWS Database Migration Service (DMS) to migrate to an RDS for PostgreSQL Multi-AZ database. Turn on the SQL_COMPAT optional extension within the database to allow the required features. Update the application to use the PostgreSQL port.
• C. Use AWS Database Migration Service (DMS) to migrate to an RDS for SQL Server Single-AZ database. Update the application to use the new database endpoint.
• D. Use AWS Database Migration Service (DMS) to migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish for Aurora PostgreSQL. Update the application to use the Babelfish TDS port.

Answer: D

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?

• A. Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.
• B. Create an RDS snapshot. Share the snapshot with each account. Deploy the snapshot into each account.
• C. Use AWS CloudFormation to create RDS instances in each account. Run AWS Database Migration Service (AWS DMS) replication to each of the created instances.
• D. Create a script by using the AWS CLI to copy the RDS instance into the other accounts from a template account.

Answer: A

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?

• A. Use Amazon DevOps Guru insights.
• B. Use AWS CloudTrail.
• C. Use Amazon CloudWatch Logs.
• D. Use Amazon Aurora Database Activity Streams.

Answer: A

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.)

• A. Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormation template.
• B. Turn on AWS CloudTrail in each AWS account.
• C. Turn on and configure AWS Config for all Aurora PostgreSQL databases.
• D. Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.
• E. Update the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL.

Answer: D, E

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.)

• A. Establish an AWS Direct Connect hosted connection between the company’s data center and AWS.
• B. Create an AWS Site-to-Site VPN connection between the company's data center and AWS over the internet.
• C. Use AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server databases to Amazon RDS for SQL Server. Configure Always On availability groups for SQL Server.
• D. Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2. Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster. Fail over to the AWS DB cluster when it is time to migrate.
• E. Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.
• F. Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.

Answer: A, C, E

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?

• A. Amazon ElastiCache for Redis cluster
• B. Amazon Aurora MySQL DB cluster
• C. Amazon DynamoDB table
• D. Amazon Neptune DB cluster

Answer: D

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.)

• A. Set the audit_logs cluster parameter to enabled.
• B. Enable DocumentDB log export to Amazon CloudWatch Logs.
• C. Enable Enhanced Monitoring for DocumentDB.
• D. Enable AWS CloudTrail for DocumentDB.
• E. Use AWS Config to monitor the state of DocumentDB.

Answer: A, B

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?

• A. Use the internet gateway of the VPC to access the DynamoDB table. Use the ALB to route the traffic to the EC2 instances.
• B. Add a NAT gateway in one of the public subnets of the VPC. Configure the security groups of the EC2 instances to access the DynamoDB table through the NAT gateway.
• C. Use the Site-to-Site VPN connection to route all DynamoDB network traffic through the on-premises network infrastructure to access the EC2 instances.
• D. Create a VPC endpoint for DynamoDB. Assign the endpoint to the route table of the private subnets that contain the EC2 instances.

Answer: D

A company has a reporting application that runs on an Amazon EC2 instance in an isolated developer account on AWS. The application needs to retrieve data during non-peak company hours from an Amazon Aurora PostgreSQL database that runs in the company’s production account. The company's security team requires that access to production resources complies with AWS best security practices. A database administrator needs to provide the reporting application with access to the production database. The company has already configured VPC peering between the production account and developer account. The company has also updated the route tables in both accounts with the necessary entries to correctly set up VPC peering. What must the database administrator do to finish providing connectivity to the reporting application?

• A. Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.
• B. Add an outbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.
• C. Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on all TCP ports. Add an inbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on port 5432.
• D. Add an inbound security group rule to the database security group that allows access from the developer account VPC CIDR on port 5432. Add an outbound security group rule to the EC2 security group that allows access to the production account VPC CIDR on all TCP ports.

Answer: A