Oracle 1z0-935 Free Practice Questions

NEW QUESTION 1
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 2
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 3
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 4
When excluding pluggable databases, schemas, and objects from your configuration, which of these parameters does NOT apply?

• A. EXCLUDEWILDCARD0BJECTSONLY
• B. EXCLUDETAG
• C. TABI.EEXCL.UDE
• D. SCHEMAEXCLUDE

Answer: D

NEW QUESTION 5
Which authentication protocol is supported when configuring theData integration Platform Cloud (OIPC) remote agent?

• A. HMAC
• B. Oracle Wallet
• C. Public / Private key pairs
• D. OAUTH2

Answer: C

NEW QUESTION 6
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 7
Which is NOT a valid privilege to grant your source and target users?

• A. CONNECT
• B. RESOURCE
• C. SELECTANY DATABASELINK
• D. CREATE SESSION

Answer: A

NEW QUESTION 8
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 9
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 10
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 11
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 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 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 14
Which Cloud Serviceis used to manage the Data Integration Platform Cloud (DIPC) users and their roles?

• A. Identity Cloud
• B. Identity Management Cloud
• C. User Management Cloud
• D. Data Integration Platform Cloud

Answer: D

NEW QUESTION 15
Your Source Database is running inside the company firewall on the internal trusted network and the Target Database Is a DBaaS Instance inside Oracle Public Cloud. No VPN is used.
When configuring on-premises to cloud replication using ssh socks proxy solution, which location is recommended to run the ssh proxy server to maximize the security and protection?

• A. a public-lacing VM server o< computer host sitting in a demilitarized zone
• B. VM Server in Oracle Cloud that couldconnect to the internet
• C. VM Server or computer hosted by thirdparty that oilers anonymous service
• D. VM server or computerhost sitting inside the company's trusted network

Answer: B

NEW QUESTION 16
You have been tasked with designing a data cleansing process that does NOT write any Interim data or results In Enterprise Data Quality (EDQ). How should you proceed?

• A. Stage all results views and export them when running the |ob.
• B. Design the process to read and write data from web services interfaces and mi* it in Interval mode.
• C. Design aJob in EDQ and deploy it directly to the data source using a DIPC agent.
• D. Configure a Job without any whole record set processors, disableall data staging, and ensure all processes are writingno drilldown data.

Answer: A

NEW QUESTION 17
Which two editions can be provisioned for Data Integration Platform Cloud (DIPC)?

• A. Governance
• B. Extreme Performance
• C. Enterprise
• D. Data Lake
• E. Basic
• F. Real-time

Answer: AC

Explanation: https://blogs.oracle.com/dataintegration/walkthrough%3a-oracle-data-integration-platform-cloud-provisioning

NEW QUESTION 18
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