Achieve The Utmost Performance In 1Z1-947 Exam Pass Guaranteed [Q45-Q68]

QUESTION 45
What is not a role used in a Microservices architecture deployment?

Security

Administrator

User

Manager

QUESTION 46
To display SQL DML statements before execution using a classic Replicat, what should you do?

Enable the ShowSyntax parameter

None of the above

Execute Detail On

Execute ScanForRBA

QUESTION 47
Which Oracle GoldenGate parameter manages conflicts between initial load and change replication?

CheckpointTable

PASSTHRU

DiscardFile

HandleCollisions

QUESTION 48
You can connect to the Receiver Server to manage (start and stop) the configured data paths.

FALSE

TRUE

QUESTION 49
DDL can be used in conjunction with filter options. What would be the correct DDL parameter if you need DDL for specific objects?

DDL <objectname>

DDL Include All, Exclude ObjName <objectname>

DDL Exclude All, Include ObjName <objectname>

DDL Include. <objectname>

QUESTION 50
What parameter manages conflicts between initial load and replication?

RESOLVE_INIT_LOAD

HANDLECOLLISIONS

IGNORE_ERRORS

CONFLICT_RESOLVER

QUESTION 51
To identify a bottleneck, where should monitoring begin?

From the target back to the source

From the source to the target

QUESTION 52
Key names and values can be stored in:

ENCKEYS

DefsFile

GLOBALS

SourceDefs

QUESTION 53
What is the purpose of the DiscardFile?

To backup configuration changes

To discard unused trail files

To log failed operations Replicat couldn’t process

To store Replicat cache

QUESTION 54
Users of both Extract and Replicat require the DBA role for the database.

TRUE

FALSE

QUESTION 55
What Oracle GoldenGate microservices component is used to handle all incoming trail files?

Service Manager

Receiver server

Trail File server

Administration server

QUESTION 56
Using the built-in lightweight filtering facility, the Distribution Server allows you to operate simple transformations while dispatching trail files to the Receiver Server.

FALSE

TRUE

QUESTION 57
You need to manually patch Oracle GoldenGate source and targets. How should you proceed?

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.

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. 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 GG processes when ready to begin capturing 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.

QUESTION 58
If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

Manager

Extract and Replicat

Extract

Replicat

QUESTION 59
User exits can be used for tables processed by a data pump Extract in passthru mode.

TRUE

FALSE

QUESTION 60
In integrated mode, the Replicat process leverages the apply processing functionality that is available within the Oracle database. How does it operate?

It reads the Oracle GoldenGate trail, performs data filtering, mapping, and conversion. Then, it constructs logical change records (LCRs) from source database DML transactions. DDL is applied directly by Replicat. Finally, it transmits the LCRs to the inbound server, which applies the data to the target database.

It reads the Oracle GoldenGate trail, performs data filtering, mapping, and conversion. Then, it constructs logical change records (LCRs) from source database DML transactions. Then it is attached to a background process in the target database by means of lightweight streaming mechanism, which transmits the LCRs to the inbound server, which applies the data to the target database.

It reads the Oracle GoldenGate trail, performs data filtering, mapping and conversion. Then, it transmits the regular change records to the inbound server, which applies the data to the target database.

It reads the Oracle GoldenGate trail, performs data filtering, mapping and conversion. Then, it constructs logical change records from source database DML transactions. Next, it uses standard SQL to apply data directly to the target tables.

QUESTION 61
The Integrated Extract can use the LogMiner components to collectively read and format the logical change records and create trail entries in the trail file. Which of the following is not a component of the LogMiner?

Builder

Reader

Preparer

Converter

QUESTION 62
What is a “trail” in GoldenGate?

A series of files that store captured data

A transport layer protocol

A type of error log

A link between Replicat and Extract

QUESTION 63
Which tools would you use to determine if all Oracle GoldenGate processes are up and running?

GGSCI

Oracle GoldenGate Monitor

Process report

CMDSEC

tcpers

QUESTION 64
How is Integrated Capture different from Classic Capture?

Integrated Capture is different because it connects directly to the inbound server to apply transactions.

Integrated Capture is different because it captures processes to integrate with an application server.

Integrated Capture is different because it automatically configures the Capture process of GoldenGate.

Integrated Capture is different because it receives Logical Change Records (LCRs) directly from a database logmining server.

QUESTION 65
Where are the Oracle GoldenGate parameters officially documented?

Oracle GoldenGate AdminClient Manual

Oracle Fusion Middleware Reference for Oracle GoldenGate 19c

GoldenGate GGSCI Command Reference

Oracle Database Concepts Guide

QUESTION 66
Cache and queue statistic drill-downs are available for both Extract and Replicat groups.

FALSE

TRUE

QUESTION 67
You were assigned to install the Oracle GoldenGate 19c Microservices architecture software. There are three things that need to be done for the installation process: Install the software using the Oracle Universal Installer. Set the necessary environment variables. Deploy an Oracle GoldenGate instance using the configuration assistant, oggc a. What will running the oggca.sh utility do?

Configure the Service Manager and the other Microservices architecture servers.

Create the administration user for the GoldenGate instance.

Create a database user for the GoldenGate instance.

Launch GoldenGate instance wizard to guide you through creating an Extract and a Replicat.

QUESTION 68
Only the EncryptTrail Extract parameter should be used to encrypt/decrypt trail file records.

TRUE

FALSE