Alteryx Core Exam – Alteryx Designer Core
Certification – 2026/2027 Edition – 200
Verified Questions and Answers with
Evidence-Based Rationales | with complete
solutions.
SECTION 1: INPUT & OUTPUT TOOLS (Questions 1-
25)
1. When configuring an Input Data tool to read multiple files, what
does entering an asterisk (*) in the file path do?
A) It brings in only the first file that matches the pattern
B) It brings in anything that starts with the characters before the "*" and
anything after it
C) It excludes all files from the directory
D) It creates a new file with an asterisk in the name
Answer: B) It brings in anything that starts with the characters
before the "*" and anything after it
Rationale: The asterisk (*) acts as a wildcard character in the Input Data
tool, bringing in all files that match the pattern where the asterisk represents
any characters between the specified prefix and suffix . This is useful for
dynamically reading multiple files with similar naming conventions (e.g.,
Sales_2024_01.csv, Sales_2024_02.csv) .
Source: Alteryx Core Exam Prep Guide; Docsity
,2. What are the two sections of the Input Data Configuration
window?
A) File Path AND Data Preview
B) Connect a File or Database AND Options
C) Connection Type AND Authentication
D) Source AND Destination
Answer: B) Connect a File or Database AND Options
Rationale: The Input Data Configuration window is divided into two main
sections: "Connect a File or Database" for selecting the data source, and
"Options" for configuring how the data is read (including file format options,
delimiters, and data preview settings) .
Source: Alteryx Core Exam Prep Guide; Docsity
3. How many records can the data layout preview window in the
Input Data tool display?
A) 50 records or fewer
B) 100 records or fewer in wide files
C) 500 records maximum
D) Unlimited records
Answer: B) 100 records or fewer in wide files
Rationale: The Input Data tool's data layout preview window displays up to
100 records, particularly when dealing with wide files . This limitation helps
,maintain performance while still providing enough data to verify column
structure and data types .
Source: Alteryx Core Exam Prep Guide; Docsity
4. Without a Browse tool connected, how much data shows in the
Results window?
A) No data will show
B) Unlimited data can be displayed
C) Up to 1 MB of data
D) Up to 100 records
Answer: C) Up to 1 MB of data
Rationale: Without a Browse tool, the Results window displays up to 1 MB of
data . The Browse tool provides the ability to view more data and profiling
information, making it essential for data validation .
Source: Alteryx Core Exam Prep Guide; Docsity
5. What is the Text Input tool used for?
A) Reading external CSV files
B) Manually adding data that will be stored and saved within the workflow
C) Connecting to SQL databases
D) Parsing unstructured text data
Answer: B) Manually adding data that will be stored and saved
within the workflow
, Rationale: The Text Input tool allows users to manually enter or paste data
directly into the workflow . The data is embedded within the workflow and is
static, making it highly portable when sharing workflows (unlike external file
sources) .
Source: Alteryx Core Exam Prep Guide; Docsity
6. Which statement correctly distinguishes the Text Input tool from
the Input Data tool?
A) Text Input reads from external files; Input Data reads manually entered
data
B) Text Input data is embedded in the workflow; Input Data reads from
external sources
C) Both tools function identically
D) Text Input is for numeric data only; Input Data is for text data
Answer: B) Text Input data is embedded in the workflow; Input Data
reads from external sources
Rationale: The key distinction is where the data resides. Text Input tool data
is embedded in the workflow (static, portable), while Input Data tool reads
from external files or databases (dynamic, must be shared separately) .
Source: Alteryx Core Exam Prep Guide; Stuvia
7. What does the "Append Suffix to File/Table Name" option do to
the output data file?
A) Appends the selected field name to the end of the file path
B) Appends the selected field name to the beginning of the file name
C) Appends the selected field name to the end of the name of the selected
table
D) Changes the file extension
Certification – 2026/2027 Edition – 200
Verified Questions and Answers with
Evidence-Based Rationales | with complete
solutions.
SECTION 1: INPUT & OUTPUT TOOLS (Questions 1-
25)
1. When configuring an Input Data tool to read multiple files, what
does entering an asterisk (*) in the file path do?
A) It brings in only the first file that matches the pattern
B) It brings in anything that starts with the characters before the "*" and
anything after it
C) It excludes all files from the directory
D) It creates a new file with an asterisk in the name
Answer: B) It brings in anything that starts with the characters
before the "*" and anything after it
Rationale: The asterisk (*) acts as a wildcard character in the Input Data
tool, bringing in all files that match the pattern where the asterisk represents
any characters between the specified prefix and suffix . This is useful for
dynamically reading multiple files with similar naming conventions (e.g.,
Sales_2024_01.csv, Sales_2024_02.csv) .
Source: Alteryx Core Exam Prep Guide; Docsity
,2. What are the two sections of the Input Data Configuration
window?
A) File Path AND Data Preview
B) Connect a File or Database AND Options
C) Connection Type AND Authentication
D) Source AND Destination
Answer: B) Connect a File or Database AND Options
Rationale: The Input Data Configuration window is divided into two main
sections: "Connect a File or Database" for selecting the data source, and
"Options" for configuring how the data is read (including file format options,
delimiters, and data preview settings) .
Source: Alteryx Core Exam Prep Guide; Docsity
3. How many records can the data layout preview window in the
Input Data tool display?
A) 50 records or fewer
B) 100 records or fewer in wide files
C) 500 records maximum
D) Unlimited records
Answer: B) 100 records or fewer in wide files
Rationale: The Input Data tool's data layout preview window displays up to
100 records, particularly when dealing with wide files . This limitation helps
,maintain performance while still providing enough data to verify column
structure and data types .
Source: Alteryx Core Exam Prep Guide; Docsity
4. Without a Browse tool connected, how much data shows in the
Results window?
A) No data will show
B) Unlimited data can be displayed
C) Up to 1 MB of data
D) Up to 100 records
Answer: C) Up to 1 MB of data
Rationale: Without a Browse tool, the Results window displays up to 1 MB of
data . The Browse tool provides the ability to view more data and profiling
information, making it essential for data validation .
Source: Alteryx Core Exam Prep Guide; Docsity
5. What is the Text Input tool used for?
A) Reading external CSV files
B) Manually adding data that will be stored and saved within the workflow
C) Connecting to SQL databases
D) Parsing unstructured text data
Answer: B) Manually adding data that will be stored and saved
within the workflow
, Rationale: The Text Input tool allows users to manually enter or paste data
directly into the workflow . The data is embedded within the workflow and is
static, making it highly portable when sharing workflows (unlike external file
sources) .
Source: Alteryx Core Exam Prep Guide; Docsity
6. Which statement correctly distinguishes the Text Input tool from
the Input Data tool?
A) Text Input reads from external files; Input Data reads manually entered
data
B) Text Input data is embedded in the workflow; Input Data reads from
external sources
C) Both tools function identically
D) Text Input is for numeric data only; Input Data is for text data
Answer: B) Text Input data is embedded in the workflow; Input Data
reads from external sources
Rationale: The key distinction is where the data resides. Text Input tool data
is embedded in the workflow (static, portable), while Input Data tool reads
from external files or databases (dynamic, must be shared separately) .
Source: Alteryx Core Exam Prep Guide; Stuvia
7. What does the "Append Suffix to File/Table Name" option do to
the output data file?
A) Appends the selected field name to the end of the file path
B) Appends the selected field name to the beginning of the file name
C) Appends the selected field name to the end of the name of the selected
table
D) Changes the file extension
