In which two locations should files be staged, to be loaded using external tables into a database
on a Database Machine?
A.
On a dbfs file system stored in a staging database on the Database Machine
B.
On an Exadata-based ACFS file system on the Database Machine
C.
On an nfs file system mounted on a database server where the external table will be accessed.
D.
On local storage on one or more cells that are accessible to the database server where the load
will be performed.
Explanation:
Prepare a Temporary File System
The Oracle E-Business Suite Rapid Install creates a file system based Oracle Database release
11.1.0.7 database, and it cannot install directly to a database that uses Oracle ASM. Therefore it
requires non-Exadata storage of about 55 GB and an additional 50 GB of storage for the install
staging area for a total of 105 GB. The file system to be used for the database node file system
and the stage area can either use the database machine local storage or an NFS mounted file
system.Reference:Installing Oracle E-Business Suite Release 12 with the Oracle Exadata Database
Machine
According to “Oracle Exadata Recipes: A Problem-Solution Approach”,
one of the reasons why DBFS can be excellent fit in Exadata environment
include the following.
—-
A data load strategy involving external tables on DBFS file systems, with parallel operations,
typically yields the fastest way to bulk load data into your database.
—-
Therefore, A looks Correct Answer.
It is thought that it is difficult to use storage cell as a file system for database server.
Correct answer is A & C.
I think A is the only correct answer. but asked for two select then C is best fit compare to others. so Answer is A,C
a c
it cant be d [there is no local storage in the cell]
What’s the issue with B?
ACFS is not supported in Exadata
AC
A is right. DBFS is the desired or only file system available within exadata prior 12.1.0.2
B is wrong. ACFS is supported after 12.1.0.2. so for this question, it is not right answer
c is right. NFS from external can be used as file system
D is wrong. cell node local disk is for binary and log files. it is not big and not meant for data loading.
So A.C. are correct
AC .. if Mat and L. Zhu agree …