A Review Of 100% Correct 1Z0-447 exam

Q3. Which GLOBALS parameter is required to initially enable monitoring?

A. JAGENTMONITORING

B. ENABLEMONITORING

C. ENABLEOEMMONITORING

D. CHECKMONITORING

View Answer

Q4. You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT

<extractgroup> 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.

View Answer

Q5. When would you use the PASSTHRU parameter?

A. When using a data pump to distribute all of the trail data "as is" to a remote system.

B. When Extract is processing database transaction logs where you have a remote database connection.

C. For a SPECIALRUN one-time processing task that is doing an initial load.

D. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

View Answer

Q6. Which three are required to correctly configure an OGG?

A. A maximum file size

B. An extract process

C. A trail file identifier

D. Designation as local or remote

View Answer

Q7. 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

View Answer

Q8. Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column? (Select three.)

A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

C. TABLE fin.Sales, FILTER (@RANGE (1, 2));

D. FILTER (@RANGE (2, 2, AccountID));

E. FILTER (@RANGE 2, 2, ID);

View Answer

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

A. Configure Replicat with theFORMATASCII SQLLOADER OPTION.

B. Configure Extract with theFORMATSQL SQLLOADER OPTION.

C. Configure Extract with theFORMATASCII SQLLOADER OPTION.

D. Configure Replicat with theFORMATXML OPTION.

View Answer

Q10. Which option is supported by GoldenGate DDL replication?

A. CREATE ROLE

B. ALTER SYSTEM

C. ALTER DATABASE

D. ALTER TABLE SYS

View Answer

Q11. Which option is an invalid GLOBALS parameter?

A. DISCARDFILE

B. GGSCHEMA

C. MGRSERVNAME

D. CHECKPOINTTABLE

View Answer

Q12. Identify two correct statements regarding GoldenGate supported features.

A. GoldenGate supports network encryption and compression.

B. GoldenGate supports DML and DDL replication for all supported databases.

C. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.

D. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

View Answer