Business Intelligence Exam 1 Questions with correct Answers

Which of the following statements about Big Data is true? - Answer- Pure Big Data systems do not involve fault tolerance In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated? - Answer- Transformation All of the following statements about data mining are true EXCEPT: - Answer- the process aspect means that data mining should be a one-step process to results For the majority of organizations, a daily accounts receivable transaction is a(n) - Answer- Structured decision The ________ handle a company s routine ongoing business and give management the ability to scour data from the data warehouse for information about the business and use the analysis to provide tactical or operational decision support. - Answer- online transaction processing systems Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? - Answer- Independent Data Mart Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are - Answer- subject-oriented and nonvolatile. The data field "salary" can be best described as - Answer- ratio data. What application is MOST dependent on text analysis of transcribed sales call center notes and voice conversations with customers? - Answer- CRM When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is - Answer- Drill down In data mining, finding an affinity of two products to be commonly together in a shopping cart is known as - Answer- association rule mining Active data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is - Answer- Speed of data transfer Which broad area of data mining applications analyzes data, forming rules to distinguish between defined classes? - Answer- classification Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information? - Answer- ROLAP The data field "ethnic group" can be best described as - Answer- nominal data Sentiment classification usually covers all the following issues EXCEPT: - Answer- biometric identification of the consumer expressing the sentiment What data discovery process, whereby objects are categorized into predetermined groups, is used in text mining? - Answer- classification Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses? - Answer- Improved customer service In sentiment analysis, which of the following is an implicit opinion? - Answer- The customer service I got for my TV was laughable A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a - Answer- Three tier architectures Which broad area of data mining applications partitions a collection of objects into natural groupings with similar features? - Answer- clustering Using data mining software, the act of finding events linked over time (ex: if a house is bought today, 75 % of the time a refrigerator will be purchased within two weeks) is known as: - Answer- sequences The deployment of large data warehouses with terabytes or even petabytes of data been crucial to the growth of decision support. All the following explain why EXCEPT: - Answer- data warehouses have enabled the collection of decision makers in one place. When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure? - Answer- Star schema Which of the following is not a data mining algorithm category? - Answer- Progression In text mining, stemming is the process of - Answer- reducing multiple words to their base or root. All of the following statements about metadata are true EXCEPT - Answer- For most organizations, data warehouse metadata are an unnecessary expense. For those executives who do not have the time to go through lengthy reports, the best alternative is the - Answer- executive summary Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests? - Answer- Parallel Processing In text mining, tokenizing is the process of - Answer- categorizing a block of text in a sentence Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses? - Answer- Large number of users, including operational staffs ________ are used to replace or enhance human intelligence by their ability to scan massive storehouses of data and so discover meaningful new correlations, patterns, and trends by using pattern recognition technologies and advanced statistical methods. - Answer- Data Mining Tools A star schema contains a central __________ surrounded by several dimension tables. - Answer- Fact Table Business intelligence (BI) can be characterized as a transformation of - Answer- data to information to decisions to actions. In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected - Answer- Cleanse In text analysis, what is a lexicon? - Answer- a catalog of words, their synonyms, and their meanings The database which is used as an interim staging area for a data warehouse is called the: - Answer- Operational Data Store Using data mining software, the act of finding occurrences linked to a single event (ex: with chips we buy soda 65% of the time) is known as - Answer- Association? In data warehouse development approaches, The Inmon Model - Answer- also known as the EDW approach, emphasizes top-down development, employing established database development methodologies and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral development approach. Or EDW approach (top-down). goes form data warehouse to data marts. more risky because you have to find out the business terminology for the company. More people are involved.