Question 1: The correct answer is 3. Ingest is the best choice to process and load the data in real-time.
Load: Low: allows read-only operations
Import: High: sometimes escalates to table level lock
Ingest: Very high: row-level locking
db2move: This utility is beneficial whenever you want to move data from one database to another. But, it can't be used for real-time processing.
Question 2: The correct answer is 1. Ingest is a client-side utility.
|
Attribute |
Ingest |
|
Speed |
Fast: uses parallel insert threads |
|
Concurrency |
Very high: row-level locking |
|
Transaction logging |
Every record change is logged |
|
Behavior on failure |
Rollback, and table is accessible |
|
LOBs and XML data |
Unsupported data type |
|
Utility type |
Client-side |
|
Triggers activation |
Yes |
|
Constraint validation |
Yes |
|
Is table space backup necessary? |
No |
|
Utility... |