CREATE TEST

ERASED TEST, YOU MAY BE INTERESTED ON Cert Test 001

COMMENTS	STATISTICS	RECORDS

TAKE THE TEST

Title of test: Cert Test 001 Description: Preguntas de exámen para certificación de GG Author: GHS Other tests from this author Creation Date: 12/10/2024 Category: Computers Number of questions: 142

Share the Test:

New Comment

No comments about this test.

Content:

You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this? Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run ggsci < input_file, where the file name is an OBEY file. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci ./ input_file from the command line of the operating system, where the file name is the script file. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI ./ input_file, where the file name is the script file. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci < input_file from the command line of the operating system, where the input_file is an OBEY text file. You are experiencing an issue with the downstream database server for the Integrated Capture Downstream Model. Which step should you take to resolve the issue? Ensure that the GoldenGate version used on the downstream database server is the same version used on the source database server. Ensure that the GoldenGate version used on the downstream database server is the same version used on the target database server. Ensure that the platform type of the downstream database server is the same platform as the source database server. Ensure that the Oracle database version on the downstream database server is the same version as the source Oracle version. You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services? Multiple Manager services are not allowed on the same Windows server. Accept the default service name and manually edit within the Services applet. Create a GLOBALS file for each installation and use the MGRSERVNAME parameter, with a unique name. Include the parameter SERVICENAME in each Manager, with a unique name. What software is required prior to running Oracle GoldenGate in a Windows Server environment? JDBC drivers into the GoldenGate home directory Nothing, configure GoldenGate Jagent for that particular database platform Microsoft Visual C++ 2010 SP1 Redistributable Package Oracle Gateway software configured for that particular database platform. Which GLOBALS parameter is required to initially enable monitoring? JAGENTMONITORING CHECKMONITORING ENABLEMONITORING ENABLEOEMMONITORING. You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running? Start the Extract task and then start the Replicat task. Start the Extract task, wait for it to stop, and then start the Replicat task. Start the Replicat task. Start the Extract task. In which process should you configure the warning for long-running transactions? Extract Manager Replicat Jagent. Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after Extract has stopped? Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility. Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility. Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility. Use the "PURGEORPHANEDTRANSACTIONS" parameter to control the bounded recovery feature of the general Extract checkpointing facility. Which statement regarding the GoldenGate Data Pump is incorrect? Data Pump can be used to pump trail records to multiple locations. Data Pump is a separate process. Data Pump uses TCP/IP to route the trail records. Data Pump has distance limitations. An integrated Replicat is running with PARALLELISM set to 4, yet you discover that for a series of large operations, only one apply server is processing the operations. What is the reason for this issue? Operations are grouped into one apply server automatically based on GROUPTRANSOPS. The operations are all part of one transaction. Parallelism for an Integrated Replicat cannot exceed one. The operations for a particular table are pinned to a specific apply server. Your GoldenGate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version. How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key? View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by all Replicat groups GoldenGate deployments cannot use a shared wallet View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key. You edit the GLOBALS file, save the changes, and restart GGSCI to have the change take effect. However, when you try to start the Manager, it fails. Which action should solve the problem? Use the CLEANUP REPLICAT command Verify that Oracle environment variables are set correctly Use a text editor to check the GLOBALS file for syntax errors and correct them Add the Oracle GoldenGate Installation directory to the system PATH. 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? View the Veridata Agent repository View the confirm-out-of-sync (COOS) queue View the Veridata log file View the maybe out-of-sync (MOOS) queue. Which command provides statistics about GoldenGate processes and memory resource utilization? SEND…LOGSTATS SEND…CACHEMGR SEND…GETTCPSTATS INFO…SHOWCH. You must locate the next good record header in a Logdump file. How should you do this? Logdump > GHDR ON Logdump > SCANFORHEADER Logdump > SCANFORGHDR Logdump > SCANFORENDTRANS. You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time? system memory the number of concurrent users disk space the number of compound keys on the source tables. Which Logdump command is used to check how many change records are in the trail file? COUNT REPORT STATS REPORTCOUNT. What is the purpose of a VAM parameter? It specifies that a Vendor Access Module is being used to perform data transformation functions. It specifies that Virtual Application Memory is being used to perform data replication functions. It specifies that a Vendor Access Module is being used to perform data capture functions. It specifies that a Virtual Access Module is being used to perform data capture functions. You want to monitor replication not only to check that the processes are running, but to specifically verify that the data continuously replicates. How should you accomplish this? Implement GoldenGate Monitor Have the customer continuously update the application data Monitor the GoldenGate lag and last checkpoint time statistics Implement heartbeat tables for replication. Which parameter for GoldenGate 12c enables DDL replication for a Replicat? TARGETDDL GETDDL DDL for Replicat is enabled by default USEDDL. You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to–database utility. How should you configure GoldenGate in order to accomplish this? Configure Replicat with the FORMATASCII SQLLOADER OPTION Configure Extract with the FORMATSQL SQLLOADER OPTION Configure Replicat with the FORMATXML OPTION Configure Extract with the FORMATASCII SQLLOADER OPTION. You need to manually patch Oracle GoldenGate source and targets. How should you proceed? Stop access to the source. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump/Replicat are finished processing the data in their respective trails. Stop the data pump/Replicat. Apply the patch on the target. If the patches changed table defs, run DEFGEN for the source tables to generate updated source defs, and then replace the old defs with the new ones in the existing source defs file on the target. Start GoldenGate processes when ready to begin capturing activity again. Stop access to the source and target databases. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source and on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again. Stop access to the source and target databases. Start applying the patch on the source. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again. Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate? ENABLE_DATABASE_REPLICATION=true Configure the STREAMS_POOL_SIZE database parameter ENABLE_STREAMS_REPLICATION=true ENABLE_GOLDENGATE_REPLICATION=true. Which syntax would you use in an OBEY script to stop a process without waiting for user input? stop immediate * stop * ! stop * noinput stop force *. Which Replicat MAP parameter and syntax should be used to detect an update conflict on the EURO.SEAT_RESV table and resolve the conflict by determining which record has the oldest LAST_UDATE value? MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT(UPDATEROWEXISTS, (DEFAULT, USEMIN (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON INSERT KEYINCLUDING (last_update)), RESOLVECONFLICT(INSERTROWEXISTS, (DEFAULT, USEDELTA (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT(UPDATEROWEXISTS, (DEFAULT, USEMIN (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT(UPDATEROWEXISTS, (DEFAULT, USEMAX (last_update)));. What is the function of the GoldenGate JAgent? It integrates GoldenGate with Oracle Data Integrator It performs connections via JDBC to run the Veridata comparisons It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent It reads the database transaction logs. You must synchronize tables with Large Object data types. Which Initial Load method supports this process? File to Replicat GoldenGate Direct Load Direct bulk load to SQL*Loader File to database utility. You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this? Use the command option UNTIL CANCEL Use the command option AFTERCSN Use the command option ATCSN Use the command option RESUME. How should you configure Replicat to control how errors are handled in one-way replication? Use REPERROR in the Replicat parameter file Use MAPEXCEPTION in the Replicat parameter file Use HANDLECOLLISION in the Replicat parameter file Use Conflict Detection and Resolution in the Replicat parameter file. Identify the correct statement regarding Trails. Extract and Pump are different OS level executable binary files. RMTTRAIL is for remote trails and EXTTRAIL is for local trails. Extracts cannot perform filtering, mapping, and transformations. Extract is typically used to produce local trail files over a TCP/IP connection. You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with “java.lang.Exception: One or more Java Agent properties in Config.properties are not defined properly”. What is the first thing to check? if the Oracle Wallet has been created for the JAgent. if the agent type is set to OEM in JAgent properties. if The Enterprise Manager Agent is running. if the JAgent has been enabled in the GoldenGate Manager. Which option is not included as part of a Veridata installation? Veridata Agent Veridata BackPlane Server Veridata Repository Veridata Web Server. You must prepare the source database to send redo to the mining database. What sequence of steps should you follow to accomplish this? Ensure that the source database is running with the required compatibility. Set DB_CONFIG at the source database. Set up redo transport at the source database. Ensure that the source database is running with the required compatibility. Set DG_CONFIG at the source database. Set up redo transport at the source database and enable the downstream destination. Set DG_CONFIG at the source database and enable the downstream destination. Ensure that the source database is running with the required compatibility. Use the TRANSLOGOPTIONS parameter, set up redo transport at the source database, and enable the downstream destination. When is a Pump not required to connect to a source database? when transformations, filtering, and mapping are required when a NOPASSTHRU parameter is used when a PASSTHRU parameter is used when look-ups are needed against the source database. You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to? It is caused by THREAD and THREADRANGE being used with wildcard MAP statements It is caused by the thread with the highest thread ID applying barrier transactions It is caused by the use of the MAXTRANSOPS parameter It is caused by barrier transactions in a Coordinated Replicat. Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger? Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater Any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater. What sequence of steps should you follow to add a data pump that reads from a local trail? In GGSCI, on the source system, issue the command: ADD PUMP group name, TRAILSOURCE trail name. In GGSCI, on the source system, issue the command: ADD PUMP group name, EXTTRAILSOURCE trail name. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, EXTTRAILSOURCE trail name. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, TRAILSOURCE trail name. You must return column-level detail for out-of-sync rows. How can you accomplish this? The Oracle GoldenGate Veridata Manager executes auto-memory database-related requests on behalf of the Oracle GoldenGate Veridata Server. The Oracle GoldenGate Veridata Agent source database executes database-related requests on behalf of the Oracle GoldenGate Veridata Server. The Oracle GoldenGate Veridata Manager executes database-related requests on behalf of the Oracle GoldenGate Veridata Server. The Oracle GoldenGate Veridata Agent executes database-related requests on behalf of the Oracle GoldenGate Veridata Server. For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management? Sybase Informix Teradata DB2. 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. Use Extract and Replicat with the GoldenGate Reverse utility. Run the Reverse Utility on the target database transaction logs. You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used? Oracle Goldengate Veridata Oracle Goldengate Application Adapters Oracle Data Integrator Adapters Oracle Goldengate for Big Data. You want to eliminate the reporting output from processing a Macro. How should you proceed? Use the optional parameter NOREPORT Use the optional parameter UNLIST Use the optional parameter NOMACROOUTPUT Use the optional parameter NOLIST. You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts. How should you accomplish this? Use the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause. Use the GETBEFORECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat. Use the COMPARECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause. Use the COMPCOLS with the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause. You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT group_name SHOWCH. How should you proceed? Use the Read Recovery Checkpoint Use the Read Current Checkpoint Use the Write Startup Checkpoint Use the Read Startup Checkpoint. Which statement is valid for DDL replication? Target objects can be different from source when using SOURCEDEFS in Replicat Source and target objects can be different GoldenGate User Exits are not supported for DDL It can use WILDCARDRESOLVE IMMEDIATE. Select four Oracle GoldenGate use cases. real-time data warehousing data center load balancing by using multi-master replication offload reporting zero downtime upgrades and migrations real-time discovery. Select four Oracle GoldenGate use cases. real-time data warehousing data center load balancing by using multi-master replication offload reporting zero downtime upgrades and migrations backup & recovery. Which parameter could you use to start an Extract when Manager starts? AUTOSTART BEGIN START PROCESS. What GoldenGate process writes to RMTTRAILS? Server/Collector Pump All of the above Replicat Extract. With BATCHSQL enabled, what causes a Replicat to use normal mode operation? Statements which cause errors. When BATCHSQL and GROUPTRANSOPS coexist. Statements with rows between 8k and 24k in length. When server memory < 8GB. Which parameters would be used for one-time initial Replicat? PASSTHRU SOURCEISTABLE CHECKMINUTES SOURCEISFILE SPECIALRUN. You have a source table with a PRODUCT_ID column and a target table with PRODUCT_DESCRIPTION column. On the target database, there is a lookup table containing product codes and corresponding descriptions. What should you use to look up the PRODUCT_DESCRIPTION for each transaction? SQLEXEC ( ) SQLLOOKUP ( ) DBLOGIN ( ) DBLOOKUP ( ). Which replication topology requires conflict resolution? Broadcast Consolidation Cascading Master-to-Master. What Oracle GoldenGate feature provides recoverability without loss of transactions? Checkpointing Sub-second latency Transactional integrity Two-phase commits. 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? Do not specify those columns in the ADD TRANDATA command. Use the COLS and COLSEXCEPT options in the TABLE parameter. Use the COLMAP option in the MAP parameter. Use the FILTER option in the MAP parameter. Select the function that stores environmental values. GGENVIRONMENT ETOKEN @COLGEN @GETENV. Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat? TARGETDB sampleID samplepword SOURCEDB sampleDB USERID sampleID PASSWORD samplepword TARGETDB TargetDSN USERID sampleID PASSWORD samplepword SOURCEDB SourceDSN. Which option is supported by GoldenGate DDL replication? ALTER SYSTEM ALTER TABLE SYS CREATE ROLE ALTER DATABASE. What is expected behavior of CHECKPARAMS parameter? A report file is created listing all missing parameters. The process checks the parameter syntax and then stops. A report file is created listing all default values not specified in the parameter file. The process checks the parameter syntax and then starts running. 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) MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID)); TABLE fin.Sales, FILTER (@RANGE (1, 2)); FILTER (@RANGE 2, 2, ID); FILTER (@RANGE (2, 2, AccountID)); MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));. Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables. Run the chkpt_db_extracttrail.sql script Use the INFO REPLICAT command with the SHOWCH option Run the chkpt_db_create.sql script. Use the ADD Extract Trail command Use the ADD CHECKPOINTTABLE command. Which three are the responsibility of the MGR process? (Select three) Receive or route requests from the UI. Process management. Data movement Trigger execution Trail File management. Which three are types of encryption supported by OGG? Password Parameter file encryption Message encryption Trail file encryption. What is GGSCI an Acronym for? GoldenGate Software Connection Interface GoldenGate Secure Command Interface GoldenGate Secure Connection Interface GoldenGate Software Command Interface. How many Extracts can write to the same GoldGate trail? Up to 10. Unlimited. Up to 50. Only one. 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 user session running Manager is set to log all messages. The Manager parameter file contains SYSLOG ALL. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN. 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 the USEDELTA command. Include the UPDATAROWEXISTS command. Include the ADD TRANDATA command. Include the OVERWRITE command. If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up? Extract Replicat Manager Extract and Replicat. How do you control the size of the buffer that contains data extracted from an ASM instance? DBOPTIONS BUFSIZE TRANLOGOPTIONS ASMBUFSIZE. DBOPTIONS ASMBUFSIZE TRANLOGOPTIONS BUFSIZE. Which three describe a valid OGG Event Action? Write a checkpoint before and/or after writing the record to the trail. Stop the process. Run a shell command. Purge old trail files. When would you use the PASSTHRU parameter? For a SPECIALRUN one-time processing task that is doing an initial load. When using a data pump to distribute all of the trail data "as is" to a remote system. When Extract is processing database transaction logs where you have a remote database connection. When Extract is processing database transaction logs and writing to a local trail that will be read by a local Replicat. Which three can GoldenGate encrypt? Passwords Extract to Server messages Redo logs Trails. Replicat is responsible for which three options? Reading data out of the GoldenGate trails. Check pointing the oldest uncommitted transaction. Performing data flow filtering. Performing data transformations. You have a requirement to extract changes from an oracle 10g database without installing or running any GoldenGate processes on the host server. To accomplish this, which GoldenGate process parameter is most likely to be part of your solution? This configuration is not supported in GoldenGate 10. WILDCARDRESOLVE DYNAMIC TRANLOGOPTIONS ARCHIVEDLOGONLY ASSUMETARGETDEFS. What is the default format for a GoldenGate trail? SQL: SQL statements INPUT ASCII: from 1 to 127 representing ASCII characters XML: XML statement ASCII:ASCII format CDF: Canonical Data format. When implementing GoldenGate on a 11gR2 Oracle database and after running the GoldenGate Database profiling script, you discover that certain objects are compressed, what should you do? Continue the implementation of OGG and exclude those objects from replication. Contact Oracle Support. Configure OGG with Classic Capture. Configure OGG with Integrated Capture. Which could be used to map a value stored in a user token to a target column? @GETENV GGENVIRONMENT @TOKEN GGHEADER. What three types of information are reported in discard file? The trail file sequence number. The database error message. The details of the discarded records. Runtime statistics. Which utility is responsible for generating source data definitions files? DDLGEN COBGEN EMSCLNT DEFGEN. Which command forces a running Extract to close the current trail and start writing to the next trail sequence number? SEND EXTRACT <group>, ETROLLOVER ALTER EXTTRAIL <trail name>, ROLLOVER ALTER EXTTRAIL <trail name>, NEXTSEQNO SEND EXTRACT <group>, ROLLOVER. You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this? You can configure integrated Replicat with the SPECIALRUN parameter. You can configure integrated Replicat with two parallel apply servers. You can configure integrated Replicat with two parallel child servers. You can configure integrated Replicat with ASSUMETARGETDEFS and SPECIALRUN parameters. You need to look up table definitions in a file. Which Replicat parameter should you use? SOURCEDEFS MAP COLMATCH ASSUMETARGETDEFS. GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them? in the trail files area in the checkpoint file area. in the server temporary file system in the bounded recovery area. How would you specify the data source for a secondary Extract functioning as a Data Pump? LOCTRAILSOURC SOURCEISTABLE SOURCEISTRAIL EXTTRAILSOURCE. What file must be configured in order to use custom encryption keys? ENCKEYS GLOBALS ENCRYPT CUSTKEYS. Which Replicat parameter is used when looking up table definitions in a file? SOURCEDEFS SOURCEISFILE DEFERAPPLYINTERVAL SPECIALRUN. Select the statement that is supported by OGG DDL Replication. CREATE ROLE ALTGLOBAL ENCRYPT ALTDB. By default which type of operations are captured by Extract? Inserts, compresses, and deletes. Inserts, updates, deletes, and table operations such as ADD COLUMN. Inserts, updates, deletes, and table operations such as CREATE TABLE. Inserts only. Inserts, updates, and deletes. Ideally which process should be configured purge old trail files? Replicat Pump Manager Extract. What is the name and the location of the file that lists the key values used by extract for encryption and Server Collector for decryption? ENCKEYS file in the GoldenGate installation location. COBGEN file in the GoldenGate installation location. GGSKEY file in the GoldenGate data location. KEYGEN file in the GoldenGate data location. You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover from this? Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files. What is expected behavior of CHECKPARAMS parameter? A report file is created listing all missing parameters. The process checks the parameter syntax and then stops. A report file is created listing all default values not specified in the parameter file. The process checks the parameter syntax and then starts running. Which Replicat MAP parameter and syntax should be used to detect an update conflict on the EURO.SEAT_RESV table and resolve the conflict by determining which record has the oldest LAST_UDATE value? MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT(UPDATEROWEXISTS, (DEFAULT, USEMIN (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON INSERT KEYINCLUDING (last_update)), RESOLVECONFLICT(INSERTROWEXISTS, (DEFAULT, USEDELTA (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT(UPDATEROWEXISTS, (DEFAULT, USEMIN (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT(UPDATEROWEXISTS, (DEFAULT, USEMAX (last_update))); None options correct. You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate manage process is running on port 7809. Your requirements include using a custom encryption key and advanced encryption standard (AES), and you have created an ENCKEYS file What parameters should you use? RMTHOST usserval, MGRPORT AES, ENCRYPTKEY MYKWY, MBRPORT 7809 RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY This feature is not supported in oracle GoldenGate 10. RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, ENCRYPT KEY. What command is issued to alter Replicat to start processing trail number 10 at relative byte address 100345? Alter <group>, sequence 10, rba 100345 Alter <group>, extseqno 10, extrba 100345 Alter Replicat <group>, sequence lO, rba 100345 Alter Replicat *, exttrail <trail prefix>, extseqno 10, extrba 100345. 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? Tables set with nologging. Triggers and sequences. Tables that have conflicts. Tables with Large Object (LOB) data types. What parameter provides options for compression and encryption? TCPIP RMTHOST TARGET DB TARGET. Where are GoldenGate macros defined? Macros can be defined in the parameter file or included in a macro file. Macros are placed in a file and referenced using environment variable. Macros are declared, compiled and referenced via GoldenGate's user exits. Macros are defined in the GLOBALS parameter file. Which command creates the database logmining server in Oracle? REGISTER MININGDB. REGISTER EXTRACT. ADD MININGDB. REGISTER REPLICATION. 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 Example 3 only. Examples 1 and 3. Examples 1 and 2. Example 2 only. Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicat with a lag over 60 minutes? LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60 LAGREPOBT 1, I.AGCRITICALHOURS 1 LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I LAGREPORTMINUTES 60, LAGINFOHOURS 1 CORRECT. How can you tell if GoldenGate has been configured for batch processing? The SPECIALRUN parameter is in the GLOBALS parameter file. There is a dedicated GoldenGate process called SPECIALRUN. The SPECIALRUN parameter is in the Replicat parameter file. Replicat is started with the INITIALLOAD task. Which statements are true of GoldenGate password encryption? 1 - A password can be encrypted and pasted into a parameter file. 2 - An encrypted password can be generated using the default key. 3 - An encrypted password can be generated using a user defined-key. 1, 2 and 3 3 only 1 only 2 only 1 and 3. Which process receives data from the Extract process over TCP/IP and writes it to a trail or extract file on the target system? Manager Release Collector Replicat. From which portion of SGA the shared memory comes from for GoldenGate Extract process? Large Pool Redo Log Buffer Streams Pool Buffer Cache. Which GoldenGate process would you configure to enable Synchronous Streaming? A Knowledge Module Secondary Extract. Manager Replicat. Which argument is used to set the maximum size of the EXTTRAIL or RMTTRAIL. TRAILMAXSIZE F HAXTRAILSI2E TRAILSIZE MEGABYTES MAXSIZE. What is the GoldenGate command line interface? GGCTRL GGCUI SQLCUI GGSCI. If your system has a firewall controlling port access which parameter can be used to control ports used for GoldenGate processes? GETPORTINFO DYNAMICPORTLIST CHILDPORTS ALLOWEDPORTS. You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue? GoldenGate Manager was not started first. The incorrect version of GoldenGate was installed for your CPU architecture. The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set. A license key must be applied first. Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default? An image of the contents of the record after the insert, update or delete operation. An after image for inserts and a before image for updates and deletes. The new value for updated fields; the primary key for deleted rows; the after-image for inserts. An after image for inserts and updates and a before image for deletes. You are asked to create an Extract process on a source database to capture data from materialized views. Which of these are valid statements for Extract process which captures data of materialized view? (Choose Two) Materialized view created WITH ROWID are not supported. DML (but not DDL except truncate) from a full refresh of materialized view is supported. Source table may or may not have a primary key. DML (but not DDL) from a full refresh of materialized view is supported. You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (….), the best solution is______. Include the tranlogoptions (exclude user) parameter in each Extract parameter file. This feature is not supported in GoldenGate 10. Use the add FILTERTABLE command at the GGSCI prompt. Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping. Identify two correct statements regarding GoldenGate supported features. GoldenGate supports network encryption and compression. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source. GoldenGate supports DML and DDL replication for all supported databases. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source. What is the SOCKSPROXY sub-parameter of the RMTHOST parameter typically used for? Configuring remote database access. Remote capturing. Connecting to a source database via secure communication. Replicating information using a SOCKS5 proxy server, thereby creating a tunnel for TCP communication between a source Extract and a target process. Which option is an invalid GLOBALS parameter? DISCARDFILE GGSCHEMA MGRSERVNAME CHECKPOINTTABLE. Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data? The Extract will revert to single-row fetch mode, and then resume array fetches afterwards. The Extract will abend unless LOBMEMORY is increased. The Extract will revert to single-row fetch mode for all tables. The Extract will perform poorly due to paging unless LOBMEMORY is increased. Which three types of information are stored in the GoldenGate trail header? Relative byte address of the commit record. Time of the transaction. Data type (e. g. integer, alphanumeric). Before or after image indicator. Ideally which process should be configured purge old trail files? Replicat. Pump. Manager. Extract. In addition to using the parameter comment to enter remarks in parameter file(s) what can be used? \\ /* // --. Which best describes the function of OGG user tokens? User-defined variables. User privileges. Security tokens. User-defined functions. In GoldenGate terms, what is the definition of Extract lag? The difference in time between when a change is made to source data and when that change is reflected in the target data. The difference in time between the current times at the target system. The difference in time between when a change record is received at the target system and when the change is reflected in the target data. The difference in time between when a change record is processed by the extract and the timestamp of the record in the data source. You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate. What do you need to configure to ensure that backwards replication works? The Replicat with the FORMAT RELEASE parameter. The Extract with the FORMAT RELEASE parameter. The collector with the FORMAT RELEASE parameter. The Extract to write directly to the remote trail. Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete? The first column, excluding virtual columns and nullable columns, will be treated as the primary key. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes. The combination of all fields up to the first thirty-two will be treated as a compound primary key. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key. Which of following Oracle data types Oracle GoldenGate does not support? (Choose three) BINARY_FLOAT MLSLABEL DATE TIMEZONE_ABBR URITYPE TIMESTAMP WITH LOCAL TIMEZONE NVARCHAR2. Which parameter tells Extract the tables for which to Capture Changes? MAP C Table LOG LOGTABLE. When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture? GoldenGate only supports UNIX on the middle-tier server. GoldenGate only supports Windows or Linux on the middle-tier server. The middle-tier server must have a database installed on it. The middle-tier capture server has the same endian order and bit width. Which statement correctly explains when you would use ASSUMETARGETDEFS? The source and target tables have identical data structure. The target tables are already created. You have specified wildcards in either the TABLE or MAP parameters. Only the fields in the target tables are mapped. What GoldenGate facility allows for custom processing in response to a data value? GGSExec DDLGEN User Tokens User Exits. Which three ggsci commands are used to create and start a replicat? edit params <group> OK create param <group> add replicat <group> OK create replicat <group> add exttrail replicat <group> create exttrail replicat <group> start replicat <group> OK startup replicat <group> . Which replicat parameter manages conflicts between initial load and change delivery? HandleConflicts HandleDuplicates HandleMissingRecords HandleCollisions -- OK. Which component performs dependency calculation for a Parallel Replicat Mapper Collater Scheduler -- OK Applier. When is AssumeTargetDefs valid? When the source and target table names are the same When the source and target table structures are the same -- OK When the source and target table records are the same When the source and target databases are the same. Which three of the following are tools that can be used to determine whether all GoldenGate processes are up and running ? tcperrs CMDSEC ggsci -- OK Process Reports -- OK GoldenGate Monitor -- OK. Which files are used to capture information about the GoldenGate operations that have failed? Discard Files -- OK Purged trail files tcperrs CMDSEC. Which two ggsci commands creates a GoldenGate checkpoint table on the target database? Create CheckpointTable Add CheckpointTable <table> -- OK Add CheckpointTable, if there is a GLOBALS file with 'CheckPointTable <table>' parameter and valid value -- OK Start replicat <group> (the checkpoint table is automatically created) . What does TransInd with a value of x01 mean? It is the first record of a multi-record transaction. It is the only record of a single-record transaction. It is the middle record of a multi-record transaction. -- OK It is last record of a multi-record transaction. You have a source Oracle database that includes the HR schema with the EMPLOYEES table which stores its records in the example tablespace on the source database. Which command should be used to find records only for it in the trail? filter include filename example01.dbf filter include tablename HR.EMPLOYEES filter include filename EXAMPLE01.dbf filter include tablename hr.employees filter include filename HR.EMPLOYEES -- OK select * from hr.employees;. Which parameter and keyword can be used in GoldenGate 12.3 to write to an ASCII file which can be read by a database utility? FormatASCII OutputFormat TEXT -- OK FormatTEXT OutputFormat ASCII. Which GoldenGate utility enables you to view trail contents? gedit vi logdump ggsci. Which four formats can extract trails and files be written? LCR -- OK ASCII -- OK JSON HDFS SQL -- OK XML -- OK Hive HTML. What is a trail? A series of files on disk where GoldenGate stores data for further processing -- OK A series of in-memory queues where GoldenGate stores data for further processing A series of tables in a database where GoldenGate stores data for further processing A series of records in a table where GoldenGate stores data for further processing.

Report abuse