OCP CBT Question 564

Please solve the following question.

You are managing a large data warehouse database (`DWPROD`) and need to migrate a specific schema `SALES_ARCHIVE` into a new Pluggable Database `PDB_ARCHIVE` within the same CDB, while minimizing downtime for `DWPROD`. The `SALES_ARCHIVE` schema contains only tables residing in a dedicated tablespace `TS_SALES_ARCHIVE`. Which is the most efficient method to perform this migration?

Use expdp to export the SALES_ARCHIVE schema and then impdp to import it into PDB_ARCHIVE.

Use CREATE PLUGGABLE DATABASE PDB_ARCHIVE FROM PDB$SEED and then use CREATE TABLE AS SELECT statements to move data from DWPROD into PDB_ARCHIVE.

Use Transportable Tablespaces (TTS) to move TS_SALES_ARCHIVE from the root CDB to PDB_ARCHIVE.

Create a database link from PDB_ARCHIVE to DWPROD and use CREATE TABLE ... AS SELECT ...@DWPROD to move the data.