DBS-C01 (Page 10)

A company’s applications store data in Amazon Aurora MySQL DB clusters.The company has separate AWS accounts for its production, test, and development environments.To test new functionality in the test environment, the company’s development team requires a copy of the production database four times a day.Which solution meets this requirement with the MOST operational efficiency?Read More →

A database specialist needs to enable IAM authentication on an existing Amazon Aurora PostgreSQL DB cluster.The database specialist already has modified the DB cluster settings, has created IAM and database credentials, and has distributed the credentials to the appropriate users.What should the database specialist do next to establish the credentials for the users to use to log in to the DB cluster?Read More →

An ecommerce company is planning to launch a custom customer relationship management (CRM) application on AWS.The development team selected Microsoft SQL Server as the database engine for this deployment.The CRM application will require operating system access because the application will manipulate files and packages on the server hosting the database.A senior database engineer must help the application team select a suitable deployment model for SQL Server.The deployment model should be optimized for the workload requirements.Which deployment option should the database engineer choose that involves the LEAST operational overhead?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 →

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