Exit demo 1Z0-935 Oracle Cloud Platform Data Integration 2018 Associate PDF format · free preview

Oracle 1Z0-935 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-935.html

Question 1
Multiple choice

Which two are correct statements about Oracle Data Integrator work repositories? (Choose two.)

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 information.

Question 2
Single choice

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

A.

Run-Time Agents

B.

Repositories

C.

Users

D.

ODI Console

Question 3
Single choice

You need to troubleshoot the execution of a Mapping and visualize the data contained in the Oracle Data Integrator (ODI) Staging tables while the Mapping is being executed.

How should you proceed?

A.

Execute the ODI scenario via the Data Integration Platform Console and query the source database.

B.

Use variables in a Package to query the Staging tables and evaluate the variable values.

C.

Modify a KM to dump the staging tables data into log files for review.

D.

Start a Mapping in Debug mode using the Get Data feature to view the Staging tables.

Question 4
Single choice

Which command-line interface should you use when configuring Oracle GoldenGate manually?

A.

RMAN

B.

SQLPLUS

C.

GG_CONFIG

D.

GGSCI

Question 5
Single choice

Which Data Integration Platform editions support data replication?

A.

Enterprise and Governance

B.

Oracle GoldenGate edition

C.

Standard and Governance

D.

Standard and Enterprise

Question 6
Single choice

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;

Question 7
Single choice

From where can you download the Data Integration Platform Cloud (DIPC) remote agent?

A.

Oracle Cloud Marketplace

B.

Data Integration Platform Cloud Console

C.

Oracle.com

D.

Oracle edelivery

Question 8
Single choice

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

Question 9
Multiple choice

Which two editions can be provisioned for Data Integration Platform Cloud (DIPC)? (Choose two.)

A.

Governance

B.

Extreme Performance

C.

Enterprise

D.

Data Lake

E.

Basic

F.

Real-time

Question 10
Single choice

What style(s) of integration is/are supported by Oracle Data Integrator?

A.

both ETL and E-LT

B.

both ETL and Real-Time Data Warehouse

C.

E-LT

D.

both E-LT and Real-Time Data Warehouse

Showing 10 of 76 questions · Unlock the full set