AWS-Certified-Database-Specialty Free Practice Test

A database professional is tasked with the task of migrating 25 GB of data files from an on-premises storage system to an Amazon Neptune database.
Which method of data loading is the FASTEST?

1. A. Upload the data to Amazon S3 and use the Loader command to load the data from Amazon S3 into the Neptune database.
2. B. Write a utility to read the data from the on-premises storage and run INSERT statements in a loop to load the data into the Neptune database.
3. C. Use the AWS CLI to load the data directly from the on-premises storage into the Neptune database.
4. D. Use AWS DataSync to load the data directly from the on-premises storage into the Neptune database.

Correct Answer: A
* 1. Copy the data files to an Amazon Simple Storage Service (Amazon S3) bucket.
* 2. Create an IAM role with Read and List access to the bucket.
* 3. Create an Amazon S3 VPC endpoint.
* 4. Start the Neptune loader by sending a request via HTTP to the Neptune DB instance.
* 5. The Neptune DB instance assumes the IAM role to load the data from the bucket.

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times. What could be causing these slow response times?

1. A. New volumes created from snapshots load lazily in the background
2. B. Long-running statements on the master
3. C. Insufficient resources on the master
4. D. Overload of a single replication thread by excessive writes on the master

Correct Answer: A
snapshot is lazy loaded If the volume is accessed where the data is not loaded, the application accessing the volume encounters a higher latency than normal while the data gets loaded
https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-ebs-fast-snapshot-restore-eliminates-need-for-p

A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours. Which solution will meet these requirements and is the MOST operationally efficient?

1. A. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.Move the snapshot to the company’s Amazon S3 bucket.
2. B. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
3. C. Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30days.
4. D. Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.

Correct Answer: A
Unlike automated backups, manual snapshots aren't subject to the backup retention period. Snapshots don't expire. For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can't restore to that version from a snapshot. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html

A company is migrating its on-premises database workloads to the AWS Cloud. A database specialist performing the move has chosen AWS DMS to migrate an Oracle database with a large table to Amazon RDS. The database specialist notices that AWS DMS is taking significant time to migrate the data.
Which actions would improve the data migration speed? (Choose three.)

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

Correct Answer: CDE

On a single Amazon RDS DB instance, a business hosts a MySQL database for its ecommerce application. Automatically saving application purchases to the database results in high-volume writes. Employees routinely create purchase reports for the company. The organization wants to boost database performance and minimize downtime associated with upgrade patching.
Which technique will satisfy these criteria with the LEAST amount of operational overhead?

1. A. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.
2. 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.
3. C. Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.
4. D. Add a read replica and promote it to an Amazon Aurora MySQL DB cluster maste
5. E. Then enable Amazon Aurora Serverless.

Correct Answer: C