1z0-935 Free Practice Test

When do you grant the privilege, select on v_Sdatabase, to the databaseuser?

1. A. For source schema only
2. B. For target schema only
3. C. For both source and target schemas
4. D. For neither source nor target schemas

Correct Answer: C

When troubleshooting the failure of a lob in Enterprise Data Quality (EDQ), you discover a process with a processor highlighted as in error. How should you resolve the issue?

1. A. Click the errored processor to see what the error is.
2. B. Disconnect the errored processor.
3. C. Add a Writer to the process to stage thedata immediately after the errored processor.
4. D. Check the process execution preferences to determine how the process was ru

Correct Answer: D

Identify the true statement when Oracle GotdenGate is configured for batch processing.

1. A. Replicate is started with theINIATIALLOADtask.
2. B. There isa SPECIALRUNReplicate task.
3. C. TheSPECIALRUNparameter is in the capture parameter file.
4. D. TheSPECIALRUN parameter is in the GLOBALSparameter fil

Correct Answer: D

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?

1. A. Superuser
2. B. Administrator
3. C. User
4. D. Developer

Correct Answer: A

You need to troubleshoot the executionofa Mapping and visualize the data contained Inthe Oracle Data Integrator (ODl)Staging tables while the Mapping is being executed.
How should you proceed?

1. A. Execute the ODI scenario via the Data Integration Platform Console and query the source database.
2. B. Use variables In a Package to query the Staging tables and evaluate the variable values.
3. C. Modify a KM to dump the staging tables data Into log files to* review.
4. D. Start a Mapping In Debug mode using the Get Data feature to view the Staging table

Correct Answer: A