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

NEW QUESTION 1
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 2
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 3
When granting the appropriate privilege for a GoldenGate user using dbms_goldengate_auth, grant_admin_admin_privilege (), If CAPTURE and APPLY are running in a multiple database, the container parameter must be set to what value?

• A. CURRENT
• B. DEFAULT
• C. ALL
• D. NULL

Answer: A

NEW QUESTION 4
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 5
Which Oracle Cloud Service is a prerequisite for provisioning a Data Integration Platform Cloud (DIPC) instance?

• A. Oracle Database Cloud Service
• B. Oracle Event Hub Cloud Service
• C. Oracle Big Data Cloud Service
• D. Oracle Analytics Cloud Service

Answer: D

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

• A. the servername / IP address of the remote agent host
• B. the Identity Cloud service domain that the DIPC instance belongs to
• C. the database server host / lp that the agent will connect to
• D. the DIPC cloud host /ip address that the agent will connect to

Answer: D

NEW QUESTION 7
You need to profile a data set In Enterprise Data Quality (£DQ) to understand how complete and unique each of its attributes are-Which processor should you use?

• A. the Record Completeness Profiler
• B. the Quickstats Profiler
• C. the Frequency Profiler'
• D. the Equal Attributes Profiler

Answer: C

NEW QUESTION 8
Which Data Integration Platform editions support data replication?

• A. Enterprise and Governance
• B. Oracle GoldenGate edition
• C. Standard and Governance
• D. Standard and Enterprise

Answer: A

NEW QUESTION 9
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 10
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 11
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 12
Which action creates a Job in Data Integration Platform Cloud (D1PC)?

• A. creating a policy
• B. running a task
• C. executing a search
• D. creating a new connection

Answer: C

NEW QUESTION 13
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 14
When you work In Oracle Data Integrator Studio (001), you OD1 profile is that of a DESIGNER. What is your equivalent application role in Data Integration Platform?

• A. Superuser
• B. Administrator
• C. User
• D. Developer

Answer: A

NEW QUESTION 15
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 16
Whichmapping component transform data from multiple Input rows into a single output row?

• A. Distincts
• B. Pivots
• C. Subquery Filters
• D. Sets

Answer: C

NEW QUESTION 17
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 18
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 19
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 20
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 21
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 22
......