Database Specialty (Page 9)

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

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 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 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 company’s database specialist disabled TLS on an Amazon DocumentDB cluster to perform benchmarking tests.A few days after this change was implemented, a database specialist trainee accidentally deleted multiple tables.The database specialist restored the database from available snapshots.An hour after restoring the cluster, the database specialist is still unable to connect to the new cluster endpoint.What should the database specialist do to connect to the new, restored Amazon DocumentDB cluster?Read More →

A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend.A custom stored procedure is used to send email notifications to another system when data is inserted into a table.The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams.The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.Which AWS solution meets these requirements?Read More →

A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ.The database supports an ecommerce website that runs continuously.The company can only provide a maintenance window of up to 5 minutes.Which solution will meet these requirements?Read More →

A company is running an Amazon RDS for MySQL Multi-AZ DB instance for a business-critical workload.RDS encryption for the DB instance is disabled.A recent security audit concluded that all business-critical applications must encrypt data at rest.The company has asked its database specialist to formulate a plan to accomplish this for the DB instance.Which process should the database specialist recommend?Read More →

A user has a non-relational key-value database.The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases.The solution must be cost-effective and able to handle unpredictable application traffic.What should a Database Specialist recommend for this user?Read More →