Oracle 1Z0-935 Online Practice Questions and Exam Preparation

Oracle 1Z0-935 Online Questions & Answers

• Question 51:

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

  A. None, they're all included when you provision the instance
  B. Oracle GoldenGate
  C. Oracle Enterprise Data Quality
  D. Oracle Data Integrator
  B. Oracle GoldenGate

  ---

  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 52:

  Which TRANLOGOPTIONS parameter option is required for supporting bidirectional replication when using MySQL as a source database?

  A. EXCLUDETAG
  B. FILTERTABLE
  C. EXCLUDETRANS
  D. EXCLUDEUSER
  B. FILTERTABLE

• Question 53:

  Which two tasks should you perform to configure a pluggable database (PDB) as a source for a Synchronize Data task? (Choose two.)

  A. Create a container database connection before creating the PDB connection.
  B. Connect to a cloud database only.
  C. Configure the PDB connection to use the system user.
  D. Associate the pluggable (PDB) connection to a container database connection.
  A. Create a container database connection before creating the PDB connection.
  D. Associate the pluggable (PDB) connection to a container database connection.

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/data-source-connection-details.html#GUID-20EFB1FC-4F90-4364-96DB-A4E41D2DC1B5

• Question 54:

  Which two characteristics of match processors are NOT true of simpler processors in Enterprise Data Quality (EDQ)? (Choose two.)

  A. generating their own subprocesses
  B. operating on multiple processing threads
  C. storing cluster values in the Results repository
  D. using a single phase of processing
  C. storing cluster values in the Results repository
  D. using a single phase of processing

• Question 55:

  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?

  A. CURRENT
  B. DEFAULT
  C. ALL
  D. NULL
  C. ALL

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/using-data-integration-platform-cloud.pdf (464)

• Question 56:

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

  A. exec dbms_goldengate_auth.grant_admin_privileges('cdbuser','capture',container=>'all');
  B. grant create session to cdbuser;
  C. grant create container to cdbuser;
  D. grant alter session to cdbuser;
  C. grant create container to cdbuser;

  ---

  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 57:

  Which Object Storage Classic type is required to provision a Data Integration Platform Cloud (DIPC) instance?

  A. Directory
  B. Container
  C. Bucket
  D. Folder
  B. Container

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integrator-cloud/user/creating-object-storage-classic-container.html

• Question 58:

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

  A. Create GoldenGate credentials via the GGSCI utility.
  B. Access physical topology via the Management screen within the ODI Console.
  C. Access the Catalog screen within DIPC Console.
  D. VNC into the DIPC host and create a connection in ODI Studio.
  C. Access the Catalog screen within DIPC Console.

  ---

  Reference: https://blogs.perficient.com/2018/10/02/integrate-your-data-using-oracle-data-integration-platform-cloud/

• Question 59:

  Which two sets of roles are associated with Data Integration Platform Cloud (DIPC)? (Choose two.)

  A. Database Level
  B. Service Level
  C. Instance Level
  D. Application level
  B. Service Level
  D. Application level

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/obe-manage-security-dipc/

• Question 60:

  Which statement is true about Packages, Scenarios, and Load Plans?

  A. Scenarios are the largest executable objects in Oracle Data Integrator.
  B. Packages do not provide native support for parallelism, restartability, and exception handling.
  C. Load Plans cannot be created in Production environments.
  D. Load plans are substitutes for Packages and Scenarios.
  B. Packages do not provide native support for parallelism, restartability, and exception handling.

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/differences-packages-scenarios-and-load-plans.html