PDF Download Free of 1Z0-947 Valid Practice Test Questions [Q47-Q67]

4/5 - (1 vote)

PDF Download Free of 1Z0-947 Valid Practice Test Questions

1Z0-947 Test Engine files, 1Z0-947 Dumps PDF

Q47. Which statement about trails is correct?

Trail files are used to show the order GoldenGate files are accessed to perform replication.

RMTTRAIL is for remote trails and EXTTRAIL is for local trails.

Trail files are used to show how many records your Distribution Path is trailing behind the Extract.

Extract is typically used to produce local trail files over a TCP/IP connection.

Q48. Which three statements are true about Oracle GoldenGate?

Oracle GoldenGate is an Oracle Database product that supports other Oracle products.

Oracle GoldenGate is a middleware product that does not require an Oracle database.

Oracle GoldenGate can support high availability.

Oracle GoldenGate captures changes from Oracle Redo logs or non-Oracle transaction logs and moves them to another database.

Q49. Which capability does GoldenGate support?

File-based Capture

Asynchronous Capture and Delivery of committed DML transactions

Two-phase commit operations from application interfaces

Synchronous transaction Capture from application interfaces

Q50. Which formats can extract trails be written in?

Only Canonical and SQL

LOB, RAW, JSON

Canonical, LCR, Text (ASCII/UTF), SQL, XML

Binary, CSV, JSON

Q51. Which of these is a valid Replicat parameter in Oracle GoldenGate?

PASSTHRU

DynamicPortList

RmtHost

SourceDefs

Q52. 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 barrier transactions in a Coordinated Replicat.

It is caused by the use of the MAXTRANSOPS parameter.

It is caused by the thread with the highest thread ID applying barrier transactions.

It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.

Q53. Which of the following is not an initial load method in Oracle GoldenGate?

File to database utility

SQL*Net Load

Direct load

File to Replicat

Q54. Which Oracle GoldenGate utility helps troubleshoot OGG-02191 Incompatible Record errors?

The CONVCHK utility

The reverse utility

The logdump utility

Q55. You want to use coordinated Replicat mode instead of classic mode. Which three reasons should you consider for this?

Replicat is multi-threaded in coordinated mode.

Only one parameter file is required for a coordinated Replicat, regardless of the number of threads.

Coordinated Replicat allows for user-defined partitioning of the workload so as to apply high-volume transactions concurrently.

Multiple transactions on the target are executed with full synchronization.

Parent and child tables must not be processed by the same apply thread.

Q56. You must locate the next good record header in a Logdump file. How should you do this?

Logdump > SCANFORENDTRANS

Logdump > SCANFORHEADER

Logdump > GHDR ON

Logdump > SCANFORGHDR

Q57. What must be done when adding a new table after GoldenGate has been implemented?

Nothing, it auto-detects

Restart the database

Restart Oracle GoldenGate

Run Add TranData or AddSchemaTranData

Q58. The IF function is used to test one or more conditions and return a value. The Replicat parameter file has the following entry:

Central

Pacific

East

Mountain

Q59. Which option is an invalid GLOBALS parameter?

GGSCHEMA

CHECKPOINTTABLE

DISCARDFILE

MGRSERVNAME

Q60. What parameter manages conflicts between initial load and replication?

RESOLVE_INIT_LOAD

HANDLECOLLISIONS

IGNORE_ERRORS

CONFLICT_RESOLVER

Q61. 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.

Q62. Which is an invalid combination for EVENTACTIONS with options?

EVENTACTIONS (CHECKPOINT BOTH, IGNORE)

EVENTACTIONS (CHECKPOINT BEFORE, ABORT)

EVENTACTIONS (CHECKPOINT AFTER, ABORT)

EVENTACTIONS (CHECKPOINT BOTH, STOP)

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

TRUE

FALSE

Q64. With BATCHSQL enabled, what causes a Replicat to use normal mode operation?

Statements that cause errors

Statements with rows between 8k and 24k in length

When BATCHSQL and GROUPTRANSOPS coexist

When server memory < 8 GB

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

FALSE

TRUE

Q66. You must provide credentials, like a username and password, to access the database credentials store where the actual user credentials are stored. The credential store is preferable to using the database username and password in the commands or the parameter file. What may you use rather than a user ID and password, in the parameter file, for the Extract or Replicat to provide credentials for access to the source or target database?

UserIDAlias

UserReplicationUser

Oracle SID

Single Sign On

Q67. Where can you view Oracle GoldenGate command syntax?

AWR Report

Command Line Interface Reference

Data Dictionary Views

SQL*Plus Guide