AWS-Certified-Database-Specialty Free Practice Test

After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?

1. A. The restored DB instance does not have Enhanced Monitoring enabled
2. B. The production DB instance is using a custom parameter group
3. C. The restored DB instance is using the default security group
4. D. The production DB instance is using a custom option group

Correct Answer: C
https://aws.amazon.com/premiumsupport/knowledge-center/rds-cannot-connect/ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html

A company is running an Amazon RDS for MySQL Multi-AZ DB instance for a business-critical workload. RDS encryption for the DB instance is disabled. A recent security audit concluded that all business-critical applications must encrypt data at rest. The company has asked its database specialist to formulate a plan to accomplish this for the DB instance.
Which process should the database specialist recommend?

1. A. Create an encrypted snapshot of the unencrypted DB instanc
2. B. Copy the encrypted snapshot to Amazon S3. Restore the DB instance from the encrypted snapshot using Amazon S3.
3. C. Create a new RDS for MySQL DB instance with encryption enable
4. D. Restore the unencrypted snapshot to this DB instance.
5. E. Create a snapshot of the unencrypted DB instanc
6. F. Create an encrypted copy of the snapsho
7. G. Restore the DB instance from the encrypted snapshot.
8. H. Temporarily shut down the unencrypted DB instanc
9. I. Enable AWS KMS encryption in the AWS Management Console using an AWS managed CM
10. J. Restart the DB instance in an encrypted state.

Correct Answer: C
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.Encryption.html#Overview.Encryption.

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?

1. A. Increase the size of the DB instance storage
2. B. Change the underlying EBS storage type to General Purpose SSD (gp2)
3. C. Disable EBS optimization on the DB instance
4. D. Change the DB instance to an instance class with a higher maximum bandwidth

Correct Answer: D
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html

A business is launching a new Amazon RDS for SQL Server database instance. The organization wishes to allow auditing of the SQL Server database.
Which measures should a database professional perform in combination to achieve this requirement? (Select two.)

1. A. Create a service-linked role for Amazon RDS that grants permissions for Amazon RDS to store audit logs on Amazon S3.
2. B. Set up a parameter group to configure an IAM role and an Amazon S3 bucket for audit log storage.Associate the parameter group with the DB instance.
3. C. Disable Multi-AZ on the DB instance, and then enable auditin
4. D. Enable Multi-AZ after auditing is enabled.
5. E. Disable automated backup on the DB instance, and then enable auditin
6. F. Enable automated backup after auditing is enabled.
7. G. Set up an options group to configure an IAM role and an Amazon S3 bucket for audit log storage.Associate the options group with the DB instance.

Correct Answer: AE
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.Audit.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/security_iam_service-with-iam.html

A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process.
Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade.
What should a database specialist do to prevent data loss during the stack upgrade?

1. A. Create a snapshot of the DB instanc
2. B. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapsho
3. C. Update the stack.
4. D. Modify the stack policy using the aws cloudformation update-stack command and the set-stack-policy command, then make the DB resource protected.
5. E. Create a snapshot of the DB instanc
6. F. Update the stac
7. G. Restore the database to a new instance.
8. H. Deactivate any applications that are using the DB instanc
9. I. Create a snapshot of the DB instance.Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapsho
10. J. Update the stack and reactivate the applications.

Correct Answer: D
To preserve your data, perform the following procedure:
* 1.Deactivate any applications that are using the DB instance so that there's no activity on the DB instance. * 2.Create a snapshot of the DB instance. For more information about creating DB snapshots
* 3. If you want to restore your instance using a DB snapshot, modify the updated template with your DB instance changes and add the DBSnapshotIdentifier property with the ID of the DB snapshot that you want to use
* 4. Update the stack.