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:

Partial-Year Depreciation

Partial-year depreciation is the calculation of depreciation expenses for assets used in part of a year, usually during the first year of purchase or the last year before disposal.

Useful Life

The estimated duration over which an asset is expected to be functional and economically viable.

List Price

The manufacturer's suggested retail price (MSRP) for a product, before any discounts or allowances.

Accumulated Depreciation

The complete tally of depreciation charges applied to a fixed asset since its initial usage.