CREAR TEST

TEST BORRADO, QUIZÁS LE INTERESE: GoldenGate Exam Q/A

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test: GoldenGate Exam Q/A Descripción: Examen de certificacion para GG Autor: GHS OTROS TESTS DEL AUTOR Fecha de Creación: 06/10/2024 Categoría: Arte Número Preguntas: 50

COMPARTE EL TEST

Comentar

No hay ningún comentario sobre este test.

Temario:

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. Which parameter for GoldenGate 12c enables DDL replication for a Replicat? TARGETDDL GETDDL DDL for Replicat is enabled by default USEDDL. 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. 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. Select four Oracle GoldenGate use cases. backup and recovery real-time data warehousing data center load balancing by using multi-master replication real-time discovery offload reporting zero downtime upgrades and migrations. 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 “ajava.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. 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));. For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management? Sybase Informix Teradata DB2. 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. 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. 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. 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. 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. 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.

Denunciar Test