BT2102 T6

What is your favorite drink from cool spot?

Which of the following best describes a Data Warehouse?

• A collection of raw, unstructured data stored in its native format

• A centralized system that functions as a management point for data flow across an enterprise

• A highly structured and processed data repository used for business intelligence and analytics

• A database system that allows real-time transaction processing

In the relational data model, what is a "Tuple"?

• A column in a relation

• A row in a relation

• A named column in a table

• A key that uniquely identifies a relation

Which of the following statements about Data Lakes is true?

• They store only structured data

• They require extensive preprocessing before data can be stored

• They allow storage of large amounts of raw, unstructured, semi-structured, and structured da

• They primarily use traditional ETL processes for data integration

Which type of key is selected from a set of candidate keys to uniquely identify tuples within a relation?

• Foreign key

• Superkey

• Primary key

• Alternate key

In the ANSI-SPARC three-level database architecture, which level describes how the data is physically stored?

• External level

• Conceptual level

• Internal level

• Logical level

Which normal form eliminates partial dependencies but still allows transitive dependencies?

• 1NF

• 2NF

• 3NF

• BCNF

In a hierarchical data model, how are relationships between records represented?

• As tables with primary and foreign keys

• As tree structures where each node has only one parent

• As graphs where nodes represent records and edges represent relationships

• As a network of interconnected records with multiple parent-child links

Which of the following statements about Entity-Relationship (ER) modeling is false?

• A weak entity depends on a strong entity for its existence

• A composite attribute is composed of multiple components with independent existence

• A derived attribute is stored in the database and cannot be calculated from other attributes

• A relationship occurrence represents a unique association between entity types

Which of the following data integration methods is primarily used in a data warehouse?

• ELT (Extract, Load, Transform)

• ETL (Extract, Transform, Load)

• Streaming analytics

• Direct database querying