Alteryx Core Cert – MS Exam Questions
and Answers
Which of the following statements below shows the contrast between data and
information? - Correct Answers -Information is the primary output of an accounting
information system.
The value of information can best be determined by - Correct Answers -the benefits
associated with obtaining the information minus the cost of producing it.
Data must be converted into information to be considered useful and meaningful for
decision making. There are seven characteristics that make information both useful and
meaningful. If information is free from error or bias and accurately represents the events
or activities of the organization, it is representative of the characteristic of - Correct
Answers -reliability.
Identify the piece of information below that is typically needed to hire and train
employees. - Correct Answers -job descriptions
Transaction cycles can be summarized on a high level as "give-get" transactions. An
example of "give-get" in the revenue cycle would be - Correct Answers -give goods, get
cash.
What does the "Change Entire File Path" option do to the output data file? - Correct
Answers -Changes the file name to the name of the selected field. The name must be a
complete file path. This option can overwrite an existing file if a file exists in the full path
directory
What does Default Sort do to numeric string data? - Correct Answers -Using the default
sort, numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Correct Answers -Using the
dictionary sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Correct Answers -Use Auto Field to read through
all of the records of an input and set the field type to the smallest possible size relative
to the data contained within the column.
The tool correctly assigns a numeric field to a string data type where any record starts
with zero and not a number.
, An AIS provides value by - Correct Answers -both improving products or services
through information that increases quality and reduces costs and providing timely and
reliable information to decision makers
Which of the following is a true statement? - Correct Answers -Business strategy
directly influences AIS, but not information technology.
Which of the following is a primary activity in the value chain? - Correct Answers -
marketing and sales
Which of the following is not one of the components of an AIS? - Correct Answers -
Hardware: refers to the computer's tangible components or delivery systems that store
and run the written instructions provided by the software.
Information that does not omit important aspects of the underlying events or activities
that it measures is - Correct Answers -complete.
The Browse tool: - Correct Answers -green binoculars
The Dynamic Input tool: - Correct Answers -grey pointy circle with white book
To limit the number of input rows to 10 from a CSV file, where will you put the number
10 in the Configuration window? - Correct Answers -Record Limit
Which of the following file types support reading in multiple sheets? - Correct Answers
-.xlsx
Which of the following statements are true? - Correct Answers -The Output Data tool's
configuration options change based on the output file type.
Base on the table below, how many output files will be produced when the Output Data
tool is configured as shown? (The field chosen is Common Name) - Correct Answers -
Two (2)
Cells that are left blank in the Text Input tool are assigned what value? - Correct
Answers -Null
Which of the following options is not a data type recognized in Designer? - Correct
Answers -Auto
Which of the values are not included in a data stream's metadata in Designer? - Correct
Answers -Rename
Longer statements that document a workflow are best put in a ________ while shorter
comments are better in a(n) ___________. - Correct Answers -comment tool,
annotation
and Answers
Which of the following statements below shows the contrast between data and
information? - Correct Answers -Information is the primary output of an accounting
information system.
The value of information can best be determined by - Correct Answers -the benefits
associated with obtaining the information minus the cost of producing it.
Data must be converted into information to be considered useful and meaningful for
decision making. There are seven characteristics that make information both useful and
meaningful. If information is free from error or bias and accurately represents the events
or activities of the organization, it is representative of the characteristic of - Correct
Answers -reliability.
Identify the piece of information below that is typically needed to hire and train
employees. - Correct Answers -job descriptions
Transaction cycles can be summarized on a high level as "give-get" transactions. An
example of "give-get" in the revenue cycle would be - Correct Answers -give goods, get
cash.
What does the "Change Entire File Path" option do to the output data file? - Correct
Answers -Changes the file name to the name of the selected field. The name must be a
complete file path. This option can overwrite an existing file if a file exists in the full path
directory
What does Default Sort do to numeric string data? - Correct Answers -Using the default
sort, numeric strings are sorted left to right, character by character
What does Dictionary Sort do to numeric string data? - Correct Answers -Using the
dictionary sort, numeric strings are sorted from the smallest to largest number
What does the Auto Field Tool do? - Correct Answers -Use Auto Field to read through
all of the records of an input and set the field type to the smallest possible size relative
to the data contained within the column.
The tool correctly assigns a numeric field to a string data type where any record starts
with zero and not a number.
, An AIS provides value by - Correct Answers -both improving products or services
through information that increases quality and reduces costs and providing timely and
reliable information to decision makers
Which of the following is a true statement? - Correct Answers -Business strategy
directly influences AIS, but not information technology.
Which of the following is a primary activity in the value chain? - Correct Answers -
marketing and sales
Which of the following is not one of the components of an AIS? - Correct Answers -
Hardware: refers to the computer's tangible components or delivery systems that store
and run the written instructions provided by the software.
Information that does not omit important aspects of the underlying events or activities
that it measures is - Correct Answers -complete.
The Browse tool: - Correct Answers -green binoculars
The Dynamic Input tool: - Correct Answers -grey pointy circle with white book
To limit the number of input rows to 10 from a CSV file, where will you put the number
10 in the Configuration window? - Correct Answers -Record Limit
Which of the following file types support reading in multiple sheets? - Correct Answers
-.xlsx
Which of the following statements are true? - Correct Answers -The Output Data tool's
configuration options change based on the output file type.
Base on the table below, how many output files will be produced when the Output Data
tool is configured as shown? (The field chosen is Common Name) - Correct Answers -
Two (2)
Cells that are left blank in the Text Input tool are assigned what value? - Correct
Answers -Null
Which of the following options is not a data type recognized in Designer? - Correct
Answers -Auto
Which of the values are not included in a data stream's metadata in Designer? - Correct
Answers -Rename
Longer statements that document a workflow are best put in a ________ while shorter
comments are better in a(n) ___________. - Correct Answers -comment tool,
annotation
