A business is transferring a database from one AWS Region to another using an Amazon RDS for SQL Server DB instance. The organization wishes to keep database downtime to a minimum throughout the transfer.
Which migration strategy should the organization use for this cross-regional move?

• A.Back up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.
• B.Back up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.
• C.Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.
• D.Add an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.

Comment: *

Name: *

Email: *

Verification: *

A media company is using Amazon RDS for PostgreSQL to store user data. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements.
Only certain on-premises corporate network IPs should connect to the DB instance. Connectivity is allowed from the corporate network only.
Which combination of steps does the Database Specialist need to take to meet these new requirements?
(Choose three.)

• A.Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
• B.Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
• C.Move the DB instance to a private subnet using AWS DMS.
• D.Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
• E.Disable the publicly accessible setting.
• F.Connect to the DB instance using private IPs and a VPN.

Comment: *

Name: *

Email: *

Verification: *

A business is operating an on-premises application that is divided into three tiers: web, application, and MySQL database. The database is predominantly accessed during business hours, with occasional bursts of activity throughout the day. As part of the company's shift to AWS, a database expert wants to increase the availability and minimize the cost of the MySQL database tier.
Which MySQL database choice satisfies these criteria?

• A.Amazon RDS for MySQL with Multi-AZ
• B.Amazon Aurora Serverless MySQL cluster
• C.Amazon Aurora MySQL cluster
• D.Amazon RDS for MySQL with read replica

Comment: *

Name: *

Email: *

Verification: *

A business is transferring its on-premises database workloads to the Amazon Web Services (AWS) Cloud. A database professional migrating an Oracle database with a huge table to Amazon RDS has picked AWS DMS.
The database professional observes that AWS DMS is consuming considerable time migrating the data.
Which activities would increase the pace of data migration? (Select three.)

• A.Create multiple AWS DMS tasks to migrate the large table.
• B.Configure the AWS DMS replication instance with Multi-AZ.
• C.Increase the capacity of the AWS DMS replication server.
• D.Establish an AWS Direct Connect connection between the on-premises data center and AWS.
• E.Enable an Amazon RDS Multi-AZ configuration.
• F.Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.

Comment: *

Name: *

Email: *

Verification: *

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 specialist do to resolve this issue while minimizing access to external resources?

• A.Add a route to an internet gateway in the subnet's route table.
• B.Add a route to a NAT gateway in the subnet's route table.
• C.Assign a new security group to the EC2 instances with an outbound rule to ports 80 and 443.
• D.Create a VPC endpoint for DynamoDB and add a route to the endpoint in the subnet's route table.

Comment: *

Name: *

Email: *

Verification: *