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