A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database…

Question

Options

• ARestore a snapshot from the production cluster into test clusters
• BCreate logical dumps of the production cluster and restore them into new test clusters
• CUse database cloning to create clones of the production cluster
• DAdd an additional read replica to the production cluster and use that node for testing

• B
  12% (2)
• C
  82% (14)
• D
  6% (1)

Explanation

Aurora Database Cloning Explanation

Why C is Correct: Aurora database cloning uses a copy-on-write protocol, meaning it creates a clone almost instantly without copying the underlying data - the clone only stores changes made after cloning. This makes it the fastest method with the least administrative overhead, as no data needs to be physically duplicated upfront, and it's done entirely within the Aurora console with minimal configuration.

Why the Distractors are Wrong:

• Option A (snapshot restore) is slower because it requires a full data copy to provision the new cluster, adding significant wait time and manual steps.
• Option B (logical dumps) is the most time-consuming and labor-intensive approach, requiring export, transfer, and reimport of data - high administrative effort.
• Option D (read replica for testing) is dangerous because it would expose the production cluster to test workloads, risking performance degradation on live data.

Memory Tip : Think of Aurora cloning like a "snapshot shortcut" - it's faster than a snapshot because it doesn't copy data immediately. Remember the phrase: "Clone = Instant, Snapshot = Wait." Whenever an AWS exam question mentions Aurora + speed + least effort for test/dev environments, cloning is almost always the answer.

No community discussion yet for this question.