You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current…

The correct answer is D. Create an external table and leave the data in the flat file. An external table is the most effective solution because it lets Oracle query data directly from a flat file on the operating system using standard SQL, without loading or moving any data into the database. The flat file stays where it is, so there is no storage duplication and…

Moving Data

Question

You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database?

Options

AUse the database link.
BUse the SQL*Loader utility.
CUse the Oracle Data Pump utility.
DCreate an external table and leave the data in the flat file.

How the community answered

(48 responses)

A
13% (6)
B
8% (4)
C
4% (2)
D
75% (36)

Explanation

An external table is the most effective solution because it lets Oracle query data directly from a flat file on the operating system using standard SQL, without loading or moving any data into the database. The flat file stays where it is, so there is no storage duplication and no ETL overhead. This is ideal when the file is too large to load. The other options are unsuitable: (A) a database link connects one Oracle database to another - it cannot reference a flat file. (B) SQL*Loader would physically load the data into a database table, which is explicitly ruled out by the file being too large. (C) Oracle Data Pump is an export/import utility for Oracle-format dump files, not for querying external flat files.

Topics

#external tables#flat files#data access methods#SQL*Loader

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice