1z0-935: Oracle Cloud Platform Data Integration 2018 Associate

Which two are correct purposes of the Enterprise Data Quality (EDQ) repository database? (Choose two.)

to store report documents generated from data quality jobs
to store results of data quality processing for user browsing
to store persistent single views of data entities for customers
to store data representing the configuration of data quality projects.

Correct answer: BD

When configuring a Data Integration Platform Cloud (DIPC) remote agent, what does the -dipchost property define?

the servername / IP address of the remote agent host
the Identity Cloud service domain that the DIPC instance belongs to
the database server host / ip that the agent will connect to
the DIPC cloud host / ip address that the agent will connect to

Correct answer: D

Explanation:

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

When troubleshooting the failure of a job in Enterprise Data Quality (EDQ), you discover a process with a processor highlighted as in error.

How should you resolve the issue?

Click the errored processor to see what the error is.
Disconnect the errored processor.
Add a Writer to the process to stage the data immediately after the errored processor.
Check the process execution preferences to determine how the process was run.

Correct answer: D

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?

CURRENT
DEFAULT
ALL
NULL

Correct answer: C

Explanation:

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

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

EXCLUDEWILDCARDOBJECTSONLY
EXCLUDETAG
TABLEEXCLUDE
SCHEMAEXCLUDE

Correct answer: B

Explanation:

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

Which are three valid sources for Oracle GoldenGate Capture Process? (Choose three.)

Oracle Database Cloud Service
Oracle database
MySQL
MongoDB
Big Data

Correct answer: BCE

Explanation:

Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/configure-goldengate.html#GUID-41BB9B43-D03F-4DEF-A68B-42AB1378A6F2

You need to profile a data set in Enterprise Data Quality (EDQ) to understand how complete and unique each of its attributes are.

Which processor should you use?

the Record Completeness Profiler
the Quickstats Profiler
the Frequency Profiler
the Equal Attributes Profiler

Correct answer: D

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

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

Correct answer: C

Explanation:

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

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 Platform Cloud (DIPC) server that runs Oracle GoldenGate Replicate in cloud has all ports locked down for incoming traffic except the ssh port 22.

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

Run scp to copy the trail files from on-premises server to DIPC cloud using the opc user.
Configure a data pump Extract to send trail files directly to data collector (Server) running in DIPC server.
Configure another data pump Extract in a DMZ server and connect directly to Manager running in DIPC server.
Run Socks5 Proxy on-premises to connect to DIPC server via ssh protocol in cloud and use that tunnel for the data pump Extract.

Correct answer: B

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

dbaascli show gg
dbaascli gg status
dbaascli info all
dbaascli info gg

Correct answer: B

Explanation:

Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/configure-goldengate.html#GUID-9C833533-A2B6-4B37-9662-BC00D661E8B6