View the Exhibit. Note the values in the CHKPOINT row.
This program is taking much longer to run than it needs to.
The ability to restart without compromising data integrity is crucial. The program has the Disable Restart check box deselected.
What is one area of opportunity to cut processing time?
A. Reduce the frequency of commits.
B. Reduce the number of checkpoints by using Bulk Insert.
C. Replace section-level or step-level auto commits with explicit commits within SQL steps.
D. Use a derived/work record for the state record so that checkpoints are stored in memory instead of in a SQL table.
E. PeopleCode records checkpoints much more quickly than SQL actions, so execute SQL using PeopleCode actions wherever possible.
|
Download Printable PDF. VALID exam to help you PASS. |
 |