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.

A. "Apply Change Processing Tuning" settings relate to the ongoing Change Data Capture (CDC) phase, not the initial Full Load phase specified in the question.

B. This statement is factually incorrect. By default, Qlik Replicate loads multiple tables (typically five) in parallel to optimize the speed of the Full Load.

D. While the setting is in a "Tuning" sub-section, the primary configuration area is "Full Load Settings". Option C provides a more accurate high-level description of the required action.

1. Qlik Replicate User Guide (May 2023), Section: Task settings > Full Load settings > Tuning tab. The documentation states: "Maximum number of tables to load in parallel: The maximum number of tables that Qlik Replicate can load in parallel from the source database. The default is 5... You may want to decrease this value... if the source system is overloaded." This directly confirms that limiting the number of parallel table loads is the correct method to manage source system constraints. (Accessed via Qlik Help Portal).

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.

B. exporttask is not a valid command within the repctl utility. The correct command for exporting any repository object is exportrepository.

C. export is an incomplete and invalid command. Additionally, the syntax task-Oracle2SSTarget1 is incorrect for specifying the task name.

D. exporttask is not a valid command in the repctl utility. The correct command is exportrepository.

1. Qlik Replicate User Guide (November 2023), "Managing Replicate using commands" -> "repctl command syntax" -> "Repository commands". The documentation explicitly lists exportrepository as the command for exporting repository objects. The syntax provided is: repctl exportrepository [jsonfile=] [collection=] [task=] [noct=] [nopasswords=]. This confirms that task= is the correct argument for specifying a task. (Reference available via the official Qlik Help portal).

The diagnostic package for a specific Qlik Replicate task is a crucial tool for troubleshooting. It bundles task-specific logs, settings, and status information into a single downloadable file. The correct procedure to access this is by first opening the task to enter its detailed Monitor view. From the toolbar within this view, the Tools menu provides access to advanced options, including the Support submenu, which contains the Download Diagnostic Package command.

B. The 'Run' button is an action command to start a task; it does not provide access to a 'Tools' menu for diagnostics.

C. 'Server settings' are for global server configuration and logging levels, not for downloading diagnostic packages for individual tasks.

D. Right-clicking a task from the main overview screen provides primary actions like Run, Stop, and Monitor, but not a direct option to download diagnostics.

1. Qlik Replicate User Guide (May 2023). In the section "Monitoring Tasks", subsection "Using the task tools", the procedure is explicitly outlined: "In Monitor view, click the Tools button and then select one of the following options from the drop-down menu: ... Support > Download Diagnostic Package: Downloads a zip file containing the task logs and the task settings." (Page 161).

2. Qlik Help - Replicate (May 2023). The online documentation under the topic "Monitoring tasks" details the user interface elements. It describes the path via the Monitor view's toolbar: "Click the Tools button and then select one of the following options... Support > Download Diagnostic Package". This confirms the navigation path is through the task's monitor interface.

Qlik Replicate's core functionality for near real-time data replication is Change Data Capture (CDC). The primary method for CDC involves non-intrusively reading the source database's native transaction logs (e.g., Redo Logs in Oracle, Transaction Log in SQL Server, Write-Ahead Log in PostgreSQL). This allows Replicate to capture INSERT, UPDATE, and DELETE operations as they occur without placing significant load on the source system. Therefore, providing Replicate with the necessary permissions and access path to these logs is a fundamental prerequisite for configuring most transactional database source endpoints, in addition to standard connectivity credentials.

A. Database client: This is a component required to establish the connection itself and is implicitly part of setting up a valid "connection string".

B. File access: This is too generic. While some log access methods might require direct file system permissions, the essential requirement is access to the log data, which can be achieved via various database-specific APIs or functions.

D. Access to database server: This is a basic prerequisite for using a connection string and credentials to connect to the database; it is not a distinct, additional element.

1. Qlik Replicate Documentation - Setting up Oracle as a source: The official documentation states, "To enable Qlik Replicate to capture changes, the user specified in the Oracle endpoint settings must be granted the required privileges." It then lists specific privileges required for "Access to the online and archived redo logs," which are Oracle's transactional logs.

Source: Qlik Help Portal, Qlik Replicate Documentation, "Prerequisites for using Oracle as a source," Section: "Required permissions."

