Oracle 1z0-935 Dump 2021

NEW QUESTION 1
You want to copy, profile, and cleanse your data. Which Data Integration platform edition should you use?

• A. Enterprise


• B. Data Quality edition


• C. Governance


• D. Standard

Answer: B

NEW QUESTION 2
Which statement is correct about the dependency between the Master and Work repositories?

• A. You can have a maximum o1 two Work repositories linked to


• B. Master repository.


• C. A Work repository must be attached to a Master repository.


• D. Oracle Data Integrator (ODI) agents have a dependency with Work repositories.


• E. The Master and Work repositories are not linked to each other.

Answer: B

NEW QUESTION 3
Where do you create Synchronize Data connections within Data Integration platform Cloud (DIPC)?

• A. Create GoldenGate credentials via the GGSC1 utility.


• B. Access physicaltopology via the Management screen within the ODI Console.


• C. Access the Catalog screen within OIPC Console.


• D. VNC into theD1PC host and create a connection in ODI Studi

Answer: C

NEW QUESTION 4
Which key must be used to access the command line of a Data Integration Platform Cloud (D1PC) instance?

• A. Wallet key


• B. Remote Shell (RSH) key


• C. Internal key


• D. Secure Shell (SSH) key

Answer: C

NEW QUESTION 5
When using BusinessRules Check in EnterpriseData Quality (EDQ),how should you apply a specific rule to a subset of the data beingprocessed?

• A. Use multiple instances of Business Rules Check with different rules enabled.


• B. Filter the data before processing It with Business Rules Check.


• C. Add a condition in the Business Rules data and reference it in the rule definition.


• D. Apply logic to the Check such that the records you do not want to apply therule to are always given a No Data resul

Answer: B

NEW QUESTION 6
The customer needs to run Oracle GoldenGate to replicate data in real time (rom on-premises tables into the Database in cloud. The Data integration platform Cloud (DIPC) serverthat runs Oracle GoldenGate Relocation in cloud has all ports locked down for incoming traffic except the
How can you configure the data pump Extract to run on-premises sending data into cloud?

• A. Run scp 10 copy the Hail dies from on-premises server to OPC cloud using the ope user


• B. Configure a data pumpExtract to send trail files directly lo data collector (Server)runningin DIPC server


• C. Configure another data pump Extract in a DMZ server and connect directlyto Manager runningin DIPC server


• D. Run Socks5 Proxy on-premises to connect lo DIPC servervia ssh protocol in cloud and use that tunnel for the data pomp Extract

Answer: D

NEW QUESTION 7
Howdo you access Oracle Data Integrator (OD1) Studio within Data Integration Platform Cloud (D1PC)?

• A. The DIPC console provides direct access to ODI Studio.


• B. Run ODI Studio from your laptop.


• C. VNC into your 01PC Instance VM and execute odi.sh,


• D. Download the DIPC Remote agent toaccess to ODI Studi

Answer: C

NEW QUESTION 8
When is a Data pump Extract NOT required to connect to the source database?

• A. when the look-ups are needed against the source database


• B. when transformations, filtering, and mapping are required


• C. when a PASSTHRUparameter Is used


• D. when a NOPASSTHRUparameter is used

Answer: B

NEW QUESTION 9
When using the Oraclecommend-line interface to configure Oracle 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, beginnow


• D. add extract ptpcadb, exttrailsource ./dirdat/ea

Answer: D

NEW QUESTION 10
Which technology does Data Integration Platform Cloud (OIPC) use to communicate with your remote agent?

• A. Oracle Identity Cloud


• B. SOCKS Proxy Tunnel


• C. HTTP Proxy


• D. Secure Shell (SSH)

Answer: A

NEW QUESTION 11
Which dbaascli command below should vou use to check If Oracle GoldenGate is enabled on a DBaaS Database instance?

• A. dbaascli show gg


• B. dbaascli qq status


• C. dbaascli info all


• D. dbaasCli info gg

Answer: B

NEW QUESTION 12
In which scenario can you NOT use Oracle GoldonGate?

• A. data synchronization from Oracleto MySQL databases


• B. batch data transfer from table data


• C. real-time change data capture from transaction logs


• D. capture change data from HDFS

Answer: B

NEW QUESTION 13
Which SSH Key is required when provisioning a DIPC Instance?

• A. Identity Key


• B. Authentication Key


• C. Private Key


• D. Public Key

Answer: D

NEW QUESTION 14
What backup destination must beselected when provisioning an Oracle Database Cloud instance to host Data Integration Platform Cloud (DIPC) metadata?

• A. both Cloud Storage and local Storage


• B. none


• C. Cloud Storage Only


• D. Local Storage Only

Answer: A

NEW QUESTION 15
Which two statements are correct about using Enterprise Data Quality (EDQ) Oracle Integrator together?

• A. ODI can call EDQ Jobs either synchronously or asynchronously.


• B. EDQ can conned to any data source defined in ODI without additional configuration.


• C. ODI and EDQ share a repository database where configuration and working data Is stored.


• D. ODI and EDQ can be used together to synchronize data between systems.


• E. In combination, ODI and EDQ can add data quality metrics to data flowing into Big Data system

Answer: AD

NEW QUESTION 16
Which two are benefits of the ELI approach?

• A. high performance with optimized transformations


• B. better parallelism with extra Ell server


• C. taking advantage of existing hardware and software infrastructure


• D. shortens development and maintenance time

Answer: AC

NEW QUESTION 17
Which TRANLOCATIONS parameter option is requiredfor supporting bidirectional replication when using MySQL as a source database?

• A. EXCLUDETAG


• B. FILTERTABLE


• C. EXCLUDETRANS


• D. EXCLUDEUSER

Answer: A

NEW QUESTION 18
How do you register your data sources and targets with Data Integration Platform Cloud (DIPC)?

• A. Create Agents


• B. Create Connections


• C. Create Data Entities


• D. Create Tasks

Answer: C

NEW QUESTION 19
When do you grant the privilege, select on v_Sdatabase, to the databaseuser?

• A. For source schema only


• B. For target schema only


• C. For both source and target schemas


• D. For neither source nor target schemas

Answer: C

NEW QUESTION 20
What is the purpose of Oracle GoldenGate Initial Loads?

• A. to carry out performance load testing


• B. to stream change data to target


• C. to synchronize source and target data


• D. to create target database objects

Answer: C

NEW QUESTION 21
From where can youdownload the Data Integration platform Cloud (DIPC) remote agent?

• A. Oracle Cloud Marketplace


• B. Data Integration Platform Cloud Console


• C. Oracle.com


• D. Oracle edelivery

Answer: B

NEW QUESTION 22
Where is the Oracle Data Integrator(ODI) Console deployed out-of-the-box in Data Intonation Platform Cloud (01PC)?

• A. In the Data Integration Platform Cloud Agent running on-promises


• B. outside of the Data Integration Platform Cloud VM in java Cloud service


• C. In the Data Integration PlatformCloud VM inside WebLogicServer


• D. In the Data Integration Platform Cloud VM outside of WebLogic Server

Answer: B

NEW QUESTION 23
Identify the true statement when Oracle GotdenGate is configured for batch processing.

• A. Replicate is started with theINIATIALLOADtask.


• B. There isa SPECIALRUNReplicate task.


• C. TheSPECIALRUNparameter is in the capture parameter file.


• D. TheSPECIALRUN parameter is in the GLOBALSparameter fil

Answer: D

NEW QUESTION 24
......