How can you configure the data pump Extract to run on-premises sending data into cloud?

Correct Answer for the following Question is given below The customer needs to run Oracle GoldenGate to replicate data in real time from on-premises tables into the Database in Cloud. The Data Integration PlatformCloud (DIPC) server that runs Oracle GoldenGate Replicate in cloud has all ports locked down for incoming traffic except the ssh port … Read more

What style(s) of integration is/are supported by Oracle Data Integrator?

Correct Answer for the following Question is given below What style(s) of integration is/are supported by Oracle Data Integrator?Reference: https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG118 Question: What style(s) of integration is/are supported by Oracle Data Integrator? Options: both ETL and E-LT both ETL and Real-Time Data Warehouse E-LT both E-LT and Real-Time Data Warehouse Correct Answer The Correct Answer for … Read more

Which two Oracle GoldenGate commands are used to create both an Extract and the source local trail for the Extract?

Correct Answer for the following Question is given below Which two Oracle GoldenGate commands are used to create both an Extract and the source local trail for the Extract? (Choose two.)Reference: https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/GGS_Sect_Config_WinUX_ORA_to_WinUX_ORA_datapump/GGS_Sect_Config_WinUX_ORA_to_WinUX_ORA_datapump.pdf Question: Which two Oracle GoldenGate commands are used to create both an Extract and the source local trail for the Extract? Options: ADD … Read more

Which command-line interface should you use when configuring Oracle GoldenGate manually?

Correct Answer for the following Question is given below Which command-line interface should you use when configuring Oracle GoldenGate manually?Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/configure-goldengate.html#GUID-BCCCC99C-78D7-4E31-A660-664B634C2EB4 Question: Which command-line interface should you use when configuring Oracle GoldenGate manually? Options: RMAN SQLPLUS GG_CONFIG GGSCI Correct Answer The Correct Answer for this Question is GGSCI Explanation The Question – Which command-line interface … Read more

Which dbaascli command below should you use to check if Oracle GoldenGate is enabled on a DBaaS Database instance?

Correct Answer for the following Question is given below Which dbaascli command below should you use to check if Oracle GoldenGate is enabled on a DBaaS Database instance?Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/configure-goldengate.html#GUID-9C833533-A2B6-4B37-9662-BC00D661E8B6 Question: Which dbaascli command below should you use to check if Oracle GoldenGate is enabled on a DBaaS Database instance? Options: dbaascli show gg dbaascli gg … Read more

Which product do you need to install manually after you have provisioned a Data Integration Platform Cloud (DIPC) instance?

Correct Answer for the following Question is given below Which product do you need to install manually after you have provisioned a Data Integration Platform Cloud (DIPC) instance?Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/get-started-data-integration-platform-cloud.html#GUID-B82DE087-9EC5-4484-8769-23929CF756C8 Question: Which product do you need to install manually after you have provisioned a Data Integration Platform Cloud (DIPC) instance? Options: None, they’re all included when … Read more

Where do you create Synchronize Data connections within Data Integration Platform Cloud (DIPC)?

Correct Answer for the following Question is given below Where do you create Synchronize Data connections within Data Integration Platform Cloud (DIPC)?Reference: https://blogs.perficient.com/2018/10/02/integrate-your-data-using-oracle-data-integration-platform-cloud/ Question: Where do you create Synchronize Data connections within Data Integration Platform Cloud (DIPC)? Options: Create GoldenGate credentials via the GGSCI utility. Access physical topology via the Management screen within the ODI … Read more

When granting the appropriate privileges for a GoldenGate user using dbms_goldengate_auth.grant_admin_privilege(), if CAPTURE and APPLY are running in a multitenant database, the container parameter must be set to what value?

Correct Answer for the following Question is given below When granting the appropriate privileges for a GoldenGate user using dbms_goldengate_auth.grant_admin_privilege(), if CAPTURE and APPLY are running in a multitenant database, the container parameter must be set to what value?Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/using-data-integration-platform-cloud.pdf (464) Question: When granting the appropriate privileges for a GoldenGate user using dbms_goldengate_auth.grant_admin_privilege(), if CAPTURE … Read more

Which is NOT a valid privilege to grant a CDB user?

Correct Answer for the following Question is given below Which is NOT a valid privilege to grant a CDB user?Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/data-source-connection-details.html#GUID-528CF27A-6321-4570-AB4C-98A77777A340 Question: Which is NOT a valid privilege to grant a CDB user? Options: exec dbms_goldengate_auth.grant_admin_privileges(‘cdbuser’,’capture’,container=>’all’); grant create session to cdbuser; grant create container to cdbuser; grant alter session to cdbuser; Correct Answer The Correct … Read more