QREP practice question 10 of 15
Which is the path to add a new column to a single table in a task?
Full set: 60 questionsTo add a new column to a single table within a Qlik Replicate task, the user must first navigate to the Table Selection tab. From there, the specific table is selected, and the Transform settings for that table are opened. Inside the Transform tab, the user can then use the "Add Column" function to define the new column, its data type, and an expression to populate its value. This process ensures the transformation is applied only to the selected table.
A. Table Selection -> Schemas -> Add Column: This path is incorrect. Schema-level operations are managed differently and do not involve adding a column to a single, specific table in this manner.
B. New Transformation -> Column -> Add Column: This describes the process for creating a global transformation, which would apply the new column to all tables in the task, not a single table as specified.
D. Table Settings -> General -> Add New Column: The General tab within a table's settings is used for defining properties like the target table name and schema, not for adding or transforming columns.
1. Qlik Replicate User Guide (May 2023): In the section "Defining transformations on a single table," the procedure is outlined. It states: "In the Table Selection tab, select the table that you want to transform. The Transform button will be enabled above the list of tables. Click Transform to open the Transform tab for the selected table... To add a column to the table, click the Add Column button..." This directly supports the path of selecting a table and then using the Transform function. (See Chapter: Using Transformations, Sub-section: Defining transformations on a single table).
2. Qlik Help - Replicate (November 2023): The online documentation for "Defining transformations on a single table" confirms the same steps. It shows that after selecting a table from the Table Selection screen, the user clicks the Transform button to access the interface for adding columns. This aligns with the sequence described in option C. (See Qlik Help Portal -> Qlik Replicate -> Transforming data -> Defining transformations on a single 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 3A Qlik Replicate administrator is working on a database where the column names in a sourc…
- 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…
