QREP practice question 11 of 15

Which are valid source endpoint types for Qlik Replicate change processing (CDC)? (Select two )

Full set: 60 questions
Answer options
A: Classic Relational RDBMS Correct answer
B: MS Dynamics direct access
C: SAP ECC and Extractors Correct answer
D: Generic REST APIs Data Lake file formats
Correct Answer:
A. Classic Relational RDBMS; C. SAP ECC and Extractors
Explanation

Qlik Replicate is fundamentally designed for Change Data Capture (CDC) from transactional systems. Its core capability is capturing changes from the transaction logs of classic Relational Database Management Systems (RDBMS) like Oracle, SQL Server, and PostgreSQL. This allows for low-latency, low-impact data replication. Additionally, Qlik Replicate provides specialized connectors for enterprise applications, most notably SAP. It can capture changes from SAP systems using various methods, including database-level CDC (for SAP on HANA, Oracle, etc.) and application-level extraction via SAP Extractors, which is a supported method for change processing.

Why Incorrect

B. MS Dynamics direct access: Qlik Replicate does not offer a native source endpoint for MS Dynamics that supports log-based or trigger-based CDC for change processing.
D. Generic REST APIs Data Lake file formats: These are not transactional sources suitable for CDC. While Replicate can read files, this is for full loads, not for capturing real-time changes as they occur.

References

1. Qlik Replicate Documentation - Sources: The official documentation lists supported sources. The sections for "Microsoft SQL Server source," "Oracle source," and others confirm CDC support for RDBMS.

Source: Qlik Help. (2023). Qlik Replicate November 2023 User Guide. Section: "Working with sources".

2. Qlik Replicate Documentation - SAP as a Source: The documentation explicitly details the methods for capturing data from SAP ECC, including CDC via SAP Extractors.

Source: Qlik Help. (2023). Qlik Replicate November 2023 User Guide. Section: "Working with sources > SAP Application source". Paragraph: "Qlik Replicate supports change data capture (CDC) from SAP Extractors."

3. Qlik Replicate Supported Platforms: The official support matrix (PAM - Product Availability Matrix) for Qlik Replicate confirms the specific versions of RDBMS and SAP systems that are validated as CDC sources, while omitting MS Dynamics, REST APIs, and file formats as CDC sources.

Source: Qlik Community. (2023). Qlik Replicate - Supported Platforms. Document: "QlikReplicate-November2023-Supported-Platforms.pdf". Sections: "Replicate Source Endpoints".

Scroll to Top