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?