21 October, 2019

Accurate Oracle 1Z0-447 Paper

Exambible 1Z0-447 Questions are updated and all 1Z0-447 answers are verified by experts. Once you have completely prepared with our 1Z0-447 exam prep kits you will be ready for the real 1Z0-447 exam without a problem. We have Leading Oracle 1Z0-447 dumps study guide. PASSED 1Z0-447 First attempt! Here What I Did.

Page: 1 / 6

Total 72 questions Full Exam Access

Question 1

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

Oracle Goldengate for Big Data

Oracle Goldengate Application Adapters

Oracle Goldengate Veridata

Oracle Data Integrator Adapters

Question 2

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

Use the Read Startup Checkpoint.

Use the Read Recovery Checkpoint.

Use the Write Startup Checkpoint.

Use the Read Current Checkpoint.

Question 3

What is the default format for a GoldenGate trail?

ASCII:ASCII format

INPUT ASCII: from 1to 127 representing ASCII characters

SQL: SQL statements

CDF: Canonical Data format

XML: XML statement

Question 4

Ideally which process should be configured purge old trial files?

Manager

Extract

Replicat

Pump

Question 5

In which process should you configure the warning for long-running transactions?

Jagent

Extract

Replicat

Manager

Question 6

What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

KEYGEN file in the GoldenGate data location

COBGEN file in the GoldenGate installation location

GGSKEY file in the GoldenGate data location

GGSKEY file in the GoldenGate installation location

ENCKEYS file in the GoldenGate installation location

Question 7

What is the key purpose of GoldenGate trail files?

They are a persistent storage area for captured transactions.

They are configuration files for the GoldenGate processes.

They are checkpoint files for the GoldenGate processes.

They are database auditing logs where GoldenGate captures changes.

Question 8

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

The GGSCI session was configured incorrectly.

The Manager parameter file containsSYSLOG ALL.

An Extract or Replicat is overriding GLOBALS withSYSLOG WARN.

The user session running Manager is set to log all messages.

Question 9

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?

Use theFILTERoption in theMAPparameter.

Use theCOLMAPoption in theMAPparameter.

Do not specify those columns in theADD TRANDATAcommand.

Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

Question 10

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

UseREPERRORin the Replicat parameter file.

UseHANDLECOLLISIONin the Replicat parameter file.

Use Conflict Detection and Resolution in the Replicat parameter file.

UseMAPEXCEPTIONin the Replicat parameter file.

Question 11

Which method in GoldenGate should you use to undo DML changes previously made to a target database?

Run Extract and Replicat from the command line.

Use Extract and Replicat with the GoldenGate Logdump utility.

Run the Reverse Utility on the target database transaction logs.

Use Extract and Replicat with the GoldenGate Reverse utility.

Question 12

What Oracle GoldenGate feature provides recoverability without loss of transactions?

Checkpointing

Sub-second latency

Two-phase commits

Transactional integrity

Question 13

By default which type of operations are captured by extract?

Inserts, updates, deletes, and table operations such as CREATE TABLE

Inserts, compresses, and updates

Inserts, updates, deletes, and table operations such as ADD COLUMN

Inserts only

Inserts, updates, and deletes

Question 14

Which GLOBALS parameter is required to initially enable monitoring?

JAGENTMONITORING

ENABLEMONITORING

ENABLEOEMMONITORING

CHECKMONITORING

Question 15

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

Manager

Extract

Replicat

Both Extract and Replicat

Question 16

Identify two correct statements regarding GoldenGate supported features.

GoldenGate supports network encryption and compression.

GoldenGate supports DML and DDL replication for all supported databases.

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

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

Question 17

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

Use the command optionAFTERCSN.

Use the command optionATCSN.

Use the command optionUNTIL CANCEL.

Use the command optionRESUME.

Question 18

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging.
How should you proceed?

Include theOVERWRITEcommand.

Include theUSEDELTAcommand.

Include theADD TRANDATAcommand.

Include theUPDATAROWEXISTScommand.

Question 19

Which three are types of encryption supported by OGG?

Parameter file encryption

Password

Trial file encryption

Message encryption

Question 20

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

Run thechkpt_db_extracttrail.sqlscript.

Run thechkpt_db_create.sqlscript.

Use theADD Extract Trailcommand.

Use theINFO REPLICATcommand with theSHOWCHoption.

Use theADD CHECKPOINTTABLEcommand.

Page: 1 / 6

Total 72 questions Full Exam Access