QREP practice question 3 of 15
A Qlik Replicate administrator is working on a database where the column names in a source endpoint are too long and exceed the character limit for column names in the target endpoint. How should the administrator solve this issue?
Full set: 60 questionsGlobal Transformations in Qlik Replicate are designed to apply a single rule to multiple tables within a task, making it the most efficient method for widespread changes. To address excessively long column names, an administrator can create a "Rename Column" transformation. This rule can be configured to apply to all tables (or a subset matching a pattern) and rename columns based on specified criteria, such as using a function to truncate the name, thereby solving the issue systematically without manual, table-by-table intervention.
A. Qlik Replicate management is primarily performed through its user interface. While command-line utilities exist, a renamecolumn command for bulk updates is not the standard or recommended procedure for this task.
B. While the Transform tab in Table Settings can rename columns, this approach is inefficient as it must be applied manually to each affected column in every single table, which is not scalable.
C. The Filter tab is used for filtering rows (records) based on data conditions, not for renaming or transforming column metadata. This option is functionally incorrect for the stated problem.
1. Qlik Replicate User Guide (November 2023), "Transforming data on the fly," Page 219, Section: "Global transformations". This section states, "Global transformations allow you to apply transformation rules to multiple tables in a task... This is especially useful when you need to apply the same rule to many tables."
2. Qlik Replicate User Guide (November 2023), "Defining global transformations," Page 221, Section: "Rename column". This section details the procedure for creating a global rule to rename columns, confirming it as a primary feature. It describes how to select the schema, table, and column(s) to be renamed, supporting the application of a single rule across multiple objects.
3. Qlik Replicate User Guide (November 2023), "Defining transformations for a single table," Page 239, Section: "The Transform tab". This section describes the per-table transformation process, which corroborates why option B is less efficient for a task-wide issue. It states, "You can add, remove, and modify columns in a specific table."
Keep practicing
Take the free QREP practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other QREP practice questions
- Question 1An operative database can only commit two engines to Qlik Replicate (or initial loads at …
- Question 2Which types of notifications can be set up in Qlik Replicate?
- Question 4A Qlik Replicate administrator is replicating data from a source system with some columns…
- Question 5Which files can be exported and imported to Qlik Replicate to allow for remote backup, mi…
- Question 6A Qlik Replicate administrator will use Parallel load during full load Which three ways d…
- Question 7What is the directory for the ODBC drivers in Qlik Replicate?
