Database Specialty (Page 17)

A company is migrating its on-premises database workloads to the AWS Cloud.A database specialist performing the move has chosen AWS DMS to migrate anOracle database with a large table to Amazon RDS.The database specialist notices that AWS DMS is taking significant time to migrate the data.Which actions would improve the data migration speed? (Choose three.)Read More →

A company uses a single-node Amazon RDS for MySQL DB instance for its production database.The DB instance runs in an AWS Region in the United States.A week before a big sales event, a new maintenance update is available for the DB instance.The maintenance update is marked as required.The company wants to minimize downtime for the DB instance and asks a database specialist to make the DB instance highly available until the sales event ends.Which solution will meet these requirements?Read More →

A large company has a variety of Amazon DB clusters.Each of these clusters has various configurations that adhere to various requirements.Depending on the team and use case, these configurations can be organized into broader categories.A database administrator wants to make the process of storing and modifying these parameters more systematic.The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.Which AWS service or feature will help automate and achieve this objective?Read More →

A company uses Amazon Aurora for secure financial transactions.The data must always be encrypted at rest and in transit to meet compliance requirements.Which combination of actions should a database specialist take to meet these requirements? (Choose two.)Read More →

A database specialist manages a critical Amazon RDS for MySQL DB instance for a company.The data stored daily could vary from .01% to 10% of the current database size.The database specialist needs to ensure that the DB instance storage grows as needed.What is the MOST operationally efficient and cost-effective solution?Read More →

An IT company wants to reduce its database operation costs in its development environment.The company’s workflow creates an Amazon Aurora MySQL DB cluster for each development group.The DB clusters are used for only 8 hours a day.The DB clusters can be deleted at the end of a development cycle, which lasts 2 weeks.Which solution will meet these requirements MOST cost-effectively?Read More →

A software company uses an Amazon RDS for MySQL Multi-AZ DB instance as a data store for its critical applications.During an application upgrade process, a database specialist runs a custom SQL script that accidentally removes some of the default permissions of the master user.What is the MOST operationally efficient way to restore the default permissions of the master user?Read More →

A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances.The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.What is the MOST operationally efficient solution to meet these requirements?Read More →

A company uses Amazon DynamoDB to store its customer data.The DynamoDB table is designed with the user ID as the partition key value and multiple other non-key attributes.An external application needs to access data for specific user IDs.The external application must have access only to items with specific partition key values.What should the database specialist do to meet these requirements?Read More →

A company hosts an on-premises Microsoft SQL Server Enterprise edition database with Transparent Data Encryption (TDE) enabled.The database is 20 TB in size and includes sparse tables.The company needs to migrate the database to Amazon RDS for SQL Server during a maintenance window that is scheduled for an upcoming weekend.Data-at-rest encryption must be enabled for the target DB instance.Which combination of steps should the company take to migrate the database to AWS in the MOST operationally efficient manner? (Choose two.)Read More →