Projector components in a mapping hides attributes from preceding components. All succeeding components can only use the attributes from projector component.
Which three components below are NOT a projector component in Oracle Data Integrator (ODI)? (Choose three.)
In Oracle Data Integrator (ODI), projector components, like Aggregate and Distinct, limit the attributes available to succeeding components. Non-projector components, such as Sort, Filter, and Join, do not impose this limitation; they manipulate data streams without hiding attributes, allowing subsequent components in the mapping to access all available attributes.
Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose all correct answers)
In ODI, extracting data from Fusion SaaS applications to ADW can leverage components like the Enterprise Scheduler Service (ESS) SOAP API for job scheduling, REST API for web service interactions, and Cloud Connector for cloud-specific integrations. These components enable efficient data extraction and loading workflows from Fusion SaaS to ADW.
Which autonomous database types are available on Oracle Cloud? (Choose three.)
Oracle Cloud offers various types of Autonomous Databases, including Autonomous Data Warehouse (ADW) for analytics, Autonomous Transaction Processing (ATP) for transactional workloads, and Autonomous JSON Database for document-centric data models. These services provide self-managing, self-securing, and self-repairing database capabilities tailored to specific data management needs.
Which type of Zero Downtime Migration (ZDM) can you use for Inflight Upgrade?
For Inflight Upgrade scenarios, Zero Downtime Migration (ZDM) supports Logical Migration only. Logical migration involves capturing and transforming the database schema and data into a logical format before transferring it to the target system, which is suitable for upgrades that involve significant changes to the database structure or version.
You took a backup to DISK on the on-premises database and copied it to an Object Storage bucket to be used to instantiate a new Database Cloud Service.
Which RMAN operation is required before the backup can be restored?
Before restoring a TDE-encrypted backup from an on-premises database to a Cloud Database Service, the RMAN operation required is to decrypt the backup if the encryption keys or wallet are not available in the target environment. This ensures the backup can be restored without encryption constraints in the new environment.