- All Exams Instant Download
Which approach should the Database Specialist take?
A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective. Which approach should the Database Specialist take?A . Dump all the tables...
Which backup methodology should the database specialist use to MINIMIZE management overhead?
A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy. Which backup methodology should the database specialist use to MINIMIZE management overhead?A . Install the AWS CLI on an Amazon EC2 instance. Write a CLI command that...
Which settings will result in the LEAST amount of downtime for the application during failover?
The website of a manufacturing firm makes use of an Amazon Aurora PostgreSQL database cluster. Which settings will result in the LEAST amount of downtime for the application during failover? (Select three.)A . Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster....
What should a database specialist do to resolve this issue while minimizing access to external resources?
A company has applications running on Amazon EC2 instances in a private subnet with no internet connectivity. The company deployed a new application that uses Amazon DynamoDB, but the application cannot connect to the DynamoDB tables. A developer already checked that all permissions are set correctly. What should a database...
Which configurations will result in the LEAST application downtime during a failover?
A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster. Which configurations will result in the LEAST application downtime during a failover? (Choose three.)A . Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster. B. Create an Amazon CloudWatch alert triggering...
What should the database specialist do to meet these requirements?
A company has an ecommerce web application with an Amazon RDS for MySQL DB instance. The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets. The marketing team wants a database specialist to audit future database activity to...
Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?
A business's production databases are housed on a 3 TB Amazon Aurora MySQL DB cluster. The database cluster is installed in the region us-east-1. For disaster recovery (DR) requirements, the company's database expert needs to fast deploy the DB cluster in another AWS Region to handle the production load with...
Which combination of steps should the database specialist take to rename the database?
A company uses Microsoft SQL Server on Amazon RDS in a Multi-AZ deployment as the database engine for its application. The company was recently acquired by another company. A database specialist must rename the database to follow a new naming standard. Which combination of steps should the database specialist take...
Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively?
Amazon Aurora MySQL is being used by an ecommerce business to migrate its main application database. The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing. Examining the Amazon CloudWatch stats...
Which process should the database specialist recommend?
A company is running an Amazon RDS for MySQL Multi-AZ DB instance for a business-critical workload. RDS encryption for the DB instance is disabled. A recent security audit concluded that all business-critical applications must encrypt data at rest. The company has asked its database specialist to formulate a plan to...
