|
Which of the following does not represent a company that requires up-to-the-second information |
Construction companies |
|
Which of the following defines the relationship between variables along with the nature and frequency of the relationship |
Association detection |
|
What is a primary key |
A field (or group of fields) that uniquely identifies a given entity in a table |
|
Which of the following asks users to write lines of code to answer questions against a database |
Structured query language |
|
What is a common association detection analysis technique where you analyze certain items to detect customers’ buying behavior and predict future behavior |
Market basket analysis |
|
Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making |
Data-mining tools |
|
Which of the following encompasses all of the information contained within a single business process or unit of work, where its primary purpose is to support daily operational tasks |
Transactional information |
|
Which of the following is a disadvantage of database-stored information |
Increased data redundancy |
|
Which of the following is not a primary trait of information |
Quantity |
|
Which of the following implies that information is current with respect to the business requirement |
Timeliness |
|
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? |
|
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 |
|
What is the smallest or basic unit of information |
Data element |
|
Which of the following will enforce business rules vital to an organization’s success and often require more insight and knowledge than relational integrity constraints |
Business critical integrity constraints |
|
Which of the following represents a reason data warehouses were created |
• Numbers and types of operational databases increased as businesses grew. • Many companies had information scattered across multiple systems with different formats. • Completing reporting requests from numerous operational systems took days or weeks. |
|
What are the primary differences between a data warehouse and a data mart |
Data warehouses have a more organizationwide focus; data marts have functional focus |
|
Which of the following refers to the extent of detail within the information |
Information granularity |
|
Which of the following represents a reason an organization might encounter low-quality information |
• Online customers intentionally enter inaccurate information to protect their privacy. • Different systems have different information-entry standards and formats. • Third-party and external information contains inaccuracies and errors. |
|
What type of keys do you need to use to create a relational database model |
Primary keys and foreign keys |
|
What are the three common forms for mining structured and unstructured data |
Cluster analysis, association detection, and statistical analysis |
|
Which of the following is not a common form of data mining |
Division organization |
|
Which of the following companies used analytical analysis to identify a correlation between storms and the increased sale of Pop-Tarts |
Walmart |
|
Which of the following are examples of analytical information |
Future growth analysis, sales projections, and product statistics |
|
What is another term for information cleansing |
information scrubbing |
|
Which of the following lists include all of the five characteristics common to high-quality information |
Accuracy, completeness, consistency, timeliness, and uniqueness |
|
What are the two main objectives associated with data mining |
Uncovering trends and patterns |
|
A database maintains information on ___________ |
Inventory Transactions Employees |
|
A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks |
Logical; operational |
|
What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible |
Cluster analysis |
|
What provides real-time information in response to query requests |
Real-time systems |
|
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored |
Entity |
|
What is another term for data that do not exist in a fixed location |
Unstructured data |
|
Which of the following describes ETL |
• A process that extracts information from internal and external databases • A process that transforms information using a common set of enterprise definitions • A process that loads information into a data warehouse |
|
Which of the following is not an example of an advantage of using a relational database |
Decreased information security |
|
What is a real-time system |
It provides real-time information in response to query requests. |
|
Which of the following would not be considered part of the complete characteristic of high-quality information |
Is each transaction represented only once in the information? |
|
What is the role of a foreign key |
It 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. |
|
When discovering trends and seasonal variations in transactional information, use a ________________ forecast to change the transactional information by units of time, such as transforming weekly information into monthly or seasonal information or hourly information and into daily information |
Time-series |
|
What is a great example of using cluster analysis in business to create target-marketing strategies |
Zip code segmentation |
|
What is it called when each transaction, entity, and event is represented only once in the information |
Uniqueness |
|
Which of the following represents the different information granularities |
Detail, summary, aggregate |
|
Why do relational databases use primary keys and foreign keys |
To create logical relationships |
|
What are the rules that enforce basic and fundamental information-based constraints |
Relational integrity constraints |
|
What are rules that enforce basic and fundamental information-based constraints |
Relational integrity constraint |
|
Which of the following are examples of transactional information |
Airline ticket, sales receipts, and packing slips |
|
Which of the following refers to immediate, up-to-date information |
Real-time information |
|
Which of the following provides real-time information in response to requests |
Real-time system |
|
What compiles all of the metadata about the data elements in the data model |
Data dictionary |
|
Which of the following implies that aggregate or summary information is in agreement with detailed information |
Consistency |
|
The primary purpose of a data warehouse is to _____________ |
Combine strategic information |
|
Which of the following is not one of the five characteristics common to high-quality information |
Quantity |
|
Which of the following is not included as an information cleansing activity |
Identifies sales trends |
|
Which of the following illustrates the primary concepts of the relational database model |
Entities, attributes, keys, and relationships |
|
Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls |
Change |
|
Which of the following is a valid type of integrity constraint |
Business-critical integrity constraint |
|
What is information that people use to support their decision-making efforts |
Business intelligence |
|
Which of the following techniques performs such functions as information correlations, distributions, calculations, and variance analysis |
Statistical analysis |
|
Which of the following would not be considered part of the unique characteristic of high-quality information |
Is aggregate information in agreement with detailed information? |
|
Which of the following encompasses all organizational information, where its primary purpose is to support the performing of managerial analysis tasks |
Analytical information |
|
What is a logical data structure that details the relationship among data elements using graphics or pictures |
Data model |
|
What is the overall management of the availability, usability, integrity, and security of company data |
Data governance |
|
Which of the following is not an example of an advantage to using the web to access organizational databases |
It is cleaner and virus-free. |
|
What is the process of analyzing data to extract information not offered by the raw data alone |
Data mining |
|
What do data warehouses support |
OLAP and analytical processing |
|
Standardizing of data elements allows for ______________ |
Greater accuracy, completeness, and consistency |
|
Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the following represents the three common types of information found throughout an organization |
Levels, formats, granularities |
|
Which of the following contains a subset of data warehouse information |
Data mart |
|
Which of the following is the common term for the representation of multidimensional information |
Cube |
|
Which of the following statements means the same as easy-to-manage content |
Users can update data-driven website with little or no training. |
|
Which of the following focuses on how individual users logically access information to meet their own particular business needs |
Logical view |
|
Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table |
Entity |
|
When does information cleansing occur in the data warehouse |
During the ETL process and once it is in the data warehouse |
|
Which of the following does not describe Zappos’ database |
Zappos’ database was highly redundant |
|
What determines the accuracy and completeness of organizational data |
Data quality audit |
|
Which of the following is true with regard to the elimination of redundant data |
Improves information quality |
|
What is another term for data that are already contained in a database or a spreadsheet |
Structured data |
|
What is the physical view of information |
Deals with the physical storage of information on a storage device such as a hard disk |
|
Which of the following systems allow users to create, read, update, and delete data in a relational database |
Relational database management system |
|
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 correct in reference to a database |
A database can support many logical views |
|
Which of the following occurs when the same data element has different values |
Data inconsistency issue |
|
Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. What is this an example of |
Standardizing information |
|
What is a foreign key |
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables |
|
Which of the following statements is true |
The more complete and accurate an organization wants its information to be, the more it costs |
|
Which of the following is not an advantage of a data-driven website |
Increasing update costs |
|
Which of the following statements is true regarding customer information |
• Customer information can exist in several operational systems. • Customer information in each operational system could change. • Customer information in each operational system can be different. |
|
What is one of the biggest pitfalls associated with real-time information |
It continually changes. |
|
What is web mining |
Unstructured data associated with websites to identify consumer behavior and website navigation |
|
What is immediate, up-to-date information |
Real-time information |
|
What encompasses all organizational information where its primary purpose is to support the performing of managerial analysis tasks |
Analytical information |
|
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security |
Database management system |
|
What are the rules that help ensure the quality of information |
Integrity constraints |
|
Which of the following occurs during data cleansing |
• Clean missing records • Clean redundant records • Clean inaccurate data |
|
What type of integrity constraint does not allow someone to create an order for a nonexistent customer |
Relational integrity constraint |
|
What is the ultimate outcome of a data warehouse |
Data marts |
|
What are rules that help ensure the quality of information |
Integrity constraints |
|
Which of the following represents the different information formats |
Document, presentation, spreadsheet, database |
|
Which of the following offers an advantage of using a data-driven website |
• Easy to eliminate human errors • Easy to manage content • Easy to store large amounts of data |
|
What maintains information about various types of objects, events, people, and places |
Database |
|
Which of the following would not be considered part of the timely characteristic of high-quality information |
Is the Zip code missing in the address? |
Share This
Flashcard
