By:
On:
In: DBS-C01
With: 0 Comments

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 →

By:
On:
In: DBS-C01
With: 0 Comments

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 →

By:
On:
In: DBS-C01
With: 0 Comments

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 →

By:
On:
In: DBS-C01
With: 0 Comments

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 →

By:
On:
In: DBS-C01
With: 0 Comments

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 →

By:
On:
In: DBS-C01
With: 0 Comments

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 →

By:
On:
In: DBS-C01
With: 0 Comments

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 →

By:
On:
In: DBS-C01
With: 0 Comments

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 →