Oracle 1z0-935 Free Practice Questions

NEW QUESTION 1
Which command grant 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_AAD
• B. START_CAPTURE (' USER_NAME ');
• C. exec DBMS_GOLDENGATE_AUTH-GRANT_ADMIN_PRIVILEGE ( ''USER_NAME'') ;
• D. grant SYSDBA TO USER _NAME;
• E. grant golden_gate_admin to user_NAME

Answer: B

NEW QUESTION 2
Which Oracle database can be used as a repository lot the Data Integration Platform Cloud (DIPC)?

• A. Oracle Autonomous Data Warehouse Cloud
• B. Oracle Database Exadata Cloud at Customer
• C. Oracle Database Exadata Cloud
• D. Oracle Database Cloud

Answer: A

NEW QUESTION 3
Which two are correct statementsabout Oracle Data Integrator work repositories?

• A. They contain data and security information.
• B. They contain data model and project information.
• C. They contain data model and execution information.
• D. They contain project and security informatio

Answer: CD

NEW QUESTION 4
Which two Compute Shapes are valid for Data Integration Platform Cloud (D1PC) Instances?

• A. OC1M
• B. OC4M
• C. OC4
• D. OC3M
• E. OC2M

Answer: AC

NEW QUESTION 5
Which product do you need to install manually after you have provisioned a Data Integration Platform Cloud (PIPC) Instance?

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

Answer: A

NEW QUESTION 6
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 7
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 8
What style(s) of integration is/are supported by Oracle Data Integrator?

• A. both ETLand ELT
• B. both ETL and Real-Time Data Warehouse
• C. E-LT
• D. both E-LT and Real-Time Data Warehouse

Answer: A

Explanation:
https://docs.oracle.com/cd/E29542_01/integrate.1111/e12643/intro.htm

NEW QUESTION 9
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 10
Where do you create new tasks in Data IntegrationPlatformCloud (DIPC)?

• A. Catalog
• B. Agents page
• C. Tasks page
• D. Jobs page

Answer: C

NEW QUESTION 11
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 12
You can configure the database during databasedeploymentcreation by selecting Enable Oracle GoldenGate on the Service Details pageof the provisioning wizard. If you do not, you can configure it manually after the database deployment.
What is the utility you can use to configure It?

• A. dbca
• B. notcfg
• C. ggsci
• D. dbaaacli

Answer: C

NEW QUESTION 13
Which elements of data integration does Oracle Data Integrator (ODI) combine?

• A. data movement, data encryption, and data services
• B. data abstraction, data validation, and data encapsulation
• C. data movement,data transformation and data services
• D. data abstraction, data transformation, and data quality

Answer: D

NEW QUESTION 14
What is the purpose of a Data Interface in EnterpriseData 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

Answer: C

NEW QUESTION 15
Which Object Storage Classic type is required to prevision a Data PlatformCloud (DIPC) instance?

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

Answer: D

NEW QUESTION 16
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 17
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 18
Which are three valid sources for Oracle GoldenGate Capture Process?

• A. Oracle Database Cloud Service
• B. Oracle database
• C. MySQL
• D. MongoDB
• E. Big Data

Answer: ACE

NEW QUESTION 19
Which component of Oracle Data Integrator(ODI) architecture contains configuration information and metadata?

• A. Run-Time Agents
• B. Repositories
• C. Users
• D. ODI Console

Answer: B

Explanation:
https://docs.oracle.com/cd/E21764_01/integrate.1111/e12641/overview.htm#ODIGS421

NEW QUESTION 20
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 21
When troubleshooting the failure of a lob in Enterprise Data Quality (EDQ), you discover a process with a processor highlighted as in error. How should you resolve the issue?

• A. Click the errored processor to see what the error is.
• B. Disconnect the errored processor.
• C. Add a Writer to the process to stage thedata immediately after the errored processor.
• D. Check the process execution preferences to determine how the process was ru

Answer: D

NEW QUESTION 22
Which two characteristics of match processors are NOT true of simpler processors in Enterprise Data Quality (EDQ)?

• 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

Answer: CD

NEW QUESTION 23
Which Oracle Data Integrator (ODI) object canbe created underneath a Data Server?

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

Answer: D

NEW QUESTION 24
......