Download PrepIQ L1 Basic Proficiency in KNIME Analytics Platform Ultimate Exam and more Exams Technology in PDF only on Docsity!
Analytics Platform Ultimate Exam
Question 1. Which KNIME node state is displayed in red? A) Executed B) Configured C) Not Configured D) Disabled Answer: C Explanation: A red node indicates that required configuration settings or input data are missing, meaning the node is not ready to run. Question 2. In the KNIME workbench, which view lets you search for nodes and drag them onto the workflow editor? A) KNIME Explorer B) Node Repository C) Console D) Node Monitor Answer: B Explanation: The Node Repository contains all installed nodes; you can search, preview, and drag nodes from this view into your workflow. Question 3. When you export a workflow as a .knar file, what is included? A) Only the workflow’s graphical layout B) The workflow plus all dependent data files and configuration C) Only the nodes, not the connections D) Only the metadata of the workflow
Analytics Platform Ultimate Exam
Answer: B Explanation: A KNIME Archive (.knar) bundles the workflow, its configuration, and any referenced external files, enabling full reproducibility on another system. Question 4. Which port type does a typical data table input use? A) Image Port B) String Port C) Table Port D) Model Port Answer: C Explanation: Table ports carry data tables (rows and columns) between nodes; they are the most common port type for data processing. Question 5. What is the purpose of the Column Filter node? A) To rename columns B) To change column data types C) To select or exclude specific columns from the flow D) To sort rows based on a column Answer: C Explanation: Column Filter lets you include or exclude columns, reducing the dataset to only the variables needed for subsequent analysis. Question 6. Which option in the CSV Reader configuration determines whether the first line is treated as column headers?
Analytics Platform Ultimate Exam
Answer: B Explanation: The Binner node creates discrete intervals (bins) from continuous numeric values, optionally labeling them. Question 9. How does the Missing Value node handle nulls when the “Replace with” option is set to “Mean”? A) It deletes the rows containing nulls. B) It substitutes the column’s arithmetic mean for each null. C) It replaces nulls with the string “Mean”. D) It leaves the nulls unchanged. Answer: B Explanation: Selecting “Mean” calculates the average of the non-missing values in that column and fills each missing entry with that value. Question 10. Which shortcut key executes the currently selected node(s) in KNIME? A) F B) F C) F D) F Answer: C Explanation: Pressing F7 runs the selected node(s) or the whole workflow if nothing is selected. Question 11. What does the Console view display during workflow execution?
Analytics Platform Ultimate Exam
A) Node configuration dialogs B) Real-time log messages, warnings, and errors C) A graphical representation of the workflow D) Exported data files Answer: B Explanation: The Console streams log entries, including status updates, warnings, and error messages, helping users debug workflows. Question 12. When using the Excel Reader, what does the “Sheet selection” dropdown allow you to do? A) Choose which columns to import B) Set the file encoding C) Pick a specific worksheet from the Excel workbook D) Define the number of rows to skip Answer: C Explanation: Excel files can contain multiple worksheets; the dropdown lets you select which sheet’s data to read. Question 13. Which node can be used to concatenate two tables that have different column headers, aligning columns by name and filling missing values with nulls? A) Joiner B) Concatenate C) Column Filter D) GroupBy
Analytics Platform Ultimate Exam
B) A color palette that can be applied to visualizations. C) A transformed CSV file. D) A statistical summary of colors. Answer: B Explanation: Color Manager creates a mapping between categorical or numeric values and colors, which can be referenced by downstream chart nodes. Question 17. Which node calculates the sum, average, and count of a numeric column grouped by a categorical column? A) Math Formula B) GroupBy C) Pivoting D) Row Filter Answer: B Explanation: GroupBy aggregates data based on grouping columns, providing statistics like sum, mean, and count. Question 18. When configuring a Database Connector, which piece of information is NOT required? A) JDBC driver class name B) Database URL C) Table name to read D) Username and password Answer: C
Analytics Platform Ultimate Exam
Explanation: The connector establishes a connection; the specific table is selected later using a DB Table Selector node. Question 19. Which node would you use to change all characters in a string column to uppercase? A) String Manipulation B) Math Formula C) Column Rename D) Row Filter Answer: A Explanation: String Manipulation provides functions such as toUpperCase($column$) to modify string case. Question 20. In a GroupBy node, what does the “Manual Aggregation” option allow you to do? A) Automatically detect the best aggregation method. B) Write custom Java code for aggregation. C) Choose specific aggregation functions for each column. D) Skip aggregation entirely. Answer: C Explanation: Manual Aggregation lets you assign different aggregation functions (e.g., Sum, Median) to individual columns. Question 21. Which view in KNIME shows the hierarchical structure of remote repositories such as KNIME Hub? A) Node Monitor
Analytics Platform Ultimate Exam
Explanation: The “Append to existing file” checkbox determines if the writer adds to an existing file (append) or replaces it (overwrite). Question 24. How does the Row Filter node treat a wildcard pattern such as “Smith” applied to a string column? A) It filters rows that exactly match “Smith”. B) It filters rows containing the substring “Smith”. C) It filters rows that start with “Smith”. D) It treats the asterisk as a literal character. Answer: B Explanation: In Row Filter, the asterisk () acts as a wildcard matching any sequence of characters, so “Smith*” selects rows where the column contains “Smith”. Question 25. Which node would you use to reshape a dataset from a “wide” format (multiple measurement columns) to a “long” format (single measurement column with a variable identifier)? A) Pivoting B) Unpivoting C) Binner D) Concatenate Answer: B Explanation: Unpivoting converts wide tables into long tables by gathering selected columns into two new columns: one for variable names and one for values. Question 26. What is the effect of enabling “Cache results” for a node?
Analytics Platform Ultimate Exam
A) The node’s output is stored on disk and reused on subsequent executions. B) The node runs faster but does not produce output. C) The node’s configuration is locked. D) The node automatically clears its output after execution. Answer: A Explanation: Caching saves the node’s results, allowing downstream nodes to reuse them without recomputing the node each time. Question 27. Which shortcut opens the configuration dialog for the currently selected node? A) F B) F C; F D) F Answer: B Explanation: Pressing F6 brings up the node’s configuration window, enabling quick adjustments. Question 28. In the Math Formula node, which expression would calculate the natural logarithm of a column named “Revenue”? A) log($Revenue$) B) ln($Revenue$) C) ln($Revenue$) + 1 D) log10($Revenue$) Answer: B
Analytics Platform Ultimate Exam
B) The node is currently executing. C) The node encountered an error during execution. D) The node is disabled. Answer: C Explanation: An “X” marks a node that failed; the Console will contain the associated error messages. Question 32. Which node is used to merge two tables side-by-side based on a common key column? A) Concatenate B) Joiner C) Column Append D) GroupBy Answer: B Explanation: Joiner matches rows from two tables using key columns, producing a combined table with columns from both inputs. Question 33. How can you change the visual order of columns without altering the underlying data order? A) Column Filter B) Column Resorter C) Column Rename D) Row Filter Answer: B
Analytics Platform Ultimate Exam
Explanation: Column Resorter lets you rearrange the displayed column order, which affects downstream nodes that respect column order. Question 34. Which node provides a quick way to remove duplicate rows based on all columns? A) Duplicate Row Filter B) Row Filter C) GroupBy (with Count) D) Column Filter Answer: A Explanation: Duplicate Row Filter identifies and discards rows that are identical across all selected columns (by default, all columns). Question 35. In the Pivoting node, what does the “Group column” represent? A) Columns that will become row identifiers in the pivoted table. B) Columns that will be aggregated. C) Columns that will be removed. D) Columns that will be renamed. Answer: A Explanation: Group columns define the identifiers that stay constant while other columns are pivoted into new rows. Question 36. Which node allows you to write a KNIME table directly to a relational database? A) DB Writer
Analytics Platform Ultimate Exam
Explanation: String Manipulation can combine columns using the join($FirstName$, " ", $LastName$) expression. Question 39. In the Database Table Selector node, what does the “SQL Statement” field allow you to specify? A) The name of the database driver. B) A custom query to retrieve a subset of rows. C) The file path for export. D) The column order for import. Answer: B Explanation: The SQL Statement lets you write a SELECT query to fetch exactly the rows and columns you need. Question 40. Which node can transform a numeric column into a categorical column based on user-defined intervals? A) Binner B) Math Formula C) String Manipulation D) GroupBy Answer: A Explanation: Binner creates bins (intervals) and assigns a categorical label to each numeric value according to the defined ranges. Question 41. What does the Component node enable you to do? A) Perform statistical modeling. B) Bundle a collection of nodes into a reusable, interactive interface.
Analytics Platform Ultimate Exam
C) Export workflow metadata. D) Generate random numbers. Answer: B Explanation: Components encapsulate sub-workflows and expose selected ports, allowing users to build modular and interactive dashboards. Question 42. When you set the CSV Reader option “Trim spaces” to true, what happens? A) All spaces are removed from the file path. B) Leading and trailing whitespace in each cell is stripped. C) Columns are renamed to remove spaces. D) The output file is saved without spaces. Answer: B Explanation: Enabling “Trim spaces” cleans cell values by deleting leading/trailing whitespace during import. Question 43. Which node can be used to calculate the Z-score (standard score) for a numeric column? A) Normalizer B) Math Formula C) Z-Score Normalizer D) GroupBy Answer: C Explanation: The Z-Score Normalizer computes (value - mean) / standard deviation for each entry, producing standardized scores.
Analytics Platform Ultimate Exam
D) Saves the node’s output to a file. Answer: B Explanation: Reset removes the node’s cached results and configuration, forcing the user to re-configure before next execution. Question 47. Which node can be used to split a single column containing “City, Country” into two separate columns? A) Column Splitter B) String Manipulation C) Row Filter D) GroupBy Answer: A Explanation: Column Splitter separates a column into multiple columns based on a delimiter such as a comma. Question 48. In the Line Plot node, what does the “Series column” control? A) The X-axis values. B) The Y-axis values. C) The grouping of multiple lines (different series). D) The chart title. Answer: C Explanation: The Series column determines which distinct values generate separate lines on the same plot.
Analytics Platform Ultimate Exam
Question 49. Which node provides a quick way to convert all numeric columns to double precision? A) Column Auto Type Cast B) Number To String C) String To Number D) Column Filter Answer: A Explanation: Column Auto Type Cast can enforce a specific data type (e.g., double) across selected numeric columns. Question 50. What is the effect of checking “Append to existing file” in the Excel Writer node? A) The writer overwrites the existing workbook. B) The writer adds new rows to the existing sheet without removing previous data. C) The writer creates a new sheet for each execution. D) The writer compresses the output file. Answer: B Explanation: Enabling “Append” tells KNIME to keep the existing sheet content and add the new rows beneath it. Question 51. Which node can be used to detect and replace outlier values based on the Interquartile Range (IQR) method? A) Outlier Removal B) Missing Value C) Math Formula
