Q&A Hero

Q: ETL stands for extraction, transformation, and loading.

Q: What is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools? A. big data B. distributed computing C. advanced analytics D. data scientist

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

Q: In terms of big data, what includes the analysis of streaming data as it travels around the Internet? A. variety B. veracity C. volume D. velocity

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

Q: In terms of big data, what includes the scale of data? A. variety B. veracity C. volume D. velocity

Q: A data mart contains a subset of data warehouse information.

Q: In terms of big data, what includes the uncertainty of data, including biases, noise, and abnormalities? A. variety B. veracity C. volume D. velocity

Q: A data miner contains a subset of data warehouse information.

Q: In terms of big data what includes different forms of structured and unstructured data? A. variety B. veracity C. volume D. velocity

Q: The primary purpose of a data warehouse is to perform analytical processes.

Q: In terms of big data what is velocity? A. includes different forms of structured and unstructured data B. includes the uncertainty of data, including biases, noise, and abnormalities C. includes the scale of data D. includes the analysis of streaming data as it travels around the Internet

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

Q: In terms of big data what is volume? A. includes different forms of structured and unstructured data B. includes the uncertainty of data, including biases, noise, and abnormalities C. includes the scale of data D. includes the analysis of streaming data as it travels around the Internet

Q: Data warehouses struggle with combining too much standardized information.

Q: In terms of big data what is veracity? A. includes different forms of structured and unstructured data B. includes the uncertainty of data, including biases, noise, and abnormalities C. includes the scale of data D. includes the analysis of streaming data as it travels around the Internet

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

Q: In terms of big data what is variety? A. includes different forms of structured and unstructured data B. includes the uncertainty of data, including biases, noise, and abnormalities C. includes the scale of data D. includes the analysis of streaming data as it travels around the Internet

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

Q: What is data that is not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages? A. structured data B. machine-generated data C. human-generated data D. unstructured data

Q: The financial industry uses business intelligence to predict hardware failures.

Q: What is data that humans, in interaction with computers, generate? A. structured data B. machine-generated data C. human-generated data D. unstructured data

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

Q: What is created by a machine without human intervention? A. structured data B. machine-generated data C. human-generated data D. unstructured data

Q: A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Q: What has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address? A. structured data B. machine-generated data C. human-generated data D. unstructured data

Q: Dynamic website information is stored in a dynamic catalog, or an area of a website that stores information about products in a database.

Q: What is unstructured data? A. has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address B. created by a machine without human intervention C. data that humans, in interaction with computers, generate D. not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages

Q: Dynamic information includes data that change based on user actions.

Q: What is human-generated data? A. has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address B. created by a machine without human intervention C. data that humans, in interaction with computers, generate D. not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages

Q: Static information includes data that changes based on user actions.

Q: What is machine-generated data? A. has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address B. created by a machine without human intervention C. data that humans, in interaction with computers, generate D. not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages

Q: Static information includes fixed data incapable of change in the event of a user action.

Q: 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

Q: A content editor is the person responsible for updating and maintaining website content.

Q: 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

Q: A content creator is the person responsible for updating and maintaining website content.

Q: What is structured data? A. has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address B. created by a machine without human intervention C. data that humans, in interaction with computers, generate D. not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages

Q: A content creator is the person responsible for creating the original website content.

Q: What segments a heterogeneous population of more homogeneous subgroups? A. classification B. estimation C. affinity grouping D. clustering

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

Q: What determines which things go together? A. classification B. estimation C. affinity grouping D. clustering

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

Q: What determines values for an unknown continuous variable behavior or estimated future value? A. classification B. estimation C. affinity grouping D. clustering

Q: What assigns records to one of a predefined set of classes? A. classification B. estimation C. affinity grouping D. clustering

Q: Business critical integrity constraints enforce business rules vital to an organizations success and often require more insight and knowledge than relational integrity constraints.

Q: What is clustering? A. determines values for an unknown continuous variable behavior or estimated future value B. determines which things go together C. segments a heterogeneous population of more homogeneous subgroups D. assigns records to one of a predefined set of classes

Q: Relational integrity constraints enforce business rules vital to an organizations success and often require more insight and knowledge than relational integrity constraints.

Q: What is affinity grouping? A. determines values for an unknown continuous variable behavior or estimated future value B. determines which things go together C. segments a heterogeneous population of more homogeneous subgroups D. assigns records to one of a predefined set of classes

Q: Relationship integrity criteria are rules that enforce basic and fundamental information-based constraints.

Q: What is estimation? A. determines values for an unknown continuous variable behavior or estimated future value B. determines which things go together C. segments a heterogeneous population of more homogeneous subgroups D. assigns records to one of a predefined set of classes

Q: Information integrity are rules that help ensure the quality of information.

Q: What is classification? A. determines values for an unknown continuous variable behavior or estimated future value B. determines which things go together C. segments a heterogeneous population of more homogeneous subgroups D. assigns records to one of a predefined set of classes

Q: Information constraints is a measure of the quality of information.

Q: 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

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

Q: Which of the following is not a common form of data mining analysis? A. division organization B. classification C. estimation D. clustering

Q: Integrity constraints are rules that help ensure the quality of information.

Q: 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

Q: Information integrity is a measure of the quality of information.

Q: What is a statistical process for estimating the relationships among variables? A. prediction B. optimization C. forecasting D. regression

Q: What are predictions based on time-series information? A. prediction B. optimization C. forecasting D. regression

Q: A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Q: What is a statistical process that finds the way to make a design, system, or decision as effective as possible; for example, finding the values of controllable variables that determine maximal productivity or minimal waste? A. prediction B. optimization C. forecasting D. regression

Q: Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Q: What is a statement about what will happen or might happen in the future; for example, predicting future sales or employee turnover? A. prediction B. optimization C. forecasting D. regression

Q: 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.

Q: What is regression? A. a statement about what will happen or might happen in the future; for example, predicting future sales or employee turnover B. a statistical process that finds the way to make a design, system, or decision as effective as possible; for example, finding the values of controllable variables that determine maximal productivity or minimal waste C. predictions based on time-series information D. a statistical process for estimating the relationships among variables

Q: A business rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Q: What are forecasts? A. a statement about what will happen or might happen in the future; for example, predicting future sales or employee turnover B. a statistical process that finds the way to make a design, system, or decision as effective as possible; for example, finding the values of controllable variables that determine maximal productivity or minimal waste C. predictions based on time-series information D. a statistical process for estimating the relationships among variables

Q: The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

Q: What is optimization? A. a statement about what will happen or might happen in the future; for example, predicting future sales or employee turnover B. a statistical process that finds the way to make a design, system, or decision as effective as possible; for example, finding the values of controllable variables that determine maximal productivity or minimal waste C. predictions based on time-series information D. a statistical process for estimating the relationships among variables

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

Q: What is a prediction? A. a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover B. a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste C. predictions based on time-series information D. a statistical process for estimating the relationships among variables

Q: The logical view of information deals with the physical storage of information on a storage device.

Q: 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

Q: The logical view of information focuses on how individual users logically access information to meet their own particular business needs.

Q: 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

Q: The physical view of information deals with the physical storage of information on a storage device.

Q: 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