Free QREP sample questions
The free QREP sample questions on this page come with answers and explanations. They cover endpoint and task design, log-based troubleshooting and server administration. Use them to check your Replicate skills before the exam.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
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)
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?
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?
## 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?
A Qlik Replicate task uses Batch optimized apply mode. What is the primary purpose of the 'Force apply a batch when processing a DDL' option in the task's error handling settings?
True or False: The Qlik Replicate Log Stream feature allows forwarding of server-level logs but not task-specific logs to an external monitoring system.
A replication task from MySQL to a file-based target on a network share is experiencing intermittent failures with 'access denied' errors when writing files. The Qlik Replicate service runs as Local System. The network share has granted 'Full Control' to the machine account of the Replicate server (e.g., `DOMAIN\REPSRV$`). What is the most likely cause of the failure?
When designing a task to replicate data to a data warehouse, an architect must decide on the method for handling deleted records from the source. The business requirement is to keep a historical record of all rows ever present in the source system, marking them as 'inactive' in the target rather than physically deleting them. Which feature should be used to achieve this?
## Case Study PharmaCore, a pharmaceutical research company, uses Qlik Replicate to consolidate clinical trial data from various global sites into a central SQL Server database. Each site has its own PostgreSQL database. A new regulation requires an immutable audit trail of all data changes. **Current Setup:** 50 individual Qlik Replicate tasks, one for each research site's PostgreSQL database, replicate data to the central SQL Server. The tasks run in 'Batch optimized apply' mode for performance. **New Requirement:** For every INSERT, UPDATE, and DELETE operation on the source tables, a corresponding record must be created in a set of 'audit' tables in the central database. These audit tables should store the before and after images of the data, the operation type, commit timestamp, and the transaction ID. The solution must not significantly impact the performance of the existing replication to the primary tables. **Constraints:** The source PostgreSQL databases cannot be modified. The solution should be implemented within the existing Qlik Replicate environment. How should the architect design the solution to meet the new audit trail requirement? graph TD subgraph Site A PG1[PostgreSQL DB] end subgraph Site B PG2[PostgreSQL DB] end subgraph ... PG_N[...] end subgraph Central Data Center RepSrv[Qlik Replicate Server] SQL_DB[SQL Server] end PG1 --> RepSrv PG2 --> RepSrv PG_N --> RepSrv RepSrv --> SQL_DB
10 more free samples are waiting
Create a free account to unlock the whole QREP sample bank, or get full access to all 246 practice questions in the simulator.