Q&A Hero

Q: Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Q: What determines the accuracy and completeness of organizational data? A. data quantity audit B. data quality audit C. data intelligence audit D. data accuracy audit

Q: 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.

Q: 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.

Q: A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Q: 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.

Q: A foreign key uniquely identifies a given record in a table.

Q: 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

Q: A field is a collection of related data elements.

Q: 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

Q: Entities are the data elements associated with an attribute.

Q: 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.

Q: A primary key is a field (or group of fields) that uniquely identifies a given record in a table.

Q: What is another term for information cleansing? A. information mining B. information scrubbing C. information scrapping D. information marts

Q: A record is a collection of related data elements.

Q: Which of the following is the common term for the representation of multidimensional information? A. block B. square C. column D. cube

Q: Attributes (also called columns or fields) are the data elements associated with an entity.

Q: Which of the following is a problem associated with dirty data? A. formatted data B. misleading data C. correct data D. All of these are correct.

Q: A relational database management system allows users to create, read, update, and delete data in a relational database.

Q: Which of the following is a problem associated with dirty data? A. nonformatted data B. misleading data C. incorrect data D. All of these are correct.

Q: A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Q: Which of the following is a problem associated with dirty data? A. accurate data B. integrated data C. violates business rules D. All of these are correct.

Q: A relational database model stores information in the form of logically related two-dimensional tables.

Q: Which of the following is a problem associated with dirty data? A. inaccurate data B. nonintegrated data C. violates business rules D. All of these are correct.

Q: A hierarchical database model stores information in the form of logically related two-dimensional tables.

Q: Which of the following is a problem associated with dirty data? A. inaccurate data B. misleading data C. nonformatted data D. All of these are correct.

Q: Structured query language compiles all of the metadata about the data elements in the data model.

Q: Which of the following is a problem associated with dirty data? A. duplicate data B. correct data C. accurate data D. All of these are correct.

Q: A DBMS provides details about data.

Q: Which of the following is a problem associated with dirty data? A. duplicate data B. incorrect data C. violates business rules D. All of these are correct.

Q: Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

Q: What is erroneous or flawed data? A. dirty data B. information cleansing C. information Scrubbing D. ETL

Q: Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Q: 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.

Q: A primary key is the smallest or basic unit of information.

Q: Which of the following contains a subset of data warehouse information? A. data miner B. data mart C. data pool D. data analyzing tool

Q: A data dictionary compiles all of the metadata about the data elements in the data model.

Q: What is the ultimate outcome of a data warehouse? A. data goals B. data relationships C. data marketing D. data marts

Q: Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

Q: 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

Q: Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

Q: Which of the following describes ETL? A. a process that extracts information from internal and external databases B. a process that transforms information using a common set of enterprise definitions C. a process that loads information into a data warehouse D. All of these are correct.

Q: Data elements can include a customers name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Q: 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.

Q: Data element (or data field) is the smallest or basic unit of information.

Q: 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

Q: A DBMS uses three primary data models for organizing informationthe hierarchical, network, and the relational database.

Q: 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.

Q: A foreign key provides details about data.

Q: 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

Q: MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Q: 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.

Q: The core component of any system, regardless of size, is a database and a database management system.

Q: 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.

Q: Data governance is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Q: Which of the questions below can be answered using business intelligence? A. Where has the business been? B. Where is the business now? C. Where is the business going? D. All of these are correct.

Q: Data governance refers to the overall management of the availability, usability, integrity, and security of company data.

Q: What do data warehouses support? A. OLAP B. analytical processing C. OLTP D. OLAP and analytical processing

Q: Master data management (MDM) is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems. MDM is commonly included in data governance.

Q: Which of the following is incorrect in terms of data warehousing and business intelligence? A. does not include information from other operational applications B. operational systems are integrated C. operational information is mainly current D. operational information frequently has quality issues

Q: Determining if information is updated weekly, daily, or hourly is an example of a timely characteristic of high-quality information.

Q: 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

Q: Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Q: How would the technology industry use business intelligence? A. track crime patterns, locations, and criminal behavior B. analyze customer demographics C. predict sales, inventory levels, and distribution D. predict hardware failures

Q: Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information. TRUE

Q: How would the retail industry use business intelligence? A. track crime patterns, locations, and criminal behavior B. analyze customer demographics C. predict sales, inventory levels, and distribution D. predict hardware failures

Q: Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Q: How would the marketing industry use business intelligence? A. track crime patterns, locations, and criminal behavior B. analyze customer demographics C. predict sales, inventory levels, and distribution D. predict hardware failures

Q: Timely information asks if each transaction and event is represented only once in the information.

Q: How would the law enforcement industry use business intelligence? A. track crime patterns, locations, and criminal behavior B. analyze customer demographics C. predict sales, inventory levels, and distribution D. predict hardware failures

Q: Unique information asks if the information is current with respect to the business needs.

Q: How would the insurance industry use business intelligence? A. analyze popular vacation locations with current flight listings B. understand customer credit card usage and nonpayment rates C. compare the demographics of patients with critical illnesses D. predict claim amounts and medical coverage costs

Q: Accurate information asks if the aggregate or summary information is in agreement with detailed information.

Q: How would the health care industry use business intelligence? A. analyze popular vacation locations with current flight listings B. understand customer credit card usage and nonpayment rates C. compare the demographics of patients with critical illnesses D. predict claim amounts and medical coverage costs

Q: Consistent information asks if there is a value missing from the information.

Q: How would the banking industry use business intelligence? A. analyze popular vacation locations with current flight listings B. understand customer credit card usage and nonpayment rates C. compare the demographics of patients with critical illnesses D. predict claim amounts and medical coverage costs

Q: Complete information asks if there is an incorrect value in the information.

Q: How would the airline industry use business intelligence? A. analyze popular vacation locations with current flight listings B. understand customer credit card usage and nonpayment rates C. compare the demographics of patients with critical illnesses D. predict claim amounts and medical coverage costs

Q: Unique information asks if each transaction and event is represented only once in the information.

Q: What is information that people use to support their decision-making efforts? A. information cleansing and scrubbing B. data-mining tools C. data mining D. business intelligence