Oracle 1Z0-935 Online Practice Questions and Exam Preparation

Oracle 1Z0-935 Online Questions & Answers

• Question 31:

  Which action creates a job in Data Integration Platform Cloud (DIPC)?

  A. creating a policy
  B. running a task
  C. executing a search
  D. creating a new connection
  B. running a task

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/what-is-dipc.html#GUID-BC752DF9-0421-4AFB-8F37-04EB44AF200C

• Question 32:

  Which command grants the required Oracle GoldenGate privileges to a Data Integration Platform Cloud (DIPC) connection user (USER_NAME) for a Synchronize Data task?

  A. exec DBMS_CAPTURE_ADM.START_CAPTURE('USER_NAME');
  B. exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('USER_NAME');
  C. grant SYSDBA to USER_NAME;
  D. grant golden_gate_admin to USER_NAME;
  B. exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('USER_NAME');

  ---

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

  When excluding pluggable database, schemas, and objects from your configuration, which of these parameters does NOT apply?

  A. EXCLUDEWILDCARDOBJECTSONLY
  B. EXCLUDETAG
  C. TABLEEXCLUDE
  D. SCHEMAEXCLUDE
  B. EXCLUDETAG

  ---

  Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GGODB/configuring-oracle-goldengate-multitenant-container-database-1.htm#GGODB-GUID-4E44370D-0D96-41F6-A23F-4CE789AFF20D

• Question 34:

  When using the Oracle GoldenGate command-line interface to configure Oracle GoldenGate manually, which command is used to manually create a data pump Extract?

  A. register extract pump, database
  B. add extract etpcadb, tranlog, begin now
  C. add extract pump, integrated tranlog, begin now
  D. add extract ptpcadb, exttrailsource dirdat/ea
  D. add extract ptpcadb, exttrailsource dirdat/ea

  ---

  Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GWURF/ggsci-12.3-command-interface-help.htm

• Question 35:

  Which two are use cases for Enterprise Data Quality (EDQ) within Data Integration Platform Cloud (DIPC)? (Choose two.)

  A. measure data against defined data quality business rules
  B. load a data warehouse
  C. find sensitive data in data sources
  D. discover characteristics of source data in preparation for a data migration
  A. measure data against defined data quality business rules
  B. load a data warehouse

• Question 36:

  Which Oracle Data Integrator (ODI) object can be created underneath a Data Server?

  A. Logical Agents
  B. Logical Schemas
  C. Physical Agents
  D. Physical Schemas
  D. Physical Schemas

  ---

  Reference: https://docs.oracle.com/middleware/1212/odi/ODIDG/setup_topology.htm#ODIDG187

• Question 37:

  Which action is mandatory while creating a Data Server?

  A. defining the Array Fetch Size
  B. adding Connection Properties
  C. setting up On Connect/Disconnect commands
  D. defining Datasources
  A. defining the Array Fetch Size

  ---

  Creating a Data Server (Advanced Settings) The following actions are optional: Adding Connection Properties Defining Data Sources Setting Up On Connect/Disconnect Commands

  Reference: https://docs.oracle.com/middleware/1212/odi/ODIDG/setup_topology.htm#ODIDG201

• Question 38:

  What is the purpose of a Data Interface in Enterprise Data Quality (EDQ)?

  A. to enable EDQ to send and receive data in real time
  B. to enable processes to be defined independently of any physical source or target
  C. to enable publication of data into EDQ Case Management
  D. to enable integration with Oracle Data as a Service
  B. to enable processes to be defined independently of any physical source or target

  ---

  Reference: https://www.oracle.com/webfolder/technetwork/data-quality/edqhelp/Content/concepts/datainterfaces.htm

• Question 39:

  On which technology is Oracle GoldenGate based?

  A. Log Shipping technology
  B. Light weight transaction or redo parser technology
  C. Database mirror technology
  D. Triggers and Views subscription technology
  C. Database mirror technology

• Question 40:

  In which scenario can you NOT use Oracle GoldenGate?

  A. data synchronization from Oracle to MySQL databases
  B. batch data transfer from table data
  C. real-time change data capture from transaction logs
  D. capture change data from HDFS
  B. batch data transfer from table data