Database Specialty (Page 23)

A company runs an Amazon Aurora MySQL DB instance for one of its critical applications.The company’s marketing department sends promotional email messages to customers based on the data in this database.A database engineer needs to make the data from all the tables available in the company’s Amazon S3 data lake.The database engineer wants to perform an export from a snapshot to populate the S3 data lake with the contents of the database.Which combination of steps will meet these requirements with the LEAST operational overhead? (Choose three.)Read More →

A company is using an Amazon Aurora PostgreSQL database for a project with a government agency.All database communications must be encrypted in transit.All non-SSL/TLS connection requests must be rejected.What should a database specialist do to meet these requirements?Read More →

A legal research company wants to build a recommendation engine on AWS that connects datasets to help lawyers create legal arguments.The recommendation engine will collect millions of unstructured text documents from third-party sources to identify connections between documents without users needing to manually compare the documents.Which solution will meet these requirements with the LEAST operational overhead?Read More →

A news portal is looking for a data store to store 120 GB of metadata about its posts and comments.The posts and comments are not frequently looked up or updated.However, occasional lookups are expected to be served with single-digit millisecond latency on average.What is the MOST cost-effective solution?Read More →

A database specialist needs to replace the encryption key for an Amazon RDS DB instance.The database specialist needs to take immediate action to ensure security of the database.Which solution will meet these requirements?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 →

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