Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 155 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 155
Topic #: 1

[All AWS Certified Database - Specialty Questions]

An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition DB instance. The company expects a spike in read traffic due to an upcoming sale. A database specialist must create a read replica of the DB instance to serve the anticipated read traffic.
Which actions should the database specialist take before creating the read replica? (Choose two.)

A. Identify a potential downtime window and stop the application calls to the source DB instance.
B. Ensure that automatic backups are enabled for the source DB instance.
C. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
D. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
E. Modify the read replica parameter group setting and set the value to 1.

Show Suggested Answer

Suggested Answer: BC 🗳️

by alwaysAstudent at Nov. 9, 2021, 4:41 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

alwaysAstudent

Highly Voted 3 years, 8 months ago

Ans B,C https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 6 times

...

jove

Highly Voted 3 years, 6 months ago

B, C https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 5 times

...

testhello

Most Recent 1 year, 12 months ago

Selected Answer: BC

B. Ensure that automatic backups are enabled for the source DB instance: Before creating a read replica, it is essential to have automatic backups enabled on the source DB instance. This ensures that the read replica can be created from a recent snapshot of the source DB instance. C. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups: To create a read replica for a SQL Server DB instance, the source DB instance must be configured as a Multi-AZ deployment with Always ON Availability Groups. This ensures high availability and data synchronization between the primary and standby replicas.

upvoted 1 times

...

aviathor

2 years, 1 month ago

Selected Answer: BC

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 1 times

...

tsk9921

2 years, 2 months ago

BC is right

upvoted 1 times

...

parle101

2 years, 6 months ago

Ans B, C https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html Before a DB instance can serve as a source instance for replication, you must enable automatic backups on the source DB instance. To do so, you set the backup retention period to a value other than 0. The source DB instance must be a Multi-AZ deployment with Always On Availability Groups (AGs). Setting this type of deployment also enforces that automatic backups are enabled.

upvoted 1 times

...

lollyj

2 years, 6 months ago

Selected Answer: BC

Makes the most sense to me

upvoted 1 times

...

novice_expert

3 years, 2 months ago

Selected Answer: BC

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 1 times

...

megadba

3 years, 3 months ago

Selected Answer: BC

Before a DB instance can serve as a source instance for replication, you must enable automatic backups on the source DB instance. To do so, you set the backup retention period to a value other than 0. The source DB instance must be a Multi-AZ deployment with Always On Availability Groups (AGs). Setting this type of deployment also enforces that automatic backups are enabled.

upvoted 3 times

...

mnzsql365

3 years, 7 months ago

B & C Before a DB instance can serve as a source instance for replication, you must enable automatic backups on the source DB instance. To do so, you set the backup retention period to a value other than 0. The source DB instance must be a Multi-AZ deployment with Always On Availability Groups (AGs). Setting this type of deployment also enforces that automatic backups are enabled.

upvoted 2 times

...