Amazon AWS Certified Database - Specialty
Prev

There are 231 results

Next
#91 (Accuracy: 100% / 2 votes)
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.)
  • A. Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.
  • B. Deploy an ElastiCache for Memcached global datastore.
  • C. Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.
  • D. Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.
  • E. Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.
#92 (Accuracy: 90% / 6 votes)
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.)
  • A. In the RDS console, choose ג€Enable encryptionג€ to encrypt the DB instance by using an AWS Key Management Service (AWS KMS) key.
  • B. Encrypt the read replica of the unencrypted DB instance by using an AWS Key Management Service (AWS KMS) key. Fail over the read replica to the primary DB instance.
  • C. Create a snapshot of the unencrypted DB instance. Encrypt the snapshot by using an AWS Key Management Service (AWS KMS) key. Restore the DB instance from the encrypted snapshot. Delete the original DB instance.
  • D. Require SSL connections for applicable database user accounts.
  • E. Use SSL/TLS from the application to encrypt a connection to the DB instance.
  • F. Enable SSH encryption on the DB instance.
#93 (Accuracy: 93% / 8 votes)
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?
  • A. Modify the unencrypted DB cluster using the AWS Management Console. Enable encryption and choose to apply the change immediately.
  • B. Take a snapshot of the unencrypted DB cluster and restore it to a new DB cluster with encryption enabled. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
  • C. Create an encrypted Aurora Replica of the unencrypted DB cluster. Promote the Aurora Replica as the new master.
  • D. Create a new DB cluster with encryption enabled and use the pg_dump and pg_restore utilities to load data to the new DB cluster. Update any database connection strings to reference the new DB cluster endpoint, and then delete the unencrypted DB cluster.
#94 (Accuracy: 100% / 5 votes)
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 device
What is the cause of this error and what should the Database Specialist do to resolve this issue?
  • A. The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to modify the workload to load the data slowly.
  • B. The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.
  • C. The local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.
  • D. The local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.
#95 (Accuracy: 100% / 3 votes)
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?
  • A. Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.
  • B. Use the table metrics of the AWS DMS task created for migrating the data to verify the statistics for the tables being migrated and to verify that the data definition language (DDL) statements are completed.
  • C. Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.
  • D. Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.
#96 (Accuracy: 100% / 3 votes)
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.)
  • A. Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
  • B. Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
  • C. Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
  • D. Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
  • E. Enable email notifications for AWS Trusted Advisor.
#97 (Accuracy: 100% / 4 votes)
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?
  • A. Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.
  • B. Use AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.
  • C. Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.
  • D. Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
#98 (Accuracy: 100% / 3 votes)
The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB. A database engineer must increase the local storage available in the Aurora DB instance.
How should the database engineer meet this requirement?
  • A. Modify the DB instance to use an instance class that provides more local SSD storage.
  • B. Modify the Aurora DB cluster to enable automatic volume resizing.
  • C. Increase the local storage by upgrading the database engine version.
  • D. Modify the DB instance and configure the required storage volume in the configuration section.
#99 (Accuracy: 100% / 3 votes)
A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.
What should the database specialist do to accomplish this task?
  • A. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.
  • B. Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.
  • C. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.
  • D. Modify the default DB parameter group and set the wait_timeout parameter value to 900.
#100 (Accuracy: 100% / 3 votes)
A database specialist is responsible for designing a highly available solution for online transaction processing (OLTP) using Amazon RDS for MySQL production databases. Disaster recovery requirements include a cross-Region deployment along with an RPO of 5 minutes and RTO of 30 minutes.
What should the database specialist do to align to the high availability and disaster recovery requirements?
  • A. Use a Multi-AZ deployment in each Region.
  • B. Use read replica deployments in all Availability Zones of the secondary Region.
  • C. Use Multi-AZ and read replica deployments within a Region.
  • D. Use Multi-AZ and deploy a read replica in a secondary Region.