5360 Midterm Practice

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: a. Association b. Extraction c. Load d. Cleanse

a. Association

__________ helps the telephone companies to detect the characteristics of customers who are most likely to leave: a. Customer Chrun b. Extraction c. Load d. Cleanse

a. Customer Chrun

________ 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. a. Data Mining Tools b. Parallel Processing c. Microsoft Windows d. A larger IT staff

a. Data Mining Tools

A star schema contains a central __________ surrounded by several dimension tables. a. Fact Table b. Parallel Processing c. Microsoft Windows d. A larger IT staff

a. Fact Table

The database which is used as an interim staging area for a data warehouse is called the: a. Operational Data Store b. Extraction c. Load d. Cleanse

a. Operational Data Store

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? a. Star schema b. Snowflake Schema c. Relational Schema d. Dimensional Schema

a. Star schema

In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated? a. Transformation b. Extraction c. Load d. Cleanse

a. Transformation

In text analysis, what is a lexicon? a. a catalog of words, their synonyms, and their meanings b. a catalog of customers, their words, and phrase c. a catalog of letters, words, phrases and sentences d. a catalog of customers, products, words, and phrase

a. a catalog of words, their synonyms, and their meanings

In data mining, finding an affinity of two products to be commonly together in a shopping cart is known as a. association rule mining. b. cluster analysis. c. decision trees. d. artificial neural networks.

a. association rule mining.

In text mining, tokenizing is the process of a. categorizing a block of text in a sentence. b. reducing multiple words to their base or root. c. transforming the term-by-document matrix to a manageable size. d. creating new branches or stems of recorded paragraphs.

a. categorizing a block of text in a sentence.

Business intelligence (BI) can be characterized as a transformation of a. data to information to decisions to actions. b. Big Data to data to information to decisions. c. actions to decisions to feedback to information. d. data to processing to information to actions.

a. data to information to decisions to actions.

The data field "ethnic group" can be best described as a. nominal data. b. interval data. c. ordinal data. d. ratio data.

a. nominal data.

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. a. online transaction processing systems b. Structured decision c. Unstructured decision d. Managerial control decision

a. online transaction processing systems

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: a. sequences b. visualization c. classification d. clustering

a. sequences

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are a. subject-oriented and nonvolatile. b. product-oriented and nonvolatile. c. product-oriented and volatile. d. subject-oriented and volatile.

a. subject-oriented and nonvolatile.

All of the following statements about data mining are true EXCEPT: a. the process aspect means that data mining should be a one-step process to results. b. the novel aspect means that previously unknown patterns are discovered. c. the potentially useful aspect means that results should lead to some business benefit. d. the valid aspect means that the discovered patterns should hold true on new data. e. Building the model takes the most time and effort

a. the process aspect means that data mining should be a one-step process to results. e. Building the model takes the most time and effort

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests? a. Use of the web by users as a front-end b. Parallel Processing c. Microsoft Windows d. A larger IT staff

b. Parallel Processing

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information? a. MOLAP b. ROLAP c. HOLAP d. SQL

b. ROLAP

For the majority of organizations, a daily accounts receivable transaction is a(n) a. Strategic decision b. Structured decision c. Unstructured decision d. Managerial control decision

b. Structured decision

In sentiment analysis, which of the following is an implicit opinion? a. The hotel we stayed in was terrible. b. The customer service I got for my TV was laughable. c. The cruise we went on last summer was a disaster. d. Our new mayor is great for the city.

b. The customer service I got for my TV was laughable.

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: a. data warehouses have enabled the affordable collection of data for analytics. b. data warehouses have enabled the collection of decision makers in one place. c. data warehouses have assisted the collection of data for data mining. d. data warehouses have assisted the collection of data from multiple sources.

b. data warehouses have enabled the collection of decision makers in one place.

What application is MOST dependent on text analysis of transcribed sales call center notes and voice conversations with customers? a. finance b. OLAP c. CRM d. ERP

c. CRM

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? a. Sectional Data Mart b. Public Data Mart c. Independent Data Mart d. Volatile Data Mart

c. Independent Data Mart

Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses? a. Strategic decisions whose impacts are hard to measure b. Detailed data available for strategic use only c. Large number of users, including operational staffs d. Restrictive reporting with daily and weekly data currency

c. Large number of users, including operational staffs

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 a. Country of (data) origin b. Nature of the data c. Speed of data transfer d. Source of the data

c. Speed of data transfer

A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a a. One tier architecture b. Two tier architectures c. Three tier architectures d. Four tier architectures

c. Three tier architectures

What data discovery process, whereby objects are categorized into predetermined groups, is used in text mining? a. clustering b. association c. classification d. trend analysis

c. classification

Which broad area of data mining applications analyzes data, forming rules to distinguish between defined classes? a. associations b. visualization c. classification d. clustering

c. classification

For those executives who do not have the time to go through lengthy reports, the best alternative is the a. last page of the report. b. raw data that informed the report. c. executive summary. d. charts in the report.

c. executive summary.

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected? a. Transformation b. Extraction c. Load d. Cleanse

d. Cleanse

When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is a. Dice b. Slice c. Roll-up d. Drill down

d. Drill down

In text mining, stemming is the process of a. categorizing a block of text in a sentence. b. reducing multiple words to their base or root. c. transforming the term-by-document matrix to a manageable size. d. creating new branches or stems of recorded paragraphs.

d. For most organizations, data warehouse metadata are an unnecessary expense.

Data warehouses provide direct and indirect benefits to using organizations. Which of the following is an indirect benefit of data warehouses? a. Better and more timely information b. Extensive new analysis performed by users c. Simplified access to data d. Improved customer service

d. Improved customer service

Which of the following is not a data mining algorithm category? a. Clustering b. Association c. Classification d. Progression

d. Progression

Which of the following statements about Big Data is true? a. Data chunks are stored in different locations on one computer b. Hadoop is a type of processor used to process c. Map Reduces is a storage filing system d. Pure Big Data systems do not involve fault tolerance

d. Pure Big Data systems do not involve fault tolerance

Sentiment classification usually covers all the following issues EXCEPT: a. classes of sentiment (e.g., positive versus negative). b. range of polarity (e.g., star ratings for hotels and for restaurants). c. range in strength of opinion. d. biometric identification of the consumer expressing the sentiment.

d. biometric identification of the consumer expressing the sentiment.

Which broad area of data mining applications partitions a collection of objects into natural groupings with similar features? a. associations b. visualization c. classification d. clustering

d. clustering

The data field "salary" can be best described as a. nominal data. b. interval data. c. ordinal data. d. ratio data.

d. ratio data.