Alteryx Foundation Micro-Credential Exam
Questions and Answers
switch function - Correct Answers -what is a shortened version of a multiconditional
statement that has three or more possible outcomes
numeric data - Correct Answers -another term for Quantitative data
categorical data - Correct Answers -qualitative data can also be called
grouping of information - Correct Answers -categorical data allows for
ordinal and independent data - Correct Answers -two subcategories of categorical data
categorical or qualitative data - Correct Answers -ordinal data is a subcategory of
categorical or qualitative data - Correct Answers -independent data is a subcategory of
big, medium, small; before, during, after - Correct Answers -example of a set ordinal
data
set of colors, phone numbers, zip codes, demograpics - Correct Answers -example of a
set of independent data
extracting information from text data - Correct Answers -what is text mining
learn what topics are discussed without reading the documents - Correct Answers -what
is topic modeling
determining what the author felt - Correct Answers -what is sentiment analysis
structured, semi-structured, unstructured - Correct Answers -what are three categories
of data
append fields - Correct Answers -tool that allows you to combine fields from a source
input to every record of a target input. Each record of the target input will be duplicated
for every record in the source input
, data cleansing tool - Correct Answers -tool that allows you to fix common data quality
issues. You can replace null values, remove punctuation, modify capitalization and
more.
output data - Correct Answers -tool that allows you to output the contents of a data
stream to a file or database
if, then, else, endif - Correct Answers -Basic Conditional Statements in the designer are
composed of what four parts or clauses
regular and predictable format - Correct Answers -what is a feature of Structured data
structured data that arranged values in tables - Correct Answers -what is tabular data
data that is regular, but not necessarily standard format - Correct Answers -what is
semi-structured data
text documents, video files, social media posts, audio files and pictures - Correct
Answers -what are a few examples of unstructured data
unstructured - Correct Answers -among Structured, Semi-Structured, and Unstructured;
which accounts the largest category
.csv and .xls, .xlsx and .xlsm - Correct Answers -name 2 spreadsheet file extensions
.doc, .txt, .pages, .pdf - Correct Answers -what are some document file extensions
.jpg, .png, .pdf - Correct Answers -what are some image file extensions
.pdf - Correct Answers -what file extension is for both documents and images
.png - Correct Answers -of the three different image file types, which is for higher quality
images
.mp3 and .wav - Correct Answers -what are two different audio file extensions
.wav - Correct Answers -of the 2 different audio file types, which is for high quality
.mp4, .avi, .mov - Correct Answers -what are three video file extensions
.avi - Correct Answers -of the three video file extensions, which was developed by
microsoft
.mov - Correct Answers -of the three video file extensions, which was developed by
apple
Questions and Answers
switch function - Correct Answers -what is a shortened version of a multiconditional
statement that has three or more possible outcomes
numeric data - Correct Answers -another term for Quantitative data
categorical data - Correct Answers -qualitative data can also be called
grouping of information - Correct Answers -categorical data allows for
ordinal and independent data - Correct Answers -two subcategories of categorical data
categorical or qualitative data - Correct Answers -ordinal data is a subcategory of
categorical or qualitative data - Correct Answers -independent data is a subcategory of
big, medium, small; before, during, after - Correct Answers -example of a set ordinal
data
set of colors, phone numbers, zip codes, demograpics - Correct Answers -example of a
set of independent data
extracting information from text data - Correct Answers -what is text mining
learn what topics are discussed without reading the documents - Correct Answers -what
is topic modeling
determining what the author felt - Correct Answers -what is sentiment analysis
structured, semi-structured, unstructured - Correct Answers -what are three categories
of data
append fields - Correct Answers -tool that allows you to combine fields from a source
input to every record of a target input. Each record of the target input will be duplicated
for every record in the source input
, data cleansing tool - Correct Answers -tool that allows you to fix common data quality
issues. You can replace null values, remove punctuation, modify capitalization and
more.
output data - Correct Answers -tool that allows you to output the contents of a data
stream to a file or database
if, then, else, endif - Correct Answers -Basic Conditional Statements in the designer are
composed of what four parts or clauses
regular and predictable format - Correct Answers -what is a feature of Structured data
structured data that arranged values in tables - Correct Answers -what is tabular data
data that is regular, but not necessarily standard format - Correct Answers -what is
semi-structured data
text documents, video files, social media posts, audio files and pictures - Correct
Answers -what are a few examples of unstructured data
unstructured - Correct Answers -among Structured, Semi-Structured, and Unstructured;
which accounts the largest category
.csv and .xls, .xlsx and .xlsm - Correct Answers -name 2 spreadsheet file extensions
.doc, .txt, .pages, .pdf - Correct Answers -what are some document file extensions
.jpg, .png, .pdf - Correct Answers -what are some image file extensions
.pdf - Correct Answers -what file extension is for both documents and images
.png - Correct Answers -of the three different image file types, which is for higher quality
images
.mp3 and .wav - Correct Answers -what are two different audio file extensions
.wav - Correct Answers -of the 2 different audio file types, which is for high quality
.mp4, .avi, .mov - Correct Answers -what are three video file extensions
.avi - Correct Answers -of the three video file extensions, which was developed by
microsoft
.mov - Correct Answers -of the three video file extensions, which was developed by
apple
