CIS9440 Chapter 1

1. What is the difference between Operational data from analytical data: A. Operational data typically contains a relatively short time span, whereas analytical data is historical. B. Operational data only is considered enterprise wide. C. Analytical data is considered more reliable than operational data. D. They are not different actually.

Answer (A) page 12.

1. -___________is a subject‐oriented, integrated, time‐variant, nonvolatile collection of data in support of management decisions. A. Data Mining. B. Data Warehousing. C. Web Mining. D. Text Mining.

Answer (B) Data Warehousing (page 14)

1. _________predicts future trends & behaviors, allowing business managers to make proactive, Knowledge‐driven decisions. A. Data warehouse. B. Data mining. C. DataMart. D. Metadata.

Answer (B) Data mining (page 17)

1. Which of the following statement is NOT CORRECT about the reasons of BI analytics is so critical: A. Many business decisions remain based on intuitive hunches, not facts. B. Analytics lessens the discontinuity between intuitions only. C. Competitive differentiation can be achieved by more sophisticated data usage. D. Big Data enables new use cases but will require analytics to take full advantage of its potential.

Answer (B) page 8.

1. When we talk about how data can be influenced by the volume, velocity and variety: A. The volume can expanding but velocity and variety can't. B. The velocity can only be expended depending on the variety. C. All three can make expanding no matter how the data is. D. All option above are wrong

Answer (C) page 4.

1. Business Intelligence and data warehousing is used for . A. Forecasting. B. Data Mining. C. Analysis of large volumes of product sales data. D. All of the above.

Answer (D) All of the above (page 14)

BI is the application used for: (a) Capturing, querying, and analytics (b) Reporting, querying, and analytics (c) Capturing, converting, and analytics (d) Capturing, reporting, and analytics

Answer: (b) Reporting, querying, and analytics (page 11)

1. Which is not an example of how businesses need to analyze data? (a) Shipping data (b) Website analytics (c) medical information (d) birds in a park

Answer: (d) birds in a park (Page 8)

1. Which of the following is NOT on the 5 Cs of data? (a)Clean (b)Conformed (c)Comprehensive (d)Compact

Answer: (d)Compact (Ch1, pg13)

1. What is used to track products from manufacturing to purchase? a. RFID (Radio Frequency Identification) b. Tracking report c. EXCEL Spreadsheet d. ALL OF THE ABOVE

Answer: A (Page 4)

1. The Importance of Analytics are: a) They make decisions based on the data to validate their intuitions. b) They work harder than the other staff. c) Since they analyze the company, they can see the whole business process easier. d) None of the above.

Answer: A) They make decisions based on the data to validate their intuitions.(page 7)

1. What does the term "Capturing data" mean? a. Storing Data in a database b. Converting or translating data into digital form c. Taking a snapshot of the data d. ALL OF THE ABOVE

Answer: B (Page 11)

1. The role of the BI is? a) BI makes data more organized b) BI makes data into knowledge c) BI makes data into "actionable" information d) BI makes information into knowledge

Answer: C) BI makes data into "actionable" information.(page 11)

1. What isn't in the Five CS Of Data? A) Clean B) Current C) Comprehensive D) Consistent E) Cohesion

Answer: E) Cohesion (page 12)

1. What are the 5 C's of Data? a. Complimentary, Cool, Complete, Conformed, Current b. Clean, Consistent, Controlled, Captured, Conditional c. Current, Consistent, Complete, Conditioned, Corrected d. Clean, Consistent, Conformed, Current,

Comprehensive Answer: D (Page 12)

1. What is data mining? (a) The process of presenting data in a visual way, such as graphs and charts, helps business people glean insights they might not otherwise discern from tabular data. (b) The process of analyzing large quantities of data to find patterns such as groups of records, unusual records, and dependencies. (c) The process of finding and fixing errors, inconsistencies and inaccuracies in data. (d) The process of packing data into a BI data store so business people can understand and use it.

Answer (b) The process of analyzing large quantities of data to find patterns such as groups of records, unusual records, and dependencies. (page 17)

1. What are 5 Cs of data? (a) clear, consistent, conformed, centralized, comprehensive (b) clean, consistent, conformed, current, comprehensive (c) clean, consistent, connected, centralized, current (d) clear, consistent, catching, combined, comprehensive

Answer (b): clean, consistent, conformed, current, comprehensive (page 13)

1. What is text analytics? (a) A technique for analyzing business data that uses dimensional models often deployed as cubes, which are like multidimensional pivot tables in spreadsheets. (b) An advanced form of analytics that uses business information to find patterns and predict future outcomes and trends. (c) The use of data mining for analysis of unstructured textual data such as emails. (d) Leveraging advances in memory to provide faster and deeper analytics by querying a system's random‐access memory (RAM) instead of on disks.

Answer (c) The use of data mining for analysis of unstructured textual data such as emails. (page 19)

