ALTERYX CORE CERTIFICATION ACTUAL EXAM QUESTIONS WITH DETAILED
ANSWERS WITH RATIONALES AND A READINESS PRACTICE EXAM TEST BANK
WITH A STUDY GUIDE | LATEST UPDATED AND VERIFIED FOR GUARANTEED PASS
Question 1
What are the two primary sections of the Input Data Tool configuration window?
A) Select Tool and File Path
B) Connect a File or Database and Options
C) Data Profiling and Results
D) Join Options and File Explorer
E) Metadata and Data Preview
Correct Answer: B) Connect a File or Database and Options
Rationale: The Input Data tool is divided into two distinct functional areas. The top section
allows the user to specify the source (Connect a File or Database), while the bottom section
(Options) provides specific configurations based on the file type, such as delimiters, record
limits, and line handling.
Question 2
When using a wildcard in the Input Data tool, what is the effect of entering an asterisk ()?
A) It replaces exactly one character in the file name.
B) It brings in files that contain only numbers.
C) It brings in anything that starts with the characters before the "" and anything after it.
D) It acts as a comment and ignores the file path.
E) It deletes the characters preceding it during the input process.
Correct Answer: C) It brings in anything that starts with the characters before the "*" and
anything after it.
Rationale: The asterisk is a multi-character wildcard. In Alteryx, using "Sales_*.csv" would
bring in every CSV file that begins with "Sales_", regardless of how many characters
follow the underscore (e.g., "Sales_2020", "Sales_January_Final").
Question 3
What is the specific functionality of the question mark (?) wildcard in an Alteryx input path?
A) It returns a list of suggested file names.
B) It brings in anything that starts with the characters before the "?" plus exactly one character.
C) It prompts the user for a manual file selection at runtime.
D) It brings in all files within a sub-folder.
E) It ignores the character immediately following the question mark.
Correct Answer: B) It brings in anything that starts with the characters before the "?" plus
exactly one character.
Rationale: Unlike the asterisk which represents any number of characters, the question
, 2
mark is a single-character wildcard. For example, "File_202?.csv" would bring in
"File_2021.csv" and "File_2022.csv" but not "File_202.csv" or "File_20211.csv".
Question 4
Which of the following describes the limitations of the data layout preview window within the
Input Data tool?
A) It shows all records regardless of file size.
B) It is limited to the first 50 records of any file.
C) It is limited to 100 records or fewer in wide files.
D) It only shows the metadata and no actual records.
E) It displays the first 1 MB of the data.
Correct Answer: C) It is limited to 100 records or fewer in wide files.
Rationale: The preview window in the configuration of the Input Data tool is meant for a
quick glance to verify the schema. To optimize performance, Alteryx limits this preview to
100 records, particularly when dealing with "wide" files containing many columns.
Question 5
How can a user convert an Output Data tool already on the canvas into an Input Data tool?
A) By dragging a new Input Data tool on top of it.
B) By double-clicking the tool and selecting "Reverse."
C) Right-click the tool and select "Convert To Input Data."
D) This action is not possible in Alteryx.
E) By changing the file path in the configuration to a read-only directory.
Correct Answer: C) Right-click the tool and select "Convert To Input Data."
Rationale: Alteryx provides a shortcut to swap between input and output. By right-clicking
an Output Data tool, the user can select "Convert To Input Data," which will retain the file
path but change the tool's behavior to read from that source instead of writing to it.
Question 6
Which of the following is NOT one of the three standard ways to add a Browse tool to a
workflow?
A) Dragging it from the Tool Palette and connecting it.
B) Right-clicking a tool and selecting "Add Browse After."
C) Using the Shift+Ctrl+B keyboard shortcut.
D) Dragging a file from Windows Explorer onto a tool's output anchor.
E) Searching for "Browse" in the search bar and clicking the result.
Correct Answer: D) Dragging a file from Windows Explorer onto a tool's output anchor.
Rationale: The three primary methods are manual dragging from the palette, using the
right-click context menu "Add Browse After," or using the shortcut Shift+Ctrl+B while one
, 3
or more tools are selected. Dragging a file from Explorer typically creates a new Input Data
tool.
Question 7
Without a Browse tool, how much data is typically visible in the Results window after running a
workflow?
A) The entire dataset.
B) Up to 10 MB.
C) Up to 1 MB.
D) Only the first 10 rows.
E) 300 MB.
Correct Answer: C) Up to 1 MB.
Rationale: To keep the Alteryx Designer responsive, the Results window caches a limited
amount of data. Without the Browse tool (which creates a temporary .yxdb file), you can
only see up to 1 MB of data in the Results window.
Question 8
To disable all Browse tools in a workflow to improve performance, where must the user
navigate?
A) The User Settings menu.
B) The specific Configuration window for each Browse tool.
C) The Workflow - Configuration window, under the Runtime tab.
D) The View menu on the top toolbar.
E) The Options menu under Global Settings.
Correct Answer: C) The Workflow - Configuration window, under the Runtime tab.
Rationale: Disabling Browse tools is a global workflow setting found in the Runtime tab of
the Workflow Configuration. Checking "Disable All Browse Tools" makes them
unavailable during the run, which is useful when moving a workflow to production or
handling massive datasets.
Question 9
What message appears in the Browse Tool's Configuration Window if a column's data type is
incompatible with data profiling?
A) "Incompatible Data"
B) "Error: Type Mismatch"
C) "No Profiling Available"
D) "Profiling Disabled"
E) "Unknown Field Type"
, 4
Correct Answer: C) "No Profiling Available"
Rationale: Data profiling (charts, distributions, etc.) requires certain data types. If a column
is of a type that the profiling engine cannot process (such as certain spatial or blob objects),
the message "No Profiling Available" is displayed in the profiling pane.
Question 10
In the Browse tool, what specific message is displayed if every single record in a column
contains the exact same value?
A) "Unique Value"
B) "Only one value"
C) "Redundant Data"
D) "No Variance"
E) "100% Match"
Correct Answer: B) "Only one value"
Rationale: When the Browse tool profiles data, it summarizes the distribution. If a column
is 100% populated by a single constant (e.g., every row has "USA" in the Country field), it
alerts the user with the "Only one value" message.
Question 11
What message does the Browse tool display when profiling a column where every entry is
different from all others?
A) "Single Entries Only"
B) "No Duplicates"
C) "All values are unique"
D) "Primary Key Detected"
E) "Distinct Data"
Correct Answer: C) "All values are unique"
Rationale: If Alteryx detects that there are no duplicate values within a specific column
during the profiling process, it summarizes this by stating "All values are unique." This is
helpful for identifying potential unique identifiers or primary keys.
Question 12
Which two categories can be used to filter fields within the Configuration Window of the Browse
Tool?
A) Name and Size
B) Fields (columns) and Data Type
C) Creation Date and Modified Date
D) Metadata and Records
E) Input and Output
ANSWERS WITH RATIONALES AND A READINESS PRACTICE EXAM TEST BANK
WITH A STUDY GUIDE | LATEST UPDATED AND VERIFIED FOR GUARANTEED PASS
Question 1
What are the two primary sections of the Input Data Tool configuration window?
A) Select Tool and File Path
B) Connect a File or Database and Options
C) Data Profiling and Results
D) Join Options and File Explorer
E) Metadata and Data Preview
Correct Answer: B) Connect a File or Database and Options
Rationale: The Input Data tool is divided into two distinct functional areas. The top section
allows the user to specify the source (Connect a File or Database), while the bottom section
(Options) provides specific configurations based on the file type, such as delimiters, record
limits, and line handling.
Question 2
When using a wildcard in the Input Data tool, what is the effect of entering an asterisk ()?
A) It replaces exactly one character in the file name.
B) It brings in files that contain only numbers.
C) It brings in anything that starts with the characters before the "" and anything after it.
D) It acts as a comment and ignores the file path.
E) It deletes the characters preceding it during the input process.
Correct Answer: C) It brings in anything that starts with the characters before the "*" and
anything after it.
Rationale: The asterisk is a multi-character wildcard. In Alteryx, using "Sales_*.csv" would
bring in every CSV file that begins with "Sales_", regardless of how many characters
follow the underscore (e.g., "Sales_2020", "Sales_January_Final").
Question 3
What is the specific functionality of the question mark (?) wildcard in an Alteryx input path?
A) It returns a list of suggested file names.
B) It brings in anything that starts with the characters before the "?" plus exactly one character.
C) It prompts the user for a manual file selection at runtime.
D) It brings in all files within a sub-folder.
E) It ignores the character immediately following the question mark.
Correct Answer: B) It brings in anything that starts with the characters before the "?" plus
exactly one character.
Rationale: Unlike the asterisk which represents any number of characters, the question
, 2
mark is a single-character wildcard. For example, "File_202?.csv" would bring in
"File_2021.csv" and "File_2022.csv" but not "File_202.csv" or "File_20211.csv".
Question 4
Which of the following describes the limitations of the data layout preview window within the
Input Data tool?
A) It shows all records regardless of file size.
B) It is limited to the first 50 records of any file.
C) It is limited to 100 records or fewer in wide files.
D) It only shows the metadata and no actual records.
E) It displays the first 1 MB of the data.
Correct Answer: C) It is limited to 100 records or fewer in wide files.
Rationale: The preview window in the configuration of the Input Data tool is meant for a
quick glance to verify the schema. To optimize performance, Alteryx limits this preview to
100 records, particularly when dealing with "wide" files containing many columns.
Question 5
How can a user convert an Output Data tool already on the canvas into an Input Data tool?
A) By dragging a new Input Data tool on top of it.
B) By double-clicking the tool and selecting "Reverse."
C) Right-click the tool and select "Convert To Input Data."
D) This action is not possible in Alteryx.
E) By changing the file path in the configuration to a read-only directory.
Correct Answer: C) Right-click the tool and select "Convert To Input Data."
Rationale: Alteryx provides a shortcut to swap between input and output. By right-clicking
an Output Data tool, the user can select "Convert To Input Data," which will retain the file
path but change the tool's behavior to read from that source instead of writing to it.
Question 6
Which of the following is NOT one of the three standard ways to add a Browse tool to a
workflow?
A) Dragging it from the Tool Palette and connecting it.
B) Right-clicking a tool and selecting "Add Browse After."
C) Using the Shift+Ctrl+B keyboard shortcut.
D) Dragging a file from Windows Explorer onto a tool's output anchor.
E) Searching for "Browse" in the search bar and clicking the result.
Correct Answer: D) Dragging a file from Windows Explorer onto a tool's output anchor.
Rationale: The three primary methods are manual dragging from the palette, using the
right-click context menu "Add Browse After," or using the shortcut Shift+Ctrl+B while one
, 3
or more tools are selected. Dragging a file from Explorer typically creates a new Input Data
tool.
Question 7
Without a Browse tool, how much data is typically visible in the Results window after running a
workflow?
A) The entire dataset.
B) Up to 10 MB.
C) Up to 1 MB.
D) Only the first 10 rows.
E) 300 MB.
Correct Answer: C) Up to 1 MB.
Rationale: To keep the Alteryx Designer responsive, the Results window caches a limited
amount of data. Without the Browse tool (which creates a temporary .yxdb file), you can
only see up to 1 MB of data in the Results window.
Question 8
To disable all Browse tools in a workflow to improve performance, where must the user
navigate?
A) The User Settings menu.
B) The specific Configuration window for each Browse tool.
C) The Workflow - Configuration window, under the Runtime tab.
D) The View menu on the top toolbar.
E) The Options menu under Global Settings.
Correct Answer: C) The Workflow - Configuration window, under the Runtime tab.
Rationale: Disabling Browse tools is a global workflow setting found in the Runtime tab of
the Workflow Configuration. Checking "Disable All Browse Tools" makes them
unavailable during the run, which is useful when moving a workflow to production or
handling massive datasets.
Question 9
What message appears in the Browse Tool's Configuration Window if a column's data type is
incompatible with data profiling?
A) "Incompatible Data"
B) "Error: Type Mismatch"
C) "No Profiling Available"
D) "Profiling Disabled"
E) "Unknown Field Type"
, 4
Correct Answer: C) "No Profiling Available"
Rationale: Data profiling (charts, distributions, etc.) requires certain data types. If a column
is of a type that the profiling engine cannot process (such as certain spatial or blob objects),
the message "No Profiling Available" is displayed in the profiling pane.
Question 10
In the Browse tool, what specific message is displayed if every single record in a column
contains the exact same value?
A) "Unique Value"
B) "Only one value"
C) "Redundant Data"
D) "No Variance"
E) "100% Match"
Correct Answer: B) "Only one value"
Rationale: When the Browse tool profiles data, it summarizes the distribution. If a column
is 100% populated by a single constant (e.g., every row has "USA" in the Country field), it
alerts the user with the "Only one value" message.
Question 11
What message does the Browse tool display when profiling a column where every entry is
different from all others?
A) "Single Entries Only"
B) "No Duplicates"
C) "All values are unique"
D) "Primary Key Detected"
E) "Distinct Data"
Correct Answer: C) "All values are unique"
Rationale: If Alteryx detects that there are no duplicate values within a specific column
during the profiling process, it summarizes this by stating "All values are unique." This is
helpful for identifying potential unique identifiers or primary keys.
Question 12
Which two categories can be used to filter fields within the Configuration Window of the Browse
Tool?
A) Name and Size
B) Fields (columns) and Data Type
C) Creation Date and Modified Date
D) Metadata and Records
E) Input and Output
