BACS Quiz 2 Flashcards

Questions and Answers

What creates, reads, updates, and deletes data in a database while controlling access and security?

Database management system

Real-time __________ provide real-time data in response to requests.

data

What does the warehouse database model do?

Processes real-time data

Stores data in the form of graphs

Creates new data elements

Stores data in the form of logically related two-dimensional tables (correct)

What are relational integrity constraints?

Rules that enforce basic and fundamental information-based constraints. Signup and view all the answers

What is data gap analysis?

Occurs when a company examines its data to determine if it can meet business expectations. Signup and view all the answers

What is data stewardship?

Management and oversight of an organization's data assets. Signup and view all the answers

What are business-critical integrity constraints?

Enforces business rules vital to an organization's success. Signup and view all the answers

What is a data steward responsible for?

Ensuring policies and procedures are implemented across the organization. Signup and view all the answers

What does query-by-example do?

Helps users graphically design the answer to a question against a database. Signup and view all the answers

What are the four functions that a database management system can perform on data in a database?

Read data Signup and view all the answers

What is a real-time system?

Provides real-time data in response to requests. Signup and view all the answers

What is a relational database model?

Stores data in the form of logically related two-dimensional tables. Signup and view all the answers

What is metadata?

Provides details about data. Signup and view all the answers

What does the physical view of data deal with?

Physical storage of data on a storage device Signup and view all the answers

What is the logical view of data?

Focuses on how individual users logically access data. Signup and view all the answers

What does data integrity measure?

The quality of data. Signup and view all the answers

What is a business rule?

Defines how a company performs certain aspects of its business. Signup and view all the answers

What is data inconsistency?

When the same data element has different values. Signup and view all the answers

What are data integrity issues?

When a system produces incorrect, inconsistent, or duplicate data. Signup and view all the answers

What does a database maintain?

Data about various types of objects, events, people, and places. Signup and view all the answers

What is a data field?

A synonym for data element; the smallest unit of data in a database. Signup and view all the answers

What is a data dictionary?

Compiles all of the metadata about data elements in the data model. Signup and view all the answers

What is data granularity?

The extent of detail within the data. Signup and view all the answers

What is data latency?

The time it takes for data to be stored or retrieved. Signup and view all the answers

What is data redundancy?

The duplication of data in multiple places. Signup and view all the answers

What does a data governance system do?

Creates, reads, updates, and deletes data in a database while controlling access and security. Signup and view all the answers

What are integrity constraints?

Rules that help ensure the quality of data. Signup and view all the answers

What are relational integrity constraints?

Rules that enforce basic and fundamental information-based constraints. Signup and view all the answers

What is data aggregation?

The collection of data from various sources for data processing. Signup and view all the answers

What is a data cube?

The common term for the representation of multidimensional data. Signup and view all the answers

What are data quality audits?

Determine the accuracy and completeness of data. Signup and view all the answers

What are infographics?

Present the results of data analysis in a graphical format. Signup and view all the answers

What is a data artist?

A business analytics specialist who uses visual tools to help understand complex data. Signup and view all the answers

What is distributed computing?

Processes and manages algorithms across many machines. Signup and view all the answers

What is a ledger?

Records classified and summarized transactional data. Signup and view all the answers

What is a dataset?

An organized collection of data. Signup and view all the answers

What does ETL stand for?

Extraction, transformation, and loading. Signup and view all the answers

What is a data warehouse?

A logical collection of data gathered from different operational databases. Signup and view all the answers

What is a data mart?

Contains a subset of data warehouse information. Signup and view all the answers

What is a data lake?

A storage repository that holds vast amounts of raw data until needed. Signup and view all the answers

What is dirty data?

Erroneous or flawed data. Signup and view all the answers

What is data cleansing?

The process of weeding out, fixing, or discarding bad data. Signup and view all the answers

What is analysis paralysis?

Occurs when over-analyzing prevents decision-making. Signup and view all the answers

What is blockchain?

A type of distributed ledger technology consisting of data structure blocks. Signup and view all the answers

What is proof-of-work?

A requirement to perform an expensive computer calculation to create new transactions. Signup and view all the answers

What is bitcoin?

A type of digital currency maintained by transaction records. Signup and view all the answers

What is source data?

Identifies the primary location where data is collected. Signup and view all the answers

What is a dataset?

An organized collection of data Signup and view all the answers

What is bluetooth?

A wireless PAN technology that transmits signals over short distances. Signup and view all the answers

What is WiMAX?

A communications technology for high-speed wireless data. Signup and view all the answers

What is a wireless MAN?

A metropolitan area network using radio signals to transmit data. Signup and view all the answers

What does an SSL certificate do?

Confirms the identity of a website Signup and view all the answers

