IBM
A2090-560 · Question #63
A2090-560 Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-560 to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Question
An ETL/ODBC application is inserting 1 million records in a single transaction against the PureData System for Analytics. 1 million individual INSERT SQL statements are generated. What can make this faster?
Options
- AUse a COPY command.
- BUse an EXTERNAL TABLE.
- CIncrease the Socket Buffer Size.
- DSet the COMMIT interval to 10,000.
Unlock A2090-560 to see the answer
You've previewed enough free A2090-560 questions. Unlock A2090-560 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.