Alteryx Core Exam - Comprehensive Review
Alteryx Core Exam - Alteryx Designer Core Certification
Comprehensive Review - 200 Verified Questions and Answers with Evidence-Based Rationales
2026/2027 Edition
Q1: In a workflow, the Multi-Field Formula tool is configured to apply ToUpper() to convert all string fields to
uppercase. However, some fields contain numeric data. What happens to the numeric fields?
A. A. The workflow errors because ToUpper() cannot process numeric fields [CORRECT]
B. B. The numeric fields are skipped and remain unchanged
C. C. The numeric fields are converted to their string representation in uppercase
D. D. The numeric fields are automatically converted to null values
Correct Answer: A
Rationale: Correct because the Multi-Field Formula tool applies the specified formula to all selected fields regardless of
data type, and ToUpper() expects a string input, so applying it to numeric fields causes a type mismatch error.
Q2: Which setting in the Report PDF tool controls whether the output document is in landscape or portrait
orientation?
A. The Page Setup section where you select the page size and orientation dropdown [CORRECT]
B. The Layout section where you choose between horizontal and vertical alignment modes
C. The Page Orientation checkbox in the tool main configuration panel
D. The Print Settings section accessed through the Workflow Configuration menu
Correct Answer: A
Rationale: Correct because the Report PDF tool Page Setup section provides a dropdown to select between Portrait and
Landscape orientation, along with page size options, controlling the physical layout of the output PDF.
Q3: Which Alteryx tool configuration option allows you to limit the number of records read from an input source
during workflow development to speed up testing?
A. A. The Sample tool placed immediately after the Input Data tool
B. B. The Filter tool with a RowNum condition
C. C. The 'Record Limit' setting within the Input Data tool configuration [CORRECT]
D. D. The Cache tool with a size parameter
Correct Answer: C
Rationale: Correct because the Input Data tool has a built-in 'Record Limit' option in its configuration that restricts the
number of records read from the source, which is specifically designed for faster iterative development and testing.
Page 1
,Alteryx Core Exam - Comprehensive Review
Q4: A workflow has two branches. Branch A reads and processes a 10-million-row dataset through several
transformation tools. Branch B reads a small 500-row reference table. You need all records from Branch A to be
fully processed before Branch B data is combined downstream. Which tool accomplishes this?
A. Block Until Done tool placed on Branch A before the point where the branches merge [CORRECT]
B. A Container tool with the 'Enable Cache' option enabled wrapping Branch A
C. A Sort tool at the end of Branch A to ensure all records are ordered before merging
D. A Message tool configured with the 'Error' mode at the end of Branch A to signal completion
Correct Answer: A
Rationale: Correct because the Block Until Done tool ensures that every record from Branch A is fully processed and
buffered before any records are released to the downstream merge point, preventing premature partial processing.
Q5: In Alteryx, which Formula tool function removes leading and trailing whitespace from a string?
A. A. Trim() [CORRECT]
B. B. Strip()
C. C. Clean()
D. D. Normalize()
Correct Answer: A
Rationale: Correct because Trim() is the Alteryx Formula function that removes both leading and trailing space
characters from a string value, similar to the SQL TRIM function.
Q6: What is the role of the Error Message tool in Alteryx workflow error handling?
A. A. It sends an email notification when an error occurs
B. B. It writes error details to the Windows Event Log
C. C. It displays a custom error message in a pop-up window when the workflow is run as an app
[CORRECT]
D. D. It automatically retries failed tool operations
Correct Answer: C
Rationale: Correct because the Error Message tool stops the workflow and displays a custom error message to the user,
which is especially useful in Analytic Apps to provide meaningful feedback when input validation fails or unexpected
conditions occur.
Q7: Which regular expression pattern would match a standard US phone number in the format (555) 123-4567?
A. A. \(\d{3}\) \d{3}-\d{4} [CORRECT]
B. B. \d{3}-\d{3}-\d{4}
C. C. \+1-\d{3}-\d{3}-\d{4}
D. D. \d{10}
Correct Answer: A
Rationale: Correct because \ (\d{3}\) \d{3}-\d{4} matches the literal opening parenthesis, three digits, closing parenthesis,
space, three digits, hyphen, and four digits exactly as formatted in the target phone number pattern.
Page 2
,Alteryx Core Exam - Comprehensive Review
Q8: When using the Join tool in Alteryx, which join type returns all records from both the Left and Right inputs,
including unmatched records from both sides?
A. A. Inner Join
B. B. Left Join
C. C. Right Join
D. D. Full Outer Join [CORRECT]
Correct Answer: D
Rationale: Correct because a Full Outer Join retains every record from both inputs regardless of whether a match is
found, placing NULL values in fields where no corresponding match exists on the opposite side.
Q9: You need to ensure that a workflow running on Alteryx Server uses specific database credentials that differ from
the credentials used during development. What is the best practice for managing this?
A. A. Hardcode the production credentials into the workflow before publishing to Server
B. B. Use the Data Connection Manager (DCM) to create a shared connection with production credentials
that the Server workflow references [CORRECT]
C. C. Store credentials in a Text Input tool within the workflow
D. D. Use the Credential Tool to prompt users for credentials at runtime
Correct Answer: B
Rationale: This matches the DCM best practice, which centralizes credential management and allows workflows to
reference named connections that resolve to environment-appropriate credentials on the Server without embedding
sensitive information in the workflow file.
Q10: What is the primary function of the Sort tool in Alteryx?
A. A. To filter records based on sort criteria
B. B. To arrange records in ascending or descending order based on one or more fields [CORRECT]
C. C. To group records by category and apply aggregate functions
D. D. To remove null or empty values from fields
Correct Answer: B
Rationale: This matches the Sort tool's function of ordering records in the data stream by specified fields and sort
directions, supporting multiple sort keys with independent ascending or descending settings.
Q11: Which Alteryx tool allows you to write a SQL query directly against a database connection and return the
results as a data stream?
A. A. Query Tool
B. B. In-DB Connection Tool
C. C. Input Data Tool with custom SQL query mode [CORRECT]
D. D. Dynamic Input Tool
Correct Answer: C
Page 3
, Alteryx Core Exam - Comprehensive Review
Rationale: Correct because the Input Data tool allows users to switch from the visual table selection mode to a 'SQL
Query' mode where a custom SQL statement can be written and executed directly against the connected database.
Q12: In the Dynamic Select tool, how do you configure it to automatically deselect all fields whose names contain
the word 'Temp'?
A. Use a Contains pattern match on the field name for 'Temp' and set the action to Deselect [CORRECT]
B. Use a Starts With pattern match for 'Temp' and set the action to Remove
C. Manually uncheck each field containing 'Temp' in the field selection list
D. Use a Formula tool upstream to rename the fields before they reach the Select tool
Correct Answer: A
Rationale: Correct because the Dynamic Select tool can use pattern-based matching with the Contains operator to
dynamically identify and deselect fields matching a naming convention, even if the exact field names change between
runs.
Q13: In Alteryx, which tool performs joins between two spatial inputs based on geographic relationships such as
containment or intersection rather than attribute keys?
A. A. Join Tool
B. B. Spatial Match Tool [CORRECT]
C. C. Spatial Info Tool
D. D. Trade Area Tool
Correct Answer: B
Rationale: Correct because the Spatial Match tool joins records from two input streams based on spatial predicates
(Contains, Intersects, Within, Touches, etc.) rather than matching on field values like the standard Join tool.
Q14: Which Alteryx tool is used to create a scatter plot, bar chart, or line chart as a static image embedded in a
report?
A. A. Interactive Chart Tool
B. B. Chart Tool [CORRECT]
C. C. Report Text Tool
D. D. Map Tool
Correct Answer: B
Rationale: This matches the Chart tool, which generates static chart visualizations in various types (bar, line, scatter, pie,
etc.) that can be composited into reports using the Report Header, Footer, and Layout tools.
Q15: What is the purpose of configuring workflow credentials in Alteryx Server?
A. To store authentication information so scheduled workflows can access secured data sources without
requiring manual login each time they run [CORRECT]
B. To encrypt workflow packages when they are shared or distributed across the Alteryx Server environment
C. To validate user permissions before allowing a workflow to be published or executed on the server
Page 4
Alteryx Core Exam - Alteryx Designer Core Certification
Comprehensive Review - 200 Verified Questions and Answers with Evidence-Based Rationales
2026/2027 Edition
Q1: In a workflow, the Multi-Field Formula tool is configured to apply ToUpper() to convert all string fields to
uppercase. However, some fields contain numeric data. What happens to the numeric fields?
A. A. The workflow errors because ToUpper() cannot process numeric fields [CORRECT]
B. B. The numeric fields are skipped and remain unchanged
C. C. The numeric fields are converted to their string representation in uppercase
D. D. The numeric fields are automatically converted to null values
Correct Answer: A
Rationale: Correct because the Multi-Field Formula tool applies the specified formula to all selected fields regardless of
data type, and ToUpper() expects a string input, so applying it to numeric fields causes a type mismatch error.
Q2: Which setting in the Report PDF tool controls whether the output document is in landscape or portrait
orientation?
A. The Page Setup section where you select the page size and orientation dropdown [CORRECT]
B. The Layout section where you choose between horizontal and vertical alignment modes
C. The Page Orientation checkbox in the tool main configuration panel
D. The Print Settings section accessed through the Workflow Configuration menu
Correct Answer: A
Rationale: Correct because the Report PDF tool Page Setup section provides a dropdown to select between Portrait and
Landscape orientation, along with page size options, controlling the physical layout of the output PDF.
Q3: Which Alteryx tool configuration option allows you to limit the number of records read from an input source
during workflow development to speed up testing?
A. A. The Sample tool placed immediately after the Input Data tool
B. B. The Filter tool with a RowNum condition
C. C. The 'Record Limit' setting within the Input Data tool configuration [CORRECT]
D. D. The Cache tool with a size parameter
Correct Answer: C
Rationale: Correct because the Input Data tool has a built-in 'Record Limit' option in its configuration that restricts the
number of records read from the source, which is specifically designed for faster iterative development and testing.
Page 1
,Alteryx Core Exam - Comprehensive Review
Q4: A workflow has two branches. Branch A reads and processes a 10-million-row dataset through several
transformation tools. Branch B reads a small 500-row reference table. You need all records from Branch A to be
fully processed before Branch B data is combined downstream. Which tool accomplishes this?
A. Block Until Done tool placed on Branch A before the point where the branches merge [CORRECT]
B. A Container tool with the 'Enable Cache' option enabled wrapping Branch A
C. A Sort tool at the end of Branch A to ensure all records are ordered before merging
D. A Message tool configured with the 'Error' mode at the end of Branch A to signal completion
Correct Answer: A
Rationale: Correct because the Block Until Done tool ensures that every record from Branch A is fully processed and
buffered before any records are released to the downstream merge point, preventing premature partial processing.
Q5: In Alteryx, which Formula tool function removes leading and trailing whitespace from a string?
A. A. Trim() [CORRECT]
B. B. Strip()
C. C. Clean()
D. D. Normalize()
Correct Answer: A
Rationale: Correct because Trim() is the Alteryx Formula function that removes both leading and trailing space
characters from a string value, similar to the SQL TRIM function.
Q6: What is the role of the Error Message tool in Alteryx workflow error handling?
A. A. It sends an email notification when an error occurs
B. B. It writes error details to the Windows Event Log
C. C. It displays a custom error message in a pop-up window when the workflow is run as an app
[CORRECT]
D. D. It automatically retries failed tool operations
Correct Answer: C
Rationale: Correct because the Error Message tool stops the workflow and displays a custom error message to the user,
which is especially useful in Analytic Apps to provide meaningful feedback when input validation fails or unexpected
conditions occur.
Q7: Which regular expression pattern would match a standard US phone number in the format (555) 123-4567?
A. A. \(\d{3}\) \d{3}-\d{4} [CORRECT]
B. B. \d{3}-\d{3}-\d{4}
C. C. \+1-\d{3}-\d{3}-\d{4}
D. D. \d{10}
Correct Answer: A
Rationale: Correct because \ (\d{3}\) \d{3}-\d{4} matches the literal opening parenthesis, three digits, closing parenthesis,
space, three digits, hyphen, and four digits exactly as formatted in the target phone number pattern.
Page 2
,Alteryx Core Exam - Comprehensive Review
Q8: When using the Join tool in Alteryx, which join type returns all records from both the Left and Right inputs,
including unmatched records from both sides?
A. A. Inner Join
B. B. Left Join
C. C. Right Join
D. D. Full Outer Join [CORRECT]
Correct Answer: D
Rationale: Correct because a Full Outer Join retains every record from both inputs regardless of whether a match is
found, placing NULL values in fields where no corresponding match exists on the opposite side.
Q9: You need to ensure that a workflow running on Alteryx Server uses specific database credentials that differ from
the credentials used during development. What is the best practice for managing this?
A. A. Hardcode the production credentials into the workflow before publishing to Server
B. B. Use the Data Connection Manager (DCM) to create a shared connection with production credentials
that the Server workflow references [CORRECT]
C. C. Store credentials in a Text Input tool within the workflow
D. D. Use the Credential Tool to prompt users for credentials at runtime
Correct Answer: B
Rationale: This matches the DCM best practice, which centralizes credential management and allows workflows to
reference named connections that resolve to environment-appropriate credentials on the Server without embedding
sensitive information in the workflow file.
Q10: What is the primary function of the Sort tool in Alteryx?
A. A. To filter records based on sort criteria
B. B. To arrange records in ascending or descending order based on one or more fields [CORRECT]
C. C. To group records by category and apply aggregate functions
D. D. To remove null or empty values from fields
Correct Answer: B
Rationale: This matches the Sort tool's function of ordering records in the data stream by specified fields and sort
directions, supporting multiple sort keys with independent ascending or descending settings.
Q11: Which Alteryx tool allows you to write a SQL query directly against a database connection and return the
results as a data stream?
A. A. Query Tool
B. B. In-DB Connection Tool
C. C. Input Data Tool with custom SQL query mode [CORRECT]
D. D. Dynamic Input Tool
Correct Answer: C
Page 3
, Alteryx Core Exam - Comprehensive Review
Rationale: Correct because the Input Data tool allows users to switch from the visual table selection mode to a 'SQL
Query' mode where a custom SQL statement can be written and executed directly against the connected database.
Q12: In the Dynamic Select tool, how do you configure it to automatically deselect all fields whose names contain
the word 'Temp'?
A. Use a Contains pattern match on the field name for 'Temp' and set the action to Deselect [CORRECT]
B. Use a Starts With pattern match for 'Temp' and set the action to Remove
C. Manually uncheck each field containing 'Temp' in the field selection list
D. Use a Formula tool upstream to rename the fields before they reach the Select tool
Correct Answer: A
Rationale: Correct because the Dynamic Select tool can use pattern-based matching with the Contains operator to
dynamically identify and deselect fields matching a naming convention, even if the exact field names change between
runs.
Q13: In Alteryx, which tool performs joins between two spatial inputs based on geographic relationships such as
containment or intersection rather than attribute keys?
A. A. Join Tool
B. B. Spatial Match Tool [CORRECT]
C. C. Spatial Info Tool
D. D. Trade Area Tool
Correct Answer: B
Rationale: Correct because the Spatial Match tool joins records from two input streams based on spatial predicates
(Contains, Intersects, Within, Touches, etc.) rather than matching on field values like the standard Join tool.
Q14: Which Alteryx tool is used to create a scatter plot, bar chart, or line chart as a static image embedded in a
report?
A. A. Interactive Chart Tool
B. B. Chart Tool [CORRECT]
C. C. Report Text Tool
D. D. Map Tool
Correct Answer: B
Rationale: This matches the Chart tool, which generates static chart visualizations in various types (bar, line, scatter, pie,
etc.) that can be composited into reports using the Report Header, Footer, and Layout tools.
Q15: What is the purpose of configuring workflow credentials in Alteryx Server?
A. To store authentication information so scheduled workflows can access secured data sources without
requiring manual login each time they run [CORRECT]
B. To encrypt workflow packages when they are shared or distributed across the Alteryx Server environment
C. To validate user permissions before allowing a workflow to be published or executed on the server
Page 4
