Oracle 1Z0-935 Online Practice Questions and Exam Preparation

Oracle 1Z0-935 Online Questions & Answers

• Question 11:

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

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

  ---

  The central component of the architecture is the Oracle Data Integrator Repository. It stores configuration information about the IT infrastructure, metadata of all applications, projects, scenarios, and the execution logs. Reference: https://docs.oracle.com/cd/E21764_01/integrate.1111/e12641/overview.htm#ODIGS421

• Question 12:

  Which technology does Data Integration Platform Cloud (DIPC) use to communicate with your remote agent?

  A. Oracle Identity Cloud
  B. SOCKS Proxy Tunnel
  C. HTTP Proxy
  D. Secure Shell (SSH)
  A. Oracle Identity Cloud

• Question 13:

  Which Oracle Data Integrator (ODI) component orchestrates an ODI process?

  A. Runtime Web Service
  B. ODI SDK
  C. Operator D. ODI Agent
  D

  ---

  Reference: https://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425.pdf page 3

• Question 14:

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

  A. data movement, data quality, 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
  A. data movement, data quality, and data services

  ---

  Reference: https://docs.oracle.com/cd/E15586_01/integrate.1111/e12643/intro.htm

• Question 15:

  Which Cloud Service is 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
  A. Identity Cloud

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/faq-oracle-data-integration-platform-cloud-user-roles.html

• Question 16:

  Which Knowledge Modules load data into the target tables?

  A. Service Knowledge Modules
  B. Loading Knowledge Modules
  C. Journalizing Knowledge Modules
  D. Integration Knowledge Modules
  B. Loading Knowledge Modules

  ---

  Reference: https://www.oracle.com/technetwork/articles/bethke-odi-090881.html

• Question 17:

  Which statement is true about the contents of Master repositories?

  A. They contain security and topology information.
  B. They contain project and security information.
  C. They contain data model and security information.
  D. They contain project and topology information.
  A. They contain security and topology information.

  ---

  Reference: https://docs.oracle.com/cd/E17904_01/integrate.1111/e12641/overview.htm#ODIGS421

• Question 18:

  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 job.
  B. Design the process to read and write data from web services interfaces and run it in Interval mode.
  C. Design a job in EDQ and deploy it directly to the data source using a DIPC agent.
  D. Configure a job without any whole record set processors, disable all data staging, and ensure all processes are writing no drilldown data.
  D. Configure a job without any whole record set processors, disable all data staging, and ensure all processes are writing no drilldown data.

• Question 19:

  Which two are benefits of the E-LT approach? (Choose two.)

  A. high performance with optimized transformations
  B. better parallelism with extra ETL server
  C. taking advantage of existing hardware and software infrastructure
  D. shortens development and maintenance time
  A. high performance with optimized transformations
  D. shortens development and maintenance time

• 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 PASSTHRU parameter is used
  D. when a NOPASSTHRU parameter is used
  A. when the look-ups are needed against the source database