1. What BI does with data? (a) Captures data (b) Stores data (c) Analyzes data (d) Disseminated data

Answer (c): Analyzes data (page 11)

1. Which one of 4 components of data management system combines data from different sources and brings it together to provide a unified view? (a) Data warehousing (b) Business Intelligence (c) Data integration Operational Business Intelligence

Answer (c): Business Intelligence (page 14)

1. What are the three core building blocks of DW/BI programs? (a) Clean, Consistent, Current. (b) Analytics, BI appliance, BI applications. (c) Data mining, Operational BI, Data Discovery (d) Data Integration, Data Warehousing, Business Intelligence.

Answer (d) Data Integration, Data Warehousing, Business Intelligence. (page 14)

1. Which key term does NOT apply to data warehousing? (a) Data Discovery (b) Business Intelligence (c) Data Integration (d) Staging

Answer: (a) Data Discovery (page 15)

Which is not a reason as to why data analytics is so important for todays organizations? (a) Data analytics allows decision‐makers to solely use their intuition to make strategic decisions (b) Data becomes a strategic guide that helps executives see patterns that they might not otherwise notice (c) Enterprises have been encountering significant increases in data volume, data variety, and data velocity over the last several years (d) Competitive differentiation can be achieved by more sophisticated data usage and analyzation

Answer: (a) Data analytics allows decision‐makers to solely use their intuition to make strategic decision (page 7)

1. What is the difference between data and information? (a) Data is raw, random, and unorganized. Information is data that has been structured and organized which allows you to gain knowledge. (b) data is data that has been structured and organized which allows you to gain knowledge. information is raw, random, and unorganized. (c) data is knowledge that makes informed decisions. information is source data from systems (d) none of these.

Answer: (a) Data is raw, random, and unorganized. Information is data that has been structured and organized which allows you to gain knowledge. (page 9)

1. Data that has been organized, structured, and processed. a. Information b. Text c. Knowledge d. None of these

Answer: (a) Information (page 8)

1. Define Data Warehousing (a) The process of storing, staging information, and optimizing it for access and analysis in an enterprise (b) The process of combining data from different resources and bringing it together (c)The process of presenting data to business people so they can use it to gain knowledge (d)The process of transferring data from one database to another

Answer: (a)The process of storing, staging information, and optimizing it for access and analysis in an enterprise. (page 14)

Which is not one of the five Cs of data a. Clean b. Customary c. Current d. Conformed

Answer: (b) Customary (page 12)

1. Regarding the 5C's, it is correct to affirm that: (a) Almost none of the source data is dirty, which mean that the cleansing and profiling are almost useless in data warehouse. (b) Data that has been whipped into shape will be clean, consistent, conformed, current and comprehensive. (c) The business doesn't need to analyze the data across common, shareable dimensions if business people across the enterprise are to use the same information for their decision‐ making. (d) Advanced analytics tools are useless when we are using data warehousing; Data Warehousing is self‐sufficient.

Answer: (b) Data that has been whipped into shape will be clean, consistent, conformed, current and comprehensive. (12)

Retrieving and manipulating data without requiring details of how it is formatted or where it is located is also known as a. Data visualization b. Data virtualization c. Dimensional modeling d. Data preparation

Answer: (b) Data virtualization (page 17)

Which terminology majorly apply to Business Intelligence? (a) Data Profiling (b) Data visualization (c) MDM (master data management) (d) OLAP Cubes

Answer: (b) Data visualization (page 17)

1. What does the acronym "ETL" stand for? (a) Extended Table Load (b) Extract Transform Load (c) External Textual Load (d) Extract Table Load

Answer: (b) Extract Transform Load (10)

About the differences among Data Integration, Data Warehousing and Business Intelligence: (a) Using DI you can combine data from different sources and provide to it different views. The components of DI are: Cleanse and aggregate data. (b) Process of storing and staging information, separate from an enterprise's day to day transaction processing generations, and optimizing it for access and analysis in an enterprise. (c) DW is what people use via tools and dashboards. Data visualization,data profiling and data mining are process exclusively related to DI.

Answer: (b) Process of storing and staging information, separate from an enterprise's day to day transaction processing generations, and optimizing it for access and analysis in an enterprise. (14)

According to a study conducted by The Economist, the flood of information and analytics has had these effects, EXCEPT: (a) Over half (54%) say that management decisions based purely on intuition or experience are increasingly regarded as suspect. (b) The majority of executives (58%) still rely on their intuitive hunches rather than unstructured data analysis. (c) As organizations increasingly look to the output from analytics to automate decision making, data quality is seen as a major hurdle. (d) The majority of companies (58%) claim they will make a bigger investment in Big Data over the next 3 years.

Answer: (b) The majority of executives (58%) still rely on their intuitive hunches rather than unstructured data analysis. (page 7)

