What happens to the I/O operations while you take a database snapshot?
A.
I/O operations to the database are suspended for a few minutes while the backup is in progress.
B.
I/O operations to the database are sent to a Replica (if available) for a few minutes while the backup is in
progress.
C.
I/O operations will be functioning normally
D.
I/O operations to the database are suspended for an hour while the backup is in progress
A is correct as it doesn’t specify ReadReplica in the question at all however if it is mentioned it will work normally
During the backup window, storage I/O may be briefly suspended while the backup process initializes (typically under a few seconds) and you may experience a brief period of elevated latency. There is no I/O suspension for Multi-AZ DB deployments, since the backup is taken from the standby.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSInstances.html
the answer is C. snapshots at most take a milliseconds.
WRONG:A=I/O operations to the database are suspended for a few minutes while the backup is in progress.
@Chef
I agree with you that, IO suspension happens for only few seconds, however we can’t say IO operations function normally during snapshot creation
More over one of the given answer is suspended for hours, so I still think we should go with answer A
any thoughts are welcome
A
During the backup window, storage I/O may be briefly suspended while the backup process initializes (typically under a few seconds) and you may experience a brief period of elevated latency. There is no I/O suspension for Multi-AZ DB deployments, since the backup is taken from the standby.
It could be A or C:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSInstances.html
Note
During the backup window, storage I/O *MAY* be briefly suspended while the backup process initializes (typically under a few seconds) and you may experience a brief period of elevated latency. There is no I/O suspension for Multi-AZ DB deployments, since the backup is taken from the standby.
In an exam situation, I would go with A due to the possibility of a suspension, but there is a case to make for C too.
A
A
Creating this DB snapshot on a Single-AZ DB instance results in a brief I/O suspension that typically lasting no more than a few minutes. Multi-AZ DB instances are not affected by this I/O suspension since the backup is taken on the standby.
C is the right answer.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSInstances.html
During the automatic backup window, storage I/O might be briefly suspended while the backup process initializes (typically under a few seconds) and you might experience a brief period of elevated latency. No I/O suspension occurs for Multi-AZ DB deployments, because the backup is taken from the standby.
What about single AZ deployments?
There is no mention of read replicas in the question
A
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html
Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases. Creating this DB snapshot on a Single-AZ DB instance results in a brief I/O suspension that typically lasting no more than a few minutes. Multi-AZ DB instances are not affected by this I/O suspension since the backup is taken on the standby.
A.
I/O operations to the database are suspended for a few minutes while the backup is in progress.
I agree with the answer. A
A,
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html
Creating a DB Snapshot
Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases. Creating this DB snapshot on a Single-AZ DB instance results in a brief I/O suspension that can last from a few seconds to a few minutes, depending on the size and class of your DB instance. Multi-AZ DB instances are not affected by this I/O suspension since the backup is taken on the standby.
If it is for single AZ then A is the answer and if multi AZ then D.
As- Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases. Creating this DB snapshot on a Single-AZ DB instance results in a brief I/O suspension that can last from a few seconds to a few minutes, depending on the size and class of your DB instance. Multi-AZ DB instances are not affected by this I/O suspension since the backup is taken on the standby.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html
For Multi AZ it is C not D.