FCR 110 COMPREHENSIVE TEST BANK
COMPLETE QUESTIONS AND ANSWERS
PRACTICE SOLUTION VERIFIED
◉ Information in data warehouses and data marts is __________, so it
reflects history, which is critical for identifying and analyzing trends.
Answer: nonvolatile
◉ According to DOMO, about how long does it take for users to
upload 48 hours of new video to YouTube, post 100,000 new tweets
to Twitter, and Instagram users to share 3,600 new photos? Answer:
One minute
◉ Which of the following is NOT one of the terms used to describe
the way in which data mining is able to identify actionable patterns in
business data? Answer: Alignment
◉ What term is used to describe the result of summarizing
information stored in a row or column of a data cube (i.e, combining
all information in a row or column into a single consolidated value)
through the process described in class as a projection? Answer: Data
Abstraction
,◉ What term is used to describe the set of functionalities that
facilitate multi-dimensional data analysis for faster, more informed
decision making? Answer: OLAP (On-line Analytical Processing)
◉ In the Purdue University video Mining Data to Ensure Student
Success at Purdue case study on student success, the "Signals" data
mining project, as described by Purdue's CIO, was able to identify
students likely to fail a class at what point in the semester? Answer:
By the end of the second week of class
◉ Commonly associated with clustering data mining, describing data
as having temporal proximity indicates the data are connected by
what common attribute? Answer: Time
◉ What data mining method uses historical information to predict
future events based on statistical models such as regression analysis?
Answer: Forecasting
◉ If the evaluation of the first parameter of an Excel IFERROR
function (shown in bold/underlined in the example below) does NOT
return an error (e.g., #N/A), what value does the IFERROR function
return?
=IFERROR( VLOOKUP(H15,D$11:F$19,3,FALSE), "Unknown" )
Answer: The value of the first parameter
◉ Although not an exact equivalent, the first column of the data range
in a VLOOKUP table_array serves a role that is similar to what
database concept?
, VLOOKUP( lookup_value, table_array, col_index_num,
range_lookup) Answer: Primary Key
◉ In the following example, if we change the "column_index_num"
value from 3 to 6 (e.g., =VLOOKUP(5, B3:H16, 6,) ), what value will
be returned?
=VLOOKUP(lookup_value, table_array, column_index_num,
range_lookup) Answer: 24.53
◉ In the Excel expression "=VLOOKUP(5, B4:H16, 3,
range_lookup)", what value should be used for range_lookup to return
a value only when the lookup value in the table_array matches "5"?
=VLOOKUP(lookup_value, table_array, column_index_number,
range_lookup) Answer: FALSE
◉ In a cross-sheet reference, what aspect of a worksheet name would
require the worksheet name to be enclosed in single quote marks (e.g.,
'Customer Data'!A1)? Answer: The worksheet name has an embedded
space
◉ What term was used to describe using the digging tool to examine
the underlying data, such as when CopLink allows you to examine
data for a specific neighborhood or time period? Answer: Drill Down
◉ The web-based system developed MIS Professor Ram using WiFi
log data help decision makers respond to the COVID-19 pandemic on
campus in all of the following ways EXCEPT: Answer: Scheduling
appointments for getting a vaccine shot
COMPLETE QUESTIONS AND ANSWERS
PRACTICE SOLUTION VERIFIED
◉ Information in data warehouses and data marts is __________, so it
reflects history, which is critical for identifying and analyzing trends.
Answer: nonvolatile
◉ According to DOMO, about how long does it take for users to
upload 48 hours of new video to YouTube, post 100,000 new tweets
to Twitter, and Instagram users to share 3,600 new photos? Answer:
One minute
◉ Which of the following is NOT one of the terms used to describe
the way in which data mining is able to identify actionable patterns in
business data? Answer: Alignment
◉ What term is used to describe the result of summarizing
information stored in a row or column of a data cube (i.e, combining
all information in a row or column into a single consolidated value)
through the process described in class as a projection? Answer: Data
Abstraction
,◉ What term is used to describe the set of functionalities that
facilitate multi-dimensional data analysis for faster, more informed
decision making? Answer: OLAP (On-line Analytical Processing)
◉ In the Purdue University video Mining Data to Ensure Student
Success at Purdue case study on student success, the "Signals" data
mining project, as described by Purdue's CIO, was able to identify
students likely to fail a class at what point in the semester? Answer:
By the end of the second week of class
◉ Commonly associated with clustering data mining, describing data
as having temporal proximity indicates the data are connected by
what common attribute? Answer: Time
◉ What data mining method uses historical information to predict
future events based on statistical models such as regression analysis?
Answer: Forecasting
◉ If the evaluation of the first parameter of an Excel IFERROR
function (shown in bold/underlined in the example below) does NOT
return an error (e.g., #N/A), what value does the IFERROR function
return?
=IFERROR( VLOOKUP(H15,D$11:F$19,3,FALSE), "Unknown" )
Answer: The value of the first parameter
◉ Although not an exact equivalent, the first column of the data range
in a VLOOKUP table_array serves a role that is similar to what
database concept?
, VLOOKUP( lookup_value, table_array, col_index_num,
range_lookup) Answer: Primary Key
◉ In the following example, if we change the "column_index_num"
value from 3 to 6 (e.g., =VLOOKUP(5, B3:H16, 6,) ), what value will
be returned?
=VLOOKUP(lookup_value, table_array, column_index_num,
range_lookup) Answer: 24.53
◉ In the Excel expression "=VLOOKUP(5, B4:H16, 3,
range_lookup)", what value should be used for range_lookup to return
a value only when the lookup value in the table_array matches "5"?
=VLOOKUP(lookup_value, table_array, column_index_number,
range_lookup) Answer: FALSE
◉ In a cross-sheet reference, what aspect of a worksheet name would
require the worksheet name to be enclosed in single quote marks (e.g.,
'Customer Data'!A1)? Answer: The worksheet name has an embedded
space
◉ What term was used to describe using the digging tool to examine
the underlying data, such as when CopLink allows you to examine
data for a specific neighborhood or time period? Answer: Drill Down
◉ The web-based system developed MIS Professor Ram using WiFi
log data help decision makers respond to the COVID-19 pandemic on
campus in all of the following ways EXCEPT: Answer: Scheduling
appointments for getting a vaccine shot
