Database Specialty (Page 8)

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 →

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 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 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 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 runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance.Tests were run on the database after work hours, which generated additional database logs.The free storage of the RDS DB instance is low due to these additional logs.What should the company do to address this space constraint issue?Read More →

A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas.This new website will replace an on-premises website connected to a legacy relational database.Due to stability issues in the legacy database, the company would like to test the resiliency ofAurora.Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?Read More →

A database specialist is managing an application in the us-west-1 Region and wants to set up disaster recovery in the us-east-1 Region.The Amazon AuroraMySQL DB cluster needs an RPO of 1 minute and an RTO of 2 minutes.Which approach meets these requirements with no negative performance impact?Read More →

A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings.This application is very popular and the company expects a tenfold increase in the user base in next few months.The application experiences more traffic during the morning and evening hours.This application has two parts:✑ An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.✑ A third-party customer relationship management (CRM) component used by customer care representatives.The CRM uses queries to access booking data.A database specialist needs to design a cost-effective database solution to handle this workload.Which solution meets these requirements?Read More →

A company has applications running on Amazon EC2 instances in a private subnet with no internet connectivity.The company deployed a new application that uses Amazon DynamoDB, but the application cannot connect to the DynamoDB tables.A developer already checked that all permissions are set correctly.What should a database specialist do to resolve this issue while minimizing access to external resources?Read More →