BI 330 Exam 2

Data Governane

A broad term describing a set of initiatives within an organization aimed at formally regulating how, when, and by whom the organizational data and metadata is created, stored, updated (inserted, modified, deleted), and archived.

Big Data

A broad term that refers to the massive volumes of diverse and rapidly growing data that is not formally modeled.

True

A data warehouse is created within an organization as a separate data store whose primary purpose is data analysis

SQL (Structured Query Language)

A language used to query a database; create a database; add, modify and delete database structures; and insert, delete, and modify records in the database.

Enterprise resources planning system

A pre-made, integrated (multi-functional) corporate information system.

True

A typical organization maintains and utilizes a number of operational data sources.

False

Analytical databases are referred to as application-oriented.

Master Data Management

Creating and maintaining a collection of quality master data tables and ensuring that the use of master data is embedded across the operational information systems in the organization.

The 4 categories of SQL are,

Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Transaction Control Language (TCL)

Data Custodian

Person responsible for the technical aspects of data management and use, such as protection, transport, and storage of data.

True

"Analytical databases are created for the analysis of one or more specific business subject areas, such as sales, returns, cost, or profit."

False

"Increasing the speed of a single query is always a priority, even if it requires slowing down the majority of other queries."

True

"Operational data typically represents the current state of affairs in the real world, while analytical data can represent both the current situation and snapshots from the past."

False

Operational databases are referred to as subject-oriented.

By more users than analytical queries

Operational queries are typically issued:

More often than analytical queries

Operational queries are typically issued:

Smaller amounts of data than analytical queries

Operational queries typically process:

Database Administration

People who manage issues related to security (e.g., creating and issuing user names and passwords, granting privileges to access data, etc.), handle backup and recovery of database systems, monitor use and adding storage space as needed, and perform other tasks related to the proper technical functioning of the database system.

Data Steward

Person who undertakes tasks related to data governance; responsible for the proper use of the data in databases.

True

The performance of operational day-to-day tasks involving data use can be severely diminished if such tasks have to compete for computing resources with analytical queries.

Creating a conceptual database model

Which of the following is NOT a data administration task?