Database Specialty (Page 22)

A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts.Post-migration, the company purged unwanted data from the instance.The company now want to downsize storage to save money.The solution must have the least impact on production and near-zero downtime.Which solution would meet these requirements?Read More →

A large financial services company uses Amazon ElastiCache for Redis for its new application that has a global user base.A database administrator must develop a caching solution that will be available across AWS Regions and include low-latency replication and failover capabilities for disaster recovery (DR).The company’s security team requires the encryption of cross-Region data transfers.Which solution meets these requirements with the LEAST amount of operational effort?Read More →

A company is using an Amazon RDS for MySQL DB instance for a production application.During the company’s upcoming scheduled maintenance window, a database specialist will perform a major version upgrade to the DB instance.The application is critical, so the company wants to minimize the maintenance time and allow for a rollback if a problem occurs.Which solution will meet these requirements?Read More →

A bank is using an Amazon RDS for MySQL DB instance in a proof of concept.A database specialist is evaluating automated database snapshots and cross-Region snapshot copies as -part of this proof of concept.After validating three automated snapshots successfully, the database specialist realizes that the fourth snapshot was not created.Which of the following are possible reasons why the snapshot was not created? (Choose two.)Read More →

A retail company uses Amazon Redshift Spectrum to run complex analytical queries on objects that are stored in an Amazon S3 bucket.The objects are joined with multiple dimension tables that are stored in an Amazon Redshift database.The company uses the database to create monthly and quarterly aggregated reports.Users who attempt to run queries are reporting the following error message: error: Spectrum Scan Error: Access throttledWhich solution will resolve this error?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 →

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