Chapter 6 Quiz questions

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