IBM
C2090-312 · Question #93
The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the…
The correct answer is C. Provide an effective commit / restart process. See the full explanation below for the reasoning.
Question
The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?
Options
- AIssue a LOCK TABLE for all 4 tables.
- BExecute the SQL INSERT before the SQL UPDATE.
- CProvide an effective commit / restart process.
- DRun a QUIESCE utility before the process starts.
How the community answered
(36 responses)- A3% (1)
- B11% (4)
- C81% (29)
- D6% (2)
Community Discussion
No community discussion yet for this question.