QREP sample questions

Question 1

A financial services company is using Qlik Replicate to stream transactional data from an on-premises Oracle database to a Kafka topic. During a period of high market volatility, the replication task latency increases significantly, and the task eventually fails with 'out of memory' errors. The Replicate server has 64GB of RAM. Which configuration change is most likely to provide a stable, long-term solution for handling these data bursts?

Accepted Answer

Enable the 'Store changes on disk' option in the task's Change Processing Tuning settings.

Answer

Increase the 'Limit task memory size to (MB)' setting to the maximum available server RAM.

Answer

Switch the task from 'Batch optimized apply' to 'Transactional apply' mode.

Answer

Upgrade the Replicate server hardware to 128GB of RAM.

Question 2

An administrator is setting up a new Qlik Replicate environment and needs to define user roles based on the principle of least privilege. The requirements are to create a role for junior operators who can only monitor tasks and another role for developers who can design and run tasks but not manage server settings or users. Which set of permissions correctly maps to these requirements?

Accepted Answer

Operators: Monitor; Developers: Designer and Operator

Answer

Operators: Viewer; Developers: Administrator

Answer

Operators: Viewer; Developers: Designer

Answer

Operators: Monitor; Developers: Administrator

Question 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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.

Top vendors

Top exams

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