BIS Quiz 3
A
A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks. A. logical; operational B. physical; operational C. logical; transactional D. physical; transactional
Primary Key
A field (or group of fields) that uniquely identifies a given entity in a table
Table
Composed of rows and columns that represent an entity
True
Date of birth would be a stored attribute
Primary Key
Field that uniquely identifies a given record in a table
C
Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ________. A. information scaling B. streamlining data points C. standardizing information D. standardizing protocols
Data rich, information poor
Many organizations find themselves in the position of being ___ and ___. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence
B
Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls. A. improvements B. change C. clustering D. cleansing
One-to-one relationship
Occurs between two entities in which an instance of one entity can be related to only one instance of a related entity
Relational Databases
Offer many advantages over using a text document or a spreadsheet, which include increased flexibility and increased scalability and performance
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
Data-driven websites
Offer several advantages as it is far easier to manage content and store large amounts of data
D
One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database? A. reduces disk space requirements B. makes updating information easier C. improves information quality D. All of these are correct
Data warehouse
Primary purpose of a __ is to perform analytical process
Relational Databases
Reduce information redundancy, not increase information redundancy
C
Some of the serious business consequences that occur due to using low-quality information to make decisions are all of the following except A. inability to accurately track customers. B. inability to identify selling opportunities. C. the success of the organization depends on appreciating and leveraging the low-quality information. D. lost revenue opportunities from marketing to nonexistent customers
Timeliness, quality, type, and governance
The 4 main primary traits that help determine the value of information
A
The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information. What is this an example of? A. increased scalability and performance B. increased information security C. reduced information redundancy D. increased flexibility
A
The primary purpose of a data warehouse is to ________. A. combine strategic information B. organize departments C. interface between the computer and employees D. All of these are correct.
Technology industry
Uses business intelligence to predict hardware failures, where the retail industry uses it to predict sales, inventory levels, and distribution
Banking industry
Uses business intelligence to understand customer credit card usage and nonpayment rates
C
What are the primary differences between a data warehouse and a data mart? A. Data warehouses make quick decisions, data marts make slow decisions. B. Data warehouses tackle ethical issues, data marts tackle hypothetical issues. C. Data warehouses have a more organization-wide focus, data marts have functional focus. D. Data warehouses have a physical focus, data marts have logical focus
D
What do data warehouses support? A. OLAP B. analytical processing C. OLTP D. OLAP and analytical processing
D
What exists to represent the relationship between two other entities? A. one-to-one relationship B. one-to-many relationship C. many-to-many relationship D. composite entity
A
What expresses the specific number of instances in an entity? A. cardinality B. composite entity C. business rule D. null-valued attribute
A
What has only a single value of each attribute of an entity? A. single-valued attribute B. multivalued attribute C. null-valued attribute D. All of these are correct
B
What has the potential to contain more than one value for an attribute? A. single-valued attribute B. multivalued attribute C. null-valued attribute D. All of these are correct.
A
What is a characteristic of a table? A. field B. table C. record D. key
C
What is a collection of related data elements? A. field B. table C. record D. key
B
What is a foreign key? A. a field that uniquely identifies a given record in a table B. 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 C. a table that uniquely identifies a given record in a field D. a foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two records
A
What is a primary key? A. a field that uniquely identifies a given record in a table B. 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 C. a table that uniquely identifies a given record in a field D. a foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two records
D
What is a statement that defines an aspect of a business? A. attribute B. entity C. business relational diagram D. business rule
A
What is a technique for documenting the entities and relationships in a database environment? A. entity-relationship diagram B. data model C. database D. relational database model
C
What is an example of using cluster analysis in business to create target-marketing strategies? A. Google search B. first name information C. zip code segmentation D. last name associations
A
What is another term for data that is already contained in a database or a spreadsheet? A. structured data B. unstructured data C. text mining D. web mining
B
What is composed of rows and columns that represent an entity? A. field B. table C. record D. key
B
What is extraction, transformation, and loading? A. It is a process of entering data, tracking data, and loading it into a database. B. It 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. C. It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube. D. It is a process that is performed at the beginning of the data mining model
A
What is it called when a manager has so much data and information that he or she cannot make a decision? A. data rich, information poor B. data rich, content poor C. data rich, communication poor D. data rich, intelligence
A
What is it called when each transaction, entity, and event is represented only once in the information? A. uniqueness B. accuracy C. consistency D. timeliness
C
What is one of the biggest pitfalls associated with real-time information? A. It is only available to high-level executives due to the expense. B. It is only available in aggregate levels of granularity. C. It continually changes. D. It rarely changes.
C
What is the logical view of information? A. deals with the physical storage of information on a storage device such as a hard disk B. deals with the logical storage of information on a storage device such as a hard disk C. focuses on how users logically access information to meet their particular business needs D. focuses on how users physically access information to meet their particular business needs
D
What is the primary problem with redundant information? A. It is difficult to determine which values are the most current. B. It is often inconsistent. C. It is difficult to determine which values are the most accurate. D. All of these are correct.
D
What is the ultimate outcome of a data warehouse? A. data goals B. data relationships C. data marketing D. data marts
C
What kind of attribute can be calculated using the value of another attribute? A. single-valued attribute B. multivalued attribute C. derived attribute D. stored attribute
D
What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown? A. single-valued attribute B. multivalued attribute C. derived attribute D. null-valued attribute
C
What kind of attribute would be age? A. null-valued attribute B. multivalued attribute C. derived attribute D. stored attribute
D
What kind of attribute would be date of birth? A. null-valued attribute B. multivalued attribute C. derived attribute D. stored attribute
A
What kind of attribute would be given for a person who does not have an email address? A. null-valued attribute B. multivalued attribute C. single-valued attribute D. stored attribute
B
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity? A. one-to-one relationship B. one-to-many relationship C. many-to-many relationship D. composite entity
A
What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity? A. one-to-one relationship B. one-to-many relationship C. many-to-many relationship D. composite entity
C
What occurs when two entities can be related to each other in many instances? A. one-to-one relationship B. one-to-many relationship C. many-to-many relationship D. composite entity
A
What type of integrity constraint does not allow someone to create an order for a nonexistent customer? A. relational integrity constraint B. business-critical integrity constraint C. information-critical integrity constraint D. mission-critical integrity constraint
B
What type of keys do you need to use to create a relational database model? A. primary keys and secondary keys B. primary keys and foreign keys C. entity keys and attribute keys D. relational keys and DBMS keys
D
Which of the choices below does not represent an organization that requires up-to-the-second information? A. 911 response center B. stock traders C. banks D. construction companies
B
Which of the following illustrates the primary concepts of the relational database model? A. ethics, applications, keys, and relationships B. entities, attributes, keys, and relationships C. endeavor, aspire, control, and regulate D. early, after, before, and future
C
Which of the following implies that aggregate or summary information is in agreement with detailed information? A. uniqueness B. completeness C. consistency D. accuracy
D
Which of the following implies that information is current with respect to the business requirement? A. uniqueness B. accuracy C. consistency D. timeliness
C
Which of the following is a disadvantage of database-stored information? A. increased flexibility B. increased performance C. increased information redundancy D. increased information integrity
D
Which of the following is a possible business rule? A. a customer can purchase many DVDs B. DVDs can be purchased by many customers C. a DVD title can have many copies D. All of these are correct.
D
Which of the following is a type of attribute? A. single-valued attribute B. multivalued attribute C. null-valued attribute D. All of these are correct.
D
Which of the following is a valid type of integrity constraint? A. relational-critical integrity constraint B. business integrity constraint C. relational integrity constraint D. business-critical integrity constraint
C
Which of the following is an example of an external databases in the data warehouse model? A. marketing information B. sales information C. competitor information D. All of these are correct
A, E
Which of the following is an example of external databases in the data warehouse model? A. competitor and industry information, mailing lists, and stock market analysis B. marketing, sales, inventory, and billing C. marketing information, sales information, and stock market analysis D. data mart 1, data mart 2, and data mart 3 E. competitor and industry information, mailing lists, and stock market analysis F. marketing information, sales information, and stock market analysis
C
Which of the following is correct in reference to a database? A. A database can support only one logical view. B. A database can support many physical views. C. A database can support many logical views. D. A database can support up to 3 logical views
C
Which of the following is incorrect in reference to a database? A. A database can be relational or network. B. Database information is accessed by logical structure. C. Database information is accessed by physical structure. D. Database users can have different views of information
A
Which of the following is not a common form of data mining analysis? A. division organization B. classification C. estimation D. clustering
C
Which of the following is not an advantage to a data-driven website? A. limit the amount of information displayed to customers B. minimizing human error C. increasing update costs D. more efficient
D
Which of the following is not an example of an advantage of using a relational database? A. increased information quality B. increased flexibility C. decreased information redundancy D. decreased information security
C
Which of the following is not an example of an advantage to using the Web to access organizational databases? A. Web browsers are much easier to use than a computer based database. B. The web interface requires few or no changes to the database model. C. It is cleaner and virus-free. D. It costs less.
D
Which of the following is not an information cleansing activity? A. identifies redundant records B. identifies inaccurate or incomplete data C. identifies missing records or attributes D. identifies sales trends
C
Which of the following is true in regard to the elimination of redundant information? A. uses additional hard disk space B. makes performing information updates harder C. improves information quality D. All of these are correct.
B
Which of the following occurs during data cleansing? A. clean data marts B. clean redundant customer data C. clean accurate data D. clean correct data
D
Which of the following occurs during data cleansing? A. clean missing records B. clean redundant records C. clean inaccurate data D. All of these are correct.
A
Which of the following represent the four primary traits that help determine the value of information? A. information type, information timeliness, information quality, and information governance B. information statistics, information tracking, information quality, and information governance C. information type, information chance, information analytics, and information policy D. information timeliness, information quality, information quantity, and information governance policy
D
Which of the following represents a reason for low-quality information? A. Online customers intentionally enter inaccurate information to protect the privacy. B. Different systems have different information entry standards and formats. C. Third-party and external information contains inaccuracies and errors. D. All of these are correct.
D
Which of the following statements does not describe the Zappos database? A. The Zappos database was highly scalable. B. The Zappos database was highly flexible. C. The Zappos database was highly secure. D. The Zappos database was highly redundant.
D
Which of the following statements is TRUE regarding customer information? A. Customer information can exist in several operational systems. B. Customer information in each operational system could change. C. Customer information in each operational system can be different. D. All of these are correct.
D
Which of the following statements is accurate? A. A correct business rule for one organization may not be correct for another organization. B. Each business rule will have entities and sometimes even attributes. C. A typical business may have hundreds of business rules. D. All of these are correct.
D
Which of the following statements is true? A. The more complete an organization wants to get its information, the less it costs. B. The more accurate an organization wants to get its information, the less it costs. C. The less accurate an organization wants to get its information, the more it costs. D. The more complete and accurate an organization wants to get its information, the more it costs
D
Which of the following would not be considered part of the accurate characteristic of high-quality information? A. Is the name spelled correctly? B. Is the email address invalid? C. Do the name and the phone values have the exact same information? D. Is aggregate information in agreement with detailed information?
B
Which of the following would not be considered part of the complete characteristic of high-quality information? A. Is a value missing from the personal information? B. Is each transaction represented only once in the information? C. Is the address incomplete? D. Is the area code missing for the phone information?
B
Which of the following would not be considered part of the consistent characteristic of high-quality information? A. Do all sales columns equal the total for the revenue column? B. Is the two-digit state code missing in the information? C. Is all summary information in agreement with detailed information? D. Does the order number match the item and the color options available?
A
Which of the following would not be considered part of the timely characteristic of high-quality information? A. Is the zip code missing in the address? B. Is the information current with respect to business needs? C. Is the customer address current? D. Is the information updated weekly or hourly?
C
Which of the following would not be considered part of the unique characteristic of high-quality information? A. Are there any duplicate orders? B. Are there any duplicate customers? C. Is aggregate information in agreement with detailed information? D. Is each transaction and event represented only once in the information?
C
Which of the statements below means the same as easy to manage content? A. Website owners can make changes only with the aid of MIS professionals. B. The website cannot organize customer data. C. Users can update data-driven website with little or no training. D. Users with extensive training can update data-driven websites
C
Why do relational databases use primary keys and foreign keys? A. to create an entity B. to create physical relationships C. to create logical relationships D. to create an attribute
D
Why were data warehouses created? A. Numbers and types of operational databases increased as businesses grew. B. Many companies had information scattered across multiple systems with different formats. C. Completing reporting requests from numerous operational systems took days or weeks. D. All of these are correct.
Data warehouse
Within the __ model, the internal databases are marketing sales, inventory, and billing
A
Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases? A. marketing, sales, inventory, and billing B. data mart 1, data mart 2, data mart 3 C. competitor and industry information, mailing lists, amp; stock market analysis D. marketing information, and stock market analysis numbers
Data-driven website
can help limit the amount of information displayed to customers based on unique search requirements
Real-time information
immediate, up-to-date information
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
Information Granularity
the extent of detail within the information (fine and detailed or coarse and abstract)
