Database Specialty (Page 17)

An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost.A Database Specialist needs to addRDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.Which settings will meet this requirement? (Choose three.)Read More →

A company recently acquired a new business.A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account.The database specialist needs to minimize the amount of time required to migrate the database.Which solution meets these requirements?Read More →

An online shopping company has a large inflow of shopping requests daily.As a result, there is a consistent load on the company’s Amazon RDS database.A database specialist needs to ensure the database is up and running at all times.The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.What should the database specialist do to achieve this? (Choose two.)Read More →

A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL.The migration must be completed with minimal downtime using AWS DMS.A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover.The migration must have minimal impact on the performance of the source database.Which approach will MOST effectively meet these requirements?Read More →

A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior.When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:ERROR: cloud not write block 7507718 of temporary file: No space left on deviceWhat is the cause of this error and what should the Database Specialist do to resolve this issue?Read More →

Developers have requested a new Amazon Redshift cluster so they can load new third-party marketing data.The new cluster is ready and the user credentials are given to the developers.The developers indicate that their copy jobs fail with the following error message:`Amazon Invalid operation: S3ServiceException:Access Denied,Status 403,Error AccessDenied.`The developers need to load this data soon, so a database specialist must act quickly to solve this issue.What is the MOST secure solution?Read More →

A finance company migrated its 3 ׀¢׀’ on-premises PostgreSQL database to an Amazon Aurora PostgreSQL DB cluster.During a review after the migration, a database specialist discovers that the database is not encrypted at rest.The database must be encrypted at rest as soon as possible to meet security requirements.The database specialist must enable encryption for the DB cluster with minimal downtime.Which solution will meet these requirements?Read More →

A company has a database fleet that includes an Amazon RDS for MySQL DB instance.During an audit, the company discovered that the data that is stored on the DB instance is unencrypted.A database specialist must enable encryption for the DB instance.The database specialist also must encrypt all connections to the DB instance.Which combination of actions should the database specialist take to meet these requirements? (Choose three.)Read More →

A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards.Millions of players around the world will complete in annual tournaments.The company wants to implement an architecture that is highly available.The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform.Which combination of steps should the company take to meet these requirements? (Choose two.)Read More →

A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL.To comply with the company’s security policy, all databases must be encrypted at rest.RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.Which solution meets these requirements?Read More →