2. Qlik Replicate Documentation - Setting up Microsoft SQL Server as a source: The documentation specifies permissions needed for different log access methods. For the Transaction Log Access method, it states, "The following permissions are required when accessing the transaction logs..." and lists permissions such as VIEW SERVER STATE and dbowner. This directly links endpoint setup to transactional log access.

Source: Qlik Help Portal, Qlik Replicate Documentation, "Prerequisites for using Microsoft SQL Server as a source," Section: "Required permissions for accessing the transaction logs."

3. Qlik Replicate Documentation - Change Data Capture Concepts: The general product documentation explains the underlying mechanism: "During CDC, Qlik Replicate reads the database transaction logs... When Qlik Replicate is started, it reads the transaction log from the time of the last successfully processed transaction..." This establishes that log reading is central to the product's operation.

Source: Qlik Help Portal, Qlik Replicate Documentation, "Using Change Data Capture (CDC)," Section: "How does CDC work?"

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.

A. Placing Replicate near the target introduces high latency to the source, which severely degrades the performance of the transaction log reading process.

B. A "middle" location is a poor compromise, as it introduces unnecessary network latency to the most critical connection (the source).

D. For an on-premises source, a cloud installation introduces significant WAN latency, which is the primary factor to be avoided for the CDC process.

1. Qlik Replicate for Windows Installation and Setup Guide: In the "Deployment considerations" section, the guide explicitly states: "The Replicate machine should be located as close as possible to the source database (i.e. on the same LAN) to minimize latency." (Qlik Replicate November 2023, Installation and Setup Guide, Page 11).

2. Qlik Replicate User Guide: The "Architectural Overview" describes how Qlik Replicate reads change data directly from the source endpoint's transaction logs. This log-based CDC mechanism is highly sensitive to network round-trip time, reinforcing the need for close proximity to the source to maintain performance and low replication latency. (Qlik Replicate November 2023, User Guide, Chapter: "Getting Started", Section: "Architectural Overview").

Qlik Replicate’s transformation engine is SQLite-based; therefore any computed column can use SQLite date/time functions.

The SQLite/Replicate function

strftime('%s', )

returns “the number of seconds since 1970-01-01 00:00:00 UTC”, i.e., Unix epoch time.

Option D uses exactly that call against the source column SARHCOMMITTIMESTAMP; the second term strftime('%s','1970-01-01 00:00:00') evaluates to 0, so the subtraction leaves the epoch value unchanged. Hence D correctly converts the stored timestamp to Unix time.

A. Uses incorrect datetime syntax and compares values; does not call strftime nor return epoch seconds.

B. datetime(,'localtime','unixepoch') converts FROM epoch TO human time, the opposite direction.

C. Mixes SQLite strftime with Python datetime; invalid in Replicate expression engine.

E. Ruby-style Time.now … not recognized by Qlik Replicate/SQLite expressions.

1. Qlik Replicate and Compose – “Functions and Expressions Guide”, May 2023, Section “Date/Time Functions”, p. 37: “strftime('%s', timestring) → seconds since 1970-01-01”.

2. Qlik Replicate Help (August 2023) – Topic “Using SQLite functions in transformations”, example 3 “Convert timestamp to Unix epoch with strftime('%s', column)”.

3. SQLite Documentation, langdatefunc.html, paragraph “strftime”: “%s … returns seconds since 1970-01-01 00:00:00 UTC” (retrieved 2025-11-26).

Qlik Enterprise Manager (QEM) employs a hierarchical permission structure. Permissions are assigned to users or groups for specific servers (e.g., a Qlik Replicate Server) that are managed by QEM. By default, all tasks ("functions") configured on that server automatically inherit the permissions assigned at the server level. This model simplifies administration by allowing global settings, while also offering the flexibility to override permissions for individual tasks when necessary. The core concept is the inheritance of permissions from a parent object (the server) to child objects (the tasks).

A. Qlik Enterprise Manager has its own independent security model; it does not use the same permission system as Qlik Replicate.

B. Permissions are defined and assigned directly within Qlik Enterprise Manager; there is no function to "transfer rights" from a Replicate instance.

D. QEM's permission model is centralized and distinct; it does not use a combined permission set from both Qlik Replicate and Qlik Compose.

---

1. Qlik Enterprise Manager User Guide, May 2023. In the "Security" chapter, the subsection "Managing server permissions" explicitly states: "By default, all tasks on a server inherit the server permissions. If you want a specific task to have different permissions than the server it is running on, you can override the inherited permissions and set task-specific permissions." This directly confirms the principle of inherited permissions.

