Free AWS-Certified-Database-Specialty Exam Braindumps

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?

1. A. Amazon RDS for MySQL with Multi-AZ
2. B. Amazon Aurora Serverless MySQL cluster
3. C. Amazon Aurora MySQL cluster
4. D. Amazon RDS for MySQL with read replica

Correct Answer: B
Amazon Aurora Serverless v1 is a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. https://aws.amazon.com/rds/aurora/serverless/

A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi- AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance.
Which approach should the database specialist to take to resolve this issue without changing the application?

1. A. Implementing sharding to distribute the load to multiple RDS for MySQL databases.
2. B. Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
3. C. Add an RDS for MySQL read replica.
4. D. Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).

Correct Answer: D

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 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 an RTO of less than two hours.
Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?

1. A. Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Regio
2. B. Restore the snapshot to an appropriately sized DB cluster in the DR Region.
3. C. Add a cross-Region read replica in the DR Region with the same instance type as the current primary instanc
4. D. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.
5. E. Create a smaller DB cluster in the DR Regio
6. F. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.
7. G. Create an Aurora global database that spans two Region
8. H. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.

Correct Answer: B
RTO is 2 hours. With 3 TB database, cross-region replica is a better option

A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system. New compliance requirements specify that the database must be encrypted at rest.
Which action will meet these requirements?

1. A. Create an encrypted copy of manual snapshot of the DB instanc
2. B. Restore a new DB instance from the encrypted snapshot.
3. C. Modify the DB instance and enable encryption.
4. D. Restore a DB instance from the most recent automated snapshot and enable encryption.
5. E. Create an encrypted read replica of the DB instanc
6. F. Promote the read replica to a standalone instance.

Correct Answer: A
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/encrypt-an-existing-amazon-rds-for-postgresq You can enable encryption for an Amazon RDS DB instance when you create it, but not after it's created.
However, you can add encryption to an unencrypted DB instance by creating a snapshot of your DB instance, and then creating an encrypted copy of that snapshot. You can then restore a DB instance from the encrypted snapshot to get an encrypted copy of your original DB instance. The pattern uses AWS Database Migration Service (AWS DMS) to migrate data and AWS Key Management Service (AWS KMS) for encryption.