Chapter 9 Flashcards Chegg PDF

Preview

Summary

Chapter 9 Flashcards Chegg Principles of Information Systems ISDS 351...

Description

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

Search

Find over 500 million flashcards

Chapter 9 75 cards

Victoria A.

Management | Management Information Systems

Practice all cards

_____ 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

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

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

1/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

extract-transform-load (ETL) process

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

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

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

extract-transform-load

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

Extract

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.

trsnsform

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

2/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

and transform steps?

PHQ, a graphics rm, decides to lter 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 rm to accomplish the task?

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

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

Load

Which of the following is true of a data mart?

It is a smaller version of a data warehouse.

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

3/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

data mart

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

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

A row

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

a column

Which of the following best describes the relational database model?

helps organize structured data into collections of twodimensional tables.

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

4/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

programming language used for accessing and manipulating data stored in a relational database?

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

data integrity

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

attributes

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

concurrency control

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

unstructured data

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.

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

5/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

and retrieve data without rigidly implementing the ACID (atomicity, consistency, isolation, and durability) conditions associated with the relational database model?

Which of the following is true of a NoSQL database?

it is highly scalable.

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

Identify a drawback of a NoSQL database.

It lacks strong data consistency.

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

simple two-column

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

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

6/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

System uptime

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

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 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 layers of Hadoop handles job failures and interruptions?

The workload management layer

Which layer of Hadoop is responsible for data storage?

The Hadoop Distributed File system layer (HDFS)

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

7/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

128 MB

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

In-memory database (IMDB)

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

Random access memory (RAM)

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

in-memory database (IMDB)

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

random access memory (RAM)

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

spreadsheet

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

8/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

Excel scenario manager

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

Excel Solver

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

spreadsheets

Which of the following best describes reporting and querying tools?

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

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

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

Online analytical processing (OLAP)

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

9/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

Online analytical processing (OLAP)

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

data cubes

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

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

online analytical processing OLAP

. _____ 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

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

10/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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?

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.

_____ 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 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 true of the neural computing technique in data mining?

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

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

11/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

Data mining tools

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

kpi

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

dashboards

Which of the following is true of dashboards?

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

_____ 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

_____ involves the overall management of the availability usability integrity and security of the

data governance

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

12/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

Identify the industry that implements data governance.

insurance industry

t/f Organizations employ data warehouses to store junk data.

false

t/f Unstructured data comes from a single source

false

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

false

t/f 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

t/f 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

true

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

13/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

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

false

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

false

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

true

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

false

t/f 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

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

14/15

9/20/21, 6:37 PM

Chapter 9 Flashcards | Chegg.com

COMPANY LEGAL & POLICIES CHEGG PRODUCTS AND SERVICES CHEGG NETWORK CUSTOMER SERVICE

© 2003-2021 Chegg Inc. All rights reserved.

https://www.chegg.com/flashcards/chapter-9-681ec44f-477f-4842-82b6-351ceebd3f9c/deck

15/15...