Chapter 3 Review
1) The amount of data produced worldwide is increasing by ___ percent each year.
50
1) Microsoft __________ is a popular example of a relational database.
Access
1) A ___________ is the smallest unit of data in the hierarchy of data for a computer-based file.
Bit
1) _________ are information consumers.
Customers
1) Which of the following is NOT a source system for a data warehouse?
DSS
1) One way to perform data integration is through _________.
ETL
1) Your course syllabus is an example of __________ knowledge.
Explicit
1) A byte is the smallest piece of data in a data hierarchy.
False
1) At its core, Sarbanes-Oxley is a federal regulation that helps control IT.
False
1) Big Data predictions come from teaching computers to think like humans.
False
1) Electronic medical records are now exclusively used by physicians.
False
1) Hadoop helped overcome the Ebola outbreak in Africa by making it easier to analyze data from many different sources.
False
1) IT people should be the ones solely responsible for creating data models.
False
1) Master data and transaction data are synonymous.
False
1) RFID implementation does not have any negative consequences for Colorado marijuana growers since RFID is so cheap and easy to use.
False
1) Tacit knowledge is easier to communicate to others than explicit knowledge.
False
1) The price of mobile data is the same for developing and developed countries.
False
1) The rapid increase in the number of new smartphones in developing countries has been accompanied by a corresponding increase in mobile marketing.
False
1) The term "Big Data" refers simply to the amount of data available, hence being "big".
False
1) Your phone number is an example of a _________.
Field
1) A customer number in an order table would be a __________ key.
Foreign
1) IBM's cloud-based analytics software incorporated data from a number of sources during the Ebola outbreak in Africa to create a(n) __________.
Heatmap
1) The ____________ architecture contains a central data warehouse that stores data with multiple dependent data marts.
Hub and spoke
1) To help fight the Ebola outbreak in Africa in 2013 and 2014, companies in Africa partnered with _____.
IBM
1) _________ are information producers.
IT developers
1) John Smith is a customer of XYZ Co. In the database, John Smith is a(n) _________.
Instance
1) If your database system is designed to ensure there are no alphabetic characters in a phone number, this is maximizing data _______.
Integrity
1) Database systems minimize data _________.
Isolation
1) __________ is an entry point to the mobile Web that allows marketers to send ads to mobile users around the world at no cost to the user.
Jana
1) Intellectual capital is another term for ____________.
Knowledge
1) Today many organizations employ _________ databases to process Big Data.
NoSQL
1) A ____________ key uniquely identifies a record.
Primary
1) ____________ is used to track marijuana production in Colorado.
RFID
1) A __________ generally describes an entity.
Record
1) Your last name is a ____________ key.
Secondary
1) Database systems maximize data _________.
Security
1) Which of the following is NOT a problem associated with Big Data?
Security
1) Most students in your major try to avoid a few professors because their classes seem to be harder for some reason. This is an example of _______ knowledge.
Tacit
1) Companies are drowning in data.
True
1) Decisions about data last longer, and have a broader impact, than decisions about hardware and software.
True
1) Hadoop allows TrueCar to work with rapidly increasing amounts of data in an economical way.
True
1) Performance Bicycle implemented a knowledge management system to help employees and customers share their love of their cycling lifestyle.
True
1) Practically, users should not have access to databases.
True
1) Relational databases reduce the data redundancy found in flat files.
True
1) The goal of master data management is to get rid of information silos.
True
1) The independent data mart is not particularly effective because it creates information silos.
True
1) To reduce Medicaid costs, Washington State and hospitals compromised by implementing a database to track patient visits to the ER.
True
1) Which of the following companies was NOT mentioned in the "Giving Data Away for Free" as having used zero-rating for some time?
1) Of the following countries, which one has the most expensive but most used mobile data?
US
1) Comments posted on social networking sites illustrate the ________ characteristic of Big Data.
Variety
1) "The number of messages on Twitter is growing at 200 percent every year." This is the _____ characteristic of Big Data.
Velocity
1) Which of the following Big Data characteristics is NOT a problem for cancer treatment centers?
Veracity
1) Which of the following is NOT a characteristic of Big Data?
Veracity
1) "In 2015, Google was processing more than 27 petabytes of data every day." This is the _____ characteristic of Big Data.
Volume
1) The state of Washington is using ___________ to reduce Medicaid costs.
a Database
1) In 2000, _____ percent of the stored information in the world was digital. By 2015, ___ percent of the stored information in the world was digital.
a. 25; 98
1) _______________ is a set of programs that provide users with tools to create and manage a database.
a. A DBMS
1) Which of the following is NOT a reason an organization would use a data warehouse or data mart rather than a database?
a. A database's information is organized in a way that makes it easy to answer a query, but data warehouses and data marts are faster.
1) Sarbanes-Oxley holds _______ personally responsible for __________ disclosures.
a. CFOs; financial
1) Which of the following is NOT a reason managing data is difficult?
a. Data is consistent across different systems but difficult to secure.
1) Which of the following is NOT a reason managing data is difficult?
a. Data is usually structured but hard to identify.
1) Compared to data warehouses, data marts are NOT ________.
a. Easier to use
1) A data file is a collection of logically related ________.
a. Records
1) Which of the following is NOT true of Big Data?
a. Relational databases easily handle Big Data.
1) Which of the following is FALSE of TrueCar's use of Hadoop?
a. TrueCar uses a data river to collect information.
1) 20 percent of all ER visits paid for by Medicaid are _____________.
a. attributed to patients going to the ER more than 4 times a year
1) From smallest to largest, which of the following is the correct order of the hierarchy of data for a computer-based file?
a. bit, byte, field, record, file, database
1) Which of the following is the correct order of the KMS cycle?
a. create, capture, refine, store, manage, disseminate
1) One strategy for implementing _________ is ___________.
a. data governance; master data management
1) Performance Bicycle added a knowledge management system to capture _______ knowledge for the benefit of _________.
a. employee; customers
1) Electronic medical records __________ addressed the data aggregation and integration issue in the health care field; more than ______ percent of US medical records remain in hard-copy format.
a. have not; 25
1) Performance Bicycle implemented a _______ to improve its business.
a. knowledge management system
1) A data ___________ is a low-cost, scaled down version of a data ___________ that is designed for the end-user needs in a SBU or an individual department.
a. mart; warehouse
1) ___________ data are applied to multiple transactions and are used to categorize, aggregate, and evaluate the __________ data.
a. master; transaction
1) Flatiron Health decided the most pressing need in cancer treatment was __________.
a. to organize the massive volumes of clinical data that are scattered in the filing systems of oncology treatment centers throughout the country
1) TrueCar created a 2-petabyte Hadoop data _________ which stores vast amounts of data in their native (original) format until they are needed, rather than forcing the integration of large volumes of data before analysis.
lake
1) Colorado implemented RFID to track its marijuana production. Which of the following is NOT a problem these RFID tags fixed?
legality
1) Big Data is about _______.
predictions
1) Data _________ is a problem with implementing Hadoop.
security
1) Jana's mCent aims to provide free mobile data to users throughout the world. This solution to the internet access problem is called ___________.
sponsored data
1) Knowledge management is a process that helps organizations manipulate important knowledge that comprises part of the organization's memory, usually in a(n) ________ format.
unstructured
