1Z0-515 Question #13: Real Exam Question with Answer & Explanation

The correct answer is A. Direct path loading. Instead of filling a bind array buffer and passing it to the Oracle database with a SQL INSERT statement, a direct path load uses the direct path API to pass the data to be loaded to the load engine in the server. The load engine builds a column array structure from the data pass

Question

Which can be used in scenario where there are large data loads of a sensitive nature into a data warehouse?

Options

ADirect path loading
BExternal tables for loading flat files
CPartition exchange loading
DAny of these are valid for certain situations.

Explanation

Instead of filling a bind array buffer and passing it to the Oracle database with a SQL INSERT statement, a direct path load uses the direct path API to pass the data to be loaded to the load engine in the server. The load engine builds a column array structure from the data passed to it. The direct path load engine uses the column array structure to format Oracle data blocks and build index keys. The newly formatted database blocks are written directly to the database (multiple blocks per I/O request using asynchronous writes if the host platform supports asynchronous I/O). Internally, multiple buffers are used for the formatted blocks. While one buffer is being filled, one or more buffers are being written if asynchronous I/O is available on the host platform. Overlapping computation with I/O increases load performance.

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice