MCSCI Chapter 6 Quiz

Which of the following statements about data warehouses is not true? They may include data from website transactions. They store supply data to be used across the enterprise for management analysis and decision making. Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. Data warehouse systems provide easy-to-use tools for managers to easily update data. Data warehouses make data available for anyone to access as needed.

Data warehouse systems provide easy-to-use tools for managers to easily update data.

Web servers can directly access a firm's back-end databases using HTML. Group of answer choices True False

False

Common data quality problems include all of the following except: misspelled names. missing codes. transposed numbers. incorrect codes. Internet connectivity problems.

Internet connectivity problems.

Which of the following best describes the importance of creating an accurate data model for your business's database? It is not essential, as the data model itself is modified by the database continuously. It is essential, as table relationships cannot be created without an accurate data model It is somewhat important, as the type of data model will define what kinds of data will be stored. It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. It is unnecessary, as a well-designed database should not require one.

It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables? Pre-digital DBMS Two-tiered DBMS Relational DBMS Hierarchical DBMS Open source DBMS

Relational DBMS

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system. True False

True

Data cleansing is the same process as data scrubbing. True False

True

In-memory computing relies on a computer's main memory for storing data. True False

True

OLAP enables users to view data from different perspectives. True False

True

OLAP is used to quickly find answers to ad hoc questions. True False

True

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems. True False

True

Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites? Web content mining Web usage mining Web protocol mining Web server mining Web structure mining

Web structure mining

The select operation: identifies the table from which the columns will be selected. combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of columns in a table. creates a subset consisting of all records in the file that meet stated criteria. specifies the content of the database.

creates a subset consisting of all records in the file that meet stated criteria.

A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed. data warehouse data lake data mart dashboard relational DBMS

data lake

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because: all the information is historical. it is open-source.it uses a web interface. it typically focuses on a single subject area or line of business. all of the information belongs to a single company.

it typically focuses on a single subject area or line of business.

OLAP is a tool that enables users to: quickly diagram data relationships. find hidden patterns in large databases. normalize data. obtain online answers to ad hoc questions in a rapid amount of time. view both logical and physical views of data.

obtain online answers to ad hoc questions in a rapid amount of time.

Hadoop is a(n): high-speed platform used to analyze large data sets. pre-configured hardware-software system designed for analyzing big data. open source software framework designed for distributing data-processing over inexpensive computers. data mining platform designed for storing and analyzing big data produced by web communications and transactions. NoSQL database technology that stores both data and procedures acting on the data as objects.

open source software framework designed for distributing data-processing over inexpensive computers.

A DBMS makes the: relational database available for different physical views. relational database available for different analytical views. physical database available for different relational views. physical database available for different logical views. logical database available for different analytical views.

physical database available for different logical views.

In a table for customers, the information about a single customer would reside in a single: entity. row. table. column. field.

row

A data ________ stores current and historical data of potential interest to decision makers throughout the company. archive warehouse mine mart center

warehouse