2. Qlik Enterprise Manager User Guide, May 2023. The "Managing user permissions" section details the permission levels (Viewer, Operator, Designer, Administrator) that can be assigned. These levels are applied within the QEM framework and are subject to the inheritance model described, demonstrating that QEM has its own permission system, separate from the products it manages.

In a Qlik Replicate Full Load task, the replication process is handled by two primary components. The SOURCEUNLOAD component is responsible for reading the data in bulk from the source endpoint. It then transfers this data to the TARGETLOAD component, which is responsible for writing the data to the target endpoint. These two components work in tandem to perform the initial, complete synchronization of the source tables to the target.

B. TARGETAPPLY: This component is used during the Change Data Capture (CDC) phase to apply cached changes (inserts, updates, deletes) to the target, not during the initial Full Load.

C. TARGETUNLOAD: This is not a standard component in the context of writing data to a target. Unloading is an action performed on a source system.

D. SOURCECAPTURE: This component is responsible for capturing ongoing data changes from the source transaction logs for CDC, which is a separate process from the Full Load.

1. Qlik Replicate User Guide (November 2023): In the section "The replication process," under the subsection "Full Load replication," the guide states: "The SOURCEUNLOAD component reads the data from the source endpoint and transfers it to the TARGETLOAD component, which writes the data to the target endpoint." (Page 41)

2. Qlik Replicate User Guide (November 2023): The same guide, in the section "Change Data Capture (CDC)," clarifies the roles of other components: "The SOURCECAPTURE component captures the changes from the source endpoint... The TARGETAPPLY component applies the changes to the target endpoint." This distinguishes them from the Full Load components. (Page 42)

When a Data Definition Language (DDL) change, such as adding a new column, is executed on a source table, Qlik Replicate captures this event. To correctly apply this structural change to the target table, the task must be stopped and then resumed. This process forces Qlik Replicate to re-cache the table's metadata from the source endpoint. Upon resuming, Replicate will apply the pending DDL change (e.g., ALTER TABLE ... ADD COLUMN) to the target and then continue with the Change Data Capture (CDC) process from where it left off.

B. Stop task, enableCT tables, and resume: Change Tables (CT) are used for specific CDC processing modes like Batch Optimized Apply and are not relevant to propagating DDL changes.

C. Change the DDL Handling Policy to accommodate this change: This is a one-time configuration setting that defines how DDL is handled (e.g., replicate, ignore). It is not the operational step taken to apply a specific DDL change that has already occurred.

D. Stop and reload the task: A full reload is an inefficient and unnecessary action for this scenario. It involves truncating the target table and re-copying all data, whereas a simple resume operation applies only the structural change.

1. Qlik Replicate User Guide (May 2023), Section: DDL and CDC > DDL change handling. The documentation states, "When a DDL change is made to a source table, Replicate applies the change to the target table. In some cases, you may need to stop and then resume the task for the DDL change to be applied." This confirms that a stop/resume cycle is a standard procedure for certain DDL operations.

2. Qlik Replicate User Guide (May 2023), Section: Task Settings > DDL. This section describes the DDL handling policies. It clarifies that setting the policy is a configuration step, distinct from the operational step of applying a captured DDL change. The default policy is typically to replicate DDL changes, which would necessitate the stop/resume action described in option A.

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.

B. Set trigger through Advanced Run options: Advanced Run options are used to control a single, specific execution of a task, such as starting from a particular timestamp, not for creating a recurring schedule.

C. Set trigger through Task Designer: The Task Designer is where the task's components (endpoints, table selection, transformations) are defined, but it does not contain settings for scheduling execution.

D. Enable task on full load and apply changes: This describes the manual process of starting a one-time full load. It is not an automated or recurring process.

1. Qlik Replicate User Guide (May 2023): In the section "Working with Tasks," subsection "Scheduling a task," page 101, the guide states, "You can schedule a task to start automatically at a predefined time or to run on a recurring basis. This is useful for Full Load only tasks that need to run periodically (e.g. every night)." It details using the "Scheduler" button from the main task view.

2. Qlik Help Portal - Qlik Replicate: The online documentation for "Scheduling a task" explicitly describes the process: "In the main Tasks view, select the task(s) you want to schedule and then click the Scheduler button in the toolbar." This confirms scheduling is a server-level function, not an option within the task designer or advanced run settings. (Accessed via help.qlik.com for Qlik Replicate).