An Ecommerce Company Recently Migrated One of Its SQL Server

question 98

Multiple Choice

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.

---

Definitions:

Remotely Accessible

Describes a system or device that can be accessed or controlled from a remote location via the internet.

Pay-Per-Usage

A pricing model where customers are billed based on their actual usage of a service or product, rather than a flat fee.

Cloud Services

Internet-based services that provide users with a scalable and on-demand access to resources such as software, storage, and processing power.

Intranet-Level Protection

Refers to security measures implemented within an organization's intranet to protect against unauthorized access and ensure data confidentiality and integrity.