Oracle 1Z0-935 Online Practice Questions and Exam Preparation

Oracle 1Z0-935 Online Questions & Answers

• Question 21:

  Which two are correct purposes of the Enterprise Data Quality (EDQ) repository database? (Choose two.)

  A. to store report documents generated from data quality jobs
  B. to store results of data quality processing for user browsing
  C. to store persistent single views of data entities for customers
  D. to store data representing the configuration of data quality projects.
  B. to store results of data quality processing for user browsing
  D. to store data representing the configuration of data quality projects.

• Question 22:

  You want to copy, profile, and cleanse your data. Which Data Integration Platform edition should you use?

  A. Enterprise
  B. Data Quality edition
  C. Governance
  D. Standard
  C. Governance

  ---

  Data quality, data profiling, and data governance features in addition to the functionality included in Enterprise Edition. With this option, you profile, cleanse and govern your data sources with customized dashboards. Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/what-is-dipc.html#GUID-102DE8B4-A8B5-4015-8E4D-0EBDD21966F5

• Question 23:

  You can configure the database during database deployment creation by selecting Enable Oracle GoldenGate on the Service Details page of 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. netcfg
  C. ggsci
  D. dbaascli
  D. dbaascli

  ---

  You can configure the database during database deployment creation by selecting Enable Oracle GoldenGate on the Service Details page of the provisioning wizard. If you don't, you can configure it manually after the database deployment is created by using the dbaascli utility. Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/configure-goldengate.html#GUID-9C833533-A2B6-4B37-9662-BC00D661E8B6

• Question 24:

  When you work in Oracle Data Integrator Studio (ODI), your ODI profile is that of a DESIGNER.

  What is your equivalent application role in Data Integration Platform?

  A. Super user
  B. Administrator
  C. User
  D. Developer
  A. Super user

• Question 25:

  Which two statements are correct about using Enterprise Data Quality (EDQ) and Oracle Data Integrator (ODI) together? (Choose two.)

  A. ODI can call EDQ jobs either synchronously or asynchronously.
  B. EDQ can connect 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 systems.
  A. ODI can call EDQ jobs either synchronously or asynchronously.
  B. EDQ can connect to any data source defined in ODI without additional configuration.

  ---

  Reference: https://www.oracle.com/technetwork/middleware/oedq/edq-int-ess-2415637.pdf

• Question 26:

  Which authentication protocol is supported when configuring the Data Integration Platform Cloud (DIPC) remote agent?

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

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/set-agent.html#GUID-1E5C6E1E-F180-4D79-84F2-0EA97C934F2E

• Question 27:

  When troubleshooting the failure of a job 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 the data immediately after the errored processor.
  D. Check the process execution preferences to determine how the process was run.
  D. Check the process execution preferences to determine how the process was run.

• Question 28:

  Which is NOT a valid privilege to grant your source and target users?

  A. CONNECT
  B. RESOURCE
  C. SELECT ANY DATABASE LINK
  D. CREATE SESSION
  C. SELECT ANY DATABASE LINK

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/data-source-connection-details.html#GUID-2B0CC735-B4A6-4010-8A0C-3D3DDC3D4C8A

• Question 29:

  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
  C. to synchronize source and target data

  ---

  Reference: https://www.oracle.com/technetwork/tutorials/tutorial-1861053.html

• Question 30:

  When using Business Rules Check in Enterprise Data Quality (EDQ), how should you apply a specific rule to a subset of the data being processed?

  A. Use multiple instances of Business Rules Check with different rules enabled.
  B. Filter the data before processing it with Business Rules Check.
  C. Add a condition in the Business Rules data and reference it in the rule definition.
  D. Apply logic to the Check such that the records you do not want to apply the rule to are always given a No Data result.
  C. Add a condition in the Business Rules data and reference it in the rule definition.

  ---

  Reference: https://docs.oracle.com/en/middleware/enterprise-data-quality/12.2.1.3/edqoh/business-rules-check.html