Free AWS-Certified-Database-Specialty Exam Dumps

Question 36

A gaming company has recently acquired a successful iOS game, which is particularly popular during the holiday season. The company has decided to add a leaderboard to the game that uses Amazon DynamoDB. The application load is expected to ramp up over the holiday season.
Which solution will meet these requirements at the lowest cost?

A. DynamoDB Streams
B. DynamoDB with DynamoDB Accelerator
C. DynamoDB with on-demand capacity mode
D. DynamoDB with provisioned capacity mode with Auto Scaling

Correct Answer:C

Question 37

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 loadin
B. The Database Specialist needs to modify the workload to load the data slowly.
C. The scaling of Aurora storage cannot catch up with the data loadin
D. The Database Specialist needs to enable Aurora storage scaling.
E. The local storage used to store temporary tables is ful
F. The Database Specialist needs to scale up the instance.
G. The local storage used to store temporary tables is ful
H. The Database Specialist needs to enable localstorage scaling.

Correct Answer:C

Question 38

A business's mission-critical production workload is being operated on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must migrate the workload without causing data loss to a new Amazon Aurora Serverless MySQL DB cluster.
Which approach will result in the LEAST amount of downtime and the LEAST amount of application impact?

A. Modify the existing DB cluster and update the Aurora configuration to Serverless.
B. Create a snapshot of the existing DB cluster and restore it to a new Aurora Serverless DB cluster.
C. Create an Aurora Serverless replica from the existing DB cluster and promote it to primary when the replica lag is minimal.
D. Replicate the data between the existing DB cluster and a new Aurora Serverless DB cluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled.

Correct Answer:D
https://medium.com/@souri29/how-to-migrate-from-amazon-rds-aurora-or-mysql-to-amazon-aurora-serverless

Question 39

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.

Correct Answer:A
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraMySQL.Monitoring.Metrics. Unlike for other DB engines, for Aurora DB instances this metric reports the amount of storage available to each DB instance. This value depends on the DB instance class (for pricing information, see the Amazon RDS product page). You can increase the amount of free storage space for an instance by choosing a larger DB instance class for your instance."

Question 40

A business's production database is hosted on a single-node Amazon RDS for MySQL DB instance. The database instance is hosted in a United States AWS Region.
A week before a significant sales event, a fresh database maintenance update is released. The maintenance update has been designated as necessary. The firm want to minimize the database instance's downtime and requests that a database expert make the database instance highly accessible until the sales event concludes.
Which solution will satisfy these criteria?

A. Defer the maintenance update until the sales event is over.
B. Create a read replica with the latest updat
C. Initiate a failover before the sales event.
D. Create a read replica with the latest updat
E. Transfer all read-only traffic to the read replica during the sales event.
F. Convert the DB instance into a Multi-AZ deploymen
G. Apply the maintenance update.

Correct Answer:D
https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/