What is a bit?

The smallest element of data, with a value of either 0 or 1. Signup and view all the answers

What is an access point?

The computer or network device that serves as an interface between devices and the network. Signup and view all the answers

What does a wireless access point do?

Enables devices to connect to a wireless network. Signup and view all the answers

What is SSL?

A standard security technology for establishing an encrypted link. Signup and view all the answers

What is WWAN?

A wide area network using radio signals for data transmission. Signup and view all the answers

What is a Wireless MAN?

A metropolitan area network using radio signals Signup and view all the answers

What does Secure Sockets Layer (SSL) do?

Establishes an encrypted link for secure data transmission. Signup and view all the answers

What does HTTPS SHTTP represent?

A standard for secure web protocols Signup and view all the answers

What is a Wide Area Network (WAN)?

Spans a large geographic area such as a state or country. Signup and view all the answers

What does bandwidth measure?

Network performance and the maximum amount of data transfer. Signup and view all the answers

What is bit rate?

The number of bits transferred per unit of time. Signup and view all the answers

What is a PAN?

Provides communication for devices over a short distance. Signup and view all the answers

What is a LAN?

A local area network using radio signals over short distances. Signup and view all the answers

What do WAPs with MIMO do?

Send and receive greater amounts of data Signup and view all the answers

What are hotspots?

Designated locations where Wi-Fi access points are available. Signup and view all the answers

What do smartphones offer compared to basic cell phones?

More advanced computing ability and connectivity. Signup and view all the answers

What is streaming?

A method of sending audio and video files so the user can view them while transferring. Signup and view all the answers

What does Voice over IP use?

IP technology to transmit telephone calls. Signup and view all the answers

What is war driving?

Deliberately searching for Wi-Fi signals while driving. Signup and view all the answers

What is wireless WAN?

A wide area network using radio signals for data transmission. Signup and view all the answers

What provides communication for devices owned by a single user over a short distance?

Personal Area Network Signup and view all the answers

Study Notes

Database Management

A database management system (DBMS) enables creation, reading, updating, and deletion of data while controlling security and access.
Functions of a DBMS include creating data, deleting data, reading data, and updating data.

Data Models

Relational database model organizes data in logically related two-dimensional tables.
Warehouse database model also stores data in related two-dimensional tables but is focused on business analysis.
Data cube represents multidimensional data for easier analysis.

Data Integrity and Governance

Integrity constraints ensure the quality of data by enforcing business rules.
Relational integrity constraints address basic information-based rules, whereas business-critical integrity constraints require deeper insights for compliance.
Data stewardship involves overseeing data assets to maintain quality and accessibility for business users.
A data steward acts as a liaison between management information systems and business requirements.

Data Analysis and Management

Data gap analysis identifies gaps in data to ensure it meets business expectations.
Data aggregation collects data from multiple sources for processing.
Data latency refers to the time required for data storage or retrieval.
Data cleansing (scrubbing) eliminates incorrect or incomplete data.

Data Quality and Consistency

Data integrity is a measure of data's quality. Issues arise when data is incorrect, inconsistent, or duplicated.
Data inconsistency occurs when the same data element has different values.
Conducting data quality audits helps assess the accuracy and completeness of data.

Digital Technologies

Blockchain is a distributed ledger technology of interconnected blocks that are timestamped and linked, ensuring transparency and security.
Proof-of-work is a computational task required for creating new transactions in blockchain.
Bitcoin is a digital currency that operates independently from central banks while maintaining transaction records using computational solutions.

Networking and Connectivity

Wireless PAN provides short-distance communication for devices owned by individual users.
Wireless LAN uses radio signals for data transmission over limited distances.
WiMAX and Wireless MAN technologies offer high-speed wireless communication over wider areas.
Hotspots allow public Wi-Fi access at designated locations.
Voice over IP (VoIP) utilizes internet technology for phone calls.

Data and Technology Terms

Metadata offers information about data characteristics.
Data dictionary collects metadata about data elements.
Data field is synonymous with data element, serving as the smallest data unit.
Dirty data refers to erroneous or flawed information.
Bit is the smallest data element, representing either a 0 or a 1.
Bandwidth measures network capacity, representing maximum data transfer capability.

General Concepts

Streaming allows audio and video files to be viewed while being transferred.
Analysis paralysis occurs when excessive analysis prevents decision-making.
Data mart is a subset of a data warehouse, focused on specific business areas.

These notes encompass critical elements of database management, data integrity, digital technologies, networking, and related terminologies for effective study and understanding.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge on database management concepts with these flashcards. This quiz covers key definitions and terms related to databases, including data management systems and warehouse database models. Perfect for reinforcing your understanding of database structures and operations.