QREP sample questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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.

Question 8

When configuring an Amazon S3 target endpoint, a user wants to ensure that data files are partitioned by the transaction commit date to optimize query performance in Amazon Athena. How can this be achieved in the endpoint settings?

Accepted Answer

In the endpoint's Advanced settings, under 'Partition Strategy', select 'Date Partitioning' and specify the desired format.

Answer

In the endpoint's General settings, specify a 'Target folder' path that includes date variables like `s3://bucket/data/YYYY/MM/DD/`.

Answer

Create a global transformation rule to add a 'commit_date' column and then use that column in the S3 object key.

Answer

This must be handled by an AWS Lambda function that triggers on S3 object creation to move files into partitioned folders.

Question 9

A Qlik Replicate task is failing with the error message: `[SOURCE_CAPTURE ] E: ORA-12899: value too large for column`. The target is a Unicode database, while the source is a non-Unicode database. The error occurs on a `VARCHAR2(50)` column. What is the most likely cause and the correct solution?

Accepted Answer

The source column contains multi-byte characters that expand when converted to Unicode, exceeding the target column's limit. The solution is to change the data type mapping for VARCHAR columns to be 3x larger on the target.

Answer

The source column contains multi-byte characters that expand beyond 50 bytes when converted to Unicode. The solution is to create a transformation to truncate the data to 50 bytes.

Answer

The Oracle source endpoint is misconfigured. The solution is to change the character set setting in the endpoint to match the target database.

Answer

A network device is corrupting the data in transit. The solution is to enable SSL encryption on the source and target endpoints.

Question 10

## Case Study A large insurance company, Global Secure Inc., is modernizing its data platform. They are migrating from a monolithic on-premises mainframe system to a cloud-based architecture on Microsoft Azure. Qlik Replicate is the core component for this migration. **Current Environment:** The source is a Db2 for z/OS database containing millions of policy and claims records. The data is highly sensitive and subject to strict regulatory compliance. The mainframe has limited processing windows for batch operations, making a prolonged outage for a bulk data export unacceptable. **Target Architecture:** The target consists of two endpoints. The primary target is Azure Synapse Analytics, which will serve as the enterprise data warehouse. A secondary target is an Azure Event Hubs topic, which will receive a real-time stream of claims data to feed a fraud detection application. All data in transit and at rest in Azure must be encrypted. **Requirements:** 1. Perform the initial load from Db2 to Azure Synapse with zero downtime for the source mainframe application. 2. Continuously replicate data changes from Db2 to both Azure Synapse and Azure Event Hubs. 3. Policyholder's Social Security Number (SSN), stored in a column named `PLCY_SSN`, must be masked with a constant value 'XXX-XX-XXXX' before it is written to Azure Synapse, but the raw SSN must be sent to Azure Event Hubs. 4. The solution must be centrally managed and monitored. Which design represents the most effective and compliant solution using Qlik Replicate and Qlik Enterprise Manager?

Accepted Answer

Create two separate tasks, both reading from the Db2 source. In the task for Azure Synapse, apply a column-level transformation to mask `PLCY_SSN`. Leave the task for Azure Event Hubs with no transformation. Manage both tasks using Qlik Enterprise Manager.

Answer

Create a single replication task with the Db2 source and both Azure Synapse and Azure Event Hubs as targets. Use a global transformation to mask the `PLCY_SSN` column.

Answer

Use a single task from Db2 to Azure Event Hubs. Then, use a second task to read from the Event Hubs topic, apply the masking transformation, and write to Azure Synapse.

Answer

Configure a single task from Db2 to Azure Synapse with masking enabled. Set up a database trigger in Azure Synapse to send unmasked data to Azure Event Hubs, which violates the requirement of masking before landing.

QREP Sample Questions & Answers

Case Study

Ready for the real thing?

QREP Sample Questions & Answers

Case Study

Related practice tests

Ready for the real thing?