Explanation:To support net changes queries, the source table must have a primary key or unique index to uniquely identify rows. 9. Upper bound on expected throughput of the capture job is calculated using the following computation:
A. (maxtrans * maxscans) / number of seconds between scans
B. (maxtrans * maxscans) * number of seconds between scans
C. (maxtrans * maxscans) – number of seconds between scans
D. None of the mentioned
Answer:A
Explanation:To support net changes queries, the source table must have a primary key or unique index to uniquely identify rows. 9. Upper bound on expected throughput of the capture job is calculated using the following computation:
A. (maxtrans * maxscans) / number of seconds between scans B. (maxtrans * maxscans) * number of seconds between scans C. (maxtrans * maxscans) – number of seconds between scans D. None of the mentioned
Explanation:When running in one shot mode, you can compute an upper bound on expected throughput of the capture job 10. The cleanup job is initiated by running the parameterless stored procedure :