question

1. Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

answer

FALSE

question

2. Information can tell an organization how it's currently performing and help it estimate and strategize for future plans and performance.

answer

TRUE

question

3. Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

answer

FALSE

question

4. There are two main primary traits that help you determine the value of information including timeliness and quality.

answer

FALSE

question

5. If a manager identifies numerous data integrity issues he should consider the reports generated from that data as invalid and not use them when making decisions.

answer

TRUE

question

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

answer

TRUE

question

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

answer

FALSE

question

8. A foreign key provides details about data.

answer

FALSE

question

9. There are three primary data models for organizing information including the hierarchical, network, and relational database models.

answer

TRUE

question

10. The three primary data models for organizing information in a DBMS are 1-hierarchical, 2-network, and 3-metadata.

answer

FALSE

question

11. 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.

answer

TRUE`

question

12. Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

answer

FALSE

question

13. Data redundancy is the duplication of data, or the storage of the same data in multiple places.

answer

TRUE

question

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

answer

FALSE

question

15. A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

answer

TRUE

question

16. Data-driven website offer several advantages as it is far easier to manage content and store large amounts of data.

answer

TRUE

question

17. Zappos is an online shoe retailer, built its data-driven website catering to a specific niche market: consumers who were tired of finding that their most-desired items were always out of stock at traditional retailers.

answer

TRUE

question

18. A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

answer

TRUE

question

19. Data warehouses struggle with combining too much standardized information.

answer

TRUE

question

20. A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.

answer

FALSE

question

21. Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

answer

TRUE

question

22. A data miner contains a subset of data warehouse information.

answer

FALSE

question

23. ETL, within a data warehouse model, stands for exit, track, and load.

answer

FALSE

question

24. Within the data warehouse model, the external databases could include competitor information, industry information and stock market analysis.

answer

TRUE

question

25. A data mart is the process of analyzing data to extract information not offered by the raw data alone.

answer

FALSE

question

26. Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

answer

TRUE

question

27. Text mining analyzes structured data to find trends and patterns in words and sentences.

answer

FALSE

question

28. The financial industry uses business intelligence to predict hardware failures.

answer

FALSE

question

29. The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

answer

TRUE

question

30. Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

answer

TRUE

question

31. Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

answer

TRUE

question

32. Timely information must be up-to-the-second to be accurate.

answer

FALSE

question

33. Organizational information comes at different levels and in different formats and granularities.

answer

TRUE

question

34. Reports for each sales person, product, and part are examples of detail or fine information granularities.

answer

TRUE

question

35. A foreign key is a fie (ldor group of fields) that uniquely identifies a given entity in a table.

answer

FALSE

question

36. One of the advantages found in a relational database is increased information redundancy.

answer

FALSE

question

37. Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

answer

TRUE

question

The 38 primary purpose of a data warehouse is to perform transactional processes.

answer

FALSE

question

39. Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.

answer

FALSE

question

40. The data warehouse is a location for all of business information.

answer

FALSE

question

41. Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the below represents the three common types of information found throughout an organization? A. Levels, forms, granularities B. Levels, forms, data C. Levels, formats, granularities D. Data, formats, granularities

answer

C. Levels, formats, granularities

question

42. Which of the following represents the different information levels? A. Detail, summary, aggregate B. Document, presentation, spreadsheet, database C. Individual, department, enterprise D. None of the above

answer

C. Individual, department, enterprise

question

43. Which of the following represents the different information formats? A. Detail, summary, aggregate B. Document, presentation, spreadsheet, database C. Individual, department, enterprise D. None of the above

answer

B. Document, presentation, spreadsheet, database

question

44. Which of the following represents the different information granularities? A. Detail, summary, aggregate B. Document, presentation, spreadsheet, database C. Individual, department, enterprise D. None of the above

answer

A. Detail, summary, aggregate

question

45. Which of the following is not a primary trait of information? A. Transactional B. Analytical C. Timeliness D. Quantity

answer

D. Quantity

question

46. What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks? A. Transactional information B. Analytical information C. Timeliness D. Quality

answer

A. Transactional information

question

47. What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks? A. Transactional information B. Analytical information C. Timeliness D. Quality

answer

B. Analytical information

question

48. What is immediate, up-to-date information? A. Real-time information B. Real-time systems C. Information granularity D. All of the above

answer

A. Real-time information

question

49. What provides real-time information in response to query requests? A. Real-time information B. Real-time systems C. Information level D. All of the above

answer

B. Real-time systems

question

50. 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

answer

C. It continually changes

question

51. Which of the following is not one of the five characteristics common to high-quality information? A. Accuracy B. Completeness C. Quantity D. Consistency

answer

C. Quantity

question

52. What is a real-time system? A. Provides immediate, up-to-date information B. Provides real-time information in response to query requests C. Encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks D. Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks

answer

B. Provides real-time information in response to query requests

question

53. Which of the following implies that aggregate or summary information is in agreement with detailed information? A. Uniqueness B. Completeness C. Consistency D. Accuracy

answer

C. Consistency

question

54. Which of the following implies that information is current with respect to the business requirement? A. Uniqueness B. Accuracy C. Consistency D. Timeliness

answer

D. Timeliness

question

55. 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

answer

A. Uniqueness

question

56. Which of the following refers to the extent of detail within the information? A. Knowledge information B. Information granularity C. Chance information D. Information analytics

answer

B. Information granularity

question

57. 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

answer

A. Information type, information timeliness, information quality, and information governance

question

58. What are the two different categories for information type? A. Analytical and productive B. Analytical and analysis C. Transactional and analytical D. Transactional and analysis

answer

C. Transactional and analytical

question

59. Which of the following encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks? A. Targeted information B. Analytical information C. Productive information D. Transactional information

answer

D. Transactional information

question

60. Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks? A. Analytical information B. Transactional information C. Statistical information D. Targeted information

answer

A. Analytical information

question

61. Which of the following companies used analytical analysis to identify a correlation between storms and the increased sale of Pop-Tarts? A. 7-Eleven B. Burger King C. McDonalds D. Walmart

answer

D. Walmart

question

62. Ben works at a top accounting firm in Salt Lake City and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products. Ben's duties provide value-added to his company and would be categorized as occurring at the different ____________. A. Information levels B. Information formats C. Information granularities D. Information focus

answer

B. Information formats

question

63. Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing individual and departmental goals, and generating financial analysis across departments and the enterprise as a whole for the executive team to review. Ben's duties provide value-added to his company and would be categorized as occurring at the different ____________. A. Information levels B. Information formats C. Information granularities D. Information focus

answer

A. Information levels

question

64. Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson, product, and part as well as departmental-wide sales reports by salesperson, product, and part. Ben's duties provide value-added to his company and would be categorized as occurring at the different ____________. A. Information levels B. Information formats C. Information granularities D. Information focus

answer

C. Information granularities

question

65. Which of the following refers to immediate, up-to-date information? A. Daily information B. Strategic information C. Real-time information D. Crisis information

answer

C. Real-time information

question

66. Which of the below does not represent a company that requires up-to-the-second information? A. 911 response B. Stock traders C. Banks D. Construction companies

answer

D. Construction companies

question

67. Which of the following provides real-time information in response to requests? A. Sales system B. Transactional system C. Real-time system D. Salary system

answer

C. Real-time system

question

68. Which of the following are examples of transactional information? A. Airline ticket, sales receipts, and packing slips B. Trends and sales statistics C. Product sales results, grocery receipts, and growth projections D. Airline tickets and sales growth spreadsheets

answer

A. Airline ticket, sales receipts, and packing slips

question

69. Which of the following are examples of analytical information? A. Airline ticket, sales receipts, and packing slips B. Hotel reservation, sales receipts, and packing slips C. Future growth analysis, sales projections, and product statistics D. Packing slips, grocery receipt, and competitor information

answer

C. Future growth analysis, sales projections, and product statistics

question

70. Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls. A. Improvements B. Change C. Clustering D. Cleansing

answer

B. Change

question

71. Which of the following occurs when the same data element has different values? A. Data modeling issue B. Data mining issue C. Data governance issue D. Data inconsistency issue

answer

D. Data inconsistency issue

question

72. Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data? A. Data inconsistency issue B. Data integrity issue C. Data control issue D. Data mining issue

answer

B. Data integrity issue

question

73. Which of the following lists include all of the five characteristics common to high-quality information? A. Accuracy, completeness, strength, support, and positive feedback B. Accuracy, association, referral, sales, and marketing C. Accuracy, competition, support, customer service, and visibility D. Accuracy, completeness, consistency, timeliness, and uniqueness

answer

D. Accuracy, completeness, consistency, timeliness, and uniqueness

question

74. 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?

answer

B. Is each transaction represented only once in the information?

question

75. 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?

answer

A. Is the zip code missing in the address?

question

76. 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. Does the name and the phone values have the exact same information? D. Is aggregate information in agreement with detailed information?

answer

D. Is aggregate information in agreement with detailed information?

question

77. 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?

answer

C. Is aggregate information in agreement with detailed information?

question

78. 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?

answer

B. Is the two digit state code missing in the information?

question

79. 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 the above

answer

D. All of the above

question

80. Nestle is one of the companies shown as an example of low-quality information causing problems for the company. Which of the following are some of the errors they found in the data or information? A. They had 550,000 actual vendors, yet the information reports showed over 9 million due to duplication and abbreviation inaccuracies B. Some of the vendor names were abbreviated where others were not C. They had too many inaccuracies and duplications to be able to identify customer profitability D. All of the above

answer

D. All of the above

question

81. 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

answer

C. The success of the organization depends on appreciating and leveraging the low-quality information

question

82. What is the overall management of the availability, usability, integrity, and security of company data? A. Data Intelligence B. Data governance C. Data forbearance D. Data forecasting

answer

B. Data governance

question

83. What maintains information about various types of objects, events, people, and places? A. Database B. Data model C. Data mining D. Data intelligence

answer

A. Database

question

84. A database maintains information on __________. A. Inventory B. Transactions C. Employees D. All of the above

answer

D. All of the above

question

85. In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? A. Entity B. Relationships C. Attribute D. Foreign Key

answer

A. Entity

question

86. 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

answer

C. To create logical relationships

question

87. What is a primary key? A. A field (or group of fields) that uniquely identifies a given entity 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 among the two tables C. Characteristics or properties of an entity D. A field (or group of fields) that uniquely identifies a given attribute in a table

answer

A. A field (or group of fields) that uniquely identifies a given entity in a table

question

88. What is a foreign key? A. A field (or group of fields) that uniquely identifies a given entity 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 among the two tables C. Characteristics or properties of an entity D. A field (or group of fields) that uniquely identifies a given attribute in a table

answer

B. 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

question

89. Which of the following is a disadvantage of database-stored information? A. Increased flexibility B. Increased performance C. Increased data redundancy D. Increased data integrity

answer

C. Increased data redundancy

question

90. 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

answer

C. Database information is accessed by physical structure

question

91. What is the physical 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

answer

A. Deals with the physical storage of information on a storage device such as a hard disk

question

92. 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

answer

C. A database can support many logical views

question

93. Which of the following creates, reads, updates, and deletes data in a database while controlling access and security? A. Database element B. Database management system C. Data governance D. Data File

answer

B. Database management system

question

94. Which of the following asks users to write lines of code to answer questions against a database? A. Structured query language B. Relational query language C. Structured elements D. Data mining tools

answer

A. Structured query language

question

95. What is the primary tool that retrieves information and helps users graphically design the answer to a question? A. Data mining tools B. Structured example language C. Query-by-example tool D. Relational query tool

answer

C. Query-by-example tool

question

96. What is the smallest or basic unit of information? A. Database management element B. Data element C. Data model D. Data integrity issue

answer

B. Data element

question

97. What is a logical data structure that details the relationship among data elements using graphics or pictures? A. Data model B. Data element C. Data mining tool D. Data mart tool

answer

A. Data model

question

98. What compiles all of the metadata about the data elements in the data model? A. Data entity B. Data element C. Data attribute D. Data dictionary

answer

D. Data dictionary

question

99. Which of the following systems allow users to create, read, update, and delete data in a relational database? A. Business intelligence system B. Informational database system C. Relational database management system D. Data mining system

answer

C. Relational database management system

question

100. 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

answer

B. Entities, attributes, keys, and relationships

question

101. Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table? A. Entity B. Extraction C. Attribute D. Foreign key

answer

A. Entity

question

102. What is the primary difference between an entity and an attribute? A. An attribute is a table, an entity is a column from the attribute table B. An entity is specific, where as an attribute is not data at all but brainstorming ideas that take place before the entity is created C. An attribute refers to applications, and an entity refers to executives D. An entity is a table that stores information about people, places, or events, whereas an attribute is a column or specific field of the data elements associated with an entity

answer

D. An entity is a table that stores information about people, places, or events, whereas an attribute is a column or specific field of the data elements associated with an entity

question

103. 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

answer

B. Primary keys and foreign keys

question

104. What is a field that uniquely identifies a given record in a table? A. Foreign key B. Primary key C. Data mining key D. DBMS key

answer

B. Primary key

question

105. What is the role of a foreign key? A. 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 B. It is a unique way to identify each record C. It is a field that uniquely identifies a given record in a table D. All of the above

answer

A. 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

question

106. Which of the below 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

answer

D. Decreased information security

question

107. Your textbook discussed a record store example where one user could perform a query to determine which recordings had a track length of four minutes or more, and another user could perform an analysis to determine the distribution of recordings as they relate to the different categories. What database advantage is this an example of? A. Increased scalability and performance B. Increased information security C. Reduced information redundancy D. Increased flexibility

answer

D. Increased flexibility

question

108. What is data redundancy? A. Duplication of data B. Storing the same data in multiple places C. Storing duplicate data in multiple places D. All of the above

answer

D. All of the above

question

109. What is the primary problem with redundant data? 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 the above

answer

D. All of the above

question

110. Which of the following is true in regards to the elimination of redundant data? A. Uses additional hard disk space B. Makes performing information updates harder C. Improves information quality D. All of the above

answer

C. Improves information quality

question

111. What are the rules that help ensure the quality of information? A. Information integrity B. Integrity constraints C. Relational integrity constraints D. Business-critical integrity constraints

answer

B. Integrity constraints

question

112. What are rules that enforce basic and fundamental information-based constraints? A. Information integrity B. Integrity constraint C. Business-critical integrity constraint D. Relational integrity constraint

answer

D. Relational integrity constraint

question

113. 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

answer

D. Business-critical integrity constraint

question

114. 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. None of the above

answer

A. Relational integrity constraint

question

115. All of the following are business-critical integrity constraints, except A. System will not allow an entry for an order for a nonexistent customer B. System will not allow returns of fresh produce after 15 days past delivery C. System will not allow shipping a product to a customer who does not have a valid address D. Systems will not allow shipping of a nonexistent product to a customer

answer

B. System will not allow returns of fresh produce after 15 days past delivery

question

116. Which of the following focuses on how individual users logically access information to meet their own particular business needs? A. Physical view B. Logical view C. Data mart view D. Data view

answer

B. Logical view

question

117. 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

answer

A. Increased scalability and performance

question

118. One of the primary goals of a database is to eliminate data redundancy by recording each piece of data in only one place in the database. What does the elimination of data redundancy do for a database? A. Reduces disk space requirements B. Makes updating information easier C. Improves information quality D. All of the above

answer

D. All of the above

question

119. What are rules that help ensure the quality of information? A. Information integrity B. Integrity constraints C. Information quality D. Information ethics

answer

B. Integrity constraints

question

120. What are the rules that enforce basic and fundamental information-based constraints? A. Responsibly integrity constraints B. Quality constraints C. Web integrity constraints D. Relational integrity constraints

answer

D. Relational integrity constraints

question

121. 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? A. Quality business constraints B. Critical web constraints C. Business critical integrity constraints D. Web integrity constraints

answer

C. Business critical integrity constraints

question

122. What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database? A. Data-driven website B. Interactive website C. Database performing website D. Data processing website

answer

A. Data-driven website

question

123. Which of the following offers an advantage of using a data-driven website? A. Easy to eliminate human errors B. Easy to manage content C. Easy to store large amounts of data D. All of the above

answer

D. All of the above

question

124. Which of the below statements 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

answer

C. Users can update data-driven website with little or no training

question

125. 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

answer

C. It is cleaner and virus-free

question

126. Which of the below does not describe Zappos database? A. Zappos database was high scalable B. Zappos database was highly flexible C. Zappos database was highly secure D. Zappos database was highly redundant

answer

D. Zappos database was highly redundant

question

127. Which of the following is not an advantage to a data-driven website? A. Development B. Minimizing human error C. Increasing update costs D. More efficient

answer

C. Increasing update costs

question

128. 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

answer

A. Logical, operational

question

129. Which of the following is not one of the reasons why operational systems are not appropriate for business analysis? 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

answer

B. Operational systems are integrated

question

130. What do data warehouses support? A. OLAP B. Analytical processing C. OLTP D. OLAP and analytical processinG

answer

D. OLAP and analytical processinG

question

131. 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 the above

answer

A. Combine strategic information

question

132. Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. What is this an example of? A. Information scaling B. Streamlining data points C. Standardizing information D. Standardizing protocols

answer

C. Standardizing information

question

133. Standardizing of data elements allows for _____________. A. Greater accuracy, completeness, and consistency B. Stabilizes pivot tables C. Processes the clients faster D. Increases security features

answer

A. Greater accuracy, completeness, and consistency

question

134. Which of the below represents a reason why data warehouses were 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 the above

answer

D. All of the above

question

135. What does extraction, transformation, and loading mean? 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

answer

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

question

136. Which of the following fall in the category of external databases in the data warehouse model? A. Marketing, sales, inventory, and billing B. Data mart 1, data mart 2, and data mart 3 C. Competitor and industry information, mailing lists, and stock market analysis D. Marketing information, sales information, and stock market analysis

answer

C. Competitor and industry information, mailing lists, and stock market analysis

question

137. 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 the above

answer

D. All of the above

question

138. What is data mining? A. The common term for the representation of multidimensional information B. A particular attribute of information C. Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making D. Process of analyzing data to extract information not offered by the raw data alone

answer

D. Process of analyzing data to extract information not offered by the raw data alone

question

139. When does information cleansing occur in the data warehouse? A. During the ETL process B. On the information, once it is in the data warehouse C. During the ETL process and once it is in the data warehouse D. During the ETL process and before it is in the data warehouse

answer

C. During the ETL process and once it is in the data warehouse

question

140. 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 the above

answer

D. All of the above

question

141. Which of the following occurs during data cleansing? A. Clean missing records B. Clean redundant records C. Clean inaccurate data D. All of the above

answer

D. All of the above

question

142. 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

answer

D. The more complete and accurate an organization wants to get its information, the more it costs

question

143. 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, & stock market analysis D. Marketing information, and stock market analysis numbers

answer

A. Marketing, sales, inventory, and billing

question

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

answer

D. Data marts

question

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

answer

B. Data mart

question

146. 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 warehouse 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

answer

C. Data warehouses have a more organization-wide focus, data marts have functional focus

question

147. Which of the following is the common term for the representation of multidimensional information? A. Block B. Square C. Column D. Cube

answer

D. Cube

question

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

answer

B. Information scrubbing

question

149. What determines the accuracy and completeness of organizational data? A. Data quantity audit B. Data quality audit C. Data intelligence audit D. All of the above

answer

B. Data quality audit

question

150. Which of the below is not included as an information cleansing activity? A. Identifies redundant records B. Identifies inaccurate or incomplete data C. Identifies missing records or attributes D. Identifies sales trends

answer

D. Identifies sales trends

question

151. What is the process of analyzing data to extract information not offered by the raw data alone? A. Data integrity B. Data mart analysis C. Data mining D. Data extraction

answer

C. Data mining

question

152. What are the two main objectives associated with data mining? A. Uncovering tactics and plans B. Uncovering trends and patterns C. Uncovering intelligence and unstructured data issues D. Uncovering competitors and market advantages

answer

B. Uncovering trends and patterns

question

153. 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? A. Data analysis tools B. Electronic analysis tools C. Data-mining tools D. Data integrity tools

answer

C. Data-mining tools

question

154. Which of the following is not a common form of data mining? A. Division organization B. Classification C. Estimation D. Clustering

answer

A. Division organization

question

155. Which of the following forms of data mining assigns records to one of a predefined set of classes? A. Clustering B. Classification C. Estimation D. Affinity grouping

answer

B. Classification

question

156. 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

answer

A. Structured data

question

157. What is another term for data that does not exist in a fixed location? A. Structured data B. Unstructured data C. Text mining D. Web mining

answer

B. Unstructured data

question

158. What analyzes unstructured data to find trends and patterns in words and sentences? A. Structured data B. Unstructured data C. Text mining D. Web mining

answer

C. Text mining

question

159. What is web mining? A. Unstructured data associated with websites to identify consumer behavior and website navigation B. Analyzes structured data associated with a website C. Filters information, both structured and unstructured, to help identify strong web customers D. None of the above

answer

A. Unstructured data associated with websites to identify consumer behavior and website navigation

question

160. What are the three common forms for mining structured and unstructured data? A. Cluster analysis, association detection, statistical analysis B. Cluster analysis, association detection, disassociation detection C. Cluster analysis statistical detection, statistical analysis D. Association detection, market-basket analysis, market-basket association

answer

A. Cluster analysis, association detection, statistical analysis

question

161. 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? A. Statistical detection B. Cluster analysis C. Association detection D. None of the above

answer

B. Cluster analysis

question

162. What is a great 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

answer

C. Zip code segmentation

question

163. Which of the below defines the relationship between variables along with the nature and frequency of the relationship? A. Association detection B. Masking detection tool C. Cluster grouping D. Blocking barriers

answer

A. Association detection

question

164. What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior? A. Clustering factors B. Mashup technology C. Market basket analysis D. Drill-down basket analysis

answer

C. Market basket analysis

question

165. Which of the following techniques performs such functions as information correlations, distributions, calculations, and variance analysis? A. Clustering objective analysis B. Statistical analysis C. Entity modeling D. Market basket analysis

answer

B. Statistical analysis

question

166. When discovering trends and seasonal variations in transactional information, use a(n) ______-__________ 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. A. Analytical graphing B. Association detection C. Market basket D. Time-series

answer

D. Time-series

question

167. What is it called when a manager has so much data and information that they cannot make a decision? A. Data rich, information poor B. Data rich, content poor C. Data rich, communication poor D. Data rich, intelligence

answer

A. Data rich, information poor

question

168. Which of the below questions 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 the above.

answer

D. All of the above.

question

169. 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

answer

D. Business intelligence

BIS CHAPTER 6 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards