Alteryx 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
The combination of the database, the DBMS, and the application programs that access
the database through the DBMS is referred to as the - Correct Answers -database
system.
Which statement below concerning the database management system (DBMS) is false?
- Correct Answers -The DBMS automatically creates application software for users,
based on data dictionary parameters.
When the human resources manager wants to gather data about salary and start date
by employees and by departments, the manager would use which language? - Correct
Answers -Data Query Language
The database requirement that foreign keys must be null or have a value corresponding
to the value of a primary key in another table is formally called the - Correct Answers -
referential integrity rule.
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.
, 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
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
Which is not a way that a Browse tool can be added to the Canvas? - Correct Answers -
Select a tool on the Canvas and hit Alt+Shift+B
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
How can data be added to a workflow with the Text Input tool? - Correct Answers -All
listed ways
Which of the following options is not a data type recognized in Designer? - Correct
Answers -Auto
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
The combination of the database, the DBMS, and the application programs that access
the database through the DBMS is referred to as the - Correct Answers -database
system.
Which statement below concerning the database management system (DBMS) is false?
- Correct Answers -The DBMS automatically creates application software for users,
based on data dictionary parameters.
When the human resources manager wants to gather data about salary and start date
by employees and by departments, the manager would use which language? - Correct
Answers -Data Query Language
The database requirement that foreign keys must be null or have a value corresponding
to the value of a primary key in another table is formally called the - Correct Answers -
referential integrity rule.
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.
, 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
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
Which is not a way that a Browse tool can be added to the Canvas? - Correct Answers -
Select a tool on the Canvas and hit Alt+Shift+B
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
How can data be added to a workflow with the Text Input tool? - Correct Answers -All
listed ways
Which of the following options is not a data type recognized in Designer? - Correct
Answers -Auto
