Get 1Z1-947 Products Practice Material for 1Z1-947 Exam Question Preparation
Most Reliable Oracle 1Z1-947 Training Materials
NEW QUESTION # 64
Which three statements are true about Oracle GoldenGate?
- A. Oracle GoldenGate captures changes from Oracle Redo logs or non-Oracle transaction logs and moves them to another database.
- B. Oracle GoldenGate is a middleware product that does not require an Oracle database.
- C. Oracle GoldenGate can support high availability.
- D. Oracle GoldenGate is an Oracle Database product that supports other Oracle products.
Answer: A,B,C
Explanation:
GoldenGate does not need Oracle DB, reads logs, and supports HA.
NEW QUESTION # 65
Only the EncryptTrail Extract parameter should be used to encrypt/decrypt trail file records.
- A. FALSE
- B. TRUE
Answer: A
Explanation:
EncryptTrail is not the only way to encrypt trail files.
NEW QUESTION # 66
What is the purpose of a data pump Extract in Oracle GoldenGate?
- A. Encrypts trail files
- B. Reads from local trail and forwards to remote system
- C. Monitors performance metrics
- D. Directly applies changes to target
Answer: B
Explanation:
It allows recovery if the network or target system fails by maintaining a local trail.
NEW QUESTION # 67
Identify the scenario in which you cannot configure GoldenGate.
- A. Real-time Change Data Capture from transaction logs
- B. Snapshot database backups
- C. Batch Data Transfer from table data
- D. Initial Load synchronization
Answer: B
Explanation:
Snapshot database backups are not a replication scenario - GoldenGate does not operate on backups. It's designed for live, transactional, and log-based data movement, not static snapshots.
NEW QUESTION # 68
You must locate the next good record header in a Logdump file. How should you do this?
- A. Logdump > SCANFORENDTRANS
- B. Logdump > SCANFORGHDR
- C. Logdump > GHDR ON
- D. Logdump > SCANFORHEADER
Answer: D
Explanation:
In Oracle GoldenGate's Logdump utility, to locate the next valid (good) record header within a trail file, you use: text Copy Edit SCANFORHEADER This command scans forward until it finds the next readable record header, which is useful for troubleshooting corrupted trail files or resynchronizing log parsing.
NEW QUESTION # 69
If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?
- A. Manager
- B. Extract
- C. Extract and Replicat
- D. Replicat
Answer: A
Explanation:
The PURGEOLDEXTRACTS parameter should be configured in the Manager (MGR) process, as it is responsible for monitoring trail file usage across GoldenGate processes and safely deleting files no longer needed by any Extract or Replicat.
NEW QUESTION # 70
If you were to create a target-initiated Distribution Path, which of the following must you provide?
- A. The target URI
- B. The name of the Extract
- C. The name of the database transaction logs where database data changes were recorded
- D. The name of the GoldenGate deployment
Answer: A
Explanation:
When creating a target-initiated Distribution Path in Oracle GoldenGate Microservices, the Receiver Service initiates the connection to the source's Distribution Service. This requires specifying the target URI, which includes details like the source host, port number, and trail name. The Extract name is not directly required in this configuration.
NEW QUESTION # 71
Why might you use multiple data pumps for one source trail?
- A. Minimize CPU usage
- B. Encrypt extract data
- C. Send to multiple targets and improve parallelism
- D. Reduce redo generation
Answer: C
Explanation:
To support multiple target systems, table separation, and parallel processing.
NEW QUESTION # 72
What is a trusted point in a GoldenGate deployment?
- A. The one root certificate authority (rootCA) that is used for signing all certificates across all deployments
- B. An access point that you can trust to be a safe connection
- C. A high level of security and protection system that is designed against various types of threats, including malware, hacking, and attacks
- D. Security keys to provide secure online authentication
Answer: A
Explanation:
In Oracle GoldenGate (especially in Microservices Architecture), the trusted point refers to the root certificate authority (rootCA) used to digitally sign all the certificates for secure communication. This ensures trust between all components within a deployment.
NEW QUESTION # 73
Where can Oracle GoldenGate software be downloaded officially?
- A. Oracle Cloud Marketplace
- B. My Oracle Support
- C. OTN or http://edelivery.oracle.com
- D. Oracle Database Utilities
Answer: C
NEW QUESTION # 74
Which parameter is typically used with data pumps unless transformation is needed?
- A. TrailFile
- B. Map
- C. ASSUMETARGETDEFS
- D. PASSTHRU
Answer: D
Explanation:
PASSTHRU (used unless transformation or exit processing is needed)
NEW QUESTION # 75
Which parameter is used to identify the remote target system in Oracle GoldenGate?
- A. RmtHost
- B. TargetTrail
- C. HostName
- D. Map
Answer: A
NEW QUESTION # 76
Which parameter gives more accurate timing for lag statistics?
- A. TCPSourceTimer
- B. DynamicResolution
- C. CacheMgr
Answer: A
Explanation:
TCPSourceTimer improves lag timing accuracy.
NEW QUESTION # 77
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?
- A. Use the COLMAP option in the MAP parameter.
- B. Do not specify those columns in the ADD TRANDATA command.
- C. Use the FILTER option in the MAP parameter.
- D. Use the COLS and COLSEXCEPT options in the TABLE parameter.
Answer: D
Explanation:
To prevent sensitive data from being replicated, you should use the COLS and COLSEXCEPT options in the TABLE parameter. These options allow you to explicitly include or exclude specific columns from the replication process, ensuring that sensitive data is not transferred to the target database.
NEW QUESTION # 78
Which utility is used to view the contents of trail files?
- A. trailreader
- B. ggconsole
- C. datapump
- D. logdump
Answer: D
Explanation:
logdump is the diagnostic tool to examine trail files at the record level.
NEW QUESTION # 79
The Integrated Replicat reads the trail, constructs logical change records that represent source DML or DDL transactions, and transmits these records to an inbound server in the Oracle target database. What statement is true about Integrated Replicat?
- A. Both source and target can be Oracle and non-Oracle databases.
- B. Source must be configured as Integrated Extract.
- C. Integrated Replicat does not need a checkpoint or a trace table for its operations.
- D. Trail files contain data that must be in logical change records format.
Answer: D
Explanation:
Integrated Replicat processes Logical Change Records (LCRs). These LCRs are read from trail files and passed to the Inbound Server. It supports parallel apply and uses Oracle Streams APIs internally.
NEW QUESTION # 80
......
LATEST 1Z1-947 Exam Practice Material: https://www.testkingpdf.com/1Z1-947-testking-pdf-torrent.html
The Realest Study Materials 1Z1-947 Dumps: https://drive.google.com/open?id=1Jkx0XWPf8XnOUooCBtQp4hQsBItlXSvk
