Oracle Oracle Certifications 1Z0-447 Questions & Answers

• Question 31:

  Which option is an invalid GLOBALS parameter?

  A. DISCARDFILE

  B. GGSCHEMA

  C. MGRSERVNAME

  D. CHECKPOINTTABLE

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters.htm#GWURF987

• Question 32:

  You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft?

  A. Implement trail file encryption.

  B. Ensure that passwords are encrypted.

  C. Ensure that network communications are encrypted.

  D. Ensure that table-level Transparent Data Encryption is implemented.

  Correct Answer: D

  Reference: http://www.oracle.com/technetwork/database/security/esi/ds-database-security-golden-gate1438944.pdf

• Question 33:

  For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?

  A. Teradata

  B. Informix

  C. Sybase

  D. DB2

  Correct Answer: D

• Question 34:

  Select four Oracle GoldenGate use cases.

  A. real-time discovery

  B. real-time data warehousing

  C. offload reporting

  D. zero downtime upgrades and migrations

  E. backup and recovery

  F. data center load balancing by using multi-master replication

  Correct Answer: BCDF

• Question 35:

  You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services?

  A. Create a GLOBALS file for each installation and use the MGRSERVNAMEparameter, with a unique name.

  B. Include the parameter SERVICENAME in each Manager, with a unique name.

  C. Accept the default service name and manually edit within the Services applet.

  D. Multiple Manager services are not allowed on the same Windows server.

  Correct Answer: A

  Reference: http://www.dba-oracle.com/t_goldengate_parameter_files.htm

• Question 36:

  GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?

  A. in the checkpoint file area

  B. in the trail files area

  C. in the server temporary file system

  D. in the bounded recovery area

  Correct Answer: C

• Question 37:

  Which option is supported by GoldenGate DDL replication?

  A. CREATE ROLE

  B. ALTER SYSTEM

  C. ALTER DATABASE

  D. ALTER TABLE SYS

  Correct Answer: D

  Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/using-ddlreplication.htm#GGHDB-GUID-B7A3B3AF-B5DE-47B3-8B0F-C6D5FCB5388C

• Question 38:

  Which Logdump command is used to check how many change records are in the trail file?

  A. STATS

  B. REPORT

  C. REPORTCOUNT

  D. COUNT

  Correct Answer: D

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GLOGD/wu_logdump.htm#GLOGD121

• Question 39:

  Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?

  A. View the maybe out-of-sync (MOOS) queue.

  B. View the Veridata log file.

  C. View the confirm-out-of-sync (COOS) queue.

  D. View the Veridata Agent repository.

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/v1221/gg-veridata/GVDUG/get_started.htm#GVDUG107

• Question 40:

  You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT SHOWCH.How should you proceed?

  A. Use the Read Startup Checkpoint.

  B. Use the Read Recovery Checkpoint.

  C. Use the Write Startup Checkpoint.

  D. Use the Read Current Checkpoint.

  Correct Answer: B

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/ wu_ogg_checkpts.htm#GWUAD968