Free Oracle 1z1-447 Exam Dumps Questions & Answers

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

• A.ENABLE_STREAMS_REPLICATION=true
• B.ENABLE_DATABASE_REPLICATION=true
• C.Configure theSTREAMS_POOL_SIZEdatabase parameter
• D.ENABLE_GOLDENGATE_REPLICATION=true

When is a Pump not required to connect to a source database?

• A.when transformations, filtering, and mapping are required
• B.when aPASSTHRUparameter is used
• C.when look-ups are needed against the source database
• D.when aNOPASSTHRUparameter is used

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.FILTER (@RANGE 2, 2, ID);
• B.FILTER (@RANGE (2, 2, AccountID));
• C.MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));
• D.TABLE fin.Sales, FILTER (@RANGE (1, 2));
• E.MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

• A.Use theFILTERoption in theMAPparameter.
• B.Use theCOLMAPoption in theMAPparameter.
• C.Do not specify those columns in theADD TRANDATAcommand.
• D.Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

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.