IBM
P2090-050 · Question #131
P2090-050 Question #131: Real Exam Question with Answer & Explanation
Sign in or unlock P2090-050 to reveal the answer and full explanation for question #131. 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 P2090-050 to see the answer
You've previewed enough free P2090-050 questions. Unlock P2090-050 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.