Database Specialty (Page 10)

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 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 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 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 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 wants to implement a design that includes multiple AWS Regions to support disaster recovery for its application.The company currently has a static website that is hosted on Amazon S3 and Amazon CloudFront.The application connects to an existing Amazon DynamoDB database in the us-east-1 Region.The DynamoDB table was recently created and was initialized with a large amount of company data.The company wants to replicate the database in real time to the us-west-2 Region.A database specialist needs to perform the replication, which must include all existing table data and any new data that is added in the future, in an automated way.Which solution will meet these requirements?Read More →

A company has an existing system that uses a single-instance Amazon DocumentDB (with MongoDB compatibility) cluster.Read requests account for 75% of the system queries.Write requests are expected to increase by 50% after an upcoming global release.A database specialist needs to design a solution that improves the overall database performance without creating additional application overhead.Which solution will meet these requirements?Read More →

A financial services company is running a MySQL database on premises.The database holds details about all customer interactions and the financial advice that the company provided.The write traffic to the database is well known and consistent.However, the read traffic is subject to significant and sudden increases for end-of-month reporting.The database is becoming overloaded during these periods of heavy read activity.The company decides to move the database to AWS.A database specialist needs to propose a solution in the AWS Cloud that will scale to meet the variable read traffic requirements without affecting the performance of write traffic.Scaling events must not require any downtime.What is the MOST operationally efficient solution that meets these requirements?Read More →

A company has a Microsoft SQL Server 2017 Enterprise edition on Amazon RDS database with the Multi-AZ option turned on.Automatic backups are turned on and the retention period is set to 7 days.The company needs to add a read replica to the RDS DB instance.How should a database specialist achieve this task?Read More →

A company is using a 1 TB Amazon RDS for PostgreSQL DB instance to store user data.During a security review, a security engineer sees that the DB instance is not encrypted at rest.How should a database specialist correct this issue with the LEAST amount of downtime and no data loss?Read More →