1z0-447Free trialFree trial

By oracle
Aug, 2025

Verified

25Q per page

Question 1

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

  • A: Oracle Goldengate for Big Data
  • B: Oracle Goldengate Application Adapters
  • C: Oracle Goldengate Veridata
  • D: Oracle Data Integrator Adapters
—

Question 2

Which statement is valid for DDL replication?

  • A: GoldenGate User Exits are not supported for DDL.
  • B: Source and target objects can be different.
  • C: Target objects can be different from source when using SOURCEDEFS in Replicat.
  • D: It can use WILDCARDRESOLVE IMMEDIATE.
—

Question 3

You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?

  • A: The incorrect version of GoldenGate was installed for your CPU architecture.
  • B: A license key must be applied first.
  • C: GoldenGate Manager was not started first.
  • D: The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set.
—

Question 4

Identify the correct statement regarding Trails.

  • A: Extract and Pump are different OS level executable binary files.
  • B: Extracts cannot perform filtering, mapping, and transformations.
  • C: RMTTRAIL is for remote trails and EXTTRAIL is for local trails.
  • D: Extract is typically used to produce local trail files over a TCP/IP connection.
—

Question 5

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

  • A: Run the chkpt_db_extracttrail.sql script.
  • B: Run the chkpt_db_create.sql script.
  • C: Use the ADD Extract Trail command.
  • D: Use the INFO REPLICAT command with the SHOWCH option.
  • E: Use the ADD CHECKPOINTTABLE command.
—

Question 6

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-todatabase utility. How should you configure GoldenGate in order to accomplish this?

  • A: Configure Replicat with the FORMATASCII SQLLOADER OPTION.
  • B: Configure Extract with the FORMATSQL SQLLOADER OPTION.
  • C: Configure Extract with the FORMATASCII SQLLOADER OPTION.
  • D: Configure Replicat with the FORMATXML OPTION.
—

Question 7

Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after
Extract has stopped?

  • A: Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility.
  • B: Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
  • C: Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility.
  • D: Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
—

Question 8

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

  • A: ENABLE_GOLDENGATE_REPLICATION=true
  • B: ENABLE_STREAMS_REPLICATION=true
  • C: Configure the STREAMS_POOL_SIZE database parameter
  • D: ENABLE_DATABASE_REPLICATION=true
—

Question 9

How should you configure Replicat to control how errors are handled in one-way replication?

  • A: Use REPERROR in the Replicat parameter file.
  • B: Use HANDLECOLLISION in the Replicat parameter file.
  • C: Use Conflict Detection and Resolution in the Replicat parameter file.
  • D: Use MAPEXCEPTION in the Replicat parameter file.
—

Question 10

You must implement GoldenGate in a master-to-master configuration. What output from the profiling scripts should you look for to ensure that your implementation is correct?

  • A: Tables set with nologging
  • B: Tables with Large Object (LOB) data types
  • C: Tables that have conflicts
  • D: Triggers and sequences
—

Question 11

If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

  • A: Manager
  • B: Replicat
  • C: Extract
  • D: Extract and Replicat
—

Question 12

You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?

  • A: the number of concurrent users
  • B: disk space
  • C: system memory
  • D: the number of compound keys on the source tables
—

That’s the end of your free questions

You’ve reached the preview limit for 1z0-447

Consider upgrading to gain full access!

Page 1 of 3 • Questions 1-25 of 56
123
→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!