A company has branch offices in the United States and Singapore. The company has a three-tier web application that uses a shared database. The database runs on an Amazon RDS for MySQL DB instance that is hosted in the us-west-2 Region. The application has a distributed front end that is deployed in us-west-2 and in the ap-southeast-1 Region. The company uses this front end as a dashboard that provides statistics to sales managers in each branch office.
The dashboard loads more slowly in the Singapore branch office than in the United States branch office. The company needs a solution so that the dashboard loads consistently for users in each location.
Which solution will meet these requirements in the MOST operationally efficient way?

1. A. Take a snapshot of the DB instance in us-west-2. Create a new DB instance in ap-southeast-2 from the snapsho
2. B. Reconfigure the ap-southeast-1 front-end dashboard to access the new DB instance.
3. C. Create an RDS read replica in ap-southeast-1 from the primary DB instance in us-west-2. Reconfigure the ap-southeast-1 front-end dashboard to access the read replica.
4. D. Create a new DB instance in ap-southeast-1. Use AWS Database Migration Service (AWS DMS) and change data capture (CDC) to update the new DB instance in ap-southeast-1. Reconfigure theap-southeast-1 front-end dashboard to access the new DB instance.
5. E. Create an RDS read replica in us-west-2, where the primary DB instance reside
6. F. Create a read replica in ap-southeast-1 from the read replica in us-west-2. Reconfigure the ap-southeast-1 front-end dashboard to access the read replica in ap-southeast-1.

Correct Answer: B

A database specialist is designing an enterprise application for a large company. The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX).
The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads.
What should the database specialist review first to improve the utility of DAX?

1. A. The DynamoDB ConsumedReadCapacityUnits metric
2. B. The trust relationship to perform the DynamoDB API calls
3. C. The DAX cluster's TTL setting
4. D. The validity of customer-specified AWS Key Management Service (AWS KMS) keys for DAX encryption at rest

Correct Answer: C
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DAX.cluster-management.html#DAX.clu

A corporation wishes to move a 1 TB Oracle database from its current location to an Amazon Aurora PostgreSQL DB cluster. The database specialist at the firm noticed that the Oracle database stores 100 GB of large binary objects (LOBs) across many tables. The Oracle database supports LOBs up to 500 MB in size and an average of 350 MB. AWS DMS was picked by the Database Specialist to transfer the data with the most replication instances.
How should the database specialist improve the transfer of the database to AWS DMS?

1. A. Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together
2. B. Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs
3. C. Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs
4. D. Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together

Correct Answer: C
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.LOBS, "AWS DMS migrates LOB data in two phases: 1. AWS DMS creates a new row in the target table and
populates the row with all data except the associated LOB value. 2.AWS DMS updates the row in the target table with the LOB data." This means that we would need two tasks, one per phase and use limited LOB mode for best performance.

A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting. These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency. System users run ad-hoc queries sporadically throughout the week. Cost is a primary concern for the company, and a solution that does not require significant rework is needed.
Which solution meets these requirements?

1. A. Create new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
2. B. Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
3. C. Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
4. D. Change the DB clusters to the burstable instance family.

Correct Answer: A
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.DBInstanceClass.html

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 to rename the database? (Choose two.)

1. A. Turn off automatic snapshots for the DB instanc
2. B. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedur
3. C. Turn on the automatic snapshots.
4. D. Turn off Multi-AZ for the DB instanc
5. E. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedur
6. F. Turn on Multi-AZ Mirroring.
7. G. Delete all existing snapshots for the DB instanc
8. H. Use the rdsadmin.dbo.rds_modify_db_name stored procedure.
9. I. Update the application with the new database connection string.
10. J. Update the DNS record for the DB instance.

Correct Answer: BD
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Renami