MGSC 300 Questions Quiz 1

Data mining is best described as... A) A research and analysis technique in which data analysts employ mathematical tools and artificial intelligence to search large volumes of data and discover less obvious patterns and trends B) The process in which businesses create a strategy and action plan based on what their data mining software has identified, modeled and predicted from their data C) a type of AI program that uses statistics to automatically identify negative trends.

A

In analyzing transactions Walmart discovered that many people who buy children's Tylenol in their stores also buy orange juice in the same transaction. They used this info to discount children Tylenol but raise the price of organge juice during flu season. What is the name of the approach Walmart used to discover this information? A) Big data B) Data volume C) Business Intelligence software

A

In contrast to computerized systems traditioanl file management systems can create issues with BLANK? A) Organization, repetition and lack of consistency B) The need for records, signatures, and workable systems C) The organization of papers, files and documents D) Too many manual records, file folders and papers

A

The best way of implementing a new BI system is to make it as seamless as possible by using... A) Software with which the users (typically first line employees, supervisors etc.) are already familiar. B) The business intelligence software that senior management is most comfortable using C) The most expensive business intelligence software the organizations can afford

A

The primary purpose of a business intelligence system is to... A) help a business make strategic decisions based on its own data B) create a model of business operations using multiple data sources C) lower the cost of administration by automating routine operations D) predict which of a business' competitors may post a serious threat.

A

The value of data analytics to an organization can be best summarized by which statement? A) Data analytics is a capability that support increased organizational performance by drawing meaning from large amounts of data B) Through the use of data analytics, algorithms can initiate numerous tasks from data processing to automation C) An organization can access a master system that integrated individual data systems through data analytics

A

Which of the following is an example of the type of information data mining can yield? A) The likelihood of a Gen-X female who makes $50,000 and is divorced with no children will take a trip within a year of her divorce being finalized. B) Middle aged males who are members of their local church bible study group are more inclined to vote than younger males who are also members of their local bible study group C) How much a 23 year old male college student will spend on a new car after starting his first job

A & B Data mining yields probabilities, not exact answers

Which of the following is an example of an organization analyzing predictive behavior with the goals of creating new offerings? More than one may be correct. A) An in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received care for falling in their homes. B) Target keeps track of how many shoppers visit their stores on sundays C) Netflix tracks what users who viewed all 3 seasons of stranger things also had in their queues. D) Dropbox tracks how many people subscribe to their services after viewing a specific marketing email.

A & C

A leading manufacturer of fitness trackers partners with a large health insurance network. Insurance network members receive a discounted fitness tracker and financial rewards for setting and achieving tracked personal fitness goals. Which characteristics of the resulting big data would be most directly affected by a tracker software error that counted users arm movements as steps? A) Volume B) Veracity C) Variety D) Velocity

B

Businesses use business intelligence systems to... A) Ensure that their technologies, computer applications and procedures are efficient B) Help them make decisions that are informed by business data and facts C) Create an accurate picture of their past, current, and future operations D) Collect and analyze information from multiple sources and analytic platforms.

B

For which task is a data mart more useful or appropriate than a data warehouse? A) comparing sales from previous years to help gauge the effectiveness of the marketing department B) Resolving a current problem with a specific type of inventory, purchase transaction or supply chain C) Determine which departments or divisions of the company are profitable and which are losing money D) Evaluating the company's data infrastructure and integration to identify redundancies and cut costs

B

In a datasheet view of a relational database (such a Microsoft access), a row of information is called a... A) List B) Record C) Table D) Field

B

Organizations use data warehouses mainly to... A) provide a single gateway to data from multiple sources B) Facilitate the analysis of data from multiple sources C) check the veracity of similar data from multiple sources D) provide internet security

B

To display or distribute information from a database, programmers or database administrators create... A) records B) reports C) forms D) tables

B

What is the purpose of an SQL statement? A) create an entity relationship diagram B) answer questions about the database C) organize data into tables based on structured groupings D) analyze nonstructured data

B

Which of the following is a task that an SQL statement would be expected to perform? A) Create relationships between data B) Retrieve data C) Organize data into tabular structure D) Maintain data integrity

B

Which statement best summarizes how organizations use data warehouses? A) Data warehouses are used to combine and cross check similar data from multiple sources B) Data warehouses are used to store data from multiple sources for collective analysis C) Data warehouses are used to grant access to data from multiple sources via a single entry point D) Data warehouses are used to regularly collect and store data from multiple sources

B

Which statement explains the difference between a database and a database management system? A) A DBMS is a collection of tables, relationships and metadata; a database is used to organize data B) A DBMS is a software program designed to organize and administer databases C) Organizations often create their own databases but usually purchase DBMS software from other companies.

B

Which of the following statements correctly describes a defining characteristic of big data? More than one answer may be correct. A) The data are automatically collected and process or analyzed as least once daily B) The data are from structured and unstructured sources and exist in multiple forms C) The data are measured in terabytes (trillions of bytes) or even larger units D) The data are accurate and have been verified across multiple separate sources

B & C

