Database Management Systems

Confidentiality, Integrity, and Availability (CIA) are the fundamental goals of Data Security. These principles ensure that data is protected from unauthorized access (confidentiality), maintained in accurate and complete form (integrity), and accessible when needed (availability). Data profiling is about analyzing data quality, governance involves policies and oversight, and MDM focuses on consistent master data.

In ELT (Extract, Load, Transform), data is loaded directly into the target database after extraction, and the transformation processing is performed using the target database engine itself.

The cube structure in OLAP (Online Analytical Processing) achieves multidimensional functionality, enabling analysis across multiple dimensions simultaneously. This allows users to slice, dice, pivot, and drill through data from various perspectives. The other options (Shared, Information, Collection) are not standard OLAP terminology or functionalities.

The statement is False. ODS (Operational Data Store) is a volatile data store by design - it reflects current operational data and is frequently updated or overwritten. Unlike data warehouses which are non-volatile and accumulate historical data, ODS is meant to provide a near real-time operational view and is regularly refreshed or reset.

The statement is False. Active data warehouse architecture (also called Active Warehouse Integration or Real-Time Warehouse) integrates and unifies data marts rather than keeping them separate and segregated. The active architecture approach creates a centralized, integrated environment where data marts share conformed dimensions and are coordinated, enabling real-time or near-real-time data integration across the enterprise.

Information delivery modes are Pull (user actively requests) and Push (system proactively delivers). Ad hoc reports are Pull, but prestored reports can be delivered either way depending on mechanism, and OLAP is typically interactive (Pull). Not all three are exclusively Pull.

In relational database theory, a table is called a relation. In ER (Entity-Relationship) modeling, a table representing an entity type can be called an entity. Records and fields refer to data within the table (rows and columns), not the table structure itself.

Normalization is the formal process of structuring data into relational tables to eliminate redundancy and improve data integrity. It involves organizing columns and tables to minimize data duplication and dependency, which is the foundation of relational database design.

Data Quality Management is the systematic process of identifying, preventing, and resolving data issues to ensure data is accurate, complete, and reliable. It directly addresses bad data through validation, cleansing, and governance processes. Data Transformations are about converting data formats, Data Mining extracts patterns, and Data Security protects against unauthorized access.

ELT (Extract, Load, Transform) differs from traditional ETL by loading raw data into the target database first, then using that target database's powerful processing engine to perform transformations. This approach is more efficient for large datasets compared to transforming before loading.

An Operational Data Store (ODS) is specifically designed to contain current, volatile data from operational systems at the lowest level of granularity. Unlike data warehouses or data marts which store aggregated or historical data, the ODS maintains the most detailed, up-to-date operational data.

Business Intelligence systems integrate data from disparate sources across an organization and transform it into meaningful, actionable information for decision-makers. Option B is incorrect because BI analyzes both historical and real-time data, and option C is too narrow - BI uses business rules but isn't primarily about defining them.

Data in a data warehouse is structured for analytical queries and reporting. It can be normalized, but it often is not (denormalized into star or snowflake schemas) to optimize read performance.

The CIA triad - Confidentiality, Integrity, and Availability - are the three fundamental goals of information security and data security. Data security focuses on protecting these three aspects of data assets from unauthorized access, corruption, or unavailability.

Data governance is a core component of Enterprise Information Management (EIM), which provides the overarching framework for managing information as an organizational asset. EIM encompasses policies, processes, and technologies for managing data across the enterprise.