What is Replication ?

  1. Writing data on primary and secondary at the same time.

  2. Writing data on primary, then copying to secondary storage

  3. Mirroring data from primary to secondary

  4. None of the above


Correct Option: B

AI Explanation

To answer this question, we need to understand the concept of replication.

Replication is the process of creating and maintaining multiple copies of data in different locations. It is commonly used in database management systems to ensure data availability, fault tolerance, and disaster recovery.

Let's go through each option to understand why it is correct or incorrect:

Option A) Writing data on primary and secondary at the same time - This option is incorrect. Replication involves copying or synchronizing data from one location to another, it does not write data on both primary and secondary simultaneously.

Option B) Writing data on primary, then copying to secondary storage - This option is correct. Replication typically involves writing data on the primary storage and then copying or synchronizing that data to secondary storage. This ensures that the secondary storage contains an up-to-date copy of the data.

Option C) Mirroring data from primary to secondary - This option is similar to Option B and is also correct. Mirroring is a form of replication where the data is copied or mirrored from the primary storage to the secondary storage.

Option D) None of the above - This option is incorrect, as Option B and Option C both correctly describe the process of replication.

The correct answer is B) Writing data on primary, then copying to secondary storage. This option accurately describes the process of replication, where data is first written on the primary storage and then copied or synchronized to the secondary storage.

Find more quizzes: