Oracle Database 12c: Multitenancy Essentials — Question 8

Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

Answer options

• A. on an ACFS file system stored in a staging database on the Database Machine
• B. a ZFS over NFS file system mounted on a database server where the external table will be accessed
• C. an Exadata-based ACFS file system on the Database Machine
• D. a DBFS file system stored in a staging database on the Database Machine
• E. on local storage on one or more storage servers that are accessible to the database server where the load will be performed

Correct answer: A, B, E

Explanation

Options A, B, and E are recommended because they provide efficient access and performance for loading external tables. Option C is not ideal since an Exadata-based ACFS file system is not specifically designed for staging files in this context, and Option D uses DBFS, which is generally less performant for external table loading compared to the other options.