Quiz 9 - Chapter 9

The Hadoop Distributed File System layer (HDFS) stores data in blocks of _____ or more.

128 MB

Which of the following is a prime number?

5

Which of the following represents the attribute of an entity in a relational database model?

A column

Which of the following represents an entity in a relational database model?

A row

Which of the following data mining techniques uses a specialized set of algorithms that sorts through data and forms statistical rules about relationships among the items?

Association analysis

Which of the following is a term used to describe data collections that are so enormous and complex that traditional data management software and analysis processes are incapable of dealing with them?

Big data

_____ includes a wide range of applications, practices, and technologies for the extraction, transformation, integration, analysis, interpretation, and presentation of data to support improved decision making.

Business intelligence

_____ tools frequently operate on data stored in a data warehouse or data mart.

Business intelligence

In-memory databases (IMDBs) have become feasible because of the decrease in _____ capacities.

C: random access memory (RAM)

Identify the technique through which an SQL database ensures that other transactions do not modify a database until the first transaction succeeds or fails.

Concurrency control

_____ present a set of key performance indicators about the state of a process at a specific point in time.

Dashboards

_____ involves the overall management of the availability, usability, integrity, and security of the data used in an organization.

Data governance

Which of the following is a minor version of a data warehouse that is scaled down to meet the specific needs of a business unit?

Data mart

_____ is a business intelligence (BI) tool used to explore large amounts of data for hidden patterns to predict future trends and behaviors for use in decision making.

Data mining

Which of the following business intelligence tools will help an organization to make business predictions?

Data mining tools

SoulTree, a software giant, has adopted a business strategy, already employed by its competitor, to market its products. Unfortunately, the adopted strategy does not work for SoulTree although it has been successful for its competitor. Which of the following business intelligence tools can help SoulTree to understand why the adopted strategy failed?

Drill-down analysis

_____ is a powerful tool that enables decision makers to gain insight into the details of business data to better understand why something happened.

Drill-down analysis

Identify the spreadsheet tool that is used to determine the optimal solution to a problem with multiple constraints.

Excel Solver

Which of the following tools in a spreadsheet performs "what if" analysis?

Excel scenario manager

PHQ, a graphics firm, decides to filter its employees according to their dates of joining. Which of the following steps in the extract-transform-load (ETL) process should be taken by the firm to accomplish the task?

Extract

Which of the following steps in an extract-transform-load (ETL) process draws desired data from various data sources to update a data warehouse?

Extract

Zomi, a fashion outlet, wishes to delete the details of orders that cost less than $30. Which of the following steps in the extract-transform-load (ETL) process is used to accomplish this task?

Extract

An SQL database stops abruptly when it encounters an error in the update process.

False

An in-memory database (IMDB) is a database management system that stores an entire database in read-only memory (ROM).

False

Case-based reasoning technique of data mining contains a specialized set of algorithms that sorts through data and forms statistical rules about relationships among the items.

False

In spreadsheets programs, Excel Solver can be used by the end users to perform "what if" analysis for the evaluation of various alternatives.

False

Online analytical processing (OLAP) involves the interactive examination of high-level summary data in increasing detail.

False

Organizations employ data warehouses to store junk data.

False

Unstructured data comes from a single source.

False

Which of the following is true of the neural computing technique in data mining?

Historical data is examined for patterns that are then used to make predictions.

_____ enables the analysis of big data and other challenging data-processing applications.

In-memory database (IMDB)

Identify the industry that implements data governance.

Insurance industry

Which of the following is true of unstructured data?

It can add a depth to data analysis, with the right tools, that could not be achieved otherwise.

Which of the following best describes the application layer of Hadoop?

It enables applications such as internally developed programming languages or purchased third-party business intelligence tools to interact with Hadoop.

Which of the following best describes the relational database model?

It helps organize structured data into collections of two-dimensional tables.

Identify a true statement about drill-down analysis.

It involves the interactive examination of high-level summary data in increasing detail to gain insight into certain elements.

Which of the following is true of a data mart?

It is a smaller version of a data warehouse.

Which of the following is true of Hadoop?

It is an open-source software framework designed for processing large volumes of data by dividing the work into a set of independent tasks.

