Big data chapter 1-stats quizes – Flashcards

What can the BI users in an organization help guide and direct? -how to implement and deploy a BI initiative that can be lengthy, expensive, and failure prone -how the DW is structured and the types of BI tools and other supporting software that are needed -how to decompose the planning and execution into business, organization, functionality, and infrastructure components -how the DW is structured and the costs and the appreciation for different classes of potential users

Business intelligence (BI) can be characterized as a transformation of

In answering the question "Which customers are likely to be using fake credit cards?" you are most likely to use which of the following analytic applications?

The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of predictive analytics. (T/F)

Once a data warehouse is in place, the general process of intelligence creation begins with

The term intelligence in a BI context is used to describe clandestine operations dedicated to stealing corporate secrets, in the manner of the government's CIA and other covert agencies. (T/F)

Information systems that support such transactions as ATM withdrawals, bank deposits, and cash register scans at the grocery store represent transaction processing, one of the critical components of BI. (T/F)

Actionable intelligence is the primary goal of modern-day Business Intelligence (BI) systems vs. historical reporting that characterized Management Information Systems (MIS). (T/F)

The very design that makes an OLTP system efficient for transaction processing makes it inefficient for what? -end-user ad hoc reports, queries, and analysis -transaction processing systems that constantly update operational databases -the collection of reputable sources of intelligence -transactions such as ATM withdrawals, where we need to reduce a bank balance accordingly

One of the four components of BI systems, business performance management, is a collection of source data in the data warehouse. (T/F)

If a company's strategy is properly aligned with DW and BI initiatives, and if the company's IS organization can be made capable of playing its role in such a project, and if the requisite user community is in place and has the proper motivation, then -it is no longer necessary to start BI within the company. -it has the basics down and you can go to the next steps of starting BI and establishing a BI Competency Center (BICC) within the company. -the organization is ready for the introduction of new data-generating technologies, such as radio-frequency identification (RFID). -business leaders are required to document their business processes and to sign off on the legitimacy of the information they rely on.

The access to data and ability to manipulate data (frequently including real-time data) are key elements of business intelligence (BI) systems. (T/F)

Organizations counter the pressures they experience in their business environments in multiple ways. Which of the following is NOT an effective way to counter these pressures? -reactive actions -anticipative actions -adaptive actions -retroactive actions

Traditional BI systems use a large volume of static data that has been extracted, cleansed, and loaded into a data warehouse to produce reports and analyses. (T/F)

The two critical partnerships required for BI governance are (a) a partnership between functional area users and/or product/service area employees, and (b) a partnership between representatives of the marketing and vendor sides. (T/F)

Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses. (T/F)

Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them. (T/F)

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. (T/F)

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. (T/F)

OLTP databases are optimized for output (querying/asking questions of the data) and data warehouses are optimized for input (getting new or updated data into the database). (T/F)

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are

Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks (T/F)

Data warehouses are subsets of data marts. (T/F)

One way an operational data store differs from a data warehouse is the recency of their data. (T/F)

Active data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is

Which of the following is a common way of visualizing the frequency distribution of data points over a range of possible values?

Statistical Data Variable Type: A variable that contains the values of United States Zip Codes (aka Postal Codes) would best be categorized as which of the following variable types?

Statistical Data Variable Type: A variable that contains a countable number of distinct values would best be categorized as which of the following variable types?

Statistical Data Variable Type: There is a web-based survey that asks you, "On a rating of 1(hated it) to 5(loved it), how much did you like the movie." This value is stored in your database and you need to categorize the statistical variable type. Which of the following variable types would be best?

Statistical Data Variable Type: A variable that contains the values of either Yes or No would best be categorized as which of the following variable types?