Amazon AWS Certified Database - Specialty
Prev

There are 231 results

Next
#101 (Accuracy: 100% / 5 votes)
A company is using Amazon Neptune as the graph database for one of its products. The company's data science team accidentally created large amounts of temporary information during an ETL process. The Neptune DB cluster automatically increased the storage space to accommodate the new data, but the data science team deleted the unused information.
What should a database specialist do to avoid unnecessary charges for the unused cluster volume space?
  • A. Take a snapshot of the cluster volume. Restore the snapshot in another cluster with a smaller volume size.
  • B. Use the AWS CLI to turn on automatic resizing of the cluster volume.
  • C. Export the cluster data into a new Neptune DB cluster.
  • D. Add a Neptune read replica to the cluster. Promote this replica as a new primary DB instance. Reset the storage space of the cluster.
#102 (Accuracy: 100% / 3 votes)
A company runs a MySQL database for its ecommerce application on a single Amazon RDS DB instance. Application purchases are automatically saved to the database, which causes intensive writes. Company employees frequently generate purchase reports. The company needs to improve database performance and reduce downtime due to patching for upgrades.
Which approach will meet these requirements with the LEAST amount of operational overhead?
  • A. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.
  • B. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and set up replication to a MySQL DB instance running on Amazon EC2.
  • C. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.
  • D. Add a read replica and promote it to an Amazon Aurora MySQL DB cluster master. Then enable Amazon Aurora Serverless.
#103 (Accuracy: 100% / 2 votes)
A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in
CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A
Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)
  • A. Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
  • B. Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
  • C. Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
  • D. Use Amazon QuickSight to view the SQL statement being run.
  • E. Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.
#104 (Accuracy: 100% / 2 votes)
A database specialist has a fleet of Amazon RDS DB instances that use the default DB parameter group. The database specialist needs to associate a custom parameter group with some of the DB instances.
After the database specialist makes this change, when will the instances be assigned to this new parameter group?
  • A. Instantaneously after the change is made to the parameter group
  • B. In the next scheduled maintenance window of the DB instances
  • C. After the DB instances are manually rebooted
  • D. Within 24 hours after the change is made to the parameter group
#105 (Accuracy: 100% / 2 votes)
A company needs to deploy an Amazon Aurora PostgreSQL DB instance into multiple accounts. The company will initiate each DB instance from an existing Aurora PostgreSQL DB instance that runs in a shared account. The company wants the process to be repeatable in case the company adds additional accounts in the future. The company also wants to be able to verify if manual changes have been made to the DB instance configurations after the company deploys the DB instances.

A database specialist has determined that the company needs to create an AWS CloudFormation template with the necessary configuration to create a DB instance in an account by using a snapshot of the existing DB instance to initialize the DB instance. The company will also use the CloudFormation template's parameters to provide key values for the DB instance creation (account ID, etc.).

Which final step will meet these requirements in the MOST operationally efficient way?
  • A. Create a bash script to compare the configuration to the current DB instance configuration and to report any changes.
  • B. Use the CloudFormation drift detection feature to check if the DB instance configurations have changed.
  • C. Set up CloudFormation to use drift detection to send notifications if the DB instance configurations have been changed.
  • D. Create an AWS Lambda function to compare the configuration to the current DB instance configuration and to report any changes.
#106 (Accuracy: 100% / 4 votes)
A database specialist is designing a disaster recovery (DR) strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its data store. The application requires an RTO of 1 minute and an RPO of 2 minutes.

Which DR strategy for the DynamoDB table will meet these requirements with the MOST operational efficiency?
  • A. Create a DynamoDB stream and an AWS Lambda function. Configure the Lambda function to process the stream and copy the data to a table in another AWS Region.
  • B. Use a DynamoDB global table replica in another AWS Region. Activate point-in-time recovery for both tables.
  • C. Use a DynamoDB Accelerator (DAX) table in another AWS Region. Activate point-in-time recovery for the table.
  • D. Create an AWS Backup plan. Assign the DynamoDB table as a resource.
#107 (Accuracy: 100% / 2 votes)
A company has an Amazon Redshift cluster with database audit logging enabled. A security audit shows that raw SQL statements that run against the Redshift cluster are being logged to an Amazon S3 bucket. The security team requires that authentication logs are generated for use in an intrusion detection system (IDS), but the security team does not require SQL queries.

What should a database specialist do to remediate this issue?
  • A. Set the use_fips_ssl parameter to true in the database parameter group.
  • B. Turn off the query monitoring rule in the Redshift cluster's workload management (WLM).
  • C. Set the enable_user_activity_logging parameter to false in the database parameter group.
  • D. Disable audit logging on the Redshift cluster.
#108 (Accuracy: 100% / 2 votes)
An online bookstore uses Amazon Aurora MySQL as its backend database. After the online bookstore added a popular book to the online catalog, customers began reporting intermittent timeouts on the checkout page. A database specialist determined that increased load was causing locking contention on the database. The database specialist wants to automatically detect and diagnose database performance issues and to resolve bottlenecks faster.

Which solution will meet these requirements?
  • A. Turn on Performance Insights for the Aurora MySQL database. Configure and turn on Amazon DevOps Guru for RDS.
  • B. Create a CPU usage alarm. Select the CPU utilization metric for the DB instance. Create an Amazon Simple Notification Service (Amazon SNS) topic to notify the database specialist when CPU utilization is over 75%.
  • C. Use the Amazon RDS query editor to get the process ID of the query that is causing the database to lock. Run a command to end the process.
  • D. Use the SELECT INTO OUTFILE S3 statement to query data from the database. Save the data directly to an Amazon S3 bucket. Use Amazon Athena to analyze the files for long-running queries.
#109 (Accuracy: 100% / 2 votes)
A company is running critical applications on AWS. Most of the application deployments use Amazon Aurora MySQL for the database stack. The company uses AWS CloudFormation to deploy the DB instances.

The company's application team recently implemented a CI/CD pipeline. A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CI/CD platform. Updates to the CloudFormation stack must not update existing production database resources.

Which CloudFormation stack policy action should the database engineer implement to meet these requirements?
  • A. Use a Deny statement for the Update:Modify action on the production database resources.
  • B. Use a Deny statement for the Update:* action on the production database resources.
  • C. Use a Deny statement for the Update:Delete action on the production database resources.
  • D. Use a Deny statement for the Update:Replace action on the production database resources.
#110 (Accuracy: 100% / 2 votes)
A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance. The company recently conducted tests on the database after business hours, and the tests generated additional database logs. As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.

The company wants to recover the free storage that the additional logs consumed. The solution must not result in downtime for the database.

Which solution will meet these requirements?
  • A. Modify the rds.log_retention_period parameter to 0. Reboot the DB instance to save the changes.
  • B. Modify the rds.log_retention_period parameter to 1440. Wait up to 24 hours for database logs to be deleted.
  • C. Modify the temp_file_limit parameter to a smaller value to reclaim space on the DB instance.
  • D. Modify the rds.log_retention_period parameter to 1440. Reboot the DB instance to save the changes.