File Info
| Exam | Oracle Cloud Platform Data Integration 2018 Associate |
| Number | 1z0-935 |
| File Name | Oracle.1z0-935.TestInside.2019-09-09.45q.vcex |
| Size | 27 KB |
| Posted | Sep 09, 2019 |
| Download | Oracle.1z0-935.TestInside.2019-09-09.45q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which two are correct statements about Oracle Data Integrator work repositories? (Choose two.)
- They contain data and security information.
- They contain data model and project information.
- They contain data model and execution information.
- They contain project and security information.
Correct answer: BD
Explanation:
Reference: https://docs.oracle.com/cd/E17904_01/integrate.1111/e12643/admin_reps.htm#ODIDG154 Reference: https://docs.oracle.com/cd/E17904_01/integrate.1111/e12643/admin_reps.htm#ODIDG154
Question 2
Which component of Oracle Data Integrator (ODI) architecture contains configuration information and metadata?
- Run-Time Agents
- Repositories
- Users
- ODI Console
Correct answer: B
Explanation:
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 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 3
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?
- Execute the ODI scenario via the Data Integration Platform Console and query the source database.
- Use variables in a Package to query the Staging tables and evaluate the variable values.
- Modify a KM to dump the staging tables data into log files for review.
- Start a Mapping in Debug mode using the Get Data feature to view the Staging tables.
Correct answer: A
Question 4
Which command-line interface should you use when configuring Oracle GoldenGate manually?
- RMAN
- SQLPLUS
- GG_CONFIG
- GGSCI
Correct answer: D
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/configure-goldengate.html#GUID-BCCCC99C-78D7-4E31-A660-664B634C2EB4 Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/configure-goldengate.html#GUID-BCCCC99C-78D7-4E31-A660-664B634C2EB4
Question 5
Which Data Integration Platform editions support data replication?
- Enterprise and Governance
- Oracle GoldenGate edition
- Standard and Governance
- Standard and Enterprise
Correct answer: A
Question 6
Which is NOT a valid privilege to grant a CDB user?
- exec dbms_goldengate_auth.grant_admin_privileges('cdbuser','capture',container=>'all');
- grant create session to cdbuser;
- grant create container to cdbuser;
- grant alter session to cdbuser;
Correct answer: C
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/data-source-connection-details.html#GUID-528CF27A-6321-4570-AB4C-98A77777A340 Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/data-source-connection-details.html#GUID-528CF27A-6321-4570-AB4C-98A77777A340
Question 7
Which product do you need to install manually after you have provisioned a Data Integration Platform Cloud (DIPC) instance?
- None, they're all included when you provision the instance
- Oracle GoldenGate
- Oracle Enterprise Data Quality
- Oracle Data Integrator
Correct answer: B
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/get-started-data-integration-platform-cloud.html#GUID-B82DE087-9EC5-4484-8769-23929CF756C8 Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/get-started-data-integration-platform-cloud.html#GUID-B82DE087-9EC5-4484-8769-23929CF756C8
Question 8
Which two editions can be provisioned for Data Integration Platform Cloud (DIPC)? (Choose two.)
- Governance
- Extreme Performance
- Enterprise
- Data Lake
- Basic
- Real-time
Correct answer: AC
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/get-started-data-integration-platform-cloud.html#GUID-1907B4FF-FD4A-4844-8AFF-FE7C3A053423 Reference: https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/using/get-started-data-integration-platform-cloud.html#GUID-1907B4FF-FD4A-4844-8AFF-FE7C3A053423
Question 9
What style(s) of integration is/are supported by Oracle Data Integrator?
- both ETL and E-LT
- both ETL and Real-Time Data Warehouse
- E-LT
- both E-LT and Real-Time Data Warehouse
Correct answer: A
Explanation:
Reference: https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG118 Reference: https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG118
Question 10
In which scenario can you NOT use Oracle GoldenGate?
- data synchronization from Oracle to MySQL databases
- batch data transfer from table data
- real-time change data capture from transaction logs
- capture change data from HDFS
Correct answer: B
