Database Specialty (Page 24)

A database specialist is designing an application to answer one-time queries.The application will query complex customer data and provide reports to end users.These reports can include many fields.The database specialist wants to give users the ability to query the database by using any of the provided fields.The database’s traffic volume will be high but variable during peak times.However, the database will not have much traffic at other times during the day.Which solution will meet these requirements MOST cost-effectively?Read More →

A financial company is hosting its web application on AWS.The application’s database is hosted on Amazon RDS for MySQL with automated backups enabled.The application has caused a logical corruption of the database, which is causing the application to become unresponsive.The specific time of the corruption has been identified, and it was within the backup retention period.How should a database specialist recover the database to the most recent point before corruption?Read More →

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 →