1. Which type of analytics is considered to be the foundational or core analytics (hint: its the most common form of analytics)? (a) predictive analytics (b) descriptive analytics (c) diagnostic analytics (d) prescriptive analytics

Answer: (b) descriptive analytics (Ch1, pg14)

1. What is information? (a) a set of raw, random facts, qualitative variables, and quantitative variables (b) organized and processed data (c) uninformed business decisions (d) systematic usage of computer‐generated tools to make informed business decisions

Answer: (b) organized and processed data (Ch1, pg10)

1. What is the process in which data is taken from the source system, configured, and stored in a data warehouse or database? (a)Data Virtualization (b)ETL (c)OLAP (d)Data Mining

Answer: (b)ETL(Extract, Transform, Load) (page 17)

1. What are the five Cs of data? (a) Cold, Campy, Candent, Cankerous, Captive (b) Cardiographer, Circumference, Comprehensive, Clean, Climactic (c) Clean, Consistent, Conformed, Current, Comprehensive (d) There is no such thing

Answer: (c) Clean, Consistent, Conformed, Current, Comprehensive (page 12)

Which of the following options represents the five C's of data: (a) Clean, consistent, complete, current, and comprehensive (b) Clean, consistent, conformed, current, and coordinated (c) Clean, consistent, conformed, current, and comprehensive (d) Common, consistent, conformed, current, and comprehensive

Answer: (c) Clean, consistent, conformed, current, and comprehensive (page 13)

1. which is not one of the five c's of data (a) Clean (b) Current (c) Correlated (d) Consistent

Answer: (c) Correlated (page 12)

Which of these is not considered to be part of the Five Cs of Data? (a) Clean (b) Consistent (c) Cryptic (d) Current

Answer: (c) Cryptic (page 12)

What is the difference between Operational data and analytical data? (a) Operational data typically contains a relatively long time span. (b) Analytical data is spread out over many source systems, making it hard to bring together and analyze. (c) Operational data is structured for efficiently processing and managing business transactions and interactions. (d) Analytical data is live in there here and now.

Answer: (c) Operational data is structured for efficiently processing and managing business transactions and interactions. (page 12)

1. Which of the following about data warehousing is true? (a) Data warehousing records the business event. (b) Data warehousing typically contains a relatively short time span, whereas analytical data is historical. (c) Operational systems live in the here and now, whereas data warehousing must support the past, present, and future. (d) Data warehousing is structured for efficiently processing and managing business transactions and interactions.

Answer: (c) Operational systems live in the here and now, whereas data warehousing must support the past, present, and future. (page 12)

1. Which of the following is true about operational systems? (a) They are used to maintain large quantities of data from different sources (b) They are the database backbone that support BI applications (c) They capture transactional data (d) They contain data that supports analysis into the past, present, and future

Answer: (c) They capture transactional data (11)

1. What is "ad hoc query"? (a) Bundled hardware and software used as a BI solution (b) BI tool that displays numeric and graphic information on a single display (c) Unique query which is usually written in SQL and used for unique purpose (d) The process in which data is taken from the source system

Answer: (c) Unique query which is usually written in SQL and used for unique purpose (16)

1. Which is not part of the Five C's of Data (a)Clean (b)Consistent (c)Challenging (d)Comprehensive

Answer: (c)Challenging (page 13)

1. What is dimensional modeling? (a) Presenting data in a visual way, such as with graphs and charts; helps business people glean insights they might not otherwise discern from tabular data (b) An essential part of the data quality process; involves examining source system data for anomalies in values, ranges, frequencies, relationships, and other characteristics that could hobble future efforts to analyze it (c) The analyzation of large quantities of data to find patterns such as groups of records, unusual records, and dependencies (d) A generally accepted practice in the data warehouse industry to structure data intended for user access, analysis, and reporting in dimensional data models

Answer: (d) A generally accepted practice in the data warehouse industry to structure data intended for user access, analysis, and reporting in dimensional data models (page 17)

1. Why Business analytics is so critical? (a) Many business decisions remain based on intuitive hunches, not facts. (b) Analytics lessens the discontinuity between intuition and factual decision‐making. (c) Competitive differentiation can be achieved by more sophisticated data usage (d) All of the above

Answer: (d) All of the above (page 8)

Which is not 5Cs of data? (a) Consistent (b) Conformed (c) Current (d) Compound

Answer: (d) Compound (page 13)

1. The process to analyze large quantities of data to find patterns is called? (a) Data preparation (b) Data Mart (c) Data cleansing (d) Data mining

Answer: (d) Data mining (page 17)

1. In terms of the concepts of data and information, it is possible to assure that: (a) Information is RAW, random and unorganized. (b) Data is information that has been organized, structured and processed. (c) There is no difference between the terms. (d) Information is what you use to gain knowledge.

Answer: (d) Information is what you use to gain knowledge. (8)