Oracle AI Database@Azure Architect Professional 1z0-1147 Question # 24 Topic 3 Discussion
1z0-1147 Exam Topic 3 Question 24 Discussion:
Question #: 24
Topic #: 3
When using Zero Downtime Migration (ZDM) to migrate a schema to an Autonomous Database target on Oracle Database@Azure, what is the default target tablespace mapping behavior?
A.
Schemas are mapped to a target tablespace with the exact same name as the source tablespace.
B.
Schemas are mapped to the SYSTEM tablespace if the source tablespace does not exist.
C.
All tablespaces are mapped to the USER_DATA tablespace by default.
D.
All tablespaces are automatically mapped to the DATA tablespace.
For migrations to Autonomous Database Shared/Serverless , ZDM applies automatic tablespace remapping because users cannot freely reproduce arbitrary source tablespaces in the same manner as on a customer-managed Oracle Database.
Oracle's ZDM documentation states that for an Autonomous Database Shared Infrastructure target, source tablespaces are automatically remapped to the predefined DATA tablespace by default. In FULL-mode migration to Autonomous Database Serverless, Oracle likewise specifies DATA as the default remap target because general user-created tablespace creation is not supported in that migration model.
This prevents source schema objects from being imported into unavailable tablespaces. SYSTEM and SYSAUX are Oracle-maintained dictionary tablespaces and must not be used as ordinary user-data destinations. USER_DATA is not the standard default target identified by ZDM. Preserving every source tablespace name is also incompatible with the default Autonomous Serverless storage model.
ZDM can support explicit metadata remapping where appropriate, but absent such an override, the default is DATA.
Therefore, D is correct.
Study Guide reference: Migrate Oracle Databases to Oracle AI Database@Azure — ZDM logical migration, Data Pump and automatic tablespace remapping.
===============
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit