Question 1

An operative database can only commit two engines to Qlik Replicate (or initial loads at any given time. How should the task settings be modified?

Accepted Answer

C

Explanation: To manage the load on a source database during an initial load, Qlik Replicate provides a specific setting to control concurrency. The "Maximum number of tables to load in parallel" option, located within the task's "Full Load Settings" (specifically on the Tuning tab), dictates how many concurrent processes, or "engines," Replicate will use. By default, this is set to five. To comply with the operative database's limitation of two concurrent engines, this setting must be modified to '2'. This ensures that Replicate does not overwhelm the source system, allowing the initial load to proceed without causing performance degradation or connection failures on the source.

Question 2

Which types of notifications can be set up in Qlik Replicate?

Accepted Answer

C

Explanation: Qlik Replicate provides a comprehensive notification system that allows administrators to monitor the health and status of the replication environment at three distinct levels. These are: 1. Server Events: Pertain to the overall Qlik Replicate server, such as license expiration, high memory usage, or disk space issues. 2. Task Events: Relate to the status of individual replication tasks, including events like a task starting, stopping, or encountering an error. 3. Endpoint Events: Concern the connectivity and status of source and target endpoints, such as connection failures. Configuring alerts for all three categories is crucial for proactive monitoring and management.

Question 3

Where are the three options in Qlik Replicate used to read the log files located? (Select three.)

Accepted Answer

Explanation: In Qlik Replicate, the options to read the log files are located in the following places: In Diagnostic package (B): The diagnostic package in Qlik Replicate includes various log files that can be used for troubleshooting and analysis purposes1. In Data directory of Installation (D): The log files are written to the log directory within the data directory. This is the primary location where Qlik Replicate writes its log files, and it is not possible to change this location2. In Monitor of Qlik Replicate (E): The Monitor feature of Qlik Replicate allows users to view and manage log files. Users can access the Log Viewer from the Server Logging Levels or File Transfer Service Logging Level sub-tabs1. The other options provided do not align with the locations where log files can be read in Qlik Replicate: A . In Windows Event log: This is not a location where Qlik Replicate log files are stored. C . In External monitoring tool: While external monitoring tools can be used to read log files, they are not a direct feature of Qlik Replicate for reading log files. F . In Enterprise Manager: The Enterprise Manager is a separate component that may manage and monitor multiple Qlik Replicate instances, but it is not where log files are directly read. Therefore, the verified answers are B, D, and E, as they represent the locations within Qlik Replicate where log files can be accessed and read21.

Question 4

A Qlik Replicate administrator is replicating data from a source system with some columns with large PDFs. Which data type should be used?

Accepted Answer

D

Explanation: PDFs are binary files, not text. The appropriate data type for storing large binary data, such as documents, images, or multimedia files, is a BLOB (Binary Large Object). Qlik Replicate is designed to handle LOB data types to efficiently replicate large, unstructured data. Using a BLOB column ensures that the binary integrity of the PDF file is maintained during replication from the source to the target system. Character-based data types like NCLOB or NVARCHAR would lead to data corruption as they are designed to handle text, not binary streams.

Question 5

Which files can be exported and imported to Qlik Replicate to allow for remote backup, migration, troubleshooting, and configuration updates of tasks?

Accepted Answer

D

Explanation: Qlik Replicate uses JSON (JavaScript Object Notation) files to export and import task definitions. This feature is fundamental for administrative operations such as creating backups, migrating tasks between different Replicate servers, or sharing task configurations with Qlik Support for troubleshooting. The exported JSON file encapsulates all the necessary task settings, including source and target endpoint configurations, table selections, and transformation rules, allowing for a complete and portable representation of the task.

Question 6

Which two endpomts have ARC (Attunity Replicate Connect) CDC (Change Data Capture) agents? (Select two )

Accepted Answer

Explanation: Questions no: 17 Verified Answer: = A. IBM IMS & E. HP NonStop Explanation: Step by Step Comprehensive and Detailed Explanation with all Reference: = ARC (Attunity Replicate Connect) CDC agents are used for capturing changes (CDC) and can be utilized with both relational and non-relational endpoints supported by ARC. The endpoints that have ARC CDC agents include: IBM IMS (A): This is a database and transaction management system, and it is listed as one of the endpoints supported by ARC CDC agents1. HP NonStop (E): This is a platform for high-availability servers and is also supported by ARC CDC agents1. The other options provided do not align with the endpoints that have ARC CDC agents: B . IBMDB2Z/OS: While DB2 for z/OS is a common database system, it is not mentioned in the context of ARC CDC agents. C . Kafka Source: Kafka is a streaming platform, and while it can be an endpoint for data, it is not listed as having ARC CDC agents. D . SAPHANA: SAP HANA is an in-memory database, and it is not specified as having ARC CDC agents. Therefore, the verified answers are A. IBM IMS and E. HP NonStop, as they are the endpoints that utilize ARC CDC agents for capturing changes1.

Question 7

What is the directory for the ODBC drivers in Qlik Replicate?

Accepted Answer

C

Explanation: The Qlik Replicate bin directory is the designated location for binary executables and required dynamic-link libraries (DLLs), which include ODBC drivers. To ensure that the Qlik Replicate server can locate and load the necessary 64-bit drivers for establishing a connection to an ODBC-based endpoint, the driver files must be placed in the \bin folder. This is a standard prerequisite for configuring many database endpoints that rely on ODBC connectivity.

Question 8

Which is the possible Escalate Action for Table Errors?

Accepted Answer

B, C, D

Explanation: In Qlik Replicate, the "Table Errors" handling settings allow for an escalation action to be triggered after a specified number of retries fail. The user can configure one of three possible actions: Stop task (the default action), which halts the entire replication task; Suspend table, which stops replication only for the table that encountered the error while others continue; or No action, which allows the task to continue running without stopping or suspending. All three are valid, configurable options for escalating a table error.

Question 9

Which is the command to export the task, task name Oracle_2_SS_Target1 using REPCTL?

Accepted Answer

A

Explanation: The repctl utility is a command-line interface for managing Qlik Replicate. To export a repository object, such as a task, the correct command is exportrepository. This command requires specifying the object type and its name. The correct syntax to specify a task is using the argument task= . Therefore, the complete and accurate command to export the specified task is repctl exportrepository task=Oracle2SSTarget1. Note that repct1 in the options is a common typo for repctl.

Question 10

Which is the path to add a new column to a single table in a task?

Accepted Answer

C

Explanation: To add a new column to a single table within a Qlik Replicate task, the user must first navigate to the Table Selection tab. From there, the specific table is selected, and the Transform settings for that table are opened. Inside the Transform tab, the user can then use the "Add Column" function to define the new column, its data type, and an expression to populate its value. This process ensures the transformation is applied only to the selected table.

Question 11

Which are valid source endpoint types for Qlik Replicate change processing (CDC)? (Select two )

Accepted Answer

A, C

Explanation: Qlik Replicate is fundamentally designed for Change Data Capture (CDC) from transactional systems. Its core capability is capturing changes from the transaction logs of classic Relational Database Management Systems (RDBMS) like Oracle, SQL Server, and PostgreSQL. This allows for low-latency, low-impact data replication. Additionally, Qlik Replicate provides specialized connectors for enterprise applications, most notably SAP. It can capture changes from SAP systems using various methods, including database-level CDC (for SAP on HANA, Oracle, etc.) and application-level extraction via SAP Extractors, which is a supported method for change processing.

Question 12

In the CDC mode of a Qlik Replicate task, which option can be set for Batch optimized apply mode?

Accepted Answer

C

Explanation: In Qlik Replicate's CDC (Change Data Capture) mode, the "Batch optimized apply" method is designed to enhance performance by grouping multiple individual changes into a single transaction before applying them to the target. The task can be configured to apply these batches based on two primary triggers that work in tandem: a time interval and data volume. The batch is applied whenever the specified time limit is reached OR the accumulated size of the change data reaches the defined volume threshold, whichever occurs first. This provides a flexible way to balance throughput and latency.

Question 13

How can a source be batch-loaded automatically on a daily basis?

Accepted Answer

A

Explanation: Qlik Replicate provides a built-in server-level Scheduler to automate task execution. This feature is specifically designed for scenarios like daily batch loads. Users can configure a task to run on a recurring schedule (e.g., daily, weekly) at a predefined time. This is the standard and officially supported method for automating periodic full load tasks. The Scheduler is accessed from the main Tasks view toolbar, where it can be applied to one or more selected tasks.

Question 14

The Qlik Replicate developer notices that errors occur about the duplicate key when applying INSERT. Which should be done in order to identify this Issue?

Accepted Answer

A

Explanation: The Apply Exceptions control table (attrepapplyexceptions) is the designated mechanism within Qlik Replicate for logging records that fail to be applied to the target database. When an INSERT operation fails due to a "duplicate key" error, Replicate captures the entire failed record, the operation type, the time of the error, and the specific error message from the target database. By querying this table, the developer can directly identify the exact row and data that caused the conflict, which is the essential first step in diagnosing the root cause of the issue.

Question 15

Where should Qlik Replicate be set up in an on-premises environment?

Accepted Answer

C

Explanation: The performance of Qlik Replicate is most critically impacted by network latency between the Replicate server and the source database. The Change Data Capture (CDC) process requires continuous and rapid reading of the source system's transaction logs. To ensure the highest efficiency and minimize delays in capturing data changes, the Replicate server must have the lowest possible latency to the source. Placing it on the same local area network (LAN) as the source database is the standard best practice. While the connection to the target is also important, applying batched changes is generally less sensitive to latency than the initial log-reading and capture process.

Free Qlik QREP Actual Exam Questions