1Z0-481Preview

Select the function that stores environmental values.

Select the commands that give statistics regarding OGG process and memory resource usage.

Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicate with a lag over 60 minutes?

What parameter provides options for compression and encryption?

What GoldenGate process is responsible for capturing changes in the source database?

You have configured and added the extract and Replicate tasks using the direct load method what do you need to do to get the processes up and running?

You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can you treat these as identical tables?

What us expected behavior of CHEKPARMS parameter?

What GoldenGate facility allows for custom processing in response to a data value?

How do you control the size of the buffer that contains data extracted from an ASM instance?

What three are valid responsibilities of the OGG Manager?

You have implemented multi-master Oracle/Oracle replication without a provision to exclude transactions committed by a Replicat process. What errors are likely to occur?

What three types of information are reported in discard file?

Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANSOPS what is the most important thing Carlos should consider before using MAXTRANSOPS

In GoldenGate terms, what is the definition of Extract lag?

Which OGG process (es) can change data in database?

You have a source installation of OGG l0 that includes an initial extract and datapump to provide a remote trail formatted for a GoldenGate 9.5 Replicat process to consume, which process should be use to convert the data to the earlier format?

You are responsible for replication between your central office and twelve regional nodes. What is the best product for you to use to actively monitor thirteen
GoldenGate TDM instances and configure email alerts based on process status?

Which GGSCI command(s) show all available information on both read and write checkpoint for an Extract?
Example: 1 INFO EXTRACT <group name>
Example: 2 INFO EXTRACT <group name>, DETAIL
Example: 3 INFO EXTRACT <group name>, SHOWCH

How would you specify the data source for a secondary Extract functioning as a data pump?

In order to add delete Replicat processes without specifying a checkpoint table, Gerald has edited the GLOBALS parameter file. To get the change to take effect,
Gerald exits from the GGSCI command line, but GGSCI fails to restart. Which solution Is most likely to solve Geralds problem

Where can you find a list of the parameters being used by a Replicat process?

Which process (es) maintain a checkpoint file?