What should be considered when determining the recovery point objective (RPO) in a log shipping
remote replication?
A.
Frequency of log switching
B.
Size of the source database
C.
Size of the standby database
D.
Frequency of reading the database
Correct: A
“All DBMSs switch log files at preconfigured time intervals or when a log file is full. The current log file is closed at the time of log switching, and a new log file is opened. When a log switch occurs, the closed log file is transmitted by the source host to the remote host. The remote host receives the log and updates the standby database.
This process ensures that the standby database is consistent up to the last committed log. ***RPO at the remote site is finite and depends on the size of the log and the frequency of log switching*** Available network bandwidth, latency, rate of updates to the source database, and the frequency of log switching should be considered when determining the optimal size of the log file”
0
0