Which of the following statements describe the capabilities of relational database system (RDBMS)... more than one answer may be correct! A) RDBMS focus on web based retrieval of data B) RDBMS have features that support the quality and security of data C) RDBMS allows users to view, add, revise, and remove data D) RDBMS allows users to analyze both structured and nonstructured data

B & C

In which three of the following statements would data analytics be most helpful A) Two architectural firms merge, maintaining their individual identities and reputations while gaining financial efficiency. B) Healthcare firm has received a vast amount of information from drug companies and research entities and must finalize their policies and communication concerning several controversial treatments. C) An international automaker is producing a new line of vehicles in several locations and the production lines must run uniformly and smoothly. D) A search engine continually adjusts its algorithms as more data enters its servers

B & C & D

Why is online analytical processing (OLAP) software included in many business intelligence software applications? More than one answer may be correct. A) It focuses on financial business data and multiple dimensions of financial markets B) It allows for sophisticated data and trend analytics, data modeling and forecasting C) It allows reports and analytics to be exported to more user friendly, front end tools D) It allows users to view data from different perspectives or angles and gain new insights E) It stores information in relational databases that more users are already familiar with

B & C & D

Select 2 statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS) A) Data warehouses are used to create valuable collections of data that organizations can sell to others, because the profits help fund the organizations enterprise level, strategic goals. B) Data marts are used to analyze recent data that a department needs for operational troubleshooting and management, because they collect and measure data specific to that area C) Data warehouses are used to analyze long term, historical data for an organizations strategic purposes, because they store data from different time periods and subject areas. D) Data marts are used to compare specific data from different departments or business functions because the data mart for each area contains more detailed data than a data warehouse.

B &C

Forms allow data to go into a database, BLANK displays information coming out of a database A) Fields B) Records C) Reports D) Tables

C

How does the structure of an online analytical processing (OLAP) database shape its core functionality? A) Its tight integration with popular front end tools such a Microsoft excel enables users to create more user friendly views of data and complex reports with illustrative graphs, including three dimensional graphs and simulations. B) Its ability to link online databases and offline back end databases in different locations allows users to conduct simultaneous queries and analysis of multiple stores of data that have not been aggregated or collected in a data warehouse. C) Its use of data cubes allows users to conduct complex queries, analyses, and modeling by taking multiple dimensions of data (types or levels) into account and viewing data from multiple viewpoints or slices (such as by date or location)

C

Which of the following statements describe the capabilities of relational database management (RDBMS)? More than one answer may be correct. A) RDBMS focus on web based retrieval of data B) RDBMS allows users to analyze both structured and nonstructured data C) RDBMS allows users to view, add, revise, and remove data D) RDBMS have features that support the quality and security of data

C & D

A database management system (DBMS) is a computer program that is used to... A) Exclusively develop software for databases B) Manage all types of programs on a network C) Collect tables, relationships and metadata D) Help organize the data found in a database

D

Organizations use data warehouses mainly to... A) Provide a single gateway to data from multiple sources B) Check the veracity of similar data from multiple sources C) Provide internet security D) Facilitate the analysis of data from multiple sources

D

What term describes the process organizations use to discover meaningful relationships and patterns among the data sets it has collected? A) Business intelligence B) Data integrity C) Big data D) Data Mining

D

Which of these steps in the data mining process most likely involves the actual mining or knowledge discovery in data? A) problem definition B) data gathering and preparation C) knowledge deployment D) model building and evaluation

D

Which statement best explains why traditional file systems have certain issues? A) Computerized systems are faster and easier to use than manual systems B) Database management systems are computerized and traditional systems are manual C) Traditional systems maintain an organizations records and files on paper D) Each file is independent of another file in a traditional system

D Each file is independent of the other files which leads to data redundancy, inconsistency and file management issues.

What is business intelligence?

Includes the technologies, computer applications, and procedures for the collection, analysis, and presentation of business information to support decision making.

What is online analytical processing (OLAP)?

It is included in many business intelligence software applications and is used for a variety of data discovery activities. The activities include report creation and analysis, analytical calculations, forecasting, budgeting, planning, and what-if predicative analysis. Allows users to perform multidimensional analysis Assists businesses in a wide range of areas Allows for delivery of reports and analytics

Data Mining - 4 key properties - the process

It is the searching of large data stores and sets to uncover patterns and trends that cannot be executed using OLAP or simple analysis techniques 4 key properties 1. Automatic discovery of patterns 2. Prediction of likely outcomes 3. Creation of actionable information 4. Focus on large data sets and databases The process 1. Problem definition 2. Data gathering and preparation 3. Model building and evaluation 4. Knowledge deployment

In a relational database such as Microsoft access, a collection of related fields in a data file is called a BLANK

Record

A DBMS maximizes the benefits a database can provide. DMS stands for Database Management BLANK?

System

What is data mining?

Takes data and refines it down into precious information. It is means of analyzing data that can help organizations find patterns and relationships within data sets.

Data warehouses vs. Data Marts

Warehouses - Help to create a decision support system environment that allows businesses to gauge the performance of an enterprise over a measurable period of time. - Contains large amounts of historical data stored in a series of snapshots that represent data points at a specific time. Marts - Designed to collect and measure data from specific operational areas of a business and are used by individual departments or groups. - Used to track inventories, purchase transactions and the supply chain