DBS-C01 (Page 25)

A company uses multiple AWS accounts in AWS Organizations to separate development teams that work on different applications.Each AWS account contains multiple applications that run in the default VPC with interface endpoints.The applications need access to the same underlying data in an Amazon Aurora PostgreSQL DB cluster in one of the AWS accounts.Which solution will meet these requirements in the MOST operationally efficient way?Read More →

A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read-only workload scaling.A failover event occurs and application performance is poor for several minutes.During this time, application servers in all AvailabilityZones are healthy and responding normally.What should the company do to eliminate this application performance issue?Read More →

A company is preparing to release a new application.During a load test on the application before launch, the company noticed that its Amazon RDS for MySQL database responded more slowly than expected.As a result, the application did not meet performance goals.A database specialist must determine which SQL statements are consuming the most load.Which set of steps should the database specialist take to obtain this information?Read More →

A company that analyzes the stock market has two offices: one in the us-east-1 Region and another in the eu-west-2 Region.The company wants to implement an AWS database solution that can provide fast and accurate updates.The office in eu-west-2 has dashboards with complex analytical queries to display the data.The company will use these dashboards to make buying decisions, so the dashboards must have access to the application data in less than 1 second.Which solution meets these requirements and provides the MOST up-to-date dashboard?Read More →

A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application.The Aurora DB cluster has one medium-sized primary instance, one large-sized replica, and two medium sized replicas.The Database Specialist did not assign a promotion tier to the replicas.In the event of a primary failure, what will occur?Read More →

After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect to the restored RDS DB instance.What is the likely cause of this problem?Read More →

A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics.The company wants to migrate the database to the AWS Cloud.Database specialist must choose one or more AWS services to run the company’s workloads.Which solution will meet these requirements in the MOST operationally efficient manner?Read More →

A company is setting up a new Amazon RDS for SQL Server DB instance.The company wants to enable SQL Server auditing on the database.Which combination of steps should a database specialist take to meet this requirement? (Choose two.)Read More →

A retail company manages a web application that stores data in an Amazon DynamoDB table.The company is undergoing account consolidation efforts.A database engineer needs to migrate the DynamoDB table from the current AWS account to a new AWS account.Which strategy meets these requirements with the LEAST amount of administrative work?Read More →

A company’s database specialist implements an AWS Database Migration Service (AWS DMS) task for change data capture (CDC) to replicate data from an on- premises Oracle database to Amazon S3.When usage of the company’s application increases, the database specialist notices multiple hours of latency with theCDC.Which solutions will reduce this latency? (Choose two.)Read More →