منشور DIS305 - Data Management - Midterm Exam - Model B (20 Marks)

DIS305 - Data Management - Midterm Exam - Model B (20 Marks) Q1. Which Data Integration and Interoperability tool provides unified views without physically moving data? A) ETL / Data Transformation Engine B) Business Rules Engine C) Data Profiling Tools D) Data Virtualization Server Q2. Which type of data steward includes IT professionals such as DBAs, BI specialists, data quality analysts, or metadata administrators? A) Business Data Stewards B) Enterprise Data Stewards C) Data Owners D) Technical Data Stewards Q3. In the CAP Theorem, which property means "every read receives the most recent write or an error"? A) Availability B) Partition Tolerance C) Consistency D) Durability Q4. Which DAMA principle states that metadata provides context and meaning (definitions, lineage, usage) for data? A) Managing data means managing quality B) It takes planning to manage data C) It takes metadata to manage data D) Data management is lifecycle management Q5. Which data privacy principle states that organizations should collect only the minimum amount of data necessary for the purpose? A) Accuracy B) Storage Limitation C) Accountability D) Data Minimization Q6. Which approach loads raw data first, then transforms it inside the data platform (e.g., cloud DW)? A) ETL B) ELT C) Data Virtualization D) Federated Queries Q7. In FAIR Data, the letters F-A-I-R stand for: A) Findable, Available, Integrated, Reliable B) Formal, Accessible, Integrated, Reusable C) Findable, Accessible, Interoperable, Reusable D) Fast, Accurate, Interoperable, Reliable Q8. "The exercise of authority and control (planning, monitoring, enforcement) over the management of data assets" is the definition of: A) Data Governance B) Data Management C) Data Stewardship D) Data Asset Valuation Q9. A dedicated high-speed network that provides access to consolidated, block-level storage is called: A) SAN (Storage Area Network) B) LAN (Local Area Network) C) ESB (Enterprise Service Bus) D) EAI (Enterprise Application Integration) Q10. In data modeling, something about which an organization collects data, often described as the "nouns" of an organization, is called: A) Entity B) Attribute C) Relationship D) Domain Q11. Which data model contains tables, columns, indexes, and constraints? A) Conceptual Data Model B) Logical Data Model C) Physical Data Model D) Fact-Based Model Q12. Which data modeling scheme is designed primarily for data warehousing and analytics, and organizes data into facts and dimensions? A) Relational B) Dimensional C) Object-Oriented D) Fact-Based Q13. What is the primary business driver of Data Storage and Operations? A) Data monetization B) Regulatory compliance C) Competitive advantage D) Business continuity Q14. Which data quality dimension means "no missing info"? A) Accuracy B) Completeness C) Consistency D) Timeliness Q15. The key goals of Data Management are: A) Performance, reliability, and availability B) Availability, usability, integrity, and security of data C) Confidentiality, integrity, and availability D) Organization, searchability, and compliance Q16. A university has several faculties, each maintaining its own independent database. Management wants to run queries across all faculties as if from one unified source, without physically centralizing the data and while each faculty keeps its independence. Which data management solution should be designed? A) A federated storage model with a federation layer that translates and routes queries to each faculty's database B) A centralized storage model that moves all faculty data into a single database server C) A distributed storage model that shards and replicates the data across network nodes D) An ETL process that extracts, transforms, and loads all faculty data into one data warehouse