QREP sample questions

Question 1

A replication task from SQL Server to Snowflake has failed. The task log shows a primary key violation error for a specific table. The administrator queries the `attrep_apply_exceptions` table and finds an entry corresponding to the failure. The `OPERATION` column for the failed record shows 'U' (Update). What is the most probable cause of this issue?

Accepted Answer

The source record was deleted and re-inserted with the same primary key before the original DELETE operation was applied to the target.

Answer

The target table in Snowflake was created without a primary key constraint.

Answer

A previous Full Load for this table failed, leaving the target table empty.

Answer

The source table's supplemental logging was not correctly configured for UPDATE operations.

Question 2

An architect is designing a data replication solution for a retail company. The primary requirement is to replicate sales data from 20 regional PostgreSQL databases to a central Amazon S3 data lake. The data must be transformed to a standardized Parquet format, and personally identifiable information (PII) like customer names and addresses must be masked using a SHA-256 hash function before being written to the target. What is the most efficient way to implement this PII masking requirement for all 20 tasks?

Accepted Answer

Define a Global Transformation rule that applies a hashing expression to columns with specific names (e.g., 'CUST_NAME', 'ADDRESS_LINE1') across all tasks.

Answer

Create a column-level transformation using the expression editor in each of the 20 individual tasks.

Answer

Use an external transformation script triggered by a notification service after the data lands in S3.

Answer

Configure the Amazon S3 target endpoint to use server-side encryption with a customer-managed key.

Question 3

A Qlik Replicate task is configured with 'Store Changes' to create change tables in a staging database. A separate 'Apply Changes' task then reads from these change tables to update a data warehouse. This two-task architecture has been chosen to decouple data capture from data application. If the 'Apply Changes' task fails repeatedly due to a data type mismatch, what is the correct operational procedure to resolve the issue without losing the captured changes?

Accepted Answer

Keep the 'Store Changes' task running, stop the 'Apply Changes' task, correct the transformation causing the mismatch, and resume the 'Apply Changes' task.

Answer

Stop both tasks, drop the change tables, and restart the 'Store Changes' task from a specific timestamp.

Answer

Stop both tasks, fix the transformation in the 'Apply Changes' task, then perform a full reload on both tasks.

Answer

Modify the target data warehouse table schema directly, then restart the 'Apply Changes' task from the beginning of the change table.

Question 4

A deployment requires replicating data between two data centers with an unreliable, high-latency WAN link. The architect wants to minimize the impact of network disruptions on the source database. Which TWO Qlik Replicate features are most critical to configure in this scenario? (Select TWO)

Accepted Answer

Enable compression on the Replicate server.

Accepted Answer

Configure 'Store changes on disk' in Change Processing Tuning.

Answer

Set Change Processing Mode to 'Transactional apply'.

Answer

Increase the number of apply streams on the target endpoint.

Answer

Use a File Channel target endpoint as an intermediary.

Question 5

True or False: When using Qlik Enterprise Manager to manage multiple Qlik Replicate servers, all servers must be running the exact same version and patch level of Qlik Replicate.

Accepted Answer

False

Answer

True

Question 6

A government agency is using Qlik Enterprise Manager (QEM) to provide a central dashboard for monitoring replication tasks across different departments. A new requirement mandates that all actions performed through the QEM console, such as starting a task or modifying an endpoint, must be logged for auditing purposes. Where should an administrator configure this?

Accepted Answer

In the QEM Server Settings, under the 'Audit Log' section.

Answer

In the individual Qlik Replicate server settings for each registered server.

Answer

By configuring a Log Stream on each Qlik Replicate server to forward logs to a central syslog server.

Answer

In the user role definitions by enabling an 'Audit' permission for each user.

Question 7

A task replicating a large table with LOB columns from Oracle to SQL Server is performing poorly during the Full Load phase. A review of the task logs shows significant time spent on LOB lookups. The source Oracle database is configured for log-based CDC. What is the most effective way to improve the Full Load performance for this table?

Accepted Answer

In the Oracle source endpoint's Advanced settings, enable the 'Expose LOBs in Redo' option.

Answer

Increase the 'LOB chunk size (KB)' in the source endpoint settings.

Answer

In the task's Full Load Tuning settings, select the 'Create primary key or unique index after loading' option.

Answer

Change the Full Load method from 'Parallel load' to 'Single thread'.

Question 8

A consultant is tasked with collecting detailed diagnostic information for a failing Qlik Replicate task to send to Qlik Support. The task fails intermittently, and the standard task logs do not contain enough detail to identify the root cause. What is the recommended procedure to capture the most comprehensive diagnostic data?

Accepted Answer

From the Replicate UI, select the task and use the 'Download Diagnostic Package' option while the task is in a failed state.

Answer

Stop the task, enable all logging components to 'Verbose' in the task settings, restart the task, and then export the task logs after the next failure.

Answer

Manually copy the contents of the `...\data\tasks\[TaskName]\logs` directory and the `repsrv.log` file from the Replicate server.

Answer

Enable trace logging for the source and target endpoints, reproduce the failure, and then collect the generated trace files.

Question 9

A manufacturing company uses Qlik Replicate to move production data from a legacy DB2 system to a modern PostgreSQL database for reporting. During a maintenance window, a schema change is applied to a source table: a new nullable column `LAST_UPDATED_BY` is added. The replication task for this table is currently stopped. What is the operational procedure to apply this schema change to the target with minimal disruption?

Accepted Answer

In the task's Table Settings, select the table and click 'Reload Table'. Replicate will detect the schema change and propagate it to the target before resuming CDC.

Answer

Perform a full reload of the specific table.

Answer

Manually add the column to the target table, then resume the task.

Answer

In the task's Table Settings, select the table, click 'Reload Table', and choose the 'Apply DDL changes to target' option.

Question 10

An organization has deployed Qlik Replicate on a Windows Server. To comply with security policies, the Qlik Replicate Server and Qlik Replicate UI services must run under a specific domain service account instead of the default Local System account. Which TWO steps are required to correctly configure this? (Select TWO)

Accepted Answer

Use the Windows Services console to change the 'Log On As' account for both Qlik Replicate services.

Accepted Answer

Grant the service account 'Full Control' permissions to the Qlik Replicate installation and data directories.

Answer

Add the service account to the 'Administrators' user group in the Replicate UI.

Answer

Modify the `users.json` file in the data directory to specify the new service account.

Answer

Run the `repctl` command-line utility with a `set service_account` parameter.

Free QREP sample questions

A deployment requires replicating data between two data centers with an unreliable, high-latency WAN link. The architect wants to minimize the impact of network disruptions on the source database. Which TWO Qlik Replicate features are most critical to configure in this scenario? (Select TWO)

True or False: When using Qlik Enterprise Manager to manage multiple Qlik Replicate servers, all servers must be running the exact same version and patch level of Qlik Replicate.

10 more free samples are waiting