Which of the following is true of a NoSQL database?

It is highly scalable.

Which of the following best describes an extract-transform-load (ETL) process?

It is used to pull data from disparate data sources to populate and maintain the data warehouse.

Identify a drawback of a NoSQL database.

It lacks strong data consistency.

Which of the following steps in an extract-transform-load (ETL) process creates an updated version of a data warehouse?

Load

Which of the following steps in an extract-transform-load (ETL) process updates an existing data warehouse with the data obtained from the extract and transform steps?

Load

Which of the following databases is designed to store and retrieve data without rigidly implementing the ACID (atomicity, consistency, isolation, and durability) conditions associated with the relational database model?

NoSQL

Which of the following databases should be used by a company that has over 50,000 employees in several locations to efficiently manage its database even when a couple of servers are down?

NoSQL

PindCart, a garment retailer, is not sure of the demand for its products during the festive seasons and ends up with very little profit. Which of the following business intelligence tools can help PindCart to predict the demand and maximize its sales?

Online analytical processing

Which of the following is a method to analyze multidimensional data from different perspectives?

Online analytical processing (OLAP)

_____ enables users to identify issues and opportunities as well as perform trend analysis by analyzing multidimensional data from many different perspectives.

Online analytical processing (OLAP)

_____ are designed to draw data in real time from various sources, including corporate databases and spreadsheets, so decision makers can make use of up-to-the-minute data.

Operational dashboards

Which of the following is the storage medium of an in-memory database (IMDB)?

Random access memory (RAM)

Which of the following enables end users to make their own data requests and format the results without the need for additional help from the information technology organization?

Reporting and querying tools

Which of the following is a special-purpose programming language used for accessing and manipulating data stored in a relational database?

SQL

Identify the feature of a NoSQL database that allows a large database to be distributed across thousands of servers running the same NoSQL database management system.

Scalability

Which of the following business intelligence tools performs operations on data based on formulas created by the end user?

Spreadsheet

_____ can be used to create useful reports and graphs based on given data.

Spreadsheets

Identify the system feature that is improved due to the highly scalable nature of NoSQL databases.

System uptime

Which layer of Hadoop is responsible for data storage?

The Hadoop Distributed File system layer (HDFS)

Which of the following is the reason behind the quick responsiveness of online analytical processing (OLAP)?

The pre-aggregation of detailed data into useful data summaries

Which of the following layers of Hadoop handles job failures and interruptions?

The workload management layer

Which of the following best describes reporting and querying tools?

They present data in a simplified form of graphs and charts, making it easier to understand.

Which of the following is true of dashboards?

They provide rapid access to information in an easy-to-interpret manner.

Hadoop is designed for processing large volumes of data by dividing the work into a set of independent tasks that are executed in parallel on a large number of servers.

True

Online analytical processing (OLAP) enables users to identify issues and opportunities as well as perform trend analysis.

True

The goal of a NoSQL database is to provide very fast performance even as the amount of data that must be processed continues to grow.

True

The columns in a relational database model such as customer name and address represent _____.

attributes

The ability to ensure that an update to data in one part of a database is immediately propagated to all other parts of the database is known as _____.

data consistency

Databases built to support online analytical processing (OLAP) consist of _____.

data cubes

The ACID (atomicity, consistency, isolation, and durability) properties of SQL databases ensure _____.

data integrity

A _____ is a database that stores large amounts of historical data in a form that readily supports analysis and management decision making in an organization.

data warehouse

The effectiveness of a(n) _____ process is essential to ensure the success of a data warehouse.

extract-transform-load

A(n) _____ is used to pull data from disparate data sources to populate and maintain a data warehouse.

extract-transform-load (ETL) process

A(n) _____ is a database management system that stores an entire database in random access memory (RAM).

in-memory database (IMDB)

Metrics that consist of a direction, measure, target, and time frame are known as _____.

key performance indicators

A NoSQL database stores data as highly optimized key-value pairs with the data stored in a _____ table.

simple two-column

In an extract-transform-load (ETL) process, the mined data used to update a data warehouse is converted to a different format in the _____ step.

transform

Data that does not fit nicely into relational databases is known as _____.

unstructured data