Chapter 6 Quiz questions – Flashcards
Unlock all answers in this set
Unlock answersquestion
What is a great example of using cluster analysis in business to create target marketing strategies?
answer
Zip code segmentation
question
Which of the following is a disadvantage of database stored information?
answer
increased data redundancy
question
which of the following does not describe zappos' database?
answer
Zappos' Database was highly redundant
question
Which of the following companies used analytical analysis to identify correlation between storms and the increased sale of Pop-Tarts?
answer
Walmart
question
Why do relational databases use primary keys and foreign keys?
answer
to create logical relationships
question
Which of the following would not be considered part of the accurate characteristic of high-quality information?
answer
Is aggregate information in agreement with detailed information
question
Which of the following statements is true?
answer
The more complete and accurate an organization wants it's information to be, the more it costs
question
Some of the serious business consequences that occur due to using low-quality information to make decisions include all of the following except?
answer
Success of the organization depends on appreciating and leveraging the low-quality information
question
Which of the following represents four primary traits that help determine the value of information?
answer
Information type, Information timeliness, information quality, and information governance
question
What are the primary differences between a data warehouse and a data mart
answer
data warehouses have a more organizational focus, data marts have a functional focus
question
What do data warehouses support?
answer
OLAP and analytical processing
question
Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?
answer
Marketing, sales, inventory, and billing
question
Which of the following is not an advantage of a data-driven website?
answer
Increasing update costs
question
Which of the following occurs during data cleansing?
answer
?
question
What does extraction, transformation, and loading mean?
answer
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.
question
Which of the following is not a common form of data mining?
answer
Division organization (which forms are?)
question
Some of the serious business consequences that occur due to using low-quality information to make decisions include all of the following except:
answer
Success of the organization depends on appreciating and leveraging the low-quality information
question
Which of the following represents a reason an organization might encounter low-quality information?
answer
?
question
What are the primary differences between a data warehouse and a data mart?
answer
Data warehouses have a more organization wide focus; data marts have functional focus.
question
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?
answer
Increased scalability and performance
question
What is it called when each transaction, entity, and event is represented only once in the information?
answer
Uniqueness
question
When does information cleansing occur in the data warehouse?
answer
During the ETL process and once it is in the data warehouse
question
What is the ultimate outcome of a data warehouse?
answer
Data marts
question
Which of the following would not be considered part of the consistent characteristic of high-quality information?
answer
Is the two-digit state code missing in the information?
question
Which of the following is incorrect in reference to a database?
answer
Database information is accessed by physical structure.
question
Which of the following is not included as an information cleansing activity?
answer
Identifies sales trends
question
Which of the following implies that information is current with respect to the business requirement?
answer
Timeliness
question
Which of the following implies that aggregate or summary information is in agreement with detailed information?
answer
Consistency
question
What type of keys do you need to use to create a relational database model?
answer
Primary keys and foreign keys
question
Which of the following statements means the same as easy-to-manage content?
answer
Users can update data-driven website with little or no training.
question
Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.
answer
Change
question
What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
answer
Relational integrity constraint
