OMIS 350 – Chapter 6 – Flashcards
Unlock all answers in this set
Unlock answersquestion
True
answer
T/F: Zappos is an online shoe retailer, built its data-driven website caters to a specific niche market: consumers who were tired of finding that their most-desired items were always out of stock at traditional retailers.
question
True
answer
T/F: Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.
question
data
answer
Data mining is the process of analyzing data to extract information not offered by the raw _____ alone.
question
False ETL stands for extraction, transformation, and loading.
answer
T/F: ETL, within a data warehouse model, stands for exit, track, and load.
question
False Metadata provides details about data. A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
answer
T/F: A foreign key provides details about data.
question
standardize
answer
Data warehouses can _____ information like the example of gender.
question
True
answer
T/F: There are three primary data models for organizing information: the hierarchical, network, and relational database models.
question
integrity
answer
Relational _____ constraints are rules that enforce basic and fundamental information-based constraints.
question
False A data mart contains a subset of data warehouse information. Data mining is the process of analyzing data to extract information not offered by the raw data alone.
answer
T/F: A data miner contains a subset of data warehouse information.
question
logical
answer
The _____ view of information focuses on how individual users logically access information to meet their own business needs.
question
relational
answer
A _____ database model stores information in the form of logically related two-dimensional tables.
question
True
answer
T/F: Data redundancy is the duplication of data, or the storage of the same data in multiple places.
question
query
answer
Of the two primary tools available for retrieving information from a DBMS, the first is a _____ by example tool that helps users graphically design the answer to a question against a database.
question
False There are four primary traits that help determine the value of information: information type (transactional & analytical), timeliness, quality, and governance.
answer
T/F: There are two primary traits that help you determine the value of information: timeliness and quality.
question
True
answer
T/F: The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.
question
physical
answer
The _____ view of information deals with the physical storage of information on a storage device.
question
website
answer
Companies can gain valuable business knowledge by viewing the data accessed and analyzed from their _____.
question
False
answer
T/F: Data warehouses struggle with combining too much standardized information.
question
False A data mart contains a subset of data warehouse information. Data mining is the process of analyzing data to extract information not offered by the raw data alone.
answer
T/F: A data mart is the process of analyzing data to extract information not offered by the raw data alone.
question
database
answer
Broadly defined, a _____ maintains information about various types of objects, events, people, and places.
question
"Why?"
answer
Organizations using business intelligence can find the cause to many issues and problems simply by asking the question _____.
question
True
answer
T/F: Databases offer many security features, including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.
question
True
answer
T/F: A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
question
False Text mining analyzes unstructured data to find trends and patterns in words and sentences.
answer
T/F: Text mining analyzes structured data to find trends and patterns in words and sentences.
question
granularity
answer
Information is everywhere in an organization. Information _____ refers to the extent of detail within the information.
question
frequency
answer
Time-series information is time-stamped information collected at a particular _____.
question
True
answer
T/F: The core component of any system, regardless of size, is a database and a database management system.
question
True
answer
T/F: Organizational information comes at different levels and in different formats and granularities.
question
False The primary purpose of a data warehouse is to perform analytical processes.
answer
T/F: The primary purpose of a data warehouse is to perform transactional processes.
question
shoe
answer
Zappos credits its success as an online _____ retailer to its vast inventory of nearly 3 million products available through its dynamic data-driven website.
question
False A data warehouse is a logical connection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks
answer
T/F: A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.
question
rich
answer
Many organizations find themselves in the position of being data _____ and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.
question
True
answer
T/F: Data redundancy is the duplication of data, or the storage of the same data in multiple places.
question
scrubbing
answer
Information cleansing or _____ is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
question
True
answer
T/F: Information can tell an organization how it's currently performing and help it estimate and strategize for future plans and performance.
question
True
answer
T/F: A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.
question
False The advantages found in a relational database is: increased flexibility, increased scalability & performance, reduced information redundancy, increased information integrity (quality), and increased information security.
answer
T/F: One of the advantages found in a relational database is increased information redundancy.
question
website
answer
A data-driven _____ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.
question
True
answer
T/F: Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.
question
False Information granularity refers to the extent of detail within the information (fine & detailed or coarse & abstract). Information Quality refers to business decisions are only as good as the quality of the information used to make the decisions.
answer
T/F: Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).
question
True
answer
T/F: Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.
question
False Extraction, transformation, and loading is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.
answer
T/F: Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.
question
warehouse
answer
The primary purpose of a data _____ is to combine information, specifically, strategic information, throughout an organization into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.
question
False Timely information can change for each business decision. Some decisions require weekly information, while others require daily info.
answer
T/F: Timely information must be up-to-the-second to be accurate.
question
False DMS creates, reads, updates, and deletes data in a database while controlling access and security.
answer
T/F: MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.
question
False DBMS use these three primary data models for organizing information: hierarchical, network, and the relational database (the most prevalent).
answer
T/F: The three primary data models for organizing information in a DBMS are hierarchical, network, and metadata.
question
True
answer
T/F: If a manager identifies numerous data integrity issues, she or he should consider the reports generated from that data as invalid and not use them when making decisions.
question
False The technology industry uses business intelligence to predict hardware failures.
answer
T/F: The financial industry uses business intelligence to predict hardware failures.
question
structured
answer
Data mining occurs on _____ data that are already in a database or a spreadsheet.
question
loading
answer
Extraction, transformation, and _____ is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.
