CSC220 Chapter 9

24 July 2022
4.7 (114 reviews)
17 test answers

Unlock all answers in this set

Unlock answers (13)
question
The goal of business intelligence is to _____. a. provide access to novel tools to the users b. reduce the cost of data processing c. support and improve decision making d. improve employee morale
answer
c. support and improve decision making
question
Which of the following is NOT considered business intelligence practice? a. Data extraction b. Visualization c. Analysis d. Transaction processing
answer
d. Transaction processing
question
What is the projected shortage of data scientists in the USA, according to a McKinsey & Co. report? a. 100,000 or less b. 100,000 to 200,000 c. 200,000 to 500,000 d. more than 500,000
answer
b. 100,000 to 200,000
question
Which of the following is NOT a commonly used BI tool? a. data visualization b. linear regression c. drill-down analysis d. automated customer service
answer
d. automated customer service
question
Which of the following is NOT considered a BI and analytics tool? a. Data visualization b. Drill-down analysis c. Online transaction processing d. Data mining
answer
c. online transaction processing
question
To analzye various alternative scenarios, a manager would use _______. a. the spreadsheet's 'what-if' capability b. the graphing features of spreadsheet software c. the reporting feature of a BI tool d. a data visualization tool
answer
a. the spreadsheet's 'what-if' capability
question
The graphical representation that summarizes the steps a consumer takes in making the decision to buy your product and become a customer is called _____. a. a word cloud b. a conversation funnel c. a scatter diagram d. a pivot chart
answer
b. a conversation funnel
question
What determines the size of words in a word cloud? a. length of the word or phrase b. difficulty in pronouncing the word or phrase c. whether the word is a pronoun d. frequency of occurrence of the word in source documents
answer
d. frequency of occurrence of the word in source documents
question
Suppose you have access to quantitative data on populations by ZIP code and crime rates. You wish to determine if there is a relationship between the two variables and display the results in a graph. Which BI tool will be most useful? a. Word cloud tool b. Querying tool c. Reporting tool d. Data visualization tool
answer
d. data visualization tool
question
Data within the data cube has been ______ by specific dimensional values. a. correlated b. summarized c. regressed d. drilled into
answer
b. summarized
question
The coefficient of determination, r squared, is ____. a. the same as the error term in a linear regression b. a number that indicates how well data fits the statistical model c. a number that must be close to zero to be useful d. the same as the slope of the linear regression
answer
b. a number that indicates how well data fits the statistical model
question
Which of the following is NOT true about linear regression? a. both of the variables must be quantitative variables b. the line minimizes the sum of the squared errors of prediction c. the technique implies causality between the independent and the dependent variables d. consists of finding the best-fitting straight line through a set of observations
answer
c. the technique implies causality between the independent and the dependent variables
question
_____ is used to explore large amounts of data for hidden patterns to predict future trends. a. Data governance b. Data mining c. Linear regression d. Drill down
answer
b. data mining
question
____ is the last phase of the six-phase CRISP-DM method. a. Evaluation b. Modeling c. Business understanding d. Deployment
answer
d. deployment
question
Which of the following is NOT a component of a KPI (key performance indicator)? a. direction b. measure c. time frame d. format
answer
d. format
question
Which of the following is IBM's BI product? a. Power BI b. Business objects c. Cognos d. Hyperion
answer
c. cognos
question
From which vendor is the BI product Business Objects available? a. IBM b. SAP c. Google d. Microsoft
answer
b. SAP