PrepAway - Latest Free Exam Questions & Answers

How should you transfer the data from the Oracle database?

You plan to read data from an Oracle database table and to store the data in the file system for later processing
by dplyrXdf. The size of the data is larger than the memory on the server to be used for modelling.
You need to ensure that the data can be processed by dplyrXdf in the least amount of time possible.
How should you transfer the data from the Oracle database?

PrepAway - Latest Free Exam Questions & Answers

A.
Define a data source to the Oracle database server by using RxOdbcData. Use rxImport to save the data to
a comma-separated values(CSV) file.

B.
Use the RODBC library, connect to the Oracle database server by using odbcConnect, and then use
rxDataStep to export the data to a comma-separated values (CSV) file.

C.
Define a data source to the Oracle database server by using RxOdbcData,and then use rxImport to save
the data to an XDF file.

D.
Use the RODBC library, connect to the Oracle database server by using odbcConnect, and then use rxSplit
to save the data to multiple comma-separated values (CSV) file.

Explanation:
Explanation/Reference:


Leave a Reply