Chapter 4 - Practice Quiz

Which of the following is NOT one of the important characteristics that affects the quality of information.

Cost

Which of the following is FALSE?

Unstructured data has straightforward relationships.

Data and information about data would be described as which of the following?

Metadata

A survey asking people if McDonalds is their favorite restaurant is given to people as they exit McDonalds would most likely have problems with which quality characteristic?.

Bias

A football team has video of practices and games, audio recordings of recruits, and e-mails and letters about prospective players. This content would best be categorized as_____

Unstructured Information

When each department maintains its own records, having programs available for processing, it is most likely to create which of the following for the organization?

Data Redundacny

This is one way to organize data, through duplicating the organizational chart, creating a structure that looks like an inverted tree.

Hierarchical database

Which one of the following is false?

Each record should have a data definition

When looking at the pros and cons of file processing and databases, which statement is false?

With file processing, each record is stored in conjunction with the program creating consistency.

Some companies use______, and information system that runs a high volume of records through a set of operation, typically at set timed for things like payroll, paying bills, or sending out mass mailings.

Batch Processing

Which of the following is the first thing done in setting up a database?

Create a data model

Which of the following is FALSE?

A primary key can have duplicates

A condition in which information is duplicated in a database can be eliminated using which of the following?

Normalization

With well-organized databases, questions can be answered using which of the following?

SQL

Organizing data into tables, linked by matching data between fields in the two tables, best describes which type of database?

Relational Database

Setting up______helps achieve uniform tables and data structures across the entire organization.

Master data management

Which of the following best describes the role of a data steward?

Watch how data is being used and encourage users to use the existing data structures

Which one of the following is a strategy of creating via fields such that the data, for instance a date of hire, exists in many locations but is updated in only one location?

Bridging

All of the following are true statements about master data management, EXCEPT which one?

Master data management efforts use teams form many, if not all, the business units within the organization

Which of the following best describes a shadow system?

A small database set up to focus on an individual department's needs, instead of using the organization's database

Which of the following is a common methodology for creating a data warehouse?

Extract, transform, load (ETL)

Which of the following is INCORRECT about data warehouses?

A firm's data warehouse will consolidate only internal data after checking it for quality

Hadoop, as a new technology that is open-source software that scales easily even tapping into the cloud, is used with which of the following?

Big Data

Which is a type of gathering intelligence using statistical analysis to find patterns that would NOT typically be seen in standard generated by individuals

Data mining

Which is best described as a central collection of data that is drawn from many sources, typically used with strategic planning?

Data warehouse

Facebook's database, in which everyone contributes content, images, videos, and statements, is an example of which of the following?

Database without boundaries

People who may want a database field for gender to be optional rather than required, while others want it to be required, is an example of which of the following?

Database ownership issue

Managing databases is not just about technology and big data. It also involves which two other elements?

People and processes

With regard to users and owners of information systems, which of the following statements is incorrect?

Customers are about the only people who don't bring in ownership issues with databases.

Within an organization, a department may want to control its data, leading to which of the following issues?

Ownership issues