Exam Questions Answers Braindumps 1Z1-947 Exam Dumps PDF Questions
Download Free Oracle 1Z1-947 Real Exam Questions
NEW QUESTION # 81
What is the adminclient in GoldenGate MA?
- A. A CLI tool that uses REST APIs to manage deployments
- B. A browser-based management tool
- C. A GUI for performance metrics visualization
- D. A background replication daemon
Answer: A
Explanation:
Command-line utility (like GGSCI) using REST API for Microservices Architecture control/config.
NEW QUESTION # 82
What is a valid net result for an Extract configured with the parameters in this order: GETINSERTS, GETUPDATEBEFORES, IGNOREDELETES, IGNOREUPDATES?
- A. Inserts, updates, and deletes will be captured.
- B. Before and after images of updates will be captured.
- C. Before and after images of updates will be ignored.
- D. Inserts and deletes will be captured.
Answer: C
NEW QUESTION # 83
You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?
- A. Use the command option AFTERCSN.
- B. Use the command option UNTIL CANCEL.
- C. Use the command option ATCSN.
- D. Use the command option RESUME.
Answer: A
Explanation:
"AFTERCSN causes Replicat to start processing at the transaction that occurred after the one with the specified CSN. Any transactions in the trail that have CSN values that are less than, or equal to, the specified one are skipped."
NEW QUESTION # 84
SQLEXEC can communicate only via SQL query.
- A. TRUE
- B. FALSE
Answer: B
Explanation:
SQLEXEC can run scripts, not just SQL queries.
NEW QUESTION # 85
What Oracle GoldenGate microservices component is used to allow administrators to create and manage one or multiple Oracle GoldenGate deployments on a local host?
- A. Administration server
- B. Service Manager
- C. Distribution server
- D. Extract and Replicat server
Answer: B
Explanation:
The Service Manager in Oracle GoldenGate Microservices Architecture acts as a watchdog for other services and allows administrators to create and manage deployments on the local host. It maintains inventory and configuration information about deployments, enabling the management of multiple local deployments.
NEW QUESTION # 86
What is the purpose of an Obey file in Oracle GoldenGate?
- A. Debugging configuration
- B. An ASCII file
- C. Encryption key store
- D. Temporary trail storage
Answer: B
Explanation:
An ASCII file containing command sequences for reuse (similar to a script)
NEW QUESTION # 87
DDL can be used in conjunction with filter options. What would be the correct DDL parameter if you need DDL for specific objects?
- A. DDL Include All, Exclude ObjName <objectname>
- B. DDL Include. <objectname>
- C. DDL <objectname>
- D. DDL Exclude All, Include ObjName <objectname>
Answer: D
Explanation:
This configuration first excludes all DDL operations (EXCLUDE ALL) and then selectively includes DDL for specific objects using INCLUDE OBJNAME. This approach ensures that only the desired DDL operations are replicated, providing precise control over DDL replication.
NEW QUESTION # 88
The filter clause provides the ability to include or exclude data to process. What is true with this filter clause FILTER (ON UPDATE, ON DELETE, @COMPUTE(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000);?
- A. Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.
- B. Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.
- C. Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.
- D. Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.
Answer: A
Explanation:
The clause:
sql
CopyEditFILTER (ON UPDATE, ON DELETE, @COMPUTE(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000) means the filter only applies to UPDATE and DELETE operations. Oracle GoldenGate evaluates the expression:
sql
CopyEdit@COMPUTE(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000
If TRUE, the record is processed.
If FALSE, the record is excluded from replication.
NEW QUESTION # 89
An Oracle GoldenGate topology is a representation of the databases in a GoldenGate environment, how the GoldenGate components are configured on each server, and the flow of data between the components. What topology describes a configuration of data flow from one source site to many target sites?
- A. Broadcast
- B. Multimaster
- C. Integration
- D. Cascading
Answer: A
Explanation:
Broadcast topology describes a one-to-many data replication model: A single source sends data to multiple target sites Targets often receive the same set of replicated changes
NEW QUESTION # 90
What is the adminclient in GoldenGate MA?
- A. A CLI tool that uses REST APIs to manage deployments
- B. A browser-based management tool
- C. A GUI for performance metrics visualization
- D. A background replication daemon
Answer: A
Explanation:
Command-line utility (like GGSCI) using REST API for Microservices Architecture control/config.
NEW QUESTION # 91
A Distribution Path sends the transaction of data from Extract to Replicat. How can you create a Distribution Path?
- A. At OS prompt with run preceding the GoldenGate commands
- B. From Cloud Shell with REST APIs
- C. In GGSCI with GoldenGate commands
- D. From the Service Manager home page
Answer: D
Explanation:
In Oracle GoldenGate Microservices Architecture, the Service Manager UI is the recommended and primary interface to create a Distribution Path using the Distribution Server. This method is officially documented and intended for simplified management.
NEW QUESTION # 92
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?
- A. Start the Extract task, wait for it to stop, and then start the Replicat task
- B. Start the Extract task and then start the Replicat task
- C. Start the Replicat task
- D. Start the Extract task
Answer: A
Explanation:
In the Direct Load method, the Extract performs a one-time data load and then stops. Only after that should the Replicat be started to apply the loaded data. Starting both simultaneously is not valid for this method.
NEW QUESTION # 93
Which statement is not true for a Data Path in the Oracle GoldenGate Microservices architecture environment?
- A. The Extract process stores the captured data in trail files.
- B. The Replicat process reads the trail files that are made available by the Distribution Server.
- C. The Replicat process applies all committed changes to the target database.
- D. The Distribution Server accesses the trail files for a defined Path.
Answer: D
Explanation:
In Oracle GoldenGate Microservices Architecture, the Distribution Server does not access local trail files directly. Instead, it receives data from the Source Extract (or Data Pump) and sends it to the Receiver Server on the target.
NEW QUESTION # 94
What is a "trail" in GoldenGate?
- A. A series of files that store captured data
- B. A type of error log
- C. A link between Replicat and Extract
- D. A transport layer protocol
Answer: A
Explanation:
A trail is a series of files on disk where Oracle GoldenGate stores data for further processing.
NEW QUESTION # 95
Which database setting for the Oracle 19c database is required to enable Oracle GoldenGate?
- A. ENABLE_DATABASE_REPLICATION=true
- B. Configure the STREAMS_POOL_SIZE database parameter
- C. ENABLE_GOLDENGATE_REPLICATION=true
- D. ENABLE_STREAMS_REPLICATION=true
Answer: C
Explanation:
To enable Oracle GoldenGate in Oracle 19c, set ENABLE_GOLDENGATE_REPLICATION=TRUE, which allows the database to support GoldenGate features like Integrated Extract and Replicat.
NEW QUESTION # 96
A process group in GoldenGate is a collection of things associated with a specific GoldenGate Extract or Replicat process. Which of these is not an item in a GoldenGate process group?
- A. A parameter file
- B. A checkpoint file
- C. The Extract processes
- D. A checkpoint table for the Extract
Answer: D
Explanation:
? Checkpoint tables are used only for Integrated Replicat, not Extract. Extract uses checkpoint files, not tables. So, "A checkpoint table for the Extract" is not part of an Extract process group.
NEW QUESTION # 97
You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?
- A. You can configure integrated Replicat with two parallel apply servers.
- B. You can configure integrated Replicat ASSUMETARGETDEFS and SPECIALRUN parameters.
- C. You can configure integrated Replicat with SPECIALRUN parameter.
- D. You can configure integrated Replicat with two parallel child servers.
Answer: A
Explanation:
To increase parallelism and still preserve transaction atomicity, configure Integrated Replicat with multiple parallel apply servers (e.g., 2 or more). This allows Oracle GoldenGate to apply multiple transactions concurrently while maintaining their integrity.
NEW QUESTION # 98
Which components have been made redundant in Oracle GoldenGate 12.2 and later?
- A. Replicat
- B. Extract
- C. ASSUMETARGETDEFS
- D. SOURCEDEFS
Answer: C,D
Explanation:
From 12.2, ASSUMETARGETDEFS and SOURCEDEFS are no longer needed.
NEW QUESTION # 99
Which of these is a valid Replicat parameter in Oracle GoldenGate?
- A. SourceDefs
- B. PASSTHRU
- C. RmtHost
- D. DynamicPortList
Answer: A
Explanation:
Replicat with group name, database login parameters; SourceDefs or AssumeTargetDefs, DiscardFile, Map, and others. These can be found in the section titled "Replicat Parameter Categories."
NEW QUESTION # 100
What Oracle GoldenGate microservices component is used to support the issuing and processing of data and commands in a distributed deployment?
- A. Administration server
- B. Distribution server
- C. Processor server
- D. Service Manager
Answer: B
Explanation:
In Oracle GoldenGate Microservices, the Distribution Server is responsible for distributing data and commands across deployments in a distributed environment. It replaces the classic Data Pump and is designed for routing trail data efficiently to remote targets using secure paths.
NEW QUESTION # 101
Which of the following issues can prevent Replicat from advancing?
- A. The Extract name is incorrect
- B. The Stats Replicat command must be run
- C. The trail name is incorrect
Answer: C
Explanation:
An incorrect trail name stops Replicat from progressing.
NEW QUESTION # 102
Key names and values can be stored in:
- A. GLOBALS
- B. DefsFile
- C. SourceDefs
- D. ENCKEYS
Answer: D
Explanation:
ENCKEYS stores key-value pairs for encryption.
NEW QUESTION # 103
Users of both Extract and Replicat require the DBA role for the database.
- A. TRUE
- B. FALSE
Answer: B
Explanation:
Full DBA role is not mandatory for Extract or Replicat.
NEW QUESTION # 104
User exits can be used for tables processed by a data pump Extract in passthru mode.
- A. TRUE
- B. FALSE
Answer: B
Explanation:
User exits don't work in passthru mode (no transformation).
NEW QUESTION # 105
......
Latest Oracle 1Z1-947 Real Exam Dumps PDF: https://passleader.realexamfree.com/1Z1-947-real-exam-dumps.html
