{"id":13703,"date":"2026-09-21T08:13:54","date_gmt":"2026-09-21T08:13:54","guid":{"rendered":"https:\/\/visaoestrategica.pt\/?p=13703"},"modified":"2026-09-21T13:13:05","modified_gmt":"2026-09-21T13:13:05","slug":"cdmp-practice-quiz","status":"publish","type":"post","link":"https:\/\/visaoestrategica.pt\/?p=13703","title":{"rendered":"CDMP Practice Quiz"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Certified Data Management Professional (CDMP\u00ae ) certification is globally recognized as the gold standard&nbsp;in data management. It validates your expertise and enhances your credibility. This is a simple practice quiz to test your knowledge. The certification exam is considerably more complex.<\/p>\n\n\n\n<!doctype html><html lang=\"en\"><head><meta charset=\"utf-8\"><meta name=\"viewport\" content=\"width=device-width,initial-scale=1\"><title>CDMP Practice Quiz<\/title><style>body{margin:0;background:#eef3f8;padding:18px}\n.cdmpq{max-width:980px;margin:24px auto;font-family:system-ui,-apple-system,Segoe UI,sans-serif;color:#172033}.cdmpq *{box-sizing:border-box}.cdmpq-card{background:#fff;border:1px solid #dce3ec;border-radius:16px;padding:22px;box-shadow:0 5px 20px rgba(20,40,70,.08);margin-bottom:18px}.cdmpq h2,.cdmpq h3{margin-top:0}.cdmpq-controls{display:grid;grid-template-columns:2fr 1fr 1fr;gap:12px}.cdmpq label{font-weight:650;font-size:14px}.cdmpq select,.cdmpq input,.cdmpq button{font:inherit}.cdmpq select,.cdmpq input{width:100%;padding:10px;border:1px solid #b9c5d4;border-radius:9px;margin-top:5px}.cdmpq button{border:0;border-radius:9px;padding:11px 16px;background:#1967b3;color:#fff;font-weight:700;cursor:pointer}.cdmpq button.secondary{background:#e9f0f7;color:#164c7e}.cdmpq button.danger{background:#9c2f2f}.cdmpq-actions{display:flex;gap:10px;flex-wrap:wrap;margin-top:16px}.cdmpq-progress{height:10px;background:#e9eef4;border-radius:999px;overflow:hidden;margin:14px 0}.cdmpq-progress>span{height:100%;display:block;background:#1f78c1;width:0}.cdmpq-q{border-top:1px solid #e5eaf0;padding:18px 0}.cdmpq-q:first-child{border-top:0}.cdmpq-meta{color:#526274;font-size:13px;margin-bottom:6px}.cdmpq-opt{display:block;padding:10px 12px;margin:7px 0;border:1px solid #d3dbe5;border-radius:9px;cursor:pointer;font-weight:400}.cdmpq-opt:hover{background:#f5f8fb}.cdmpq-opt input{width:auto;margin:0 9px 0 0}.cdmpq-correct{background:#e9f7ee!important;border-color:#3b9a5f!important}.cdmpq-wrong{background:#fff0f0!important;border-color:#c34b4b!important}.cdmpq-rationale{padding:10px 12px;background:#f6f8fb;border-left:4px solid #547da6;margin-top:8px}.cdmpq-kpis{display:grid;grid-template-columns:repeat(3,1fr);gap:12px}.cdmpq-kpi{background:#f1f6fb;border-radius:12px;padding:16px;text-align:center}.cdmpq-kpi strong{font-size:28px;display:block;color:#14588f}.cdmpq-breakdown{width:100%;border-collapse:collapse}.cdmpq-breakdown th,.cdmpq-breakdown td{text-align:left;padding:9px;border-bottom:1px solid #e3e8ef}.cdmpq-note{font-size:13px;color:#596879}.cdmpq-hidden{display:none!important}@media(max-width:700px){.cdmpq-controls,.cdmpq-kpis{grid-template-columns:1fr}.cdmpq-card{padding:15px}}\n<\/style><\/head><body><div id=\"cdmp-practice-quiz\"><\/div><script>const CDMP_QUESTIONS=[{\"id\":1,\"chapter\":\"1. Data Governance\",\"question\":\"What is the primary purpose of data governance?\",\"options\":[\"Establish decision rights and accountability for data\",\"Operate backup infrastructure\",\"Develop analytical models\",\"Design database indexes\"],\"answer\":0,\"rationale\":\"Governance defines authority, accountability, policies, and decision processes for data.\",\"difficulty\":\"Mixed\"},{\"id\":2,\"chapter\":\"1. Data Governance\",\"question\":\"Who is normally accountable for the business definition and acceptable quality of a data domain?\",\"options\":[\"The database administrator\",\"The application developer\",\"The Data Owner\",\"The network engineer\"],\"answer\":2,\"rationale\":\"A Data Owner is accountable for decisions and outcomes within a business data domain.\",\"difficulty\":\"Mixed\"},{\"id\":3,\"chapter\":\"1. Data Governance\",\"question\":\"Which activity is most characteristic of a Data Steward?\",\"options\":[\"Monitoring definitions, quality issues, and compliance in daily operations\",\"Owning all enterprise applications\",\"Approving the corporate budget\",\"Configuring network firewalls\"],\"answer\":0,\"rationale\":\"Stewards perform operational coordination and monitoring under the accountability of owners.\",\"difficulty\":\"Mixed\"},{\"id\":4,\"chapter\":\"1. Data Governance\",\"question\":\"Two departments disagree on the meaning of 'active supplier.' What should happen first?\",\"options\":[\"Let each report retain its own definition\",\"Use the governance decision process to agree and approve one definition\",\"Delete the term from all reports\",\"Ask the DBA to choose a definition\"],\"answer\":1,\"rationale\":\"Conflicting enterprise definitions require an authorized governance decision, not an informal technical choice.\",\"difficulty\":\"Mixed\"},{\"id\":5,\"chapter\":\"1. Data Governance\",\"question\":\"Which is the best evidence that a governance policy is mature?\",\"options\":[\"It has many pages\",\"It exists as a draft file\",\"It is technically detailed\",\"It is approved, adopted, monitored, and periodically improved\"],\"answer\":3,\"rationale\":\"Document existence alone is insufficient; mature capability includes adoption, measurement, and improvement.\",\"difficulty\":\"Mixed\"},{\"id\":6,\"chapter\":\"1. Data Governance\",\"question\":\"What is a decision right?\",\"options\":[\"A defined authority to make or approve a data-related decision\",\"A report subscription\",\"A database permission granted to every user\",\"A legal ownership claim over software\"],\"answer\":0,\"rationale\":\"Decision rights clarify who may decide, approve, escalate, or resolve specific data matters.\",\"difficulty\":\"Mixed\"},{\"id\":7,\"chapter\":\"1. Data Governance\",\"question\":\"Which body commonly resolves cross-domain data conflicts?\",\"options\":[\"The Data Governance Council\",\"The database vendor\",\"The help desk\",\"The project scheduler\"],\"answer\":0,\"rationale\":\"A cross-functional governance body handles conflicts that exceed one domain owner's authority.\",\"difficulty\":\"Mixed\"},{\"id\":8,\"chapter\":\"1. Data Governance\",\"question\":\"Which statement best distinguishes policy from standard?\",\"options\":[\"There is no practical difference\",\"Policy states required intent; a standard specifies mandatory requirements\",\"Policy is optional; standards are always laws\",\"Policy is technical; standards are strategic\"],\"answer\":1,\"rationale\":\"Policies express direction and obligations, while standards make those obligations specific and testable.\",\"difficulty\":\"Mixed\"},{\"id\":9,\"chapter\":\"1. Data Governance\",\"question\":\"A governance program has many meetings but no recorded decisions. What is the main weakness?\",\"options\":[\"The data warehouse is too small\",\"The backup window is too long\",\"The operating model lacks effective decision execution\",\"The data model is over-normalized\"],\"answer\":2,\"rationale\":\"Governance should produce accountable decisions and outcomes, not only discussion.\",\"difficulty\":\"Mixed\"},{\"id\":10,\"chapter\":\"1. Data Governance\",\"question\":\"Which metric best measures stewardship effectiveness?\",\"options\":[\"CPU utilization\",\"Percentage of assigned data issues resolved within the agreed SLA\",\"Number of database servers\",\"Total document page count\"],\"answer\":1,\"rationale\":\"Issue resolution against an agreed service level reflects an operational stewardship outcome.\",\"difficulty\":\"Mixed\"},{\"id\":11,\"chapter\":\"1. Data Governance\",\"question\":\"Who should approve access to confidential supplier pricing data?\",\"options\":[\"The first user requesting access\",\"Any report developer\",\"The accountable Data Owner, following security policy\",\"The storage administrator alone\"],\"answer\":2,\"rationale\":\"Business access decisions belong to the accountable owner; technical teams implement them.\",\"difficulty\":\"Mixed\"},{\"id\":12,\"chapter\":\"1. Data Governance\",\"question\":\"What should determine the scope of a governance program?\",\"options\":[\"The age of the oldest database\",\"Business priorities, risk, and critical data needs\",\"Only the preferences of IT\",\"The number of available meeting rooms\"],\"answer\":1,\"rationale\":\"Governance scope should align with business value, obligations, and risk.\",\"difficulty\":\"Mixed\"},{\"id\":13,\"chapter\":\"1. Data Governance\",\"question\":\"Which deliverable clarifies who is Responsible, Accountable, Consulted, and Informed?\",\"options\":[\"A physical data model\",\"A star schema\",\"A RACI matrix\",\"A recovery log\"],\"answer\":2,\"rationale\":\"A RACI matrix assigns participation and accountability across activities.\",\"difficulty\":\"Mixed\"},{\"id\":14,\"chapter\":\"1. Data Governance\",\"question\":\"A policy exception is requested. What is the soundest governance response?\",\"options\":[\"Approve verbally with no record\",\"Delete the policy\",\"Ignore the policy permanently\",\"Document the rationale, risk, approval, duration, and compensating controls\"],\"answer\":3,\"rationale\":\"Controlled exceptions should be transparent, risk-assessed, time-bound, and accountable.\",\"difficulty\":\"Mixed\"},{\"id\":15,\"chapter\":\"1. Data Governance\",\"question\":\"What is the best relationship between data strategy and data governance?\",\"options\":[\"Strategy sets direction; governance supplies authority and control to execute it\",\"They are unrelated\",\"Strategy is only a technical architecture\",\"Governance replaces strategy\"],\"answer\":0,\"rationale\":\"Governance operationalizes strategic intent through roles, policies, decisions, and oversight.\",\"difficulty\":\"Mixed\"},{\"id\":16,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the central purpose of data architecture?\",\"options\":[\"Approve employee expenses\",\"Write every SQL query\",\"Provide an enterprise blueprint for organizing and using data assets\",\"Manage document retention alone\"],\"answer\":2,\"rationale\":\"Architecture translates business and data strategy into target structures, flows, and principles.\",\"difficulty\":\"Mixed\"},{\"id\":17,\"chapter\":\"2. Data Architecture\",\"question\":\"Which artifact presents major data domains and their relationships at enterprise level?\",\"options\":[\"A sprint burndown chart\",\"An enterprise conceptual data model\",\"A user access list\",\"A backup log\"],\"answer\":1,\"rationale\":\"An enterprise conceptual model communicates major business concepts without implementation detail.\",\"difficulty\":\"Mixed\"},{\"id\":18,\"chapter\":\"2. Data Architecture\",\"question\":\"What does an authoritative source designation clarify?\",\"options\":[\"Which source is trusted to create or maintain defined data\",\"Which team owns the network\",\"Which server is newest\",\"Which report has the brightest colors\"],\"answer\":0,\"rationale\":\"Authoritative-source decisions reduce ambiguity about trusted creation and maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":19,\"chapter\":\"2. Data Architecture\",\"question\":\"Which architecture principle is most appropriate?\",\"options\":[\"All data must be copied into spreadsheets\",\"Every project should create separate definitions\",\"Data should be shared through governed, reusable interfaces\",\"Security should be added only after deployment\"],\"answer\":2,\"rationale\":\"Principles should promote reuse, consistency, governance, and secure design.\",\"difficulty\":\"Mixed\"},{\"id\":20,\"chapter\":\"2. Data Architecture\",\"question\":\"What is a target-state data architecture?\",\"options\":[\"A physical table definition only\",\"The intended future arrangement of data capabilities and components\",\"A list of yesterday's incidents\",\"A vendor invoice\"],\"answer\":1,\"rationale\":\"Target state describes the future architecture toward which the roadmap progresses.\",\"difficulty\":\"Mixed\"},{\"id\":21,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the principal purpose of a data-flow diagram?\",\"options\":[\"Display employee reporting lines\",\"Calculate storage invoices\",\"Show movement of data among processes, stores, and external entities\",\"Define password length\"],\"answer\":2,\"rationale\":\"Data-flow diagrams emphasize movement, transformation context, and interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":22,\"chapter\":\"2. Data Architecture\",\"question\":\"A canonical model is primarily used to do what?\",\"options\":[\"Provide a common exchange representation across systems\",\"Set backup frequencies\",\"Replace all source databases\",\"Approve access requests\"],\"answer\":0,\"rationale\":\"A canonical model reduces repeated pairwise mappings and supports interoperability.\",\"difficulty\":\"Mixed\"},{\"id\":23,\"chapter\":\"2. Data Architecture\",\"question\":\"Which choice most directly reduces point-to-point integration complexity?\",\"options\":[\"Separate codes in every application\",\"Duplicate databases for each report\",\"A governed integration layer with reusable services or events\",\"More manual file transfers\"],\"answer\":2,\"rationale\":\"Reusable integration patterns reduce coupling and uncontrolled interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":24,\"chapter\":\"2. Data Architecture\",\"question\":\"What should drive architecture decisions first?\",\"options\":[\"The oldest available technology\",\"Individual developer preference\",\"A preferred vendor logo\",\"Business capabilities, requirements, principles, and constraints\"],\"answer\":3,\"rationale\":\"Architecture exists to serve business outcomes within agreed principles and constraints.\",\"difficulty\":\"Mixed\"},{\"id\":25,\"chapter\":\"2. Data Architecture\",\"question\":\"Which is normally an architecture concern rather than a detailed physical-design concern?\",\"options\":[\"Defining enterprise data domains and distribution patterns\",\"Creating a specific index\",\"Choosing a column's exact storage length\",\"Writing a stored procedure\"],\"answer\":0,\"rationale\":\"Architecture addresses enterprise structure and patterns; physical design addresses implementation detail.\",\"difficulty\":\"Mixed\"},{\"id\":26,\"chapter\":\"2. Data Architecture\",\"question\":\"Why maintain current-state architecture?\",\"options\":[\"To replace all operational monitoring\",\"To eliminate governance\",\"To avoid defining a target state\",\"To understand dependencies, risks, duplication, and migration needs\"],\"answer\":3,\"rationale\":\"A credible roadmap requires understanding the existing landscape and constraints.\",\"difficulty\":\"Mixed\"},{\"id\":27,\"chapter\":\"2. Data Architecture\",\"question\":\"What is an architecture transition state?\",\"options\":[\"An unapproved glossary term\",\"A retired document\",\"An intermediate configuration between current and target states\",\"A failed database transaction\"],\"answer\":2,\"rationale\":\"Complex transformations often require planned intermediate states.\",\"difficulty\":\"Mixed\"},{\"id\":28,\"chapter\":\"2. Data Architecture\",\"question\":\"A new analytics platform duplicates customer definitions. Which review should identify this risk?\",\"options\":[\"Payroll approval\",\"Printer maintenance review\",\"Data architecture and governance review\",\"Office safety inspection\"],\"answer\":2,\"rationale\":\"Architecture review checks alignment, reuse, authoritative sources, and enterprise consistency.\",\"difficulty\":\"Mixed\"},{\"id\":29,\"chapter\":\"2. Data Architecture\",\"question\":\"What does technology independence mean in a logical architecture?\",\"options\":[\"The design expresses required capabilities without binding them to one product\",\"All technologies are identical\",\"Implementation details are fully specified\",\"No technology will ever be used\"],\"answer\":0,\"rationale\":\"Logical architecture focuses on capabilities and relationships before product-specific realization.\",\"difficulty\":\"Mixed\"},{\"id\":30,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the best measure of architecture effectiveness?\",\"options\":[\"Length of architecture documents\",\"Number of diagrams produced\",\"Degree to which solutions conform to principles and deliver intended business outcomes\",\"Number of vendors engaged\"],\"answer\":2,\"rationale\":\"Effectiveness is demonstrated by useful outcomes and consistent implementation, not artifact volume.\",\"difficulty\":\"Mixed\"},{\"id\":31,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Which model is best for discussing major business entities with executives?\",\"options\":[\"Database execution plan\",\"Conceptual data model\",\"Physical data model\",\"Index definition\"],\"answer\":1,\"rationale\":\"Conceptual models communicate high-level business concepts and relationships.\",\"difficulty\":\"Mixed\"},{\"id\":32,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What distinguishes a logical data model?\",\"options\":[\"It contains only dashboards\",\"It defines backup schedules\",\"It contains only server names\",\"It defines entities, attributes, relationships, and rules without product-specific implementation\"],\"answer\":3,\"rationale\":\"Logical models add structured detail while remaining technology independent.\",\"difficulty\":\"Mixed\"},{\"id\":33,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What does a physical data model add?\",\"options\":[\"Only data-owner names\",\"Only business vision statements\",\"Platform-specific tables, columns, data types, constraints, and indexes\",\"Only retention policies\"],\"answer\":2,\"rationale\":\"Physical models translate logical designs into implementable database structures.\",\"difficulty\":\"Mixed\"},{\"id\":34,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the purpose of a primary key?\",\"options\":[\"Schedule ETL jobs\",\"Uniquely identify each entity occurrence or row\",\"Encrypt sensitive attributes\",\"Define document ownership\"],\"answer\":1,\"rationale\":\"A primary key provides stable uniqueness within a relation.\",\"difficulty\":\"Mixed\"},{\"id\":35,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the purpose of a foreign key?\",\"options\":[\"Maintain a reference to a key in a related table\",\"Generate reports automatically\",\"Classify security levels\",\"Store unstructured content\"],\"answer\":0,\"rationale\":\"Foreign keys implement relationships and support referential integrity.\",\"difficulty\":\"Mixed\"},{\"id\":36,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"How is a many-to-many relationship normally resolved in a relational model?\",\"options\":[\"Remove all keys\",\"Delete one entity\",\"Duplicate every row\",\"Introduce an associative entity or junction table\"],\"answer\":3,\"rationale\":\"The associative entity represents each valid pairing and may hold relationship attributes.\",\"difficulty\":\"Mixed\"},{\"id\":37,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What does cardinality describe?\",\"options\":[\"The number of backups\",\"The age of a database\",\"The sensitivity of a field\",\"The permitted number of occurrences in a relationship\"],\"answer\":3,\"rationale\":\"Cardinality defines one-to-one, one-to-many, many-to-many, and optionality constraints.\",\"difficulty\":\"Mixed\"},{\"id\":38,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the main objective of normalization?\",\"options\":[\"Eliminate all relationships\",\"Reduce redundancy and avoid update anomalies\",\"Replace business rules\",\"Increase duplicate storage\"],\"answer\":1,\"rationale\":\"Normalization separates dependencies to improve consistency and maintainability.\",\"difficulty\":\"Mixed\"},{\"id\":39,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"A table contains Order1, Order2, and Order3 repeating columns. Which principle is violated?\",\"options\":[\"Encryption at rest\",\"First Normal Form\",\"Data lineage\",\"Least privilege\"],\"answer\":1,\"rationale\":\"Repeating groups prevent each field from holding a single atomic value.\",\"difficulty\":\"Mixed\"},{\"id\":40,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Why might an analytical model be deliberately denormalized?\",\"options\":[\"To avoid defining metrics\",\"To simplify queries and improve analytical performance\",\"To remove all dimensions\",\"To prevent historical analysis\"],\"answer\":1,\"rationale\":\"Denormalization can be appropriate when controlled redundancy improves analytical usability.\",\"difficulty\":\"Mixed\"},{\"id\":41,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is a supertype\/subtype structure used for?\",\"options\":[\"Measure data quality\",\"Schedule backups\",\"Define API throttling\",\"Model common attributes and specialized entity variations\"],\"answer\":3,\"rationale\":\"Supertypes capture commonality; subtypes capture specialized characteristics.\",\"difficulty\":\"Mixed\"},{\"id\":42,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is a natural key?\",\"options\":[\"A password hash\",\"A database file name\",\"A randomly generated technical identifier only\",\"A meaningful business attribute or combination that uniquely identifies an entity\"],\"answer\":3,\"rationale\":\"Natural keys derive from business meaning, such as a recognized registration code.\",\"difficulty\":\"Mixed\"},{\"id\":43,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Why use a surrogate key in a warehouse dimension?\",\"options\":[\"Provide a stable technical identifier independent of changing source keys\",\"Store documents\",\"Replace dimension attributes\",\"Eliminate all source mappings\"],\"answer\":0,\"rationale\":\"Surrogate keys support history and integration across changing or multiple source identifiers.\",\"difficulty\":\"Mixed\"},{\"id\":44,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What should happen when a model conflicts with an approved business definition?\",\"options\":[\"Let each developer choose\",\"Reconcile the model with governance and the accountable business owner\",\"Delete the model\",\"Ignore the glossary\"],\"answer\":1,\"rationale\":\"Models should faithfully represent governed business meaning.\",\"difficulty\":\"Mixed\"},{\"id\":45,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Which artifact maps a logical attribute to its physical column?\",\"options\":[\"A model mapping or transformation specification\",\"A firewall rule\",\"A retention schedule\",\"A meeting agenda\"],\"answer\":0,\"rationale\":\"Mapping documentation connects logical meaning to implementation and supports traceability.\",\"difficulty\":\"Mixed\"},{\"id\":46,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is the chief objective of data storage and operations?\",\"options\":[\"Assign data owners\",\"Maintain accessible, reliable, recoverable, and performant data platforms\",\"Design corporate logos\",\"Approve business definitions\"],\"answer\":1,\"rationale\":\"Operations manages the day-to-day technical environment and service continuity.\",\"difficulty\":\"Mixed\"},{\"id\":47,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What does Recovery Time Objective measure?\",\"options\":[\"Maximum acceptable data loss\",\"Retention duration\",\"Maximum targeted time to restore a service after disruption\",\"Average query size\"],\"answer\":2,\"rationale\":\"RTO concerns elapsed recovery time.\",\"difficulty\":\"Mixed\"},{\"id\":48,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What does Recovery Point Objective measure?\",\"options\":[\"Time to rebuild a server\",\"Annual storage growth\",\"Number of recovery staff\",\"Maximum acceptable period of data loss measured backward from an incident\"],\"answer\":3,\"rationale\":\"RPO determines how current recovered data must be.\",\"difficulty\":\"Mixed\"},{\"id\":49,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Why are recovery tests necessary even when backups succeed?\",\"options\":[\"A successful backup does not prove that restoration will work within objectives\",\"Backups automatically test every application\",\"Testing replaces retention policies\",\"Testing removes cyber risk\"],\"answer\":0,\"rationale\":\"Recoverability must be demonstrated through restoration and service exercises.\",\"difficulty\":\"Mixed\"},{\"id\":50,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is capacity management?\",\"options\":[\"Managing customer consent\",\"Designing taxonomies\",\"Forecasting and providing sufficient storage and compute resources\",\"Approving data definitions\"],\"answer\":2,\"rationale\":\"Capacity management anticipates growth and workload demand.\",\"difficulty\":\"Mixed\"},{\"id\":51,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Which metric most directly reflects service availability?\",\"options\":[\"Count of conceptual entities\",\"Percentage of agreed service time that the platform is usable\",\"Number of glossary terms\",\"Number of data owners\"],\"answer\":1,\"rationale\":\"Availability measures usable service relative to its agreed operating window.\",\"difficulty\":\"Mixed\"},{\"id\":52,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is archiving?\",\"options\":[\"Deleting all old data immediately\",\"Creating a new business term\",\"Copying production data for testing without controls\",\"Moving inactive information to managed long-term storage while retaining required access\"],\"answer\":3,\"rationale\":\"Archiving separates inactive data while preserving retention, protection, and retrievability.\",\"difficulty\":\"Mixed\"},{\"id\":53,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is the main risk of retaining data indefinitely?\",\"options\":[\"Guaranteed better quality\",\"Reduced security requirements\",\"Increased cost, exposure, and regulatory or legal risk\",\"Automatic lineage\"],\"answer\":2,\"rationale\":\"Unnecessary retention expands the attack surface and compliance burden.\",\"difficulty\":\"Mixed\"},{\"id\":54,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"A critical batch fails nightly. What is the first operational need?\",\"options\":[\"Detect, log, alert, and initiate documented incident handling\",\"Change the Data Owner\",\"Create a new taxonomy\",\"Redesign the enterprise glossary\"],\"answer\":0,\"rationale\":\"Reliable operations require timely detection, evidence, escalation, and recovery.\",\"difficulty\":\"Mixed\"},{\"id\":55,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is configuration management used for?\",\"options\":[\"Approve records disposition\",\"Calculate business KPIs\",\"Control and trace approved changes to platform configurations\",\"Define customer segments\"],\"answer\":2,\"rationale\":\"Configuration control supports stable and auditable environments.\",\"difficulty\":\"Mixed\"},{\"id\":56,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Which practice best protects backup confidentiality?\",\"options\":[\"Use shared administrator accounts\",\"Remove backup logs\",\"Store all backups publicly\",\"Encrypt backups and restrict access according to classification\"],\"answer\":3,\"rationale\":\"Backup copies require protections equivalent to the source data.\",\"difficulty\":\"Mixed\"},{\"id\":57,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is a service-level agreement?\",\"options\":[\"A master-data match rule\",\"A documented commitment for measurable service performance\",\"A business glossary\",\"A conceptual data model\"],\"answer\":1,\"rationale\":\"SLAs specify measurable expectations such as availability, response, and recovery.\",\"difficulty\":\"Mixed\"},{\"id\":58,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Why separate production and non-production environments?\",\"options\":[\"Avoid documenting changes\",\"Permit unrestricted data copying\",\"Eliminate testing\",\"Reduce operational risk and limit inappropriate access to live data\"],\"answer\":3,\"rationale\":\"Environment separation protects production and supports controlled testing.\",\"difficulty\":\"Mixed\"},{\"id\":59,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is a database health check intended to detect?\",\"options\":[\"Employee training needs only\",\"Unapproved business vocabulary only\",\"Marketing opportunities\",\"Emerging performance, capacity, integrity, or availability risks\"],\"answer\":3,\"rationale\":\"Health checks proactively assess technical service conditions.\",\"difficulty\":\"Mixed\"},{\"id\":60,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Who generally implements database permissions after business approval?\",\"options\":[\"The Data Owner alone in the database\",\"The DBA or platform operations team\",\"Any end user\",\"The Governance Council directly\"],\"answer\":1,\"rationale\":\"Business owners approve; authorized technical administrators implement and log access.\",\"difficulty\":\"Mixed\"},{\"id\":61,\"chapter\":\"5. Data Security\",\"question\":\"What does confidentiality protect?\",\"options\":[\"Document version numbering\",\"Data from unauthorized disclosure\",\"Service uptime only\",\"Data from all changes\"],\"answer\":1,\"rationale\":\"Confidentiality limits information exposure to authorized parties.\",\"difficulty\":\"Mixed\"},{\"id\":62,\"chapter\":\"5. Data Security\",\"question\":\"What does integrity protect?\",\"options\":[\"Data from unauthorized or improper alteration\",\"Only storage cost\",\"Only file discoverability\",\"Only system availability\"],\"answer\":0,\"rationale\":\"Integrity preserves correctness and trustworthiness against improper change.\",\"difficulty\":\"Mixed\"},{\"id\":63,\"chapter\":\"5. Data Security\",\"question\":\"What does availability ensure?\",\"options\":[\"All data is public\",\"All records are permanent\",\"All databases use one vendor\",\"Authorized users can access data and services when required\"],\"answer\":3,\"rationale\":\"Availability concerns reliable, timely access for authorized use.\",\"difficulty\":\"Mixed\"},{\"id\":64,\"chapter\":\"5. Data Security\",\"question\":\"What is least privilege?\",\"options\":[\"Allowing permanent access by default\",\"Sharing service accounts\",\"Giving all managers administrator rights\",\"Granting only the minimum access needed for assigned duties\"],\"answer\":3,\"rationale\":\"Least privilege limits exposure and reduces the impact of misuse or compromise.\",\"difficulty\":\"Mixed\"},{\"id\":65,\"chapter\":\"5. Data Security\",\"question\":\"What is separation of duties?\",\"options\":[\"Giving one person end-to-end control\",\"Storing all data in separate tables\",\"Dividing conflicting responsibilities among different people or roles\",\"Removing approval steps\"],\"answer\":2,\"rationale\":\"Separation reduces fraud and error by preventing incompatible powers from residing in one role.\",\"difficulty\":\"Mixed\"},{\"id\":66,\"chapter\":\"5. Data Security\",\"question\":\"Why classify data?\",\"options\":[\"Replace metadata\",\"Apply protection based on sensitivity, value, and obligations\",\"Improve query joins\",\"Eliminate access reviews\"],\"answer\":1,\"rationale\":\"Classification connects business sensitivity to appropriate controls.\",\"difficulty\":\"Mixed\"},{\"id\":67,\"chapter\":\"5. Data Security\",\"question\":\"Which control protects data in transit?\",\"options\":[\"Encrypted communication such as approved TLS\",\"A taxonomy\",\"A conceptual model\",\"A database index\"],\"answer\":0,\"rationale\":\"Transport encryption protects data while crossing networks.\",\"difficulty\":\"Mixed\"},{\"id\":68,\"chapter\":\"5. Data Security\",\"question\":\"Which control most directly protects data at rest?\",\"options\":[\"A data-flow diagram\",\"A report filter\",\"A glossary definition\",\"Approved storage or database encryption\"],\"answer\":3,\"rationale\":\"At-rest encryption protects stored copies and media.\",\"difficulty\":\"Mixed\"},{\"id\":69,\"chapter\":\"5. Data Security\",\"question\":\"What is multi-factor authentication?\",\"options\":[\"Entering the same PIN twice\",\"Authentication using evidence from more than one factor category\",\"Using two passwords\",\"Approving two reports\"],\"answer\":1,\"rationale\":\"MFA combines distinct factors such as knowledge, possession, or inherence.\",\"difficulty\":\"Mixed\"},{\"id\":70,\"chapter\":\"5. Data Security\",\"question\":\"Why are privileged accounts monitored more closely?\",\"options\":[\"They are used only for reporting\",\"They always contain better data\",\"They can perform high-impact administrative actions\",\"They require no approval\"],\"answer\":2,\"rationale\":\"Elevated permissions create greater risk and require stronger oversight.\",\"difficulty\":\"Mixed\"},{\"id\":71,\"chapter\":\"5. Data Security\",\"question\":\"What is data masking used for?\",\"options\":[\"Create primary keys\",\"Hide or transform sensitive values while preserving permitted use\",\"Schedule backups\",\"Build taxonomies\"],\"answer\":1,\"rationale\":\"Masking reduces exposure in displays, testing, or analytics.\",\"difficulty\":\"Mixed\"},{\"id\":72,\"chapter\":\"5. Data Security\",\"question\":\"A former employee retains access. Which control failed most directly?\",\"options\":[\"Timely identity deprovisioning\",\"Dimensional modeling\",\"Metadata harvesting\",\"Data profiling\"],\"answer\":0,\"rationale\":\"Joiner-mover-leaver controls should promptly remove access after departure.\",\"difficulty\":\"Mixed\"},{\"id\":73,\"chapter\":\"5. Data Security\",\"question\":\"What is the purpose of security audit logging?\",\"options\":[\"Create evidence of access, changes, and significant events\",\"Improve normalization\",\"Define business terms\",\"Replace incident response\"],\"answer\":0,\"rationale\":\"Logs support monitoring, investigation, accountability, and compliance.\",\"difficulty\":\"Mixed\"},{\"id\":74,\"chapter\":\"5. Data Security\",\"question\":\"Who should decide the acceptable business use of sensitive data?\",\"options\":[\"A developer acting alone\",\"The software vendor\",\"The accountable business owner under governance, privacy, and security rules\",\"Any system administrator\"],\"answer\":2,\"rationale\":\"Use decisions require business accountability within applicable rules and risk controls.\",\"difficulty\":\"Mixed\"},{\"id\":75,\"chapter\":\"5. Data Security\",\"question\":\"What is defense in depth?\",\"options\":[\"Using multiple complementary security controls across layers\",\"Using only physical security\",\"Relying on one strong password\",\"Removing duplicate controls\"],\"answer\":0,\"rationale\":\"Layered controls reduce dependence on a single preventive mechanism.\",\"difficulty\":\"Mixed\"},{\"id\":76,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is the basic purpose of data integration?\",\"options\":[\"Replace data modeling\",\"Define document retention\",\"Move, combine, and synchronize data across sources and consumers\",\"Approve business budgets\"],\"answer\":2,\"rationale\":\"Integration enables coordinated data use across systems and processes.\",\"difficulty\":\"Mixed\"},{\"id\":77,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What does interoperability add beyond data movement?\",\"options\":[\"Shared ability to interpret and use exchanged information correctly\",\"Faster password resets\",\"Larger storage capacity\",\"More document versions\"],\"answer\":0,\"rationale\":\"Interoperability includes syntactic and semantic understanding.\",\"difficulty\":\"Mixed\"},{\"id\":78,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is a source-to-target mapping?\",\"options\":[\"A backup schedule\",\"A security classification list\",\"A specification linking source elements to target elements and transformations\",\"A RACI matrix\"],\"answer\":2,\"rationale\":\"Mappings make integration logic explicit and testable.\",\"difficulty\":\"Mixed\"},{\"id\":79,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What does ETL mean?\",\"options\":[\"Extract, Transform, Load\",\"Encrypt, Test, Log\",\"Evaluate, Transfer, Link\",\"Extract, Track, List\"],\"answer\":0,\"rationale\":\"ETL transforms data before loading it into the target.\",\"difficulty\":\"Mixed\"},{\"id\":80,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What distinguishes ELT?\",\"options\":[\"It eliminates quality controls\",\"It requires no extraction\",\"Data is loaded before target-platform transformations are applied\",\"It is always real time\"],\"answer\":2,\"rationale\":\"ELT uses target processing capabilities after initial loading.\",\"difficulty\":\"Mixed\"},{\"id\":81,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"When is an event-driven pattern appropriate?\",\"options\":[\"When consumers need timely notification of business state changes\",\"When systems must remain completely disconnected\",\"When no event can be defined\",\"When annual archiving is the only need\"],\"answer\":0,\"rationale\":\"Events support decoupled, near-real-time reactions to business changes.\",\"difficulty\":\"Mixed\"},{\"id\":82,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is the purpose of a dead-letter queue?\",\"options\":[\"Retain messages that cannot be processed for investigation or controlled retry\",\"Store master data permanently\",\"Replace monitoring\",\"Delete all failed messages silently\"],\"answer\":0,\"rationale\":\"Dead-letter handling prevents silent loss and supports remediation.\",\"difficulty\":\"Mixed\"},{\"id\":83,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is idempotency in integration?\",\"options\":[\"Mappings never change\",\"All messages are anonymous\",\"Every retry creates a new transaction\",\"Repeated processing of the same request has no additional unintended effect\"],\"answer\":3,\"rationale\":\"Idempotent design supports safe retry after uncertain outcomes.\",\"difficulty\":\"Mixed\"},{\"id\":84,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Why use correlation identifiers?\",\"options\":[\"Encrypt backups\",\"Create document taxonomies\",\"Trace one business transaction across services and logs\",\"Define retention periods\"],\"answer\":2,\"rationale\":\"Correlation IDs improve end-to-end observability and troubleshooting.\",\"difficulty\":\"Mixed\"},{\"id\":85,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is change data capture?\",\"options\":[\"Capturing screenshots of reports\",\"Archiving documents\",\"Changing all source keys\",\"Identifying and propagating data changes since a previous point\"],\"answer\":3,\"rationale\":\"CDC enables efficient incremental integration.\",\"difficulty\":\"Mixed\"},{\"id\":86,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What should happen to records that fail validation?\",\"options\":[\"Delete all source data\",\"Disable validation\",\"Quarantine or reject them with logged reasons and accountable remediation\",\"Load them silently\"],\"answer\":2,\"rationale\":\"Controlled exception handling prevents contamination and supports correction.\",\"difficulty\":\"Mixed\"},{\"id\":87,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Why is reconciliation performed?\",\"options\":[\"Define business ownership\",\"Confirm that expected records and values arrived accurately and completely\",\"Choose a database vendor\",\"Create a conceptual model\"],\"answer\":1,\"rationale\":\"Reconciliation detects loss, duplication, and transformation errors.\",\"difficulty\":\"Mixed\"},{\"id\":88,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is data virtualization?\",\"options\":[\"Providing governed access across sources without necessarily copying all data\",\"Replacing metadata\",\"Encrypting virtual machines\",\"Creating duplicate master records\"],\"answer\":0,\"rationale\":\"Virtualization presents integrated views while leaving data in underlying sources.\",\"difficulty\":\"Mixed\"},{\"id\":89,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is API versioning intended to manage?\",\"options\":[\"Database backup rotation\",\"Data-owner succession\",\"Controlled evolution of interfaces without unexpectedly breaking consumers\",\"Document disposal\"],\"answer\":2,\"rationale\":\"Versioning allows interfaces and consumers to evolve safely.\",\"difficulty\":\"Mixed\"},{\"id\":90,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Which artifact should connect integration requirements to the implemented flow?\",\"options\":[\"A standalone logo\",\"A printer inventory\",\"Traceability from requirement through design, mapping, tests, and monitoring\",\"An employee directory\"],\"answer\":2,\"rationale\":\"Traceability demonstrates that implemented integration satisfies approved requirements.\",\"difficulty\":\"Mixed\"},{\"id\":91,\"chapter\":\"7. Document and Content Management\",\"question\":\"What type of information is a primary focus of document and content management?\",\"options\":[\"Only database indexes\",\"Only relational keys\",\"Unstructured and semi-structured information such as documents, images, and media\",\"Only numerical measures\"],\"answer\":2,\"rationale\":\"DCM governs content that is not primarily managed as structured rows and columns.\",\"difficulty\":\"Mixed\"},{\"id\":92,\"chapter\":\"7. Document and Content Management\",\"question\":\"What makes a document a record?\",\"options\":[\"It has more than ten pages\",\"It is stored as PDF\",\"It contains a table\",\"It is retained as evidence of a business activity or obligation\"],\"answer\":3,\"rationale\":\"Record status depends on evidentiary and retention value, not file format.\",\"difficulty\":\"Mixed\"},{\"id\":93,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is version control intended to prevent?\",\"options\":[\"All document search\",\"Use of uncontrolled or obsolete document revisions\",\"All collaboration\",\"All metadata capture\"],\"answer\":1,\"rationale\":\"Version control identifies approved revisions and preserves change history.\",\"difficulty\":\"Mixed\"},{\"id\":94,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a retention schedule?\",\"options\":[\"An ETL timetable\",\"A database execution plan\",\"An access-control matrix only\",\"Rules defining how long categories of records are kept and their final disposition\"],\"answer\":3,\"rationale\":\"Retention schedules link record classes to legal, regulatory, and business requirements.\",\"difficulty\":\"Mixed\"},{\"id\":95,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a legal hold?\",\"options\":[\"A password reset\",\"A suspension of normal disposition for information relevant to a legal matter\",\"A physical data model\",\"Automatic deletion of evidence\"],\"answer\":1,\"rationale\":\"A hold preserves potentially relevant information until released.\",\"difficulty\":\"Mixed\"},{\"id\":96,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a taxonomy?\",\"options\":[\"A database transaction\",\"A data-quality score\",\"A backup-copy type\",\"A hierarchical classification structure for organizing concepts or content\"],\"answer\":3,\"rationale\":\"Taxonomies use broader and narrower category relationships.\",\"difficulty\":\"Mixed\"},{\"id\":97,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is faceted classification?\",\"options\":[\"Encrypting each document twice\",\"Creating one category per file\",\"Classifying content using several independent metadata dimensions\",\"Using only one folder tree\"],\"answer\":2,\"rationale\":\"Facets allow filtering by dimensions such as type, department, product, and status.\",\"difficulty\":\"Mixed\"},{\"id\":98,\"chapter\":\"7. Document and Content Management\",\"question\":\"Which metadata most improves retrieval of a supplier contract?\",\"options\":[\"Supplier, document type, effective date, status, and owner\",\"CPU temperature\",\"Network hop count\",\"Database buffer size\"],\"answer\":0,\"rationale\":\"Descriptive and administrative metadata makes content discoverable and governable.\",\"difficulty\":\"Mixed\"},{\"id\":99,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is check-in\/check-out used for?\",\"options\":[\"Coordinate editing and prevent conflicting document changes\",\"Dispose of records\",\"Assign customer identifiers\",\"Design schemas\"],\"answer\":0,\"rationale\":\"The mechanism controls concurrent editing and preserves revision integrity.\",\"difficulty\":\"Mixed\"},{\"id\":100,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is records disposition?\",\"options\":[\"Renaming a file\",\"Adding a watermark\",\"Informal deletion by any user\",\"Authorized destruction or permanent transfer after retention requirements are met\"],\"answer\":3,\"rationale\":\"Disposition must be controlled, documented, and suspended when required.\",\"difficulty\":\"Mixed\"},{\"id\":101,\"chapter\":\"7. Document and Content Management\",\"question\":\"Why is full-text search alone insufficient?\",\"options\":[\"It always provides perfect results\",\"It may miss context, classification, ownership, and controlled meaning\",\"It replaces access controls\",\"It makes metadata illegal\"],\"answer\":1,\"rationale\":\"Good discovery combines content indexing with governed metadata.\",\"difficulty\":\"Mixed\"},{\"id\":102,\"chapter\":\"7. Document and Content Management\",\"question\":\"A production operator uses an obsolete work instruction. Which capability failed?\",\"options\":[\"Normalization\",\"Change data capture\",\"Controlled publication and version management\",\"Dimensional modeling\"],\"answer\":2,\"rationale\":\"Only the current approved instruction should be available for operational use.\",\"difficulty\":\"Mixed\"},{\"id\":103,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is the relationship between content management and security?\",\"options\":[\"Content access and handling must follow classification and authorization rules\",\"Public links are always acceptable\",\"Security applies only to databases\",\"Content never contains sensitive data\"],\"answer\":0,\"rationale\":\"Documents and media may contain sensitive information requiring equivalent protection.\",\"difficulty\":\"Mixed\"},{\"id\":104,\"chapter\":\"7. Document and Content Management\",\"question\":\"Why audit content access?\",\"options\":[\"Increase document length\",\"Replace retention schedules\",\"Provide evidence of viewing, editing, sharing, and disposition actions\",\"Eliminate classification\"],\"answer\":2,\"rationale\":\"Audit trails support accountability, investigations, and compliance.\",\"difficulty\":\"Mixed\"},{\"id\":105,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is the best governance approach to shared-drive sprawl?\",\"options\":[\"Delete the entire drive immediately\",\"Inventory, classify, assign ownership, apply retention, and migrate or dispose systematically\",\"Allow anonymous public access\",\"Keep every file forever\"],\"answer\":1,\"rationale\":\"A risk-based information lifecycle approach avoids both uncontrolled retention and indiscriminate deletion.\",\"difficulty\":\"Mixed\"},{\"id\":106,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What does master data primarily represent?\",\"options\":[\"One-time business events only\",\"Technical logs only\",\"Core business entities shared across processes and systems\",\"Document versions only\"],\"answer\":2,\"rationale\":\"Master data describes persistent entities such as product, customer, supplier, and location.\",\"difficulty\":\"Mixed\"},{\"id\":107,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What does reference data primarily provide?\",\"options\":[\"Unstructured media\",\"Controlled values used to classify or constrain other data\",\"Complete transaction histories\",\"Database execution plans\"],\"answer\":1,\"rationale\":\"Reference data includes codes, statuses, units, and classifications.\",\"difficulty\":\"Mixed\"},{\"id\":108,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which is most likely master data?\",\"options\":[\"Supplier\",\"Invoice line\",\"Login event\",\"Purchase order\"],\"answer\":0,\"rationale\":\"A supplier is a reusable core business entity.\",\"difficulty\":\"Mixed\"},{\"id\":109,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which is most likely reference data?\",\"options\":[\"Unit-of-measure code\",\"Customer account\",\"Payment transaction\",\"Production order\"],\"answer\":0,\"rationale\":\"Units of measure form a controlled list used by master and transactional data.\",\"difficulty\":\"Mixed\"},{\"id\":110,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is a golden record?\",\"options\":[\"A glossary definition\",\"A permanent backup of every transaction\",\"The trusted, consolidated representation of a master-data entity\",\"A security audit log\"],\"answer\":2,\"rationale\":\"The golden record represents the reconciled best view of an entity.\",\"difficulty\":\"Mixed\"},{\"id\":111,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is entity resolution?\",\"options\":[\"Creating database indexes\",\"Determining which records refer to the same real-world entity\",\"Classifying documents\",\"Deleting every similar record\"],\"answer\":1,\"rationale\":\"Entity resolution uses matching evidence to identify duplicates and relationships.\",\"difficulty\":\"Mixed\"},{\"id\":112,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is survivorship in MDM?\",\"options\":[\"Deleting reference values\",\"Rules selecting trusted attribute values when sources conflict\",\"Keeping only the oldest database\",\"Choosing the cheapest vendor\"],\"answer\":1,\"rationale\":\"Survivorship determines which source or value wins for each attribute.\",\"difficulty\":\"Mixed\"},{\"id\":113,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which MDM style maintains cross-references while source systems continue to own records?\",\"options\":[\"Registry style\",\"Document archive\",\"Star schema\",\"Transactional hub only\"],\"answer\":0,\"rationale\":\"Registry MDM links identities across sources without necessarily centralizing all attributes.\",\"difficulty\":\"Mixed\"},{\"id\":114,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which MDM style creates a central hub that authors and distributes master records?\",\"options\":[\"Document versioning\",\"Transactional or centralized authoring style\",\"Registry-only style\",\"Unmanaged replication\"],\"answer\":1,\"rationale\":\"A transactional hub acts as a central system for master-data creation and maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":115,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Why assign a master-data owner?\",\"options\":[\"Establish accountability for definitions, rules, quality, and access decisions\",\"Remove stewardship\",\"Avoid governance reviews\",\"Give one person all database passwords\"],\"answer\":0,\"rationale\":\"Ownership provides accountable business decision authority.\",\"difficulty\":\"Mixed\"},{\"id\":116,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is reference-data mapping?\",\"options\":[\"Defining backup media\",\"Relating code sets or values used by different systems\",\"Mapping office locations\",\"Creating document folders\"],\"answer\":1,\"rationale\":\"Mappings translate equivalent or related codes across sources and standards.\",\"difficulty\":\"Mixed\"},{\"id\":117,\"chapter\":\"8. Reference and Master Data\",\"question\":\"A system uses KG and another uses KGM. What is the principal requirement?\",\"options\":[\"A longer retention period\",\"Governed unit-code mapping and semantic equivalence\",\"More duplicate product records\",\"Removal of all units\"],\"answer\":1,\"rationale\":\"Interoperability requires controlled meanings and mappings for reference values.\",\"difficulty\":\"Mixed\"},{\"id\":118,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Why measure duplicate rate in customer master data?\",\"options\":[\"It indicates uniqueness problems and possible fragmented customer views\",\"It measures system uptime\",\"It defines document taxonomy\",\"It proves encryption strength\"],\"answer\":0,\"rationale\":\"Duplicate rate is a core MDM quality indicator.\",\"difficulty\":\"Mixed\"},{\"id\":119,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is hierarchy management in MDM?\",\"options\":[\"Managing governed parent-child and grouping relationships among master entities\",\"Encrypting messages\",\"Managing file folders only\",\"Scheduling ETL jobs\"],\"answer\":0,\"rationale\":\"Examples include product categories, organizational structures, and customer households or groups.\",\"difficulty\":\"Mixed\"},{\"id\":120,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What should happen before merging suspected duplicate suppliers?\",\"options\":[\"Merge every similar name automatically\",\"Apply matching evidence, stewardship review, and approved merge rules\",\"Ask the DBA to guess\",\"Delete both records\"],\"answer\":1,\"rationale\":\"Merges affect identity and downstream processes, so they require controlled evidence and oversight.\",\"difficulty\":\"Mixed\"},{\"id\":121,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is the primary purpose of a data warehouse?\",\"options\":[\"Provide integrated historical data for analysis and decision support\",\"Store only document images\",\"Manage user passwords\",\"Process every operational transaction\"],\"answer\":0,\"rationale\":\"Warehouses support analytical workloads across subject areas and time.\",\"difficulty\":\"Mixed\"},{\"id\":122,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does subject-oriented mean in a warehouse?\",\"options\":[\"Data is organized by server brand\",\"Every table belongs to one user\",\"Data is stored without business context\",\"Data is organized around major business subjects such as customer or sales\"],\"answer\":3,\"rationale\":\"Subject orientation aligns analytical data with business areas.\",\"difficulty\":\"Mixed\"},{\"id\":123,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does time-variant mean?\",\"options\":[\"Only current data is retained\",\"Historical states are retained and associated with time\",\"Time zones are ignored\",\"The database clock changes often\"],\"answer\":1,\"rationale\":\"Warehouses support analysis across periods by retaining history.\",\"difficulty\":\"Mixed\"},{\"id\":124,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does non-volatile mean in the classic warehouse definition?\",\"options\":[\"All data is immutable forever\",\"Data can never be corrected\",\"Warehouse data is mainly loaded and read rather than used for operational updates\",\"The system needs no backup\"],\"answer\":2,\"rationale\":\"Analytical repositories are optimized for stable historical use rather than transaction processing.\",\"difficulty\":\"Mixed\"},{\"id\":125,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a fact table?\",\"options\":[\"A table holding measurements at a declared business-process grain\",\"A list of user roles\",\"A document library\",\"A table of glossary definitions\"],\"answer\":0,\"rationale\":\"Facts capture measurable events such as sales quantity or production cost.\",\"difficulty\":\"Mixed\"},{\"id\":126,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a dimension table?\",\"options\":[\"A table containing only error logs\",\"A backup catalog\",\"A security policy\",\"A table providing descriptive context for facts\"],\"answer\":3,\"rationale\":\"Dimensions support slicing facts by product, customer, location, time, and other context.\",\"difficulty\":\"Mixed\"},{\"id\":127,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"Why must the grain of a fact table be declared?\",\"options\":[\"It determines password length\",\"It replaces data quality rules\",\"It defines exactly what one fact row represents\",\"It selects the BI tool\"],\"answer\":2,\"rationale\":\"Clear grain prevents mixing incompatible levels of detail.\",\"difficulty\":\"Mixed\"},{\"id\":128,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a conformed dimension?\",\"options\":[\"An encrypted fact table\",\"A deleted dimension\",\"A dimension used by one report only\",\"A consistently defined dimension shared across analytical processes\"],\"answer\":3,\"rationale\":\"Conformed dimensions enable comparable analysis across marts.\",\"difficulty\":\"Mixed\"},{\"id\":129,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a slowly changing dimension?\",\"options\":[\"A method for managing changes to descriptive dimension attributes over time\",\"A slow ETL job\",\"An archived report\",\"A rarely used fact\"],\"answer\":0,\"rationale\":\"SCD techniques determine whether history is overwritten, retained, or versioned.\",\"difficulty\":\"Mixed\"},{\"id\":130,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What characterizes a star schema?\",\"options\":[\"A central fact table connected to denormalized dimensions\",\"A network topology\",\"Only normalized operational tables\",\"Documents arranged in folders\"],\"answer\":0,\"rationale\":\"Star schemas simplify business analysis and query navigation.\",\"difficulty\":\"Mixed\"},{\"id\":131,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a data mart?\",\"options\":[\"A backup device\",\"A metadata-only repository\",\"An analytical subset focused on a subject, process, or business community\",\"A transactional ERP module\"],\"answer\":2,\"rationale\":\"Data marts deliver focused analytical content under an enterprise integration approach.\",\"difficulty\":\"Mixed\"},{\"id\":132,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"How does Kimball's approach generally begin?\",\"options\":[\"Use only unstructured data\",\"Build one normalized enterprise warehouse before any delivery\",\"Avoid facts and dimensions\",\"Build dimensional solutions by business process using conformed dimensions\"],\"answer\":3,\"rationale\":\"Kimball emphasizes incremental dimensional delivery integrated through conformance.\",\"difficulty\":\"Mixed\"},{\"id\":133,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"How does Inmon's classic approach generally position the enterprise warehouse?\",\"options\":[\"As a document taxonomy\",\"As an API gateway\",\"As a collection of unrelated spreadsheets\",\"As an integrated enterprise repository feeding downstream analytical use\"],\"answer\":3,\"rationale\":\"Inmon emphasizes a centralized integrated enterprise warehouse.\",\"difficulty\":\"Mixed\"},{\"id\":134,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"Why govern KPI definitions?\",\"options\":[\"Avoid documenting formulas\",\"Increase dashboard color choices\",\"Eliminate measurement ownership\",\"Ensure reports calculate and interpret measures consistently\"],\"answer\":3,\"rationale\":\"Governed definitions reduce conflicting results and improve trust.\",\"difficulty\":\"Mixed\"},{\"id\":135,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is self-service BI's main governance challenge?\",\"options\":[\"Prevent all business users from analyzing data\",\"Make every dataset public\",\"Replace the warehouse with email\",\"Enable user autonomy without losing definition, quality, security, and lineage controls\"],\"answer\":3,\"rationale\":\"Successful self-service balances agility with trustworthy governed data.\",\"difficulty\":\"Mixed\"},{\"id\":136,\"chapter\":\"10. Metadata Management\",\"question\":\"What is metadata?\",\"options\":[\"Only master-data values\",\"Only transactional records\",\"Only database backups\",\"Information that describes, explains, locates, or governs data and content\"],\"answer\":3,\"rationale\":\"Metadata supplies context needed to understand and manage information assets.\",\"difficulty\":\"Mixed\"},{\"id\":137,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is business metadata?\",\"options\":[\"An ETL execution duration\",\"The approved definition and owner of 'Net Revenue'\",\"A server IP address\",\"A column data type\"],\"answer\":1,\"rationale\":\"Business metadata captures meaning, rules, ownership, and business context.\",\"difficulty\":\"Mixed\"},{\"id\":138,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is technical metadata?\",\"options\":[\"A policy exception rationale\",\"A retention justification\",\"A KPI owner only\",\"Table, column, data type, and constraint definitions\"],\"answer\":3,\"rationale\":\"Technical metadata describes implemented structures and interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":139,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is operational metadata?\",\"options\":[\"Pipeline run time, row count, status, and error details\",\"A product taxonomy\",\"A conceptual entity\",\"The definition of Customer\"],\"answer\":0,\"rationale\":\"Operational metadata explains processing behavior and outcomes.\",\"difficulty\":\"Mixed\"},{\"id\":140,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a business glossary?\",\"options\":[\"A governed collection of business terms, definitions, and related attributes\",\"A set of source-code comments\",\"A file-system directory\",\"A database backup list\"],\"answer\":0,\"rationale\":\"A glossary establishes shared business meaning.\",\"difficulty\":\"Mixed\"},{\"id\":141,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a data catalog?\",\"options\":[\"A transaction-processing system\",\"A physical backup vault\",\"A searchable inventory of data assets enriched with metadata\",\"A document scanner\"],\"answer\":2,\"rationale\":\"Catalogs support discovery, understanding, evaluation, and governed access.\",\"difficulty\":\"Mixed\"},{\"id\":142,\"chapter\":\"10. Metadata Management\",\"question\":\"What does data lineage describe?\",\"options\":[\"Only retention periods\",\"Only reporting hierarchies\",\"Only entity ownership\",\"Origins, movements, transformations, and uses of data\"],\"answer\":3,\"rationale\":\"Lineage connects source data through processing to downstream consumption.\",\"difficulty\":\"Mixed\"},{\"id\":143,\"chapter\":\"10. Metadata Management\",\"question\":\"What is business lineage?\",\"options\":[\"A business-oriented view of how information supports processes and outcomes\",\"A network route\",\"A list of database pages\",\"A password history\"],\"answer\":0,\"rationale\":\"Business lineage expresses flow and impact in terms meaningful to stakeholders.\",\"difficulty\":\"Mixed\"},{\"id\":144,\"chapter\":\"10. Metadata Management\",\"question\":\"What is technical lineage?\",\"options\":[\"Detailed field, table, job, and transformation dependencies\",\"A taxonomy of documents\",\"A list of business sponsors only\",\"A records schedule\"],\"answer\":0,\"rationale\":\"Technical lineage supports troubleshooting, impact analysis, and controls.\",\"difficulty\":\"Mixed\"},{\"id\":145,\"chapter\":\"10. Metadata Management\",\"question\":\"What is metadata harvesting?\",\"options\":[\"Encryption of every column\",\"Automated extraction of metadata from technical sources\",\"Manual deletion of old reports\",\"Creation of transaction data\"],\"answer\":1,\"rationale\":\"Harvesting scanners collect schemas, relationships, jobs, and other technical metadata.\",\"difficulty\":\"Mixed\"},{\"id\":146,\"chapter\":\"10. Metadata Management\",\"question\":\"Why is metadata stewardship needed?\",\"options\":[\"Ensure definitions and metadata remain accurate, complete, approved, and current\",\"Replace all technical administrators\",\"Operate network devices\",\"Approve company travel\"],\"answer\":0,\"rationale\":\"Metadata degrades without accountable maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":147,\"chapter\":\"10. Metadata Management\",\"question\":\"What is an impact analysis?\",\"options\":[\"A survey of office furniture\",\"Assessment of downstream assets affected by a proposed change\",\"A storage invoice calculation\",\"A backup rotation\"],\"answer\":1,\"rationale\":\"Metadata dependencies help teams identify consumers and risks before change.\",\"difficulty\":\"Mixed\"},{\"id\":148,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a controlled vocabulary?\",\"options\":[\"A database transaction log\",\"An approved set of terms used consistently for description or classification\",\"Every word used by employees\",\"A list of passwords\"],\"answer\":1,\"rationale\":\"Controlled vocabularies reduce ambiguity and improve retrieval and interoperability.\",\"difficulty\":\"Mixed\"},{\"id\":149,\"chapter\":\"10. Metadata Management\",\"question\":\"A catalog shows a data set but no owner, definition, or lineage. What is the main issue?\",\"options\":[\"The catalog replaces governance\",\"The data set is automatically high quality\",\"The data set must be deleted\",\"The catalog entry is discoverable but insufficiently trustworthy and actionable\"],\"answer\":3,\"rationale\":\"Useful catalog entries need meaningful context, accountability, and traceability.\",\"difficulty\":\"Mixed\"},{\"id\":150,\"chapter\":\"10. Metadata Management\",\"question\":\"Why is metadata called a cross-cutting capability?\",\"options\":[\"It applies only to databases\",\"It eliminates the need for other disciplines\",\"It supports governance, quality, security, integration, analytics, and operations\",\"It is independent of business meaning\"],\"answer\":2,\"rationale\":\"Metadata connects and informs nearly all data-management practices.\",\"difficulty\":\"Mixed\"},{\"id\":151,\"chapter\":\"11. Data Quality\",\"question\":\"What is the most useful general definition of data quality?\",\"options\":[\"The degree to which data is fit for its intended use\",\"The speed of database processing\",\"The volume of data under management\",\"The absence of every possible defect\"],\"answer\":0,\"rationale\":\"Quality is contextual: data must satisfy agreed business and user requirements.\",\"difficulty\":\"Easy\"},{\"id\":152,\"chapter\":\"11. Data Quality\",\"question\":\"Which dimension asks whether data correctly represents the real-world object or event?\",\"options\":[\"Completeness\",\"Accuracy\",\"Availability\",\"Uniqueness\"],\"answer\":1,\"rationale\":\"Accuracy compares recorded data with reality or an authoritative source.\",\"difficulty\":\"Easy\"},{\"id\":153,\"chapter\":\"11. Data Quality\",\"question\":\"A supplier record has no tax identifier even though it is mandatory. Which dimension is affected?\",\"options\":[\"Consistency\",\"Uniqueness\",\"Completeness\",\"Timeliness\"],\"answer\":2,\"rationale\":\"Completeness measures whether required values are present.\",\"difficulty\":\"Easy\"},{\"id\":154,\"chapter\":\"11. Data Quality\",\"question\":\"CRM classifies a customer as Active while ERP classifies the same customer as Inactive. What is the primary issue?\",\"options\":[\"Accessibility\",\"Consistency\",\"Uniqueness\",\"Precision\"],\"answer\":1,\"rationale\":\"Consistency concerns agreement across representations, data stores, or rules.\",\"difficulty\":\"Easy\"},{\"id\":155,\"chapter\":\"11. Data Quality\",\"question\":\"A country field contains XX99 although only ISO country codes are allowed. Which dimension fails?\",\"options\":[\"Timeliness\",\"Accuracy\",\"Validity\",\"Completeness\"],\"answer\":2,\"rationale\":\"Validity checks conformance with permitted formats, domains, and rules.\",\"difficulty\":\"Easy\"},{\"id\":156,\"chapter\":\"11. Data Quality\",\"question\":\"The same legal supplier appears in four records. Which dimension is primarily affected?\",\"options\":[\"Completeness\",\"Timeliness\",\"Uniqueness\",\"Accuracy\"],\"answer\":2,\"rationale\":\"Uniqueness concerns inappropriate duplicate representation of the same entity.\",\"difficulty\":\"Easy\"},{\"id\":157,\"chapter\":\"11. Data Quality\",\"question\":\"An order references a customer identifier that does not exist. Which quality concern is most direct?\",\"options\":[\"Precision\",\"Referential integrity\",\"Timeliness\",\"Formatting\"],\"answer\":1,\"rationale\":\"Referential integrity requires referenced parent records to exist.\",\"difficulty\":\"Easy\"},{\"id\":158,\"chapter\":\"11. Data Quality\",\"question\":\"A production reading arrives after the decision window has closed. Which dimension is affected?\",\"options\":[\"Validity\",\"Completeness\",\"Timeliness\",\"Uniqueness\"],\"answer\":2,\"rationale\":\"Timeliness considers whether data is sufficiently current and available when required.\",\"difficulty\":\"Easy\"},{\"id\":159,\"chapter\":\"11. Data Quality\",\"question\":\"Who is normally accountable for accepting quality thresholds for a business data domain?\",\"options\":[\"The database vendor\",\"Any report developer\",\"The network administrator\",\"The Data Owner\"],\"answer\":3,\"rationale\":\"The Data Owner is accountable for business requirements and acceptable quality.\",\"difficulty\":\"Easy\"},{\"id\":160,\"chapter\":\"11. Data Quality\",\"question\":\"What is a Critical Data Element?\",\"options\":[\"A data element prioritized because of business value, risk, or obligation\",\"Every column in every database\",\"Any value containing a number\",\"Only data used by executives\"],\"answer\":0,\"rationale\":\"CDEs focus quality investment on data that matters most.\",\"difficulty\":\"Easy\"},{\"id\":161,\"chapter\":\"11. Data Quality\",\"question\":\"What is data profiling?\",\"options\":[\"Encryption of sensitive columns\",\"Systematic analysis of data values, patterns, structures, and anomalies\",\"Manual approval of every record\",\"Design of a conceptual data model\"],\"answer\":1,\"rationale\":\"Profiling establishes empirical facts about data condition and structure.\",\"difficulty\":\"Easy\"},{\"id\":162,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a preventive data-quality control?\",\"options\":[\"A steward correcting an invalid record\",\"A post-incident root-cause review\",\"A mandatory-field validation at data entry\",\"A monthly duplicate report\"],\"answer\":2,\"rationale\":\"Preventive controls stop or reduce defects before acceptance.\",\"difficulty\":\"Easy\"},{\"id\":163,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a detective data-quality control?\",\"options\":[\"A steward merging duplicates\",\"A schema design standard\",\"A drop-down list of permitted codes\",\"A dashboard showing invalid product codes\"],\"answer\":3,\"rationale\":\"Detective controls reveal defects that already exist or have entered a process.\",\"difficulty\":\"Easy\"},{\"id\":164,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a corrective data-quality control?\",\"options\":[\"A reconciliation report identifies differences\",\"A steward repairs incorrect supplier classifications\",\"An input mask blocks bad formats\",\"A policy defines ownership\"],\"answer\":1,\"rationale\":\"Corrective controls remediate identified defects.\",\"difficulty\":\"Easy\"},{\"id\":165,\"chapter\":\"11. Data Quality\",\"question\":\"Why is root-cause analysis important?\",\"options\":[\"It targets the process or control that creates recurring defects\",\"It guarantees perfect data\",\"It replaces quality measurement\",\"It eliminates the need for ownership\"],\"answer\":0,\"rationale\":\"Fixing causes is more sustainable than repeatedly correcting symptoms.\",\"difficulty\":\"Medium\"},{\"id\":166,\"chapter\":\"11. Data Quality\",\"question\":\"A team corrects customer addresses monthly, but input errors continue. What is the best next action?\",\"options\":[\"Archive all customer records\",\"Increase the cleansing frequency only\",\"Identify and fix the faulty capture process and validation controls\",\"Stop measuring address quality\"],\"answer\":2,\"rationale\":\"Recurring correction without process improvement treats the symptom.\",\"difficulty\":\"Medium\"},{\"id\":167,\"chapter\":\"11. Data Quality\",\"question\":\"Which formula measures completeness for a mandatory field?\",\"options\":[\"Corrected records divided by data owners\",\"Duplicate records divided by all systems\",\"Available hours divided by total storage\",\"Populated valid records divided by applicable records\"],\"answer\":3,\"rationale\":\"Completeness is typically measured against the population for which the value is required.\",\"difficulty\":\"Medium\"},{\"id\":168,\"chapter\":\"11. Data Quality\",\"question\":\"A threshold states that at least 98% of active products must have a category. What does 98% represent?\",\"options\":[\"The data lineage depth\",\"The accepted quality target\",\"The recovery objective\",\"The retention period\"],\"answer\":1,\"rationale\":\"A threshold defines the minimum acceptable performance for a rule or dimension.\",\"difficulty\":\"Easy\"},{\"id\":169,\"chapter\":\"11. Data Quality\",\"question\":\"Why should a quality rule include its applicable population?\",\"options\":[\"It removes the need for thresholds\",\"It makes the database larger\",\"The rule may apply only to specific records or business conditions\",\"It guarantees statistical significance\"],\"answer\":2,\"rationale\":\"Scope prevents misleading measurement over irrelevant records.\",\"difficulty\":\"Medium\"},{\"id\":170,\"chapter\":\"11. Data Quality\",\"question\":\"Which sequence best reflects a sound quality-improvement cycle?\",\"options\":[\"Buy a tool, then define the problem\",\"Archive data, then assign ownership\",\"Define requirements, profile, measure, analyze causes, remediate, monitor\",\"Cleanse, ignore causes, stop measuring\"],\"answer\":2,\"rationale\":\"Effective improvement begins with requirements and continues through measurement and control.\",\"difficulty\":\"Medium\"},{\"id\":171,\"chapter\":\"11. Data Quality\",\"question\":\"What is the best evidence that a quality rule is operationalized?\",\"options\":[\"It has a complicated name\",\"It has an owner, implementation, threshold, monitoring, and issue workflow\",\"It appears in an old presentation\",\"It is known by one developer\"],\"answer\":1,\"rationale\":\"Operational rules are accountable, executable, measurable, and acted upon.\",\"difficulty\":\"Medium\"},{\"id\":172,\"chapter\":\"11. Data Quality\",\"question\":\"What is data-quality issue management?\",\"options\":[\"A process for deleting all failing records\",\"A controlled process to log, prioritize, assign, remediate, and close defects\",\"A method for designing APIs\",\"A substitute for data governance\"],\"answer\":1,\"rationale\":\"Issue management creates traceability and accountability for quality defects.\",\"difficulty\":\"Easy\"},{\"id\":173,\"chapter\":\"11. Data Quality\",\"question\":\"How should quality issues normally be prioritized?\",\"options\":[\"By alphabetical order\",\"By the number of screenshots\",\"By business impact, risk, urgency, and affected critical data\",\"By the age of the database\"],\"answer\":2,\"rationale\":\"Prioritization should align scarce remediation effort with business consequences.\",\"difficulty\":\"Medium\"},{\"id\":174,\"chapter\":\"11. Data Quality\",\"question\":\"A report shows 99% accuracy but the validation sample is undocumented. What is the concern?\",\"options\":[\"The report should contain no metadata\",\"The score must automatically be 100%\",\"Accuracy can never be sampled\",\"The metric may not be reproducible or credible\"],\"answer\":3,\"rationale\":\"Quality measures need transparent method, population, source, and evidence.\",\"difficulty\":\"Hard\"},{\"id\":175,\"chapter\":\"11. Data Quality\",\"question\":\"What is reconciliation used to assess?\",\"options\":[\"Whether passwords meet length rules\",\"Whether records are old enough to archive\",\"Whether expected records and values agree across stages or systems\",\"Whether taxonomies are hierarchical\"],\"answer\":2,\"rationale\":\"Reconciliation detects loss, duplication, and transformation differences.\",\"difficulty\":\"Medium\"},{\"id\":176,\"chapter\":\"11. Data Quality\",\"question\":\"Which quality dimension is most directly tested by a permitted-values list?\",\"options\":[\"Validity\",\"Uniqueness\",\"Timeliness\",\"Accuracy\"],\"answer\":0,\"rationale\":\"Permitted-values controls test conformance with a defined domain.\",\"difficulty\":\"Easy\"},{\"id\":177,\"chapter\":\"11. Data Quality\",\"question\":\"Why can valid data still be inaccurate?\",\"options\":[\"Accurate values never require formats\",\"A value can follow the permitted format but not reflect reality\",\"Validity and accuracy are identical\",\"Accuracy applies only to master data\"],\"answer\":1,\"rationale\":\"For example, a well-formed date can still be the wrong date.\",\"difficulty\":\"Medium\"},{\"id\":178,\"chapter\":\"11. Data Quality\",\"question\":\"Why can complete data still be poor quality?\",\"options\":[\"All fields may be populated with inaccurate, invalid, or inconsistent values\",\"Completeness proves every dimension\",\"Only null values create defects\",\"Complete data needs no governance\"],\"answer\":0,\"rationale\":\"Quality is multidimensional; presence alone does not establish fitness.\",\"difficulty\":\"Medium\"},{\"id\":179,\"chapter\":\"11. Data Quality\",\"question\":\"What is a quality scorecard?\",\"options\":[\"A physical model\",\"A document-retention schedule\",\"A structured view of measures, thresholds, trends, owners, and status\",\"A list of database passwords\"],\"answer\":2,\"rationale\":\"Scorecards communicate performance and accountability.\",\"difficulty\":\"Easy\"},{\"id\":180,\"chapter\":\"11. Data Quality\",\"question\":\"Which trend most strongly signals a weakening preventive control?\",\"options\":[\"The number of glossary terms increases\",\"Backups complete successfully\",\"New defects continue rising despite repeated cleansing\",\"Storage capacity remains stable\"],\"answer\":2,\"rationale\":\"Rising new defects indicate that creation processes are not being controlled.\",\"difficulty\":\"Hard\"},{\"id\":181,\"chapter\":\"11. Data Quality\",\"question\":\"A quality rule fails because an approved reference-code list changed. What control is missing?\",\"options\":[\"Change coordination between reference data and dependent validations\",\"Additional document scanning\",\"A new conceptual entity\",\"Longer backup retention\"],\"answer\":0,\"rationale\":\"Dependent rules must be updated when governed reference values change.\",\"difficulty\":\"Hard\"},{\"id\":182,\"chapter\":\"11. Data Quality\",\"question\":\"What is the relationship between metadata and data quality?\",\"options\":[\"Metadata supplies definitions, domains, rules, lineage, and ownership needed for quality control\",\"They are unrelated\",\"Metadata guarantees accuracy automatically\",\"Metadata replaces profiling\"],\"answer\":0,\"rationale\":\"Quality is difficult to define or investigate without contextual metadata.\",\"difficulty\":\"Medium\"},{\"id\":183,\"chapter\":\"11. Data Quality\",\"question\":\"How does lineage support quality management?\",\"options\":[\"It removes duplicate records automatically\",\"It defines recovery time\",\"It helps locate defect origins and identify affected downstream assets\",\"It encrypts bad data\"],\"answer\":2,\"rationale\":\"Lineage enables root-cause and impact analysis.\",\"difficulty\":\"Medium\"},{\"id\":184,\"chapter\":\"11. Data Quality\",\"question\":\"An organization measures hundreds of rules but resolves few failures. What is the maturity weakness?\",\"options\":[\"There are too few dashboards\",\"The taxonomy is too deep\",\"Measurement is not connected to accountable remediation\",\"The data model is too conceptual\"],\"answer\":2,\"rationale\":\"Metrics create value only when failures trigger decisions and action.\",\"difficulty\":\"Hard\"},{\"id\":185,\"chapter\":\"11. Data Quality\",\"question\":\"Why should quality requirements be defined with business users?\",\"options\":[\"IT cannot read data\",\"Fitness for use depends on business processes and decisions\",\"Business users should configure databases\",\"Quality is purely subjective\"],\"answer\":1,\"rationale\":\"Business context determines acceptable levels, impacts, and priorities.\",\"difficulty\":\"Medium\"},{\"id\":186,\"chapter\":\"11. Data Quality\",\"question\":\"What is the best response when improving one system reduces quality in another?\",\"options\":[\"Stop integration permanently\",\"Assess end-to-end impacts and agree an enterprise solution through governance\",\"Optimize only the first system\",\"Hide the second system's metrics\"],\"answer\":1,\"rationale\":\"Local optimization can damage enterprise outcomes and must be governed across boundaries.\",\"difficulty\":\"Hard\"},{\"id\":187,\"chapter\":\"11. Data Quality\",\"question\":\"Which metric best represents duplicate rate?\",\"options\":[\"Null attributes divided by all attributes\",\"Successful jobs divided by scheduled jobs\",\"Correct values divided by sampled values\",\"Records identified as inappropriate duplicates divided by assessed records\"],\"answer\":3,\"rationale\":\"Duplicate rate is a uniqueness measure based on the assessed population.\",\"difficulty\":\"Medium\"},{\"id\":188,\"chapter\":\"11. Data Quality\",\"question\":\"What is the primary risk of cleansing data without preserving an audit trail?\",\"options\":[\"The data becomes too complete\",\"Storage automatically doubles\",\"Changes may be unverifiable, irreversible, or unaccountable\",\"The taxonomy becomes flatter\"],\"answer\":2,\"rationale\":\"Controlled remediation needs before-and-after evidence, authority, and traceability.\",\"difficulty\":\"Medium\"},{\"id\":189,\"chapter\":\"11. Data Quality\",\"question\":\"When should a quality exception be accepted?\",\"options\":[\"When an authorized owner documents justification, risk, duration, and treatment\",\"Whenever a developer requests it verbally\",\"Whenever the quality score is unknown\",\"Whenever a rule is inconvenient\"],\"answer\":0,\"rationale\":\"Exceptions should be governed and time-bound rather than silently tolerated.\",\"difficulty\":\"Hard\"},{\"id\":190,\"chapter\":\"11. Data Quality\",\"question\":\"What is the strongest sign of an optimized quality capability?\",\"options\":[\"A tool has been purchased\",\"A policy document exists\",\"Data is cleansed once\",\"Quality controls are embedded, monitored, and improved using measured outcomes\"],\"answer\":3,\"rationale\":\"High maturity combines prevention, automation, accountability, and continuous improvement.\",\"difficulty\":\"Hard\"},{\"id\":191,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic of big data refers to scale?\",\"options\":[\"Value\",\"Veracity\",\"Volume\",\"Velocity\"],\"answer\":2,\"rationale\":\"Volume denotes the amount of data generated, stored, or processed.\",\"difficulty\":\"Easy\"},{\"id\":192,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic refers to the speed of generation and processing?\",\"options\":[\"Velocity\",\"Value\",\"Volume\",\"Variety\"],\"answer\":0,\"rationale\":\"Velocity concerns the rate and timeliness of data flows.\",\"difficulty\":\"Easy\"},{\"id\":193,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic refers to different formats and sources?\",\"options\":[\"Variety\",\"Value\",\"Veracity\",\"Volume\"],\"answer\":0,\"rationale\":\"Variety includes structured, semi-structured, and unstructured forms.\",\"difficulty\":\"Easy\"},{\"id\":194,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic concerns trustworthiness and uncertainty?\",\"options\":[\"Velocity\",\"Veracity\",\"Visualization\",\"Volume\"],\"answer\":1,\"rationale\":\"Veracity concerns reliability, bias, noise, and confidence.\",\"difficulty\":\"Easy\"},{\"id\":195,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic emphasizes useful business outcomes?\",\"options\":[\"Velocity\",\"Volume\",\"Variety\",\"Value\"],\"answer\":3,\"rationale\":\"Big-data investment is justified by value rather than scale alone.\",\"difficulty\":\"Easy\"},{\"id\":196,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which is semi-structured data?\",\"options\":[\"An analog paper form\",\"A normalized customer table\",\"A scanned photograph\",\"A JSON event message\"],\"answer\":3,\"rationale\":\"JSON has structural markers but does not require a fixed relational schema.\",\"difficulty\":\"Easy\"},{\"id\":197,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which is unstructured data?\",\"options\":[\"A country-code table\",\"A relational invoice table\",\"A fixed-width transaction file\",\"A maintenance video\"],\"answer\":3,\"rationale\":\"Video content does not naturally conform to rows and columns.\",\"difficulty\":\"Easy\"},{\"id\":198,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a data lake?\",\"options\":[\"A transaction-only ERP database\",\"A scalable repository that can retain diverse data, often in native form\",\"A document retention schedule\",\"A business glossary\"],\"answer\":1,\"rationale\":\"Data lakes commonly preserve structured and non-structured data for multiple uses.\",\"difficulty\":\"Easy\"},{\"id\":199,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does schema-on-read mean?\",\"options\":[\"All data is converted to one table\",\"Schema is fixed before ingestion\",\"Data has no structure under any circumstance\",\"Structure is applied or interpreted when data is accessed for use\"],\"answer\":3,\"rationale\":\"Schema-on-read allows flexible interpretation for different consumers.\",\"difficulty\":\"Easy\"},{\"id\":200,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does schema-on-write mean?\",\"options\":[\"Data is never validated\",\"Schema is chosen after every query\",\"All files remain in native form\",\"Data is shaped to an agreed schema before or during loading\"],\"answer\":3,\"rationale\":\"Warehousing commonly applies defined structures before analytical use.\",\"difficulty\":\"Easy\"},{\"id\":201,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a data swamp?\",\"options\":[\"A master-data registry\",\"A highly optimized warehouse\",\"A secure backup vault\",\"A poorly governed data lake whose assets are difficult to find, understand, or trust\"],\"answer\":3,\"rationale\":\"Weak metadata, stewardship, quality, and lifecycle controls reduce lake usability.\",\"difficulty\":\"Easy\"},{\"id\":202,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is distributed processing used?\",\"options\":[\"To replace governance\",\"To divide large processing workloads across multiple computing nodes\",\"To avoid all failures\",\"To eliminate metadata\"],\"answer\":1,\"rationale\":\"Parallel distributed computation enables scale beyond one machine.\",\"difficulty\":\"Easy\"},{\"id\":203,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is horizontal scaling?\",\"options\":[\"Reducing the number of users\",\"Compressing all data\",\"Adding more power to one node only\",\"Adding more nodes to increase capacity\"],\"answer\":3,\"rationale\":\"Scale-out architectures add machines or instances.\",\"difficulty\":\"Medium\"},{\"id\":204,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is fault tolerance in a distributed platform?\",\"options\":[\"Permanent duplication of every result\",\"The ability to continue or recover when components fail\",\"Ignoring failed jobs\",\"The absence of data-quality rules\"],\"answer\":1,\"rationale\":\"Distributed designs anticipate component failure and use replication or recovery mechanisms.\",\"difficulty\":\"Medium\"},{\"id\":205,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data partitioning?\",\"options\":[\"Renaming every file\",\"Dividing data into manageable segments for storage or processing\",\"Deleting historical data\",\"Encrypting each attribute\"],\"answer\":1,\"rationale\":\"Partitioning improves distribution, parallelism, and manageability.\",\"difficulty\":\"Medium\"},{\"id\":206,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is stream processing?\",\"options\":[\"Running one annual batch\",\"Updating a business glossary\",\"Archiving documents\",\"Processing events continuously or with very low latency as they arrive\"],\"answer\":3,\"rationale\":\"Streaming supports timely analysis of ongoing event flows.\",\"difficulty\":\"Easy\"},{\"id\":207,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is batch processing?\",\"options\":[\"Processing a accumulated set of records as a scheduled or bounded workload\",\"Handling every event individually at arrival\",\"Masking sensitive fields\",\"Defining data ownership\"],\"answer\":0,\"rationale\":\"Batch workloads process collected data at intervals or as bounded jobs.\",\"difficulty\":\"Easy\"},{\"id\":208,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A machine emits vibration readings every millisecond. Which big-data property is most obvious?\",\"options\":[\"Normalization\",\"Taxonomy\",\"Velocity\",\"Retention\"],\"answer\":2,\"rationale\":\"The defining challenge is the high rate of data arrival.\",\"difficulty\":\"Easy\"},{\"id\":209,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A platform stores sensor readings, images, logs, and work orders. Which property is strongest?\",\"options\":[\"Variety\",\"Cardinality\",\"Uniqueness\",\"Volatility\"],\"answer\":0,\"rationale\":\"Multiple data forms and structures demonstrate variety.\",\"difficulty\":\"Easy\"},{\"id\":210,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is predictive analytics?\",\"options\":[\"Reporting only what happened\",\"Selecting a retention schedule\",\"Designing an access role\",\"Using data and models to estimate likely future outcomes\"],\"answer\":3,\"rationale\":\"Predictive methods estimate future events, probabilities, or values.\",\"difficulty\":\"Easy\"},{\"id\":211,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is prescriptive analytics?\",\"options\":[\"Describing past performance only\",\"Creating a conceptual model\",\"Collecting metadata\",\"Recommending actions based on objectives, constraints, and predicted outcomes\"],\"answer\":3,\"rationale\":\"Prescriptive analysis addresses what action should be taken.\",\"difficulty\":\"Medium\"},{\"id\":212,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is metadata essential in a data lake?\",\"options\":[\"It replaces access security\",\"It eliminates storage costs\",\"It guarantees all models are unbiased\",\"It enables discovery, interpretation, lineage, governance, and reuse\"],\"answer\":3,\"rationale\":\"Without context, large collections become difficult to use responsibly.\",\"difficulty\":\"Medium\"},{\"id\":213,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data provenance?\",\"options\":[\"Evidence about the origin and history of data\",\"A database index\",\"An encryption key\",\"A duplicate-detection rule\"],\"answer\":0,\"rationale\":\"Provenance supports trust, reproducibility, lineage, and accountability.\",\"difficulty\":\"Medium\"},{\"id\":214,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What should govern retention of high-volume sensor data?\",\"options\":[\"Use the same period for all data\",\"Business value, obligations, risk, cost, and intended analytical use\",\"Delete everything after one day\",\"Keep everything forever by default\"],\"answer\":1,\"rationale\":\"Retention requires a risk- and value-based lifecycle decision.\",\"difficulty\":\"Hard\"},{\"id\":215,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why does more data not automatically improve an analytical model?\",\"options\":[\"Volume eliminates sampling error completely\",\"Additional data may be irrelevant, biased, noisy, or poorly labeled\",\"All large datasets are accurate\",\"Models use only metadata\"],\"answer\":1,\"rationale\":\"Quality and representativeness matter as much as quantity.\",\"difficulty\":\"Medium\"},{\"id\":216,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data drift?\",\"options\":[\"Movement of data between storage tiers\",\"A change over time in input data patterns or distributions\",\"A taxonomy being revised\",\"A backup being archived\"],\"answer\":1,\"rationale\":\"Drift can reduce model performance when current data differs from training data.\",\"difficulty\":\"Hard\"},{\"id\":217,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is concept drift?\",\"options\":[\"A change in the relationship between inputs and the outcome being predicted\",\"A server migration\",\"A glossary ownership change\",\"A change in file format only\"],\"answer\":0,\"rationale\":\"Concept drift means the phenomenon or target relationship has evolved.\",\"difficulty\":\"Hard\"},{\"id\":218,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a major privacy risk in big-data analytics?\",\"options\":[\"Encryption removes all privacy concerns\",\"Large datasets are automatically anonymous\",\"Combining data may enable unexpected identification or sensitive inference\",\"Distributed systems cannot store personal data\"],\"answer\":2,\"rationale\":\"Linkage and inference can create risks beyond individual source datasets.\",\"difficulty\":\"Hard\"},{\"id\":219,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is representative training data important?\",\"options\":[\"Biased or incomplete representation can produce systematically poor outcomes\",\"It guarantees perfect predictions\",\"It reduces the need for testing\",\"It makes governance unnecessary\"],\"answer\":0,\"rationale\":\"Model outcomes depend on the populations and conditions represented in the data.\",\"difficulty\":\"Medium\"},{\"id\":220,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does reproducibility require in an analytics pipeline?\",\"options\":[\"Only a larger cluster\",\"Only the model name\",\"Traceable data, code, configuration, parameters, and execution context\",\"Only the final chart\"],\"answer\":2,\"rationale\":\"Reproduction depends on preserving the full analytical context.\",\"difficulty\":\"Hard\"},{\"id\":221,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which control best limits uncontrolled data-lake access?\",\"options\":[\"Shared administrator credentials\",\"Classification-based authorization with least privilege and logging\",\"Removal of metadata\",\"Public access for all analysts\"],\"answer\":1,\"rationale\":\"Governed access should reflect sensitivity and approved purpose.\",\"difficulty\":\"Medium\"},{\"id\":222,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is the best initial question for a big-data initiative?\",\"options\":[\"Which tool has the most features?\",\"How can we keep every event forever?\",\"What business decision or outcome should the data improve?\",\"How much data can we collect?\"],\"answer\":2,\"rationale\":\"A value-led use case should precede technology and collection decisions.\",\"difficulty\":\"Medium\"},{\"id\":223,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why monitor pipeline data quality continuously?\",\"options\":[\"Source behavior and data distributions can change over time\",\"Monitoring only affects storage\",\"One initial test proves permanent quality\",\"Big data is exempt from quality rules\"],\"answer\":0,\"rationale\":\"Dynamic sources require ongoing detection of drift, failures, and anomalies.\",\"difficulty\":\"Medium\"},{\"id\":224,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is the strongest sign that a big-data platform is governed effectively?\",\"options\":[\"It has no deletion process\",\"It contains petabytes of data\",\"It uses many technologies\",\"Assets are discoverable, owned, protected, quality-assessed, and lifecycle-managed\"],\"answer\":3,\"rationale\":\"Governance is demonstrated by controlled and useful information management.\",\"difficulty\":\"Hard\"},{\"id\":225,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A predictive-maintenance model performs well in one plant but poorly in another. What should be examined first?\",\"options\":[\"The color of the dashboard\",\"The office network name\",\"The number of glossary pages\",\"Differences in equipment, operating conditions, sensor quality, and data representation\"],\"answer\":3,\"rationale\":\"Cross-context performance can fail when data and operating conditions differ.\",\"difficulty\":\"Hard\"},{\"id\":226,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a data-management maturity assessment evaluate?\",\"options\":[\"Only regulatory compliance\",\"Only database performance\",\"Only the accuracy of individual records\",\"How consistently and effectively an organization manages data capabilities\"],\"answer\":3,\"rationale\":\"Maturity assessment examines organizational capability across people, process, governance, and technology.\",\"difficulty\":\"Easy\"},{\"id\":227,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the principal output of a maturity assessment?\",\"options\":[\"A current-state capability view, gaps, priorities, and improvement roadmap\",\"A production database\",\"A list of passwords\",\"A physical data model only\"],\"answer\":0,\"rationale\":\"Assessment should guide targeted capability improvement.\",\"difficulty\":\"Easy\"},{\"id\":228,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does an Initial maturity level usually indicate?\",\"options\":[\"All controls are automated\",\"Continuous optimization is embedded\",\"Practices are ad hoc, reactive, and dependent on individuals\",\"Processes are quantitatively managed\"],\"answer\":2,\"rationale\":\"Initial capability lacks consistent institutionalized practice.\",\"difficulty\":\"Easy\"},{\"id\":229,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a Defined level generally indicate?\",\"options\":[\"Practices and roles are documented and used consistently\",\"Every process is optimized\",\"No processes exist\",\"Only technology has been purchased\"],\"answer\":0,\"rationale\":\"Defined capability is standardized and institutionalized.\",\"difficulty\":\"Easy\"},{\"id\":230,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a Managed level generally add?\",\"options\":[\"Dependence on informal experts\",\"Elimination of metrics\",\"Measurement, monitoring, control, and accountable performance management\",\"Removal of all policies\"],\"answer\":2,\"rationale\":\"Managed capability uses evidence to control outcomes.\",\"difficulty\":\"Easy\"},{\"id\":231,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What characterizes an Optimized level?\",\"options\":[\"Continuous improvement, learning, automation, and adaptive control\",\"No changes are permitted\",\"Processes are performed differently everywhere\",\"A policy exists as a file\"],\"answer\":0,\"rationale\":\"Optimization uses measured outcomes to improve capability systematically.\",\"difficulty\":\"Easy\"},{\"id\":232,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why is a yes\/no questionnaire insufficient for a robust assessment?\",\"options\":[\"Documents cannot be reviewed\",\"Maturity cannot be measured\",\"It may show existence but not adoption, consistency, effectiveness, or evidence\",\"Yes\/no questions are always illegal\"],\"answer\":2,\"rationale\":\"Capability maturity requires examining practice in operation.\",\"difficulty\":\"Medium\"},{\"id\":233,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A policy exists but is contradictory, outdated, and unknown to staff. How should it be scored?\",\"options\":[\"Below mature levels because effectiveness and adoption are weak\",\"Level 5 because a document exists\",\"Level 4 because it is long\",\"Not assessed because policies do not matter\"],\"answer\":0,\"rationale\":\"Documentation alone is not evidence of institutionalized capability.\",\"difficulty\":\"Medium\"},{\"id\":234,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is assessment evidence?\",\"options\":[\"The assessor's preference\",\"A vendor's marketing claim\",\"Artifacts, observations, records, metrics, and interviews that substantiate a rating\",\"An undocumented assumption\"],\"answer\":2,\"rationale\":\"Evidence supports transparent and repeatable scoring.\",\"difficulty\":\"Easy\"},{\"id\":235,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why triangulate evidence?\",\"options\":[\"To validate claims using more than one source or method\",\"To increase the score automatically\",\"To avoid stakeholder interviews\",\"To eliminate professional judgment\"],\"answer\":0,\"rationale\":\"Triangulation reduces reliance on unverified self-reporting.\",\"difficulty\":\"Medium\"},{\"id\":236,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a target maturity level?\",\"options\":[\"The capability level the organization intends to reach based on need and value\",\"The highest possible score for every capability\",\"The number of assessment questions\",\"The current average score\"],\"answer\":0,\"rationale\":\"Targets should reflect business priorities rather than universal perfection.\",\"difficulty\":\"Easy\"},{\"id\":237,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why should not every capability automatically target Level 5?\",\"options\":[\"Only technology can reach Level 5\",\"The cost and complexity may exceed the business need or risk reduction\",\"Level 5 is impossible\",\"Targets must always equal current scores\"],\"answer\":1,\"rationale\":\"Maturity should be appropriate and economically justified.\",\"difficulty\":\"Medium\"},{\"id\":238,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is gap analysis?\",\"options\":[\"Comparison of current capability with the desired target state\",\"A document taxonomy\",\"Comparison of two database indexes\",\"A method of data encryption\"],\"answer\":0,\"rationale\":\"Gap analysis identifies improvement needs.\",\"difficulty\":\"Easy\"},{\"id\":239,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"How should roadmap initiatives be prioritized?\",\"options\":[\"By alphabetical order\",\"By the longest document first\",\"By business value, risk, dependencies, feasibility, and capability gaps\",\"By assessor preference only\"],\"answer\":2,\"rationale\":\"Prioritization should link improvement to strategic outcomes and constraints.\",\"difficulty\":\"Medium\"},{\"id\":240,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a leading maturity indicator?\",\"options\":[\"A retired policy\",\"A result observed only after failure\",\"A historical revenue total\",\"Evidence that enabling practices are being implemented before final outcomes appear\"],\"answer\":3,\"rationale\":\"Leading indicators track adoption and control development, such as ownership coverage.\",\"difficulty\":\"Hard\"},{\"id\":241,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a lagging maturity indicator?\",\"options\":[\"An outcome measure observed after processes have operated\",\"A draft role description\",\"A proposed catalog\",\"A planned training session\"],\"answer\":0,\"rationale\":\"Lagging indicators include defect trends, incident results, or realized compliance outcomes.\",\"difficulty\":\"Hard\"},{\"id\":242,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why assess maturity by capability rather than only one overall score?\",\"options\":[\"Capabilities cannot be compared\",\"Strengths and weaknesses differ and require different actions\",\"Roadmaps need no detail\",\"Overall scores are always false\"],\"answer\":1,\"rationale\":\"A single average can hide critical low-performing areas.\",\"difficulty\":\"Medium\"},{\"id\":243,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the danger of averaging scores without weights?\",\"options\":[\"Averages always exceed five\",\"Every capability has identical risk\",\"Weights remove all judgment\",\"Low maturity in a critical capability may be hidden by less important high scores\"],\"answer\":3,\"rationale\":\"Weighting or interpretation should reflect business criticality.\",\"difficulty\":\"Hard\"},{\"id\":244,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What should a scoring rubric contain?\",\"options\":[\"Observable criteria and evidence expectations for each level\",\"Only tool names\",\"Only chapter titles\",\"Only numeric labels\"],\"answer\":0,\"rationale\":\"Anchored descriptions improve consistency and auditability.\",\"difficulty\":\"Medium\"},{\"id\":245,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Two assessors give different ratings from the same evidence. What is the best response?\",\"options\":[\"Average the scores without discussion\",\"Calibrate against the rubric and document the rating rationale\",\"Discard the evidence\",\"Use the highest score\"],\"answer\":1,\"rationale\":\"Calibration promotes consistent interpretation and transparent judgment.\",\"difficulty\":\"Hard\"},{\"id\":246,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is assessment scope?\",\"options\":[\"The target score alone\",\"Only the interview schedule\",\"The organizational units, capabilities, data domains, systems, and period included\",\"The number of colors in the report\"],\"answer\":2,\"rationale\":\"Clear scope prevents overgeneralization and supports repeatability.\",\"difficulty\":\"Easy\"},{\"id\":247,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why identify assessment stakeholders early?\",\"options\":[\"They guarantee high scores\",\"They replace the assessor\",\"They provide evidence, context, decisions, and ownership of improvements\",\"They eliminate confidentiality requirements\"],\"answer\":2,\"rationale\":\"Broad engagement improves accuracy and adoption of the roadmap.\",\"difficulty\":\"Medium\"},{\"id\":248,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is respondent bias?\",\"options\":[\"A database constraint\",\"A reporting dimension\",\"Systematic distortion caused by incentives, perceptions, or incomplete knowledge\",\"A lineage relationship\"],\"answer\":2,\"rationale\":\"Self-assessments can overstate or understate capability.\",\"difficulty\":\"Medium\"},{\"id\":249,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"How can respondent bias be reduced?\",\"options\":[\"Remove all interviews\",\"Publish names with every answer\",\"Use evidence review, multiple roles, neutral facilitation, and clear rubrics\",\"Ask only senior leaders\"],\"answer\":2,\"rationale\":\"Multiple evidence sources and structured criteria improve reliability.\",\"difficulty\":\"Medium\"},{\"id\":250,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the purpose of an assessment workshop?\",\"options\":[\"Replace individual interviews in all cases\",\"Approve every policy exception\",\"Configure production databases\",\"Build shared understanding, validate evidence, and calibrate ratings\"],\"answer\":3,\"rationale\":\"Workshops help reconcile perspectives and establish ownership of findings.\",\"difficulty\":\"Easy\"},{\"id\":251,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What makes a recommendation actionable?\",\"options\":[\"A vendor product name only\",\"A vague statement to improve data\",\"A maturity score without context\",\"A defined outcome, owner, priority, dependencies, measures, and timeframe\"],\"answer\":3,\"rationale\":\"Actionable recommendations can be assigned, planned, and measured.\",\"difficulty\":\"Medium\"},{\"id\":252,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the best way to present maturity results to executives?\",\"options\":[\"Present technology diagrams only\",\"Link capability findings to business risk, value, and prioritized decisions\",\"Hide all weaknesses\",\"Show only detailed question responses\"],\"answer\":1,\"rationale\":\"Executives need a decision-oriented narrative rather than raw scoring detail.\",\"difficulty\":\"Medium\"},{\"id\":253,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why repeat maturity assessments?\",\"options\":[\"To replace operational metrics\",\"To avoid implementing actions\",\"Repeated scoring guarantees improvement\",\"Measure progress, detect changes, and refine the improvement roadmap\"],\"answer\":3,\"rationale\":\"Periodic reassessment checks whether capability has genuinely advanced.\",\"difficulty\":\"Easy\"},{\"id\":254,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the main risk of reassessing too frequently?\",\"options\":[\"All evidence becomes invalid\",\"Scores may reflect noise before improvements have become institutionalized\",\"Policies automatically expire\",\"The model can no longer be used\"],\"answer\":1,\"rationale\":\"Capability change needs enough time to become established and measurable.\",\"difficulty\":\"Hard\"},{\"id\":255,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A governance council exists but rarely makes decisions. Which aspect should lower the score?\",\"options\":[\"Meeting-room availability\",\"Operational effectiveness\",\"Document formatting\",\"Database capacity\"],\"answer\":1,\"rationale\":\"Formal existence without effective outcomes is weak maturity evidence.\",\"difficulty\":\"Medium\"},{\"id\":256,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A data catalog is purchased but has little metadata and few users. What does this demonstrate?\",\"options\":[\"Technology implementation without mature adoption or operating processes\",\"Automatic enterprise governance\",\"Optimized metadata capability\",\"A complete target state\"],\"answer\":0,\"rationale\":\"Tool deployment is not equivalent to institutionalized capability.\",\"difficulty\":\"Medium\"},{\"id\":257,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Which finding is more useful than 'Metadata score = 2.1'?\",\"options\":[\"The score has one decimal place\",\"Definitions lack owners, lineage covers few critical reports, and catalog adoption is low\",\"The tool should be replaced\",\"Metadata needs improvement\"],\"answer\":1,\"rationale\":\"Specific evidence explains the score and informs remediation.\",\"difficulty\":\"Hard\"},{\"id\":258,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is an interdependency in a maturity roadmap?\",\"options\":[\"Two questions share the same answer\",\"One capability improvement relies on another capability or prerequisite\",\"Two charts use the same color\",\"Two assessors attend one meeting\"],\"answer\":1,\"rationale\":\"For example, quality monitoring may depend on metadata and ownership.\",\"difficulty\":\"Medium\"},{\"id\":259,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the best response to a high maturity score with poor business outcomes?\",\"options\":[\"Increase every target to Level 5\",\"Stop measuring outcomes\",\"Re-examine the evidence, rubric, effectiveness measures, and alignment to business need\",\"Accept the score without question\"],\"answer\":2,\"rationale\":\"Maturity claims should align with actual capability effectiveness.\",\"difficulty\":\"Hard\"},{\"id\":260,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the defining principle of a useful maturity assessment?\",\"options\":[\"It replaces data strategy\",\"It produces the highest possible score\",\"It compares tool brands\",\"It supports evidence-based prioritization and continuous capability improvement\"],\"answer\":3,\"rationale\":\"The assessment is a means to improve outcomes, not an end in itself.\",\"difficulty\":\"Hard\"}];<\/script><script>\n(function(){\n const ROOT_ID='cdmp-practice-quiz'; const data=CDMP_QUESTIONS; const root=document.getElementById(ROOT_ID); if(!root)return;\n let current=[],submitted=false;\n const chapters=[...new Set(data.map(q=>q.chapter))];\n root.innerHTML=`<div class=\"cdmpq\">\n <div class=\"cdmpq-card\"><h2>CDMP Practice Quiz<\/h2><p>Choose a chapter and number of questions. Results and explanations appear immediately after submission.<\/p>\n <div class=\"cdmpq-controls\"><label>Chapter<select id=\"cdmp-ch\"><option value=\"all\">All chapters<\/option>${chapters.map(c=>`<option>${c}<\/option>`).join('')}<\/select><\/label><label>Questions<select id=\"cdmp-count\"><option>10<\/option><option>20<\/option><option>30<\/option><option>50<\/option><option value=\"all\">All available<\/option><\/select><\/label><label>Order<select id=\"cdmp-order\"><option value=\"random\">Random<\/option><option value=\"number\">Question number<\/option><\/select><\/label><\/div>\n <div class=\"cdmpq-actions\"><button id=\"cdmp-start\">Start new quiz<\/button><button class=\"secondary\" id=\"cdmp-resume\">Resume saved quiz<\/button><button class=\"danger\" id=\"cdmp-clear\">Clear saved progress<\/button><\/div><p class=\"cdmpq-note\">Unofficial study aid. Not an official DAMA International examination.<\/p><\/div>\n <div id=\"cdmp-stage\"><\/div><\/div>`;\n const $=s=>root.querySelector(s), stage=$('#cdmp-stage');\n function shuffled(a){let x=[...a];for(let i=x.length-1;i>0;i--){let j=Math.floor(Math.random()*(i+1));[x[i],x[j]]=[x[j],x[i]]}return x}\n function begin(saved){submitted=false;if(saved){current=saved.questions;render(saved.answers||{}) ;return}\n   let pool=$('#cdmp-ch').value==='all'?data:data.filter(q=>q.chapter===$('#cdmp-ch').value);\n   pool=$('#cdmp-order').value==='random'?shuffled(pool):[...pool].sort((a,b)=>a.id-b.id);\n   let n=$('#cdmp-count').value==='all'?pool.length:Math.min(+$('#cdmp-count').value,pool.length);current=pool.slice(0,n);render({});\n }\n function render(answers){stage.innerHTML=`<div class=\"cdmpq-card\"><div><strong id=\"cdmp-status\">0 of ${current.length} answered<\/strong><\/div><div class=\"cdmpq-progress\"><span id=\"cdmp-bar\"><\/span><\/div><div id=\"cdmp-list\"><\/div><div class=\"cdmpq-actions\"><button id=\"cdmp-submit\">Submit answers<\/button><button class=\"secondary\" id=\"cdmp-save\">Save progress<\/button><\/div><\/div>`;\n   const list=$('#cdmp-list'); current.forEach((q,i)=>{let d=document.createElement('div');d.className='cdmpq-q';d.dataset.id=q.id;d.innerHTML=`<div class=\"cdmpq-meta\">Question ${i+1} \u00b7 Bank #${q.id} \u00b7 ${q.chapter}${q.difficulty&&q.difficulty!=='Mixed'?' \u00b7 '+q.difficulty:''}<\/div><h3>${esc(q.question)}<\/h3>${q.options.map((o,k)=>`<label class=\"cdmpq-opt\"><input type=\"radio\" name=\"q${q.id}\" value=\"${k}\" ${String(answers[q.id])===String(k)?'checked':''}>${String.fromCharCode(65+k)}. ${esc(o)}<\/label>`).join('')}`;list.appendChild(d)});\n   root.querySelectorAll('input[type=radio]').forEach(x=>x.addEventListener('change',progress)); $('#cdmp-submit').onclick=submit; $('#cdmp-save').onclick=save; progress(); root.scrollIntoView({behavior:'smooth'});\n }\n function esc(s){return String(s).replace(\/[&<>\"]\/g,c=>({'&':'&amp;','<':'&lt;','>':'&gt;','\"':'&quot;'}[c]))}\n function collect(){let a={};current.forEach(q=>{let x=root.querySelector(`input[name=q${q.id}]:checked`);if(x)a[q.id]=+x.value});return a}\n function progress(){let n=Object.keys(collect()).length;$('#cdmp-status').textContent=`${n} of ${current.length} answered`;$('#cdmp-bar').style.width=(100*n\/current.length)+'%'}\n function save(){localStorage.setItem('cdmpQuizState',JSON.stringify({questions:current,answers:collect()}));alert('Progress saved in this browser.')}\n function submit(){if(submitted)return;let a=collect();let unanswered=current.length-Object.keys(a).length;if(unanswered&&!confirm(`${unanswered} question(s) unanswered. Submit anyway?`))return;submitted=true;let correct=0,by={};current.forEach(q=>{let chosen=a[q.id],ok=chosen===q.answer;if(ok)correct++;by[q.chapter]??={c:0,n:0};by[q.chapter].n++;if(ok)by[q.chapter].c++;let box=root.querySelector(`.cdmpq-q[data-id=\"${q.id}\"]`);box.querySelectorAll('.cdmpq-opt').forEach((el,k)=>{el.classList.toggle('cdmpq-correct',k===q.answer);el.classList.toggle('cdmpq-wrong',k===chosen&&k!==q.answer);el.querySelector('input').disabled=true});let r=document.createElement('div');r.className='cdmpq-rationale';r.innerHTML=`<strong>${ok?'Correct':'Review'}.<\/strong> ${esc(q.rationale)}`;box.appendChild(r)});let pct=Math.round(100*correct\/current.length);let result=document.createElement('div');result.className='cdmpq-card';result.innerHTML=`<h2>Results<\/h2><div class=\"cdmpq-kpis\"><div class=\"cdmpq-kpi\"><strong>${correct}\/${current.length}<\/strong>Correct<\/div><div class=\"cdmpq-kpi\"><strong>${pct}%<\/strong>Score<\/div><div class=\"cdmpq-kpi\"><strong>${current.length-correct}<\/strong>To review<\/div><\/div><h3>Chapter breakdown<\/h3><table class=\"cdmpq-breakdown\"><thead><tr><th>Chapter<\/th><th>Correct<\/th><th>Score<\/th><\/tr><\/thead><tbody>${Object.entries(by).map(([c,v])=>`<tr><td>${esc(c)}<\/td><td>${v.c}\/${v.n}<\/td><td>${Math.round(100*v.c\/v.n)}%<\/td><\/tr>`).join('')}<\/tbody><\/table><div class=\"cdmpq-actions\"><button id=\"cdmp-again\">Start another quiz<\/button><\/div>`;stage.prepend(result);result.querySelector('#cdmp-again').onclick=()=>begin(false);localStorage.removeItem('cdmpQuizState');result.scrollIntoView({behavior:'smooth'})}\n $('#cdmp-start').onclick=()=>begin(false);$('#cdmp-resume').onclick=()=>{let s=localStorage.getItem('cdmpQuizState');if(!s)return alert('No saved quiz found.');try{begin(JSON.parse(s))}catch(e){alert('Saved quiz could not be opened.')}};$('#cdmp-clear').onclick=()=>{localStorage.removeItem('cdmpQuizState');alert('Saved progress cleared.')};\n})();\n<\/script><\/body><\/html>\n\n\n\n<!doctype html><html lang=\"en\"><head><meta charset=\"utf-8\"><meta name=\"viewport\" content=\"width=device-width,initial-scale=1\"><title>CDMP Practice Quiz<\/title><style>body{margin:0;background:#eef3f8;padding:18px}\n.cdmpq{max-width:980px;margin:24px auto;font-family:system-ui,-apple-system,Segoe UI,sans-serif;color:#172033}.cdmpq *{box-sizing:border-box}.cdmpq-card{background:#fff;border:1px solid #dce3ec;border-radius:16px;padding:22px;box-shadow:0 5px 20px rgba(20,40,70,.08);margin-bottom:18px}.cdmpq h2,.cdmpq h3{margin-top:0}.cdmpq-controls{display:grid;grid-template-columns:2fr 1fr 1fr;gap:12px}.cdmpq label{font-weight:650;font-size:14px}.cdmpq select,.cdmpq input,.cdmpq button{font:inherit}.cdmpq select,.cdmpq input{width:100%;padding:10px;border:1px solid #b9c5d4;border-radius:9px;margin-top:5px}.cdmpq button{border:0;border-radius:9px;padding:11px 16px;background:#1967b3;color:#fff;font-weight:700;cursor:pointer}.cdmpq button.secondary{background:#e9f0f7;color:#164c7e}.cdmpq button.danger{background:#9c2f2f}.cdmpq-actions{display:flex;gap:10px;flex-wrap:wrap;margin-top:16px}.cdmpq-progress{height:10px;background:#e9eef4;border-radius:999px;overflow:hidden;margin:14px 0}.cdmpq-progress>span{height:100%;display:block;background:#1f78c1;width:0}.cdmpq-q{border-top:1px solid #e5eaf0;padding:18px 0}.cdmpq-q:first-child{border-top:0}.cdmpq-meta{color:#526274;font-size:13px;margin-bottom:6px}.cdmpq-opt{display:block;padding:10px 12px;margin:7px 0;border:1px solid #d3dbe5;border-radius:9px;cursor:pointer;font-weight:400}.cdmpq-opt:hover{background:#f5f8fb}.cdmpq-opt input{width:auto;margin:0 9px 0 0}.cdmpq-correct{background:#e9f7ee!important;border-color:#3b9a5f!important}.cdmpq-wrong{background:#fff0f0!important;border-color:#c34b4b!important}.cdmpq-rationale{padding:10px 12px;background:#f6f8fb;border-left:4px solid #547da6;margin-top:8px}.cdmpq-kpis{display:grid;grid-template-columns:repeat(3,1fr);gap:12px}.cdmpq-kpi{background:#f1f6fb;border-radius:12px;padding:16px;text-align:center}.cdmpq-kpi strong{font-size:28px;display:block;color:#14588f}.cdmpq-breakdown{width:100%;border-collapse:collapse}.cdmpq-breakdown th,.cdmpq-breakdown td{text-align:left;padding:9px;border-bottom:1px solid #e3e8ef}.cdmpq-note{font-size:13px;color:#596879}.cdmpq-hidden{display:none!important}@media(max-width:700px){.cdmpq-controls,.cdmpq-kpis{grid-template-columns:1fr}.cdmpq-card{padding:15px}}\n<\/style><\/head><body><div id=\"cdmp-practice-quiz\"><\/div><script>const CDMP_QUESTIONS=[{\"id\":1,\"chapter\":\"1. Data Governance\",\"question\":\"What is the primary purpose of data governance?\",\"options\":[\"Establish decision rights and accountability for data\",\"Operate backup infrastructure\",\"Develop analytical models\",\"Design database indexes\"],\"answer\":0,\"rationale\":\"Governance defines authority, accountability, policies, and decision processes for data.\",\"difficulty\":\"Mixed\"},{\"id\":2,\"chapter\":\"1. Data Governance\",\"question\":\"Who is normally accountable for the business definition and acceptable quality of a data domain?\",\"options\":[\"The database administrator\",\"The application developer\",\"The Data Owner\",\"The network engineer\"],\"answer\":2,\"rationale\":\"A Data Owner is accountable for decisions and outcomes within a business data domain.\",\"difficulty\":\"Mixed\"},{\"id\":3,\"chapter\":\"1. Data Governance\",\"question\":\"Which activity is most characteristic of a Data Steward?\",\"options\":[\"Monitoring definitions, quality issues, and compliance in daily operations\",\"Owning all enterprise applications\",\"Approving the corporate budget\",\"Configuring network firewalls\"],\"answer\":0,\"rationale\":\"Stewards perform operational coordination and monitoring under the accountability of owners.\",\"difficulty\":\"Mixed\"},{\"id\":4,\"chapter\":\"1. Data Governance\",\"question\":\"Two departments disagree on the meaning of 'active supplier.' What should happen first?\",\"options\":[\"Let each report retain its own definition\",\"Use the governance decision process to agree and approve one definition\",\"Delete the term from all reports\",\"Ask the DBA to choose a definition\"],\"answer\":1,\"rationale\":\"Conflicting enterprise definitions require an authorized governance decision, not an informal technical choice.\",\"difficulty\":\"Mixed\"},{\"id\":5,\"chapter\":\"1. Data Governance\",\"question\":\"Which is the best evidence that a governance policy is mature?\",\"options\":[\"It has many pages\",\"It exists as a draft file\",\"It is technically detailed\",\"It is approved, adopted, monitored, and periodically improved\"],\"answer\":3,\"rationale\":\"Document existence alone is insufficient; mature capability includes adoption, measurement, and improvement.\",\"difficulty\":\"Mixed\"},{\"id\":6,\"chapter\":\"1. Data Governance\",\"question\":\"What is a decision right?\",\"options\":[\"A defined authority to make or approve a data-related decision\",\"A report subscription\",\"A database permission granted to every user\",\"A legal ownership claim over software\"],\"answer\":0,\"rationale\":\"Decision rights clarify who may decide, approve, escalate, or resolve specific data matters.\",\"difficulty\":\"Mixed\"},{\"id\":7,\"chapter\":\"1. Data Governance\",\"question\":\"Which body commonly resolves cross-domain data conflicts?\",\"options\":[\"The Data Governance Council\",\"The database vendor\",\"The help desk\",\"The project scheduler\"],\"answer\":0,\"rationale\":\"A cross-functional governance body handles conflicts that exceed one domain owner's authority.\",\"difficulty\":\"Mixed\"},{\"id\":8,\"chapter\":\"1. Data Governance\",\"question\":\"Which statement best distinguishes policy from standard?\",\"options\":[\"There is no practical difference\",\"Policy states required intent; a standard specifies mandatory requirements\",\"Policy is optional; standards are always laws\",\"Policy is technical; standards are strategic\"],\"answer\":1,\"rationale\":\"Policies express direction and obligations, while standards make those obligations specific and testable.\",\"difficulty\":\"Mixed\"},{\"id\":9,\"chapter\":\"1. Data Governance\",\"question\":\"A governance program has many meetings but no recorded decisions. What is the main weakness?\",\"options\":[\"The data warehouse is too small\",\"The backup window is too long\",\"The operating model lacks effective decision execution\",\"The data model is over-normalized\"],\"answer\":2,\"rationale\":\"Governance should produce accountable decisions and outcomes, not only discussion.\",\"difficulty\":\"Mixed\"},{\"id\":10,\"chapter\":\"1. Data Governance\",\"question\":\"Which metric best measures stewardship effectiveness?\",\"options\":[\"CPU utilization\",\"Percentage of assigned data issues resolved within the agreed SLA\",\"Number of database servers\",\"Total document page count\"],\"answer\":1,\"rationale\":\"Issue resolution against an agreed service level reflects an operational stewardship outcome.\",\"difficulty\":\"Mixed\"},{\"id\":11,\"chapter\":\"1. Data Governance\",\"question\":\"Who should approve access to confidential supplier pricing data?\",\"options\":[\"The first user requesting access\",\"Any report developer\",\"The accountable Data Owner, following security policy\",\"The storage administrator alone\"],\"answer\":2,\"rationale\":\"Business access decisions belong to the accountable owner; technical teams implement them.\",\"difficulty\":\"Mixed\"},{\"id\":12,\"chapter\":\"1. Data Governance\",\"question\":\"What should determine the scope of a governance program?\",\"options\":[\"The age of the oldest database\",\"Business priorities, risk, and critical data needs\",\"Only the preferences of IT\",\"The number of available meeting rooms\"],\"answer\":1,\"rationale\":\"Governance scope should align with business value, obligations, and risk.\",\"difficulty\":\"Mixed\"},{\"id\":13,\"chapter\":\"1. Data Governance\",\"question\":\"Which deliverable clarifies who is Responsible, Accountable, Consulted, and Informed?\",\"options\":[\"A physical data model\",\"A star schema\",\"A RACI matrix\",\"A recovery log\"],\"answer\":2,\"rationale\":\"A RACI matrix assigns participation and accountability across activities.\",\"difficulty\":\"Mixed\"},{\"id\":14,\"chapter\":\"1. Data Governance\",\"question\":\"A policy exception is requested. What is the soundest governance response?\",\"options\":[\"Approve verbally with no record\",\"Delete the policy\",\"Ignore the policy permanently\",\"Document the rationale, risk, approval, duration, and compensating controls\"],\"answer\":3,\"rationale\":\"Controlled exceptions should be transparent, risk-assessed, time-bound, and accountable.\",\"difficulty\":\"Mixed\"},{\"id\":15,\"chapter\":\"1. Data Governance\",\"question\":\"What is the best relationship between data strategy and data governance?\",\"options\":[\"Strategy sets direction; governance supplies authority and control to execute it\",\"They are unrelated\",\"Strategy is only a technical architecture\",\"Governance replaces strategy\"],\"answer\":0,\"rationale\":\"Governance operationalizes strategic intent through roles, policies, decisions, and oversight.\",\"difficulty\":\"Mixed\"},{\"id\":16,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the central purpose of data architecture?\",\"options\":[\"Approve employee expenses\",\"Write every SQL query\",\"Provide an enterprise blueprint for organizing and using data assets\",\"Manage document retention alone\"],\"answer\":2,\"rationale\":\"Architecture translates business and data strategy into target structures, flows, and principles.\",\"difficulty\":\"Mixed\"},{\"id\":17,\"chapter\":\"2. Data Architecture\",\"question\":\"Which artifact presents major data domains and their relationships at enterprise level?\",\"options\":[\"A sprint burndown chart\",\"An enterprise conceptual data model\",\"A user access list\",\"A backup log\"],\"answer\":1,\"rationale\":\"An enterprise conceptual model communicates major business concepts without implementation detail.\",\"difficulty\":\"Mixed\"},{\"id\":18,\"chapter\":\"2. Data Architecture\",\"question\":\"What does an authoritative source designation clarify?\",\"options\":[\"Which source is trusted to create or maintain defined data\",\"Which team owns the network\",\"Which server is newest\",\"Which report has the brightest colors\"],\"answer\":0,\"rationale\":\"Authoritative-source decisions reduce ambiguity about trusted creation and maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":19,\"chapter\":\"2. Data Architecture\",\"question\":\"Which architecture principle is most appropriate?\",\"options\":[\"All data must be copied into spreadsheets\",\"Every project should create separate definitions\",\"Data should be shared through governed, reusable interfaces\",\"Security should be added only after deployment\"],\"answer\":2,\"rationale\":\"Principles should promote reuse, consistency, governance, and secure design.\",\"difficulty\":\"Mixed\"},{\"id\":20,\"chapter\":\"2. Data Architecture\",\"question\":\"What is a target-state data architecture?\",\"options\":[\"A physical table definition only\",\"The intended future arrangement of data capabilities and components\",\"A list of yesterday's incidents\",\"A vendor invoice\"],\"answer\":1,\"rationale\":\"Target state describes the future architecture toward which the roadmap progresses.\",\"difficulty\":\"Mixed\"},{\"id\":21,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the principal purpose of a data-flow diagram?\",\"options\":[\"Display employee reporting lines\",\"Calculate storage invoices\",\"Show movement of data among processes, stores, and external entities\",\"Define password length\"],\"answer\":2,\"rationale\":\"Data-flow diagrams emphasize movement, transformation context, and interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":22,\"chapter\":\"2. Data Architecture\",\"question\":\"A canonical model is primarily used to do what?\",\"options\":[\"Provide a common exchange representation across systems\",\"Set backup frequencies\",\"Replace all source databases\",\"Approve access requests\"],\"answer\":0,\"rationale\":\"A canonical model reduces repeated pairwise mappings and supports interoperability.\",\"difficulty\":\"Mixed\"},{\"id\":23,\"chapter\":\"2. Data Architecture\",\"question\":\"Which choice most directly reduces point-to-point integration complexity?\",\"options\":[\"Separate codes in every application\",\"Duplicate databases for each report\",\"A governed integration layer with reusable services or events\",\"More manual file transfers\"],\"answer\":2,\"rationale\":\"Reusable integration patterns reduce coupling and uncontrolled interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":24,\"chapter\":\"2. Data Architecture\",\"question\":\"What should drive architecture decisions first?\",\"options\":[\"The oldest available technology\",\"Individual developer preference\",\"A preferred vendor logo\",\"Business capabilities, requirements, principles, and constraints\"],\"answer\":3,\"rationale\":\"Architecture exists to serve business outcomes within agreed principles and constraints.\",\"difficulty\":\"Mixed\"},{\"id\":25,\"chapter\":\"2. Data Architecture\",\"question\":\"Which is normally an architecture concern rather than a detailed physical-design concern?\",\"options\":[\"Defining enterprise data domains and distribution patterns\",\"Creating a specific index\",\"Choosing a column's exact storage length\",\"Writing a stored procedure\"],\"answer\":0,\"rationale\":\"Architecture addresses enterprise structure and patterns; physical design addresses implementation detail.\",\"difficulty\":\"Mixed\"},{\"id\":26,\"chapter\":\"2. Data Architecture\",\"question\":\"Why maintain current-state architecture?\",\"options\":[\"To replace all operational monitoring\",\"To eliminate governance\",\"To avoid defining a target state\",\"To understand dependencies, risks, duplication, and migration needs\"],\"answer\":3,\"rationale\":\"A credible roadmap requires understanding the existing landscape and constraints.\",\"difficulty\":\"Mixed\"},{\"id\":27,\"chapter\":\"2. Data Architecture\",\"question\":\"What is an architecture transition state?\",\"options\":[\"An unapproved glossary term\",\"A retired document\",\"An intermediate configuration between current and target states\",\"A failed database transaction\"],\"answer\":2,\"rationale\":\"Complex transformations often require planned intermediate states.\",\"difficulty\":\"Mixed\"},{\"id\":28,\"chapter\":\"2. Data Architecture\",\"question\":\"A new analytics platform duplicates customer definitions. Which review should identify this risk?\",\"options\":[\"Payroll approval\",\"Printer maintenance review\",\"Data architecture and governance review\",\"Office safety inspection\"],\"answer\":2,\"rationale\":\"Architecture review checks alignment, reuse, authoritative sources, and enterprise consistency.\",\"difficulty\":\"Mixed\"},{\"id\":29,\"chapter\":\"2. Data Architecture\",\"question\":\"What does technology independence mean in a logical architecture?\",\"options\":[\"The design expresses required capabilities without binding them to one product\",\"All technologies are identical\",\"Implementation details are fully specified\",\"No technology will ever be used\"],\"answer\":0,\"rationale\":\"Logical architecture focuses on capabilities and relationships before product-specific realization.\",\"difficulty\":\"Mixed\"},{\"id\":30,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the best measure of architecture effectiveness?\",\"options\":[\"Length of architecture documents\",\"Number of diagrams produced\",\"Degree to which solutions conform to principles and deliver intended business outcomes\",\"Number of vendors engaged\"],\"answer\":2,\"rationale\":\"Effectiveness is demonstrated by useful outcomes and consistent implementation, not artifact volume.\",\"difficulty\":\"Mixed\"},{\"id\":31,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Which model is best for discussing major business entities with executives?\",\"options\":[\"Database execution plan\",\"Conceptual data model\",\"Physical data model\",\"Index definition\"],\"answer\":1,\"rationale\":\"Conceptual models communicate high-level business concepts and relationships.\",\"difficulty\":\"Mixed\"},{\"id\":32,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What distinguishes a logical data model?\",\"options\":[\"It contains only dashboards\",\"It defines backup schedules\",\"It contains only server names\",\"It defines entities, attributes, relationships, and rules without product-specific implementation\"],\"answer\":3,\"rationale\":\"Logical models add structured detail while remaining technology independent.\",\"difficulty\":\"Mixed\"},{\"id\":33,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What does a physical data model add?\",\"options\":[\"Only data-owner names\",\"Only business vision statements\",\"Platform-specific tables, columns, data types, constraints, and indexes\",\"Only retention policies\"],\"answer\":2,\"rationale\":\"Physical models translate logical designs into implementable database structures.\",\"difficulty\":\"Mixed\"},{\"id\":34,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the purpose of a primary key?\",\"options\":[\"Schedule ETL jobs\",\"Uniquely identify each entity occurrence or row\",\"Encrypt sensitive attributes\",\"Define document ownership\"],\"answer\":1,\"rationale\":\"A primary key provides stable uniqueness within a relation.\",\"difficulty\":\"Mixed\"},{\"id\":35,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the purpose of a foreign key?\",\"options\":[\"Maintain a reference to a key in a related table\",\"Generate reports automatically\",\"Classify security levels\",\"Store unstructured content\"],\"answer\":0,\"rationale\":\"Foreign keys implement relationships and support referential integrity.\",\"difficulty\":\"Mixed\"},{\"id\":36,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"How is a many-to-many relationship normally resolved in a relational model?\",\"options\":[\"Remove all keys\",\"Delete one entity\",\"Duplicate every row\",\"Introduce an associative entity or junction table\"],\"answer\":3,\"rationale\":\"The associative entity represents each valid pairing and may hold relationship attributes.\",\"difficulty\":\"Mixed\"},{\"id\":37,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What does cardinality describe?\",\"options\":[\"The number of backups\",\"The age of a database\",\"The sensitivity of a field\",\"The permitted number of occurrences in a relationship\"],\"answer\":3,\"rationale\":\"Cardinality defines one-to-one, one-to-many, many-to-many, and optionality constraints.\",\"difficulty\":\"Mixed\"},{\"id\":38,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the main objective of normalization?\",\"options\":[\"Eliminate all relationships\",\"Reduce redundancy and avoid update anomalies\",\"Replace business rules\",\"Increase duplicate storage\"],\"answer\":1,\"rationale\":\"Normalization separates dependencies to improve consistency and maintainability.\",\"difficulty\":\"Mixed\"},{\"id\":39,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"A table contains Order1, Order2, and Order3 repeating columns. Which principle is violated?\",\"options\":[\"Encryption at rest\",\"First Normal Form\",\"Data lineage\",\"Least privilege\"],\"answer\":1,\"rationale\":\"Repeating groups prevent each field from holding a single atomic value.\",\"difficulty\":\"Mixed\"},{\"id\":40,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Why might an analytical model be deliberately denormalized?\",\"options\":[\"To avoid defining metrics\",\"To simplify queries and improve analytical performance\",\"To remove all dimensions\",\"To prevent historical analysis\"],\"answer\":1,\"rationale\":\"Denormalization can be appropriate when controlled redundancy improves analytical usability.\",\"difficulty\":\"Mixed\"},{\"id\":41,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is a supertype\/subtype structure used for?\",\"options\":[\"Measure data quality\",\"Schedule backups\",\"Define API throttling\",\"Model common attributes and specialized entity variations\"],\"answer\":3,\"rationale\":\"Supertypes capture commonality; subtypes capture specialized characteristics.\",\"difficulty\":\"Mixed\"},{\"id\":42,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is a natural key?\",\"options\":[\"A password hash\",\"A database file name\",\"A randomly generated technical identifier only\",\"A meaningful business attribute or combination that uniquely identifies an entity\"],\"answer\":3,\"rationale\":\"Natural keys derive from business meaning, such as a recognized registration code.\",\"difficulty\":\"Mixed\"},{\"id\":43,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Why use a surrogate key in a warehouse dimension?\",\"options\":[\"Provide a stable technical identifier independent of changing source keys\",\"Store documents\",\"Replace dimension attributes\",\"Eliminate all source mappings\"],\"answer\":0,\"rationale\":\"Surrogate keys support history and integration across changing or multiple source identifiers.\",\"difficulty\":\"Mixed\"},{\"id\":44,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What should happen when a model conflicts with an approved business definition?\",\"options\":[\"Let each developer choose\",\"Reconcile the model with governance and the accountable business owner\",\"Delete the model\",\"Ignore the glossary\"],\"answer\":1,\"rationale\":\"Models should faithfully represent governed business meaning.\",\"difficulty\":\"Mixed\"},{\"id\":45,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Which artifact maps a logical attribute to its physical column?\",\"options\":[\"A model mapping or transformation specification\",\"A firewall rule\",\"A retention schedule\",\"A meeting agenda\"],\"answer\":0,\"rationale\":\"Mapping documentation connects logical meaning to implementation and supports traceability.\",\"difficulty\":\"Mixed\"},{\"id\":46,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is the chief objective of data storage and operations?\",\"options\":[\"Assign data owners\",\"Maintain accessible, reliable, recoverable, and performant data platforms\",\"Design corporate logos\",\"Approve business definitions\"],\"answer\":1,\"rationale\":\"Operations manages the day-to-day technical environment and service continuity.\",\"difficulty\":\"Mixed\"},{\"id\":47,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What does Recovery Time Objective measure?\",\"options\":[\"Maximum acceptable data loss\",\"Retention duration\",\"Maximum targeted time to restore a service after disruption\",\"Average query size\"],\"answer\":2,\"rationale\":\"RTO concerns elapsed recovery time.\",\"difficulty\":\"Mixed\"},{\"id\":48,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What does Recovery Point Objective measure?\",\"options\":[\"Time to rebuild a server\",\"Annual storage growth\",\"Number of recovery staff\",\"Maximum acceptable period of data loss measured backward from an incident\"],\"answer\":3,\"rationale\":\"RPO determines how current recovered data must be.\",\"difficulty\":\"Mixed\"},{\"id\":49,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Why are recovery tests necessary even when backups succeed?\",\"options\":[\"A successful backup does not prove that restoration will work within objectives\",\"Backups automatically test every application\",\"Testing replaces retention policies\",\"Testing removes cyber risk\"],\"answer\":0,\"rationale\":\"Recoverability must be demonstrated through restoration and service exercises.\",\"difficulty\":\"Mixed\"},{\"id\":50,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is capacity management?\",\"options\":[\"Managing customer consent\",\"Designing taxonomies\",\"Forecasting and providing sufficient storage and compute resources\",\"Approving data definitions\"],\"answer\":2,\"rationale\":\"Capacity management anticipates growth and workload demand.\",\"difficulty\":\"Mixed\"},{\"id\":51,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Which metric most directly reflects service availability?\",\"options\":[\"Count of conceptual entities\",\"Percentage of agreed service time that the platform is usable\",\"Number of glossary terms\",\"Number of data owners\"],\"answer\":1,\"rationale\":\"Availability measures usable service relative to its agreed operating window.\",\"difficulty\":\"Mixed\"},{\"id\":52,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is archiving?\",\"options\":[\"Deleting all old data immediately\",\"Creating a new business term\",\"Copying production data for testing without controls\",\"Moving inactive information to managed long-term storage while retaining required access\"],\"answer\":3,\"rationale\":\"Archiving separates inactive data while preserving retention, protection, and retrievability.\",\"difficulty\":\"Mixed\"},{\"id\":53,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is the main risk of retaining data indefinitely?\",\"options\":[\"Guaranteed better quality\",\"Reduced security requirements\",\"Increased cost, exposure, and regulatory or legal risk\",\"Automatic lineage\"],\"answer\":2,\"rationale\":\"Unnecessary retention expands the attack surface and compliance burden.\",\"difficulty\":\"Mixed\"},{\"id\":54,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"A critical batch fails nightly. What is the first operational need?\",\"options\":[\"Detect, log, alert, and initiate documented incident handling\",\"Change the Data Owner\",\"Create a new taxonomy\",\"Redesign the enterprise glossary\"],\"answer\":0,\"rationale\":\"Reliable operations require timely detection, evidence, escalation, and recovery.\",\"difficulty\":\"Mixed\"},{\"id\":55,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is configuration management used for?\",\"options\":[\"Approve records disposition\",\"Calculate business KPIs\",\"Control and trace approved changes to platform configurations\",\"Define customer segments\"],\"answer\":2,\"rationale\":\"Configuration control supports stable and auditable environments.\",\"difficulty\":\"Mixed\"},{\"id\":56,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Which practice best protects backup confidentiality?\",\"options\":[\"Use shared administrator accounts\",\"Remove backup logs\",\"Store all backups publicly\",\"Encrypt backups and restrict access according to classification\"],\"answer\":3,\"rationale\":\"Backup copies require protections equivalent to the source data.\",\"difficulty\":\"Mixed\"},{\"id\":57,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is a service-level agreement?\",\"options\":[\"A master-data match rule\",\"A documented commitment for measurable service performance\",\"A business glossary\",\"A conceptual data model\"],\"answer\":1,\"rationale\":\"SLAs specify measurable expectations such as availability, response, and recovery.\",\"difficulty\":\"Mixed\"},{\"id\":58,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Why separate production and non-production environments?\",\"options\":[\"Avoid documenting changes\",\"Permit unrestricted data copying\",\"Eliminate testing\",\"Reduce operational risk and limit inappropriate access to live data\"],\"answer\":3,\"rationale\":\"Environment separation protects production and supports controlled testing.\",\"difficulty\":\"Mixed\"},{\"id\":59,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is a database health check intended to detect?\",\"options\":[\"Employee training needs only\",\"Unapproved business vocabulary only\",\"Marketing opportunities\",\"Emerging performance, capacity, integrity, or availability risks\"],\"answer\":3,\"rationale\":\"Health checks proactively assess technical service conditions.\",\"difficulty\":\"Mixed\"},{\"id\":60,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Who generally implements database permissions after business approval?\",\"options\":[\"The Data Owner alone in the database\",\"The DBA or platform operations team\",\"Any end user\",\"The Governance Council directly\"],\"answer\":1,\"rationale\":\"Business owners approve; authorized technical administrators implement and log access.\",\"difficulty\":\"Mixed\"},{\"id\":61,\"chapter\":\"5. Data Security\",\"question\":\"What does confidentiality protect?\",\"options\":[\"Document version numbering\",\"Data from unauthorized disclosure\",\"Service uptime only\",\"Data from all changes\"],\"answer\":1,\"rationale\":\"Confidentiality limits information exposure to authorized parties.\",\"difficulty\":\"Mixed\"},{\"id\":62,\"chapter\":\"5. Data Security\",\"question\":\"What does integrity protect?\",\"options\":[\"Data from unauthorized or improper alteration\",\"Only storage cost\",\"Only file discoverability\",\"Only system availability\"],\"answer\":0,\"rationale\":\"Integrity preserves correctness and trustworthiness against improper change.\",\"difficulty\":\"Mixed\"},{\"id\":63,\"chapter\":\"5. Data Security\",\"question\":\"What does availability ensure?\",\"options\":[\"All data is public\",\"All records are permanent\",\"All databases use one vendor\",\"Authorized users can access data and services when required\"],\"answer\":3,\"rationale\":\"Availability concerns reliable, timely access for authorized use.\",\"difficulty\":\"Mixed\"},{\"id\":64,\"chapter\":\"5. Data Security\",\"question\":\"What is least privilege?\",\"options\":[\"Allowing permanent access by default\",\"Sharing service accounts\",\"Giving all managers administrator rights\",\"Granting only the minimum access needed for assigned duties\"],\"answer\":3,\"rationale\":\"Least privilege limits exposure and reduces the impact of misuse or compromise.\",\"difficulty\":\"Mixed\"},{\"id\":65,\"chapter\":\"5. Data Security\",\"question\":\"What is separation of duties?\",\"options\":[\"Giving one person end-to-end control\",\"Storing all data in separate tables\",\"Dividing conflicting responsibilities among different people or roles\",\"Removing approval steps\"],\"answer\":2,\"rationale\":\"Separation reduces fraud and error by preventing incompatible powers from residing in one role.\",\"difficulty\":\"Mixed\"},{\"id\":66,\"chapter\":\"5. Data Security\",\"question\":\"Why classify data?\",\"options\":[\"Replace metadata\",\"Apply protection based on sensitivity, value, and obligations\",\"Improve query joins\",\"Eliminate access reviews\"],\"answer\":1,\"rationale\":\"Classification connects business sensitivity to appropriate controls.\",\"difficulty\":\"Mixed\"},{\"id\":67,\"chapter\":\"5. Data Security\",\"question\":\"Which control protects data in transit?\",\"options\":[\"Encrypted communication such as approved TLS\",\"A taxonomy\",\"A conceptual model\",\"A database index\"],\"answer\":0,\"rationale\":\"Transport encryption protects data while crossing networks.\",\"difficulty\":\"Mixed\"},{\"id\":68,\"chapter\":\"5. Data Security\",\"question\":\"Which control most directly protects data at rest?\",\"options\":[\"A data-flow diagram\",\"A report filter\",\"A glossary definition\",\"Approved storage or database encryption\"],\"answer\":3,\"rationale\":\"At-rest encryption protects stored copies and media.\",\"difficulty\":\"Mixed\"},{\"id\":69,\"chapter\":\"5. Data Security\",\"question\":\"What is multi-factor authentication?\",\"options\":[\"Entering the same PIN twice\",\"Authentication using evidence from more than one factor category\",\"Using two passwords\",\"Approving two reports\"],\"answer\":1,\"rationale\":\"MFA combines distinct factors such as knowledge, possession, or inherence.\",\"difficulty\":\"Mixed\"},{\"id\":70,\"chapter\":\"5. Data Security\",\"question\":\"Why are privileged accounts monitored more closely?\",\"options\":[\"They are used only for reporting\",\"They always contain better data\",\"They can perform high-impact administrative actions\",\"They require no approval\"],\"answer\":2,\"rationale\":\"Elevated permissions create greater risk and require stronger oversight.\",\"difficulty\":\"Mixed\"},{\"id\":71,\"chapter\":\"5. Data Security\",\"question\":\"What is data masking used for?\",\"options\":[\"Create primary keys\",\"Hide or transform sensitive values while preserving permitted use\",\"Schedule backups\",\"Build taxonomies\"],\"answer\":1,\"rationale\":\"Masking reduces exposure in displays, testing, or analytics.\",\"difficulty\":\"Mixed\"},{\"id\":72,\"chapter\":\"5. Data Security\",\"question\":\"A former employee retains access. Which control failed most directly?\",\"options\":[\"Timely identity deprovisioning\",\"Dimensional modeling\",\"Metadata harvesting\",\"Data profiling\"],\"answer\":0,\"rationale\":\"Joiner-mover-leaver controls should promptly remove access after departure.\",\"difficulty\":\"Mixed\"},{\"id\":73,\"chapter\":\"5. Data Security\",\"question\":\"What is the purpose of security audit logging?\",\"options\":[\"Create evidence of access, changes, and significant events\",\"Improve normalization\",\"Define business terms\",\"Replace incident response\"],\"answer\":0,\"rationale\":\"Logs support monitoring, investigation, accountability, and compliance.\",\"difficulty\":\"Mixed\"},{\"id\":74,\"chapter\":\"5. Data Security\",\"question\":\"Who should decide the acceptable business use of sensitive data?\",\"options\":[\"A developer acting alone\",\"The software vendor\",\"The accountable business owner under governance, privacy, and security rules\",\"Any system administrator\"],\"answer\":2,\"rationale\":\"Use decisions require business accountability within applicable rules and risk controls.\",\"difficulty\":\"Mixed\"},{\"id\":75,\"chapter\":\"5. Data Security\",\"question\":\"What is defense in depth?\",\"options\":[\"Using multiple complementary security controls across layers\",\"Using only physical security\",\"Relying on one strong password\",\"Removing duplicate controls\"],\"answer\":0,\"rationale\":\"Layered controls reduce dependence on a single preventive mechanism.\",\"difficulty\":\"Mixed\"},{\"id\":76,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is the basic purpose of data integration?\",\"options\":[\"Replace data modeling\",\"Define document retention\",\"Move, combine, and synchronize data across sources and consumers\",\"Approve business budgets\"],\"answer\":2,\"rationale\":\"Integration enables coordinated data use across systems and processes.\",\"difficulty\":\"Mixed\"},{\"id\":77,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What does interoperability add beyond data movement?\",\"options\":[\"Shared ability to interpret and use exchanged information correctly\",\"Faster password resets\",\"Larger storage capacity\",\"More document versions\"],\"answer\":0,\"rationale\":\"Interoperability includes syntactic and semantic understanding.\",\"difficulty\":\"Mixed\"},{\"id\":78,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is a source-to-target mapping?\",\"options\":[\"A backup schedule\",\"A security classification list\",\"A specification linking source elements to target elements and transformations\",\"A RACI matrix\"],\"answer\":2,\"rationale\":\"Mappings make integration logic explicit and testable.\",\"difficulty\":\"Mixed\"},{\"id\":79,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What does ETL mean?\",\"options\":[\"Extract, Transform, Load\",\"Encrypt, Test, Log\",\"Evaluate, Transfer, Link\",\"Extract, Track, List\"],\"answer\":0,\"rationale\":\"ETL transforms data before loading it into the target.\",\"difficulty\":\"Mixed\"},{\"id\":80,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What distinguishes ELT?\",\"options\":[\"It eliminates quality controls\",\"It requires no extraction\",\"Data is loaded before target-platform transformations are applied\",\"It is always real time\"],\"answer\":2,\"rationale\":\"ELT uses target processing capabilities after initial loading.\",\"difficulty\":\"Mixed\"},{\"id\":81,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"When is an event-driven pattern appropriate?\",\"options\":[\"When consumers need timely notification of business state changes\",\"When systems must remain completely disconnected\",\"When no event can be defined\",\"When annual archiving is the only need\"],\"answer\":0,\"rationale\":\"Events support decoupled, near-real-time reactions to business changes.\",\"difficulty\":\"Mixed\"},{\"id\":82,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is the purpose of a dead-letter queue?\",\"options\":[\"Retain messages that cannot be processed for investigation or controlled retry\",\"Store master data permanently\",\"Replace monitoring\",\"Delete all failed messages silently\"],\"answer\":0,\"rationale\":\"Dead-letter handling prevents silent loss and supports remediation.\",\"difficulty\":\"Mixed\"},{\"id\":83,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is idempotency in integration?\",\"options\":[\"Mappings never change\",\"All messages are anonymous\",\"Every retry creates a new transaction\",\"Repeated processing of the same request has no additional unintended effect\"],\"answer\":3,\"rationale\":\"Idempotent design supports safe retry after uncertain outcomes.\",\"difficulty\":\"Mixed\"},{\"id\":84,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Why use correlation identifiers?\",\"options\":[\"Encrypt backups\",\"Create document taxonomies\",\"Trace one business transaction across services and logs\",\"Define retention periods\"],\"answer\":2,\"rationale\":\"Correlation IDs improve end-to-end observability and troubleshooting.\",\"difficulty\":\"Mixed\"},{\"id\":85,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is change data capture?\",\"options\":[\"Capturing screenshots of reports\",\"Archiving documents\",\"Changing all source keys\",\"Identifying and propagating data changes since a previous point\"],\"answer\":3,\"rationale\":\"CDC enables efficient incremental integration.\",\"difficulty\":\"Mixed\"},{\"id\":86,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What should happen to records that fail validation?\",\"options\":[\"Delete all source data\",\"Disable validation\",\"Quarantine or reject them with logged reasons and accountable remediation\",\"Load them silently\"],\"answer\":2,\"rationale\":\"Controlled exception handling prevents contamination and supports correction.\",\"difficulty\":\"Mixed\"},{\"id\":87,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Why is reconciliation performed?\",\"options\":[\"Define business ownership\",\"Confirm that expected records and values arrived accurately and completely\",\"Choose a database vendor\",\"Create a conceptual model\"],\"answer\":1,\"rationale\":\"Reconciliation detects loss, duplication, and transformation errors.\",\"difficulty\":\"Mixed\"},{\"id\":88,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is data virtualization?\",\"options\":[\"Providing governed access across sources without necessarily copying all data\",\"Replacing metadata\",\"Encrypting virtual machines\",\"Creating duplicate master records\"],\"answer\":0,\"rationale\":\"Virtualization presents integrated views while leaving data in underlying sources.\",\"difficulty\":\"Mixed\"},{\"id\":89,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is API versioning intended to manage?\",\"options\":[\"Database backup rotation\",\"Data-owner succession\",\"Controlled evolution of interfaces without unexpectedly breaking consumers\",\"Document disposal\"],\"answer\":2,\"rationale\":\"Versioning allows interfaces and consumers to evolve safely.\",\"difficulty\":\"Mixed\"},{\"id\":90,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Which artifact should connect integration requirements to the implemented flow?\",\"options\":[\"A standalone logo\",\"A printer inventory\",\"Traceability from requirement through design, mapping, tests, and monitoring\",\"An employee directory\"],\"answer\":2,\"rationale\":\"Traceability demonstrates that implemented integration satisfies approved requirements.\",\"difficulty\":\"Mixed\"},{\"id\":91,\"chapter\":\"7. Document and Content Management\",\"question\":\"What type of information is a primary focus of document and content management?\",\"options\":[\"Only database indexes\",\"Only relational keys\",\"Unstructured and semi-structured information such as documents, images, and media\",\"Only numerical measures\"],\"answer\":2,\"rationale\":\"DCM governs content that is not primarily managed as structured rows and columns.\",\"difficulty\":\"Mixed\"},{\"id\":92,\"chapter\":\"7. Document and Content Management\",\"question\":\"What makes a document a record?\",\"options\":[\"It has more than ten pages\",\"It is stored as PDF\",\"It contains a table\",\"It is retained as evidence of a business activity or obligation\"],\"answer\":3,\"rationale\":\"Record status depends on evidentiary and retention value, not file format.\",\"difficulty\":\"Mixed\"},{\"id\":93,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is version control intended to prevent?\",\"options\":[\"All document search\",\"Use of uncontrolled or obsolete document revisions\",\"All collaboration\",\"All metadata capture\"],\"answer\":1,\"rationale\":\"Version control identifies approved revisions and preserves change history.\",\"difficulty\":\"Mixed\"},{\"id\":94,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a retention schedule?\",\"options\":[\"An ETL timetable\",\"A database execution plan\",\"An access-control matrix only\",\"Rules defining how long categories of records are kept and their final disposition\"],\"answer\":3,\"rationale\":\"Retention schedules link record classes to legal, regulatory, and business requirements.\",\"difficulty\":\"Mixed\"},{\"id\":95,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a legal hold?\",\"options\":[\"A password reset\",\"A suspension of normal disposition for information relevant to a legal matter\",\"A physical data model\",\"Automatic deletion of evidence\"],\"answer\":1,\"rationale\":\"A hold preserves potentially relevant information until released.\",\"difficulty\":\"Mixed\"},{\"id\":96,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a taxonomy?\",\"options\":[\"A database transaction\",\"A data-quality score\",\"A backup-copy type\",\"A hierarchical classification structure for organizing concepts or content\"],\"answer\":3,\"rationale\":\"Taxonomies use broader and narrower category relationships.\",\"difficulty\":\"Mixed\"},{\"id\":97,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is faceted classification?\",\"options\":[\"Encrypting each document twice\",\"Creating one category per file\",\"Classifying content using several independent metadata dimensions\",\"Using only one folder tree\"],\"answer\":2,\"rationale\":\"Facets allow filtering by dimensions such as type, department, product, and status.\",\"difficulty\":\"Mixed\"},{\"id\":98,\"chapter\":\"7. Document and Content Management\",\"question\":\"Which metadata most improves retrieval of a supplier contract?\",\"options\":[\"Supplier, document type, effective date, status, and owner\",\"CPU temperature\",\"Network hop count\",\"Database buffer size\"],\"answer\":0,\"rationale\":\"Descriptive and administrative metadata makes content discoverable and governable.\",\"difficulty\":\"Mixed\"},{\"id\":99,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is check-in\/check-out used for?\",\"options\":[\"Coordinate editing and prevent conflicting document changes\",\"Dispose of records\",\"Assign customer identifiers\",\"Design schemas\"],\"answer\":0,\"rationale\":\"The mechanism controls concurrent editing and preserves revision integrity.\",\"difficulty\":\"Mixed\"},{\"id\":100,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is records disposition?\",\"options\":[\"Renaming a file\",\"Adding a watermark\",\"Informal deletion by any user\",\"Authorized destruction or permanent transfer after retention requirements are met\"],\"answer\":3,\"rationale\":\"Disposition must be controlled, documented, and suspended when required.\",\"difficulty\":\"Mixed\"},{\"id\":101,\"chapter\":\"7. Document and Content Management\",\"question\":\"Why is full-text search alone insufficient?\",\"options\":[\"It always provides perfect results\",\"It may miss context, classification, ownership, and controlled meaning\",\"It replaces access controls\",\"It makes metadata illegal\"],\"answer\":1,\"rationale\":\"Good discovery combines content indexing with governed metadata.\",\"difficulty\":\"Mixed\"},{\"id\":102,\"chapter\":\"7. Document and Content Management\",\"question\":\"A production operator uses an obsolete work instruction. Which capability failed?\",\"options\":[\"Normalization\",\"Change data capture\",\"Controlled publication and version management\",\"Dimensional modeling\"],\"answer\":2,\"rationale\":\"Only the current approved instruction should be available for operational use.\",\"difficulty\":\"Mixed\"},{\"id\":103,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is the relationship between content management and security?\",\"options\":[\"Content access and handling must follow classification and authorization rules\",\"Public links are always acceptable\",\"Security applies only to databases\",\"Content never contains sensitive data\"],\"answer\":0,\"rationale\":\"Documents and media may contain sensitive information requiring equivalent protection.\",\"difficulty\":\"Mixed\"},{\"id\":104,\"chapter\":\"7. Document and Content Management\",\"question\":\"Why audit content access?\",\"options\":[\"Increase document length\",\"Replace retention schedules\",\"Provide evidence of viewing, editing, sharing, and disposition actions\",\"Eliminate classification\"],\"answer\":2,\"rationale\":\"Audit trails support accountability, investigations, and compliance.\",\"difficulty\":\"Mixed\"},{\"id\":105,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is the best governance approach to shared-drive sprawl?\",\"options\":[\"Delete the entire drive immediately\",\"Inventory, classify, assign ownership, apply retention, and migrate or dispose systematically\",\"Allow anonymous public access\",\"Keep every file forever\"],\"answer\":1,\"rationale\":\"A risk-based information lifecycle approach avoids both uncontrolled retention and indiscriminate deletion.\",\"difficulty\":\"Mixed\"},{\"id\":106,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What does master data primarily represent?\",\"options\":[\"One-time business events only\",\"Technical logs only\",\"Core business entities shared across processes and systems\",\"Document versions only\"],\"answer\":2,\"rationale\":\"Master data describes persistent entities such as product, customer, supplier, and location.\",\"difficulty\":\"Mixed\"},{\"id\":107,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What does reference data primarily provide?\",\"options\":[\"Unstructured media\",\"Controlled values used to classify or constrain other data\",\"Complete transaction histories\",\"Database execution plans\"],\"answer\":1,\"rationale\":\"Reference data includes codes, statuses, units, and classifications.\",\"difficulty\":\"Mixed\"},{\"id\":108,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which is most likely master data?\",\"options\":[\"Supplier\",\"Invoice line\",\"Login event\",\"Purchase order\"],\"answer\":0,\"rationale\":\"A supplier is a reusable core business entity.\",\"difficulty\":\"Mixed\"},{\"id\":109,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which is most likely reference data?\",\"options\":[\"Unit-of-measure code\",\"Customer account\",\"Payment transaction\",\"Production order\"],\"answer\":0,\"rationale\":\"Units of measure form a controlled list used by master and transactional data.\",\"difficulty\":\"Mixed\"},{\"id\":110,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is a golden record?\",\"options\":[\"A glossary definition\",\"A permanent backup of every transaction\",\"The trusted, consolidated representation of a master-data entity\",\"A security audit log\"],\"answer\":2,\"rationale\":\"The golden record represents the reconciled best view of an entity.\",\"difficulty\":\"Mixed\"},{\"id\":111,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is entity resolution?\",\"options\":[\"Creating database indexes\",\"Determining which records refer to the same real-world entity\",\"Classifying documents\",\"Deleting every similar record\"],\"answer\":1,\"rationale\":\"Entity resolution uses matching evidence to identify duplicates and relationships.\",\"difficulty\":\"Mixed\"},{\"id\":112,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is survivorship in MDM?\",\"options\":[\"Deleting reference values\",\"Rules selecting trusted attribute values when sources conflict\",\"Keeping only the oldest database\",\"Choosing the cheapest vendor\"],\"answer\":1,\"rationale\":\"Survivorship determines which source or value wins for each attribute.\",\"difficulty\":\"Mixed\"},{\"id\":113,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which MDM style maintains cross-references while source systems continue to own records?\",\"options\":[\"Registry style\",\"Document archive\",\"Star schema\",\"Transactional hub only\"],\"answer\":0,\"rationale\":\"Registry MDM links identities across sources without necessarily centralizing all attributes.\",\"difficulty\":\"Mixed\"},{\"id\":114,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which MDM style creates a central hub that authors and distributes master records?\",\"options\":[\"Document versioning\",\"Transactional or centralized authoring style\",\"Registry-only style\",\"Unmanaged replication\"],\"answer\":1,\"rationale\":\"A transactional hub acts as a central system for master-data creation and maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":115,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Why assign a master-data owner?\",\"options\":[\"Establish accountability for definitions, rules, quality, and access decisions\",\"Remove stewardship\",\"Avoid governance reviews\",\"Give one person all database passwords\"],\"answer\":0,\"rationale\":\"Ownership provides accountable business decision authority.\",\"difficulty\":\"Mixed\"},{\"id\":116,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is reference-data mapping?\",\"options\":[\"Defining backup media\",\"Relating code sets or values used by different systems\",\"Mapping office locations\",\"Creating document folders\"],\"answer\":1,\"rationale\":\"Mappings translate equivalent or related codes across sources and standards.\",\"difficulty\":\"Mixed\"},{\"id\":117,\"chapter\":\"8. Reference and Master Data\",\"question\":\"A system uses KG and another uses KGM. What is the principal requirement?\",\"options\":[\"A longer retention period\",\"Governed unit-code mapping and semantic equivalence\",\"More duplicate product records\",\"Removal of all units\"],\"answer\":1,\"rationale\":\"Interoperability requires controlled meanings and mappings for reference values.\",\"difficulty\":\"Mixed\"},{\"id\":118,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Why measure duplicate rate in customer master data?\",\"options\":[\"It indicates uniqueness problems and possible fragmented customer views\",\"It measures system uptime\",\"It defines document taxonomy\",\"It proves encryption strength\"],\"answer\":0,\"rationale\":\"Duplicate rate is a core MDM quality indicator.\",\"difficulty\":\"Mixed\"},{\"id\":119,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is hierarchy management in MDM?\",\"options\":[\"Managing governed parent-child and grouping relationships among master entities\",\"Encrypting messages\",\"Managing file folders only\",\"Scheduling ETL jobs\"],\"answer\":0,\"rationale\":\"Examples include product categories, organizational structures, and customer households or groups.\",\"difficulty\":\"Mixed\"},{\"id\":120,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What should happen before merging suspected duplicate suppliers?\",\"options\":[\"Merge every similar name automatically\",\"Apply matching evidence, stewardship review, and approved merge rules\",\"Ask the DBA to guess\",\"Delete both records\"],\"answer\":1,\"rationale\":\"Merges affect identity and downstream processes, so they require controlled evidence and oversight.\",\"difficulty\":\"Mixed\"},{\"id\":121,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is the primary purpose of a data warehouse?\",\"options\":[\"Provide integrated historical data for analysis and decision support\",\"Store only document images\",\"Manage user passwords\",\"Process every operational transaction\"],\"answer\":0,\"rationale\":\"Warehouses support analytical workloads across subject areas and time.\",\"difficulty\":\"Mixed\"},{\"id\":122,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does subject-oriented mean in a warehouse?\",\"options\":[\"Data is organized by server brand\",\"Every table belongs to one user\",\"Data is stored without business context\",\"Data is organized around major business subjects such as customer or sales\"],\"answer\":3,\"rationale\":\"Subject orientation aligns analytical data with business areas.\",\"difficulty\":\"Mixed\"},{\"id\":123,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does time-variant mean?\",\"options\":[\"Only current data is retained\",\"Historical states are retained and associated with time\",\"Time zones are ignored\",\"The database clock changes often\"],\"answer\":1,\"rationale\":\"Warehouses support analysis across periods by retaining history.\",\"difficulty\":\"Mixed\"},{\"id\":124,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does non-volatile mean in the classic warehouse definition?\",\"options\":[\"All data is immutable forever\",\"Data can never be corrected\",\"Warehouse data is mainly loaded and read rather than used for operational updates\",\"The system needs no backup\"],\"answer\":2,\"rationale\":\"Analytical repositories are optimized for stable historical use rather than transaction processing.\",\"difficulty\":\"Mixed\"},{\"id\":125,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a fact table?\",\"options\":[\"A table holding measurements at a declared business-process grain\",\"A list of user roles\",\"A document library\",\"A table of glossary definitions\"],\"answer\":0,\"rationale\":\"Facts capture measurable events such as sales quantity or production cost.\",\"difficulty\":\"Mixed\"},{\"id\":126,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a dimension table?\",\"options\":[\"A table containing only error logs\",\"A backup catalog\",\"A security policy\",\"A table providing descriptive context for facts\"],\"answer\":3,\"rationale\":\"Dimensions support slicing facts by product, customer, location, time, and other context.\",\"difficulty\":\"Mixed\"},{\"id\":127,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"Why must the grain of a fact table be declared?\",\"options\":[\"It determines password length\",\"It replaces data quality rules\",\"It defines exactly what one fact row represents\",\"It selects the BI tool\"],\"answer\":2,\"rationale\":\"Clear grain prevents mixing incompatible levels of detail.\",\"difficulty\":\"Mixed\"},{\"id\":128,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a conformed dimension?\",\"options\":[\"An encrypted fact table\",\"A deleted dimension\",\"A dimension used by one report only\",\"A consistently defined dimension shared across analytical processes\"],\"answer\":3,\"rationale\":\"Conformed dimensions enable comparable analysis across marts.\",\"difficulty\":\"Mixed\"},{\"id\":129,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a slowly changing dimension?\",\"options\":[\"A method for managing changes to descriptive dimension attributes over time\",\"A slow ETL job\",\"An archived report\",\"A rarely used fact\"],\"answer\":0,\"rationale\":\"SCD techniques determine whether history is overwritten, retained, or versioned.\",\"difficulty\":\"Mixed\"},{\"id\":130,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What characterizes a star schema?\",\"options\":[\"A central fact table connected to denormalized dimensions\",\"A network topology\",\"Only normalized operational tables\",\"Documents arranged in folders\"],\"answer\":0,\"rationale\":\"Star schemas simplify business analysis and query navigation.\",\"difficulty\":\"Mixed\"},{\"id\":131,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a data mart?\",\"options\":[\"A backup device\",\"A metadata-only repository\",\"An analytical subset focused on a subject, process, or business community\",\"A transactional ERP module\"],\"answer\":2,\"rationale\":\"Data marts deliver focused analytical content under an enterprise integration approach.\",\"difficulty\":\"Mixed\"},{\"id\":132,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"How does Kimball's approach generally begin?\",\"options\":[\"Use only unstructured data\",\"Build one normalized enterprise warehouse before any delivery\",\"Avoid facts and dimensions\",\"Build dimensional solutions by business process using conformed dimensions\"],\"answer\":3,\"rationale\":\"Kimball emphasizes incremental dimensional delivery integrated through conformance.\",\"difficulty\":\"Mixed\"},{\"id\":133,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"How does Inmon's classic approach generally position the enterprise warehouse?\",\"options\":[\"As a document taxonomy\",\"As an API gateway\",\"As a collection of unrelated spreadsheets\",\"As an integrated enterprise repository feeding downstream analytical use\"],\"answer\":3,\"rationale\":\"Inmon emphasizes a centralized integrated enterprise warehouse.\",\"difficulty\":\"Mixed\"},{\"id\":134,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"Why govern KPI definitions?\",\"options\":[\"Avoid documenting formulas\",\"Increase dashboard color choices\",\"Eliminate measurement ownership\",\"Ensure reports calculate and interpret measures consistently\"],\"answer\":3,\"rationale\":\"Governed definitions reduce conflicting results and improve trust.\",\"difficulty\":\"Mixed\"},{\"id\":135,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is self-service BI's main governance challenge?\",\"options\":[\"Prevent all business users from analyzing data\",\"Make every dataset public\",\"Replace the warehouse with email\",\"Enable user autonomy without losing definition, quality, security, and lineage controls\"],\"answer\":3,\"rationale\":\"Successful self-service balances agility with trustworthy governed data.\",\"difficulty\":\"Mixed\"},{\"id\":136,\"chapter\":\"10. Metadata Management\",\"question\":\"What is metadata?\",\"options\":[\"Only master-data values\",\"Only transactional records\",\"Only database backups\",\"Information that describes, explains, locates, or governs data and content\"],\"answer\":3,\"rationale\":\"Metadata supplies context needed to understand and manage information assets.\",\"difficulty\":\"Mixed\"},{\"id\":137,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is business metadata?\",\"options\":[\"An ETL execution duration\",\"The approved definition and owner of 'Net Revenue'\",\"A server IP address\",\"A column data type\"],\"answer\":1,\"rationale\":\"Business metadata captures meaning, rules, ownership, and business context.\",\"difficulty\":\"Mixed\"},{\"id\":138,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is technical metadata?\",\"options\":[\"A policy exception rationale\",\"A retention justification\",\"A KPI owner only\",\"Table, column, data type, and constraint definitions\"],\"answer\":3,\"rationale\":\"Technical metadata describes implemented structures and interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":139,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is operational metadata?\",\"options\":[\"Pipeline run time, row count, status, and error details\",\"A product taxonomy\",\"A conceptual entity\",\"The definition of Customer\"],\"answer\":0,\"rationale\":\"Operational metadata explains processing behavior and outcomes.\",\"difficulty\":\"Mixed\"},{\"id\":140,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a business glossary?\",\"options\":[\"A governed collection of business terms, definitions, and related attributes\",\"A set of source-code comments\",\"A file-system directory\",\"A database backup list\"],\"answer\":0,\"rationale\":\"A glossary establishes shared business meaning.\",\"difficulty\":\"Mixed\"},{\"id\":141,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a data catalog?\",\"options\":[\"A transaction-processing system\",\"A physical backup vault\",\"A searchable inventory of data assets enriched with metadata\",\"A document scanner\"],\"answer\":2,\"rationale\":\"Catalogs support discovery, understanding, evaluation, and governed access.\",\"difficulty\":\"Mixed\"},{\"id\":142,\"chapter\":\"10. Metadata Management\",\"question\":\"What does data lineage describe?\",\"options\":[\"Only retention periods\",\"Only reporting hierarchies\",\"Only entity ownership\",\"Origins, movements, transformations, and uses of data\"],\"answer\":3,\"rationale\":\"Lineage connects source data through processing to downstream consumption.\",\"difficulty\":\"Mixed\"},{\"id\":143,\"chapter\":\"10. Metadata Management\",\"question\":\"What is business lineage?\",\"options\":[\"A business-oriented view of how information supports processes and outcomes\",\"A network route\",\"A list of database pages\",\"A password history\"],\"answer\":0,\"rationale\":\"Business lineage expresses flow and impact in terms meaningful to stakeholders.\",\"difficulty\":\"Mixed\"},{\"id\":144,\"chapter\":\"10. Metadata Management\",\"question\":\"What is technical lineage?\",\"options\":[\"Detailed field, table, job, and transformation dependencies\",\"A taxonomy of documents\",\"A list of business sponsors only\",\"A records schedule\"],\"answer\":0,\"rationale\":\"Technical lineage supports troubleshooting, impact analysis, and controls.\",\"difficulty\":\"Mixed\"},{\"id\":145,\"chapter\":\"10. Metadata Management\",\"question\":\"What is metadata harvesting?\",\"options\":[\"Encryption of every column\",\"Automated extraction of metadata from technical sources\",\"Manual deletion of old reports\",\"Creation of transaction data\"],\"answer\":1,\"rationale\":\"Harvesting scanners collect schemas, relationships, jobs, and other technical metadata.\",\"difficulty\":\"Mixed\"},{\"id\":146,\"chapter\":\"10. Metadata Management\",\"question\":\"Why is metadata stewardship needed?\",\"options\":[\"Ensure definitions and metadata remain accurate, complete, approved, and current\",\"Replace all technical administrators\",\"Operate network devices\",\"Approve company travel\"],\"answer\":0,\"rationale\":\"Metadata degrades without accountable maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":147,\"chapter\":\"10. Metadata Management\",\"question\":\"What is an impact analysis?\",\"options\":[\"A survey of office furniture\",\"Assessment of downstream assets affected by a proposed change\",\"A storage invoice calculation\",\"A backup rotation\"],\"answer\":1,\"rationale\":\"Metadata dependencies help teams identify consumers and risks before change.\",\"difficulty\":\"Mixed\"},{\"id\":148,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a controlled vocabulary?\",\"options\":[\"A database transaction log\",\"An approved set of terms used consistently for description or classification\",\"Every word used by employees\",\"A list of passwords\"],\"answer\":1,\"rationale\":\"Controlled vocabularies reduce ambiguity and improve retrieval and interoperability.\",\"difficulty\":\"Mixed\"},{\"id\":149,\"chapter\":\"10. Metadata Management\",\"question\":\"A catalog shows a data set but no owner, definition, or lineage. What is the main issue?\",\"options\":[\"The catalog replaces governance\",\"The data set is automatically high quality\",\"The data set must be deleted\",\"The catalog entry is discoverable but insufficiently trustworthy and actionable\"],\"answer\":3,\"rationale\":\"Useful catalog entries need meaningful context, accountability, and traceability.\",\"difficulty\":\"Mixed\"},{\"id\":150,\"chapter\":\"10. Metadata Management\",\"question\":\"Why is metadata called a cross-cutting capability?\",\"options\":[\"It applies only to databases\",\"It eliminates the need for other disciplines\",\"It supports governance, quality, security, integration, analytics, and operations\",\"It is independent of business meaning\"],\"answer\":2,\"rationale\":\"Metadata connects and informs nearly all data-management practices.\",\"difficulty\":\"Mixed\"},{\"id\":151,\"chapter\":\"11. Data Quality\",\"question\":\"What is the most useful general definition of data quality?\",\"options\":[\"The degree to which data is fit for its intended use\",\"The speed of database processing\",\"The volume of data under management\",\"The absence of every possible defect\"],\"answer\":0,\"rationale\":\"Quality is contextual: data must satisfy agreed business and user requirements.\",\"difficulty\":\"Easy\"},{\"id\":152,\"chapter\":\"11. Data Quality\",\"question\":\"Which dimension asks whether data correctly represents the real-world object or event?\",\"options\":[\"Completeness\",\"Accuracy\",\"Availability\",\"Uniqueness\"],\"answer\":1,\"rationale\":\"Accuracy compares recorded data with reality or an authoritative source.\",\"difficulty\":\"Easy\"},{\"id\":153,\"chapter\":\"11. Data Quality\",\"question\":\"A supplier record has no tax identifier even though it is mandatory. Which dimension is affected?\",\"options\":[\"Consistency\",\"Uniqueness\",\"Completeness\",\"Timeliness\"],\"answer\":2,\"rationale\":\"Completeness measures whether required values are present.\",\"difficulty\":\"Easy\"},{\"id\":154,\"chapter\":\"11. Data Quality\",\"question\":\"CRM classifies a customer as Active while ERP classifies the same customer as Inactive. What is the primary issue?\",\"options\":[\"Accessibility\",\"Consistency\",\"Uniqueness\",\"Precision\"],\"answer\":1,\"rationale\":\"Consistency concerns agreement across representations, data stores, or rules.\",\"difficulty\":\"Easy\"},{\"id\":155,\"chapter\":\"11. Data Quality\",\"question\":\"A country field contains XX99 although only ISO country codes are allowed. Which dimension fails?\",\"options\":[\"Timeliness\",\"Accuracy\",\"Validity\",\"Completeness\"],\"answer\":2,\"rationale\":\"Validity checks conformance with permitted formats, domains, and rules.\",\"difficulty\":\"Easy\"},{\"id\":156,\"chapter\":\"11. Data Quality\",\"question\":\"The same legal supplier appears in four records. Which dimension is primarily affected?\",\"options\":[\"Completeness\",\"Timeliness\",\"Uniqueness\",\"Accuracy\"],\"answer\":2,\"rationale\":\"Uniqueness concerns inappropriate duplicate representation of the same entity.\",\"difficulty\":\"Easy\"},{\"id\":157,\"chapter\":\"11. Data Quality\",\"question\":\"An order references a customer identifier that does not exist. Which quality concern is most direct?\",\"options\":[\"Precision\",\"Referential integrity\",\"Timeliness\",\"Formatting\"],\"answer\":1,\"rationale\":\"Referential integrity requires referenced parent records to exist.\",\"difficulty\":\"Easy\"},{\"id\":158,\"chapter\":\"11. Data Quality\",\"question\":\"A production reading arrives after the decision window has closed. Which dimension is affected?\",\"options\":[\"Validity\",\"Completeness\",\"Timeliness\",\"Uniqueness\"],\"answer\":2,\"rationale\":\"Timeliness considers whether data is sufficiently current and available when required.\",\"difficulty\":\"Easy\"},{\"id\":159,\"chapter\":\"11. Data Quality\",\"question\":\"Who is normally accountable for accepting quality thresholds for a business data domain?\",\"options\":[\"The database vendor\",\"Any report developer\",\"The network administrator\",\"The Data Owner\"],\"answer\":3,\"rationale\":\"The Data Owner is accountable for business requirements and acceptable quality.\",\"difficulty\":\"Easy\"},{\"id\":160,\"chapter\":\"11. Data Quality\",\"question\":\"What is a Critical Data Element?\",\"options\":[\"A data element prioritized because of business value, risk, or obligation\",\"Every column in every database\",\"Any value containing a number\",\"Only data used by executives\"],\"answer\":0,\"rationale\":\"CDEs focus quality investment on data that matters most.\",\"difficulty\":\"Easy\"},{\"id\":161,\"chapter\":\"11. Data Quality\",\"question\":\"What is data profiling?\",\"options\":[\"Encryption of sensitive columns\",\"Systematic analysis of data values, patterns, structures, and anomalies\",\"Manual approval of every record\",\"Design of a conceptual data model\"],\"answer\":1,\"rationale\":\"Profiling establishes empirical facts about data condition and structure.\",\"difficulty\":\"Easy\"},{\"id\":162,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a preventive data-quality control?\",\"options\":[\"A steward correcting an invalid record\",\"A post-incident root-cause review\",\"A mandatory-field validation at data entry\",\"A monthly duplicate report\"],\"answer\":2,\"rationale\":\"Preventive controls stop or reduce defects before acceptance.\",\"difficulty\":\"Easy\"},{\"id\":163,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a detective data-quality control?\",\"options\":[\"A steward merging duplicates\",\"A schema design standard\",\"A drop-down list of permitted codes\",\"A dashboard showing invalid product codes\"],\"answer\":3,\"rationale\":\"Detective controls reveal defects that already exist or have entered a process.\",\"difficulty\":\"Easy\"},{\"id\":164,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a corrective data-quality control?\",\"options\":[\"A reconciliation report identifies differences\",\"A steward repairs incorrect supplier classifications\",\"An input mask blocks bad formats\",\"A policy defines ownership\"],\"answer\":1,\"rationale\":\"Corrective controls remediate identified defects.\",\"difficulty\":\"Easy\"},{\"id\":165,\"chapter\":\"11. Data Quality\",\"question\":\"Why is root-cause analysis important?\",\"options\":[\"It targets the process or control that creates recurring defects\",\"It guarantees perfect data\",\"It replaces quality measurement\",\"It eliminates the need for ownership\"],\"answer\":0,\"rationale\":\"Fixing causes is more sustainable than repeatedly correcting symptoms.\",\"difficulty\":\"Medium\"},{\"id\":166,\"chapter\":\"11. Data Quality\",\"question\":\"A team corrects customer addresses monthly, but input errors continue. What is the best next action?\",\"options\":[\"Archive all customer records\",\"Increase the cleansing frequency only\",\"Identify and fix the faulty capture process and validation controls\",\"Stop measuring address quality\"],\"answer\":2,\"rationale\":\"Recurring correction without process improvement treats the symptom.\",\"difficulty\":\"Medium\"},{\"id\":167,\"chapter\":\"11. Data Quality\",\"question\":\"Which formula measures completeness for a mandatory field?\",\"options\":[\"Corrected records divided by data owners\",\"Duplicate records divided by all systems\",\"Available hours divided by total storage\",\"Populated valid records divided by applicable records\"],\"answer\":3,\"rationale\":\"Completeness is typically measured against the population for which the value is required.\",\"difficulty\":\"Medium\"},{\"id\":168,\"chapter\":\"11. Data Quality\",\"question\":\"A threshold states that at least 98% of active products must have a category. What does 98% represent?\",\"options\":[\"The data lineage depth\",\"The accepted quality target\",\"The recovery objective\",\"The retention period\"],\"answer\":1,\"rationale\":\"A threshold defines the minimum acceptable performance for a rule or dimension.\",\"difficulty\":\"Easy\"},{\"id\":169,\"chapter\":\"11. Data Quality\",\"question\":\"Why should a quality rule include its applicable population?\",\"options\":[\"It removes the need for thresholds\",\"It makes the database larger\",\"The rule may apply only to specific records or business conditions\",\"It guarantees statistical significance\"],\"answer\":2,\"rationale\":\"Scope prevents misleading measurement over irrelevant records.\",\"difficulty\":\"Medium\"},{\"id\":170,\"chapter\":\"11. Data Quality\",\"question\":\"Which sequence best reflects a sound quality-improvement cycle?\",\"options\":[\"Buy a tool, then define the problem\",\"Archive data, then assign ownership\",\"Define requirements, profile, measure, analyze causes, remediate, monitor\",\"Cleanse, ignore causes, stop measuring\"],\"answer\":2,\"rationale\":\"Effective improvement begins with requirements and continues through measurement and control.\",\"difficulty\":\"Medium\"},{\"id\":171,\"chapter\":\"11. Data Quality\",\"question\":\"What is the best evidence that a quality rule is operationalized?\",\"options\":[\"It has a complicated name\",\"It has an owner, implementation, threshold, monitoring, and issue workflow\",\"It appears in an old presentation\",\"It is known by one developer\"],\"answer\":1,\"rationale\":\"Operational rules are accountable, executable, measurable, and acted upon.\",\"difficulty\":\"Medium\"},{\"id\":172,\"chapter\":\"11. Data Quality\",\"question\":\"What is data-quality issue management?\",\"options\":[\"A process for deleting all failing records\",\"A controlled process to log, prioritize, assign, remediate, and close defects\",\"A method for designing APIs\",\"A substitute for data governance\"],\"answer\":1,\"rationale\":\"Issue management creates traceability and accountability for quality defects.\",\"difficulty\":\"Easy\"},{\"id\":173,\"chapter\":\"11. Data Quality\",\"question\":\"How should quality issues normally be prioritized?\",\"options\":[\"By alphabetical order\",\"By the number of screenshots\",\"By business impact, risk, urgency, and affected critical data\",\"By the age of the database\"],\"answer\":2,\"rationale\":\"Prioritization should align scarce remediation effort with business consequences.\",\"difficulty\":\"Medium\"},{\"id\":174,\"chapter\":\"11. Data Quality\",\"question\":\"A report shows 99% accuracy but the validation sample is undocumented. What is the concern?\",\"options\":[\"The report should contain no metadata\",\"The score must automatically be 100%\",\"Accuracy can never be sampled\",\"The metric may not be reproducible or credible\"],\"answer\":3,\"rationale\":\"Quality measures need transparent method, population, source, and evidence.\",\"difficulty\":\"Hard\"},{\"id\":175,\"chapter\":\"11. Data Quality\",\"question\":\"What is reconciliation used to assess?\",\"options\":[\"Whether passwords meet length rules\",\"Whether records are old enough to archive\",\"Whether expected records and values agree across stages or systems\",\"Whether taxonomies are hierarchical\"],\"answer\":2,\"rationale\":\"Reconciliation detects loss, duplication, and transformation differences.\",\"difficulty\":\"Medium\"},{\"id\":176,\"chapter\":\"11. Data Quality\",\"question\":\"Which quality dimension is most directly tested by a permitted-values list?\",\"options\":[\"Validity\",\"Uniqueness\",\"Timeliness\",\"Accuracy\"],\"answer\":0,\"rationale\":\"Permitted-values controls test conformance with a defined domain.\",\"difficulty\":\"Easy\"},{\"id\":177,\"chapter\":\"11. Data Quality\",\"question\":\"Why can valid data still be inaccurate?\",\"options\":[\"Accurate values never require formats\",\"A value can follow the permitted format but not reflect reality\",\"Validity and accuracy are identical\",\"Accuracy applies only to master data\"],\"answer\":1,\"rationale\":\"For example, a well-formed date can still be the wrong date.\",\"difficulty\":\"Medium\"},{\"id\":178,\"chapter\":\"11. Data Quality\",\"question\":\"Why can complete data still be poor quality?\",\"options\":[\"All fields may be populated with inaccurate, invalid, or inconsistent values\",\"Completeness proves every dimension\",\"Only null values create defects\",\"Complete data needs no governance\"],\"answer\":0,\"rationale\":\"Quality is multidimensional; presence alone does not establish fitness.\",\"difficulty\":\"Medium\"},{\"id\":179,\"chapter\":\"11. Data Quality\",\"question\":\"What is a quality scorecard?\",\"options\":[\"A physical model\",\"A document-retention schedule\",\"A structured view of measures, thresholds, trends, owners, and status\",\"A list of database passwords\"],\"answer\":2,\"rationale\":\"Scorecards communicate performance and accountability.\",\"difficulty\":\"Easy\"},{\"id\":180,\"chapter\":\"11. Data Quality\",\"question\":\"Which trend most strongly signals a weakening preventive control?\",\"options\":[\"The number of glossary terms increases\",\"Backups complete successfully\",\"New defects continue rising despite repeated cleansing\",\"Storage capacity remains stable\"],\"answer\":2,\"rationale\":\"Rising new defects indicate that creation processes are not being controlled.\",\"difficulty\":\"Hard\"},{\"id\":181,\"chapter\":\"11. Data Quality\",\"question\":\"A quality rule fails because an approved reference-code list changed. What control is missing?\",\"options\":[\"Change coordination between reference data and dependent validations\",\"Additional document scanning\",\"A new conceptual entity\",\"Longer backup retention\"],\"answer\":0,\"rationale\":\"Dependent rules must be updated when governed reference values change.\",\"difficulty\":\"Hard\"},{\"id\":182,\"chapter\":\"11. Data Quality\",\"question\":\"What is the relationship between metadata and data quality?\",\"options\":[\"Metadata supplies definitions, domains, rules, lineage, and ownership needed for quality control\",\"They are unrelated\",\"Metadata guarantees accuracy automatically\",\"Metadata replaces profiling\"],\"answer\":0,\"rationale\":\"Quality is difficult to define or investigate without contextual metadata.\",\"difficulty\":\"Medium\"},{\"id\":183,\"chapter\":\"11. Data Quality\",\"question\":\"How does lineage support quality management?\",\"options\":[\"It removes duplicate records automatically\",\"It defines recovery time\",\"It helps locate defect origins and identify affected downstream assets\",\"It encrypts bad data\"],\"answer\":2,\"rationale\":\"Lineage enables root-cause and impact analysis.\",\"difficulty\":\"Medium\"},{\"id\":184,\"chapter\":\"11. Data Quality\",\"question\":\"An organization measures hundreds of rules but resolves few failures. What is the maturity weakness?\",\"options\":[\"There are too few dashboards\",\"The taxonomy is too deep\",\"Measurement is not connected to accountable remediation\",\"The data model is too conceptual\"],\"answer\":2,\"rationale\":\"Metrics create value only when failures trigger decisions and action.\",\"difficulty\":\"Hard\"},{\"id\":185,\"chapter\":\"11. Data Quality\",\"question\":\"Why should quality requirements be defined with business users?\",\"options\":[\"IT cannot read data\",\"Fitness for use depends on business processes and decisions\",\"Business users should configure databases\",\"Quality is purely subjective\"],\"answer\":1,\"rationale\":\"Business context determines acceptable levels, impacts, and priorities.\",\"difficulty\":\"Medium\"},{\"id\":186,\"chapter\":\"11. Data Quality\",\"question\":\"What is the best response when improving one system reduces quality in another?\",\"options\":[\"Stop integration permanently\",\"Assess end-to-end impacts and agree an enterprise solution through governance\",\"Optimize only the first system\",\"Hide the second system's metrics\"],\"answer\":1,\"rationale\":\"Local optimization can damage enterprise outcomes and must be governed across boundaries.\",\"difficulty\":\"Hard\"},{\"id\":187,\"chapter\":\"11. Data Quality\",\"question\":\"Which metric best represents duplicate rate?\",\"options\":[\"Null attributes divided by all attributes\",\"Successful jobs divided by scheduled jobs\",\"Correct values divided by sampled values\",\"Records identified as inappropriate duplicates divided by assessed records\"],\"answer\":3,\"rationale\":\"Duplicate rate is a uniqueness measure based on the assessed population.\",\"difficulty\":\"Medium\"},{\"id\":188,\"chapter\":\"11. Data Quality\",\"question\":\"What is the primary risk of cleansing data without preserving an audit trail?\",\"options\":[\"The data becomes too complete\",\"Storage automatically doubles\",\"Changes may be unverifiable, irreversible, or unaccountable\",\"The taxonomy becomes flatter\"],\"answer\":2,\"rationale\":\"Controlled remediation needs before-and-after evidence, authority, and traceability.\",\"difficulty\":\"Medium\"},{\"id\":189,\"chapter\":\"11. Data Quality\",\"question\":\"When should a quality exception be accepted?\",\"options\":[\"When an authorized owner documents justification, risk, duration, and treatment\",\"Whenever a developer requests it verbally\",\"Whenever the quality score is unknown\",\"Whenever a rule is inconvenient\"],\"answer\":0,\"rationale\":\"Exceptions should be governed and time-bound rather than silently tolerated.\",\"difficulty\":\"Hard\"},{\"id\":190,\"chapter\":\"11. Data Quality\",\"question\":\"What is the strongest sign of an optimized quality capability?\",\"options\":[\"A tool has been purchased\",\"A policy document exists\",\"Data is cleansed once\",\"Quality controls are embedded, monitored, and improved using measured outcomes\"],\"answer\":3,\"rationale\":\"High maturity combines prevention, automation, accountability, and continuous improvement.\",\"difficulty\":\"Hard\"},{\"id\":191,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic of big data refers to scale?\",\"options\":[\"Value\",\"Veracity\",\"Volume\",\"Velocity\"],\"answer\":2,\"rationale\":\"Volume denotes the amount of data generated, stored, or processed.\",\"difficulty\":\"Easy\"},{\"id\":192,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic refers to the speed of generation and processing?\",\"options\":[\"Velocity\",\"Value\",\"Volume\",\"Variety\"],\"answer\":0,\"rationale\":\"Velocity concerns the rate and timeliness of data flows.\",\"difficulty\":\"Easy\"},{\"id\":193,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic refers to different formats and sources?\",\"options\":[\"Variety\",\"Value\",\"Veracity\",\"Volume\"],\"answer\":0,\"rationale\":\"Variety includes structured, semi-structured, and unstructured forms.\",\"difficulty\":\"Easy\"},{\"id\":194,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic concerns trustworthiness and uncertainty?\",\"options\":[\"Velocity\",\"Veracity\",\"Visualization\",\"Volume\"],\"answer\":1,\"rationale\":\"Veracity concerns reliability, bias, noise, and confidence.\",\"difficulty\":\"Easy\"},{\"id\":195,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic emphasizes useful business outcomes?\",\"options\":[\"Velocity\",\"Volume\",\"Variety\",\"Value\"],\"answer\":3,\"rationale\":\"Big-data investment is justified by value rather than scale alone.\",\"difficulty\":\"Easy\"},{\"id\":196,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which is semi-structured data?\",\"options\":[\"An analog paper form\",\"A normalized customer table\",\"A scanned photograph\",\"A JSON event message\"],\"answer\":3,\"rationale\":\"JSON has structural markers but does not require a fixed relational schema.\",\"difficulty\":\"Easy\"},{\"id\":197,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which is unstructured data?\",\"options\":[\"A country-code table\",\"A relational invoice table\",\"A fixed-width transaction file\",\"A maintenance video\"],\"answer\":3,\"rationale\":\"Video content does not naturally conform to rows and columns.\",\"difficulty\":\"Easy\"},{\"id\":198,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a data lake?\",\"options\":[\"A transaction-only ERP database\",\"A scalable repository that can retain diverse data, often in native form\",\"A document retention schedule\",\"A business glossary\"],\"answer\":1,\"rationale\":\"Data lakes commonly preserve structured and non-structured data for multiple uses.\",\"difficulty\":\"Easy\"},{\"id\":199,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does schema-on-read mean?\",\"options\":[\"All data is converted to one table\",\"Schema is fixed before ingestion\",\"Data has no structure under any circumstance\",\"Structure is applied or interpreted when data is accessed for use\"],\"answer\":3,\"rationale\":\"Schema-on-read allows flexible interpretation for different consumers.\",\"difficulty\":\"Easy\"},{\"id\":200,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does schema-on-write mean?\",\"options\":[\"Data is never validated\",\"Schema is chosen after every query\",\"All files remain in native form\",\"Data is shaped to an agreed schema before or during loading\"],\"answer\":3,\"rationale\":\"Warehousing commonly applies defined structures before analytical use.\",\"difficulty\":\"Easy\"},{\"id\":201,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a data swamp?\",\"options\":[\"A master-data registry\",\"A highly optimized warehouse\",\"A secure backup vault\",\"A poorly governed data lake whose assets are difficult to find, understand, or trust\"],\"answer\":3,\"rationale\":\"Weak metadata, stewardship, quality, and lifecycle controls reduce lake usability.\",\"difficulty\":\"Easy\"},{\"id\":202,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is distributed processing used?\",\"options\":[\"To replace governance\",\"To divide large processing workloads across multiple computing nodes\",\"To avoid all failures\",\"To eliminate metadata\"],\"answer\":1,\"rationale\":\"Parallel distributed computation enables scale beyond one machine.\",\"difficulty\":\"Easy\"},{\"id\":203,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is horizontal scaling?\",\"options\":[\"Reducing the number of users\",\"Compressing all data\",\"Adding more power to one node only\",\"Adding more nodes to increase capacity\"],\"answer\":3,\"rationale\":\"Scale-out architectures add machines or instances.\",\"difficulty\":\"Medium\"},{\"id\":204,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is fault tolerance in a distributed platform?\",\"options\":[\"Permanent duplication of every result\",\"The ability to continue or recover when components fail\",\"Ignoring failed jobs\",\"The absence of data-quality rules\"],\"answer\":1,\"rationale\":\"Distributed designs anticipate component failure and use replication or recovery mechanisms.\",\"difficulty\":\"Medium\"},{\"id\":205,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data partitioning?\",\"options\":[\"Renaming every file\",\"Dividing data into manageable segments for storage or processing\",\"Deleting historical data\",\"Encrypting each attribute\"],\"answer\":1,\"rationale\":\"Partitioning improves distribution, parallelism, and manageability.\",\"difficulty\":\"Medium\"},{\"id\":206,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is stream processing?\",\"options\":[\"Running one annual batch\",\"Updating a business glossary\",\"Archiving documents\",\"Processing events continuously or with very low latency as they arrive\"],\"answer\":3,\"rationale\":\"Streaming supports timely analysis of ongoing event flows.\",\"difficulty\":\"Easy\"},{\"id\":207,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is batch processing?\",\"options\":[\"Processing a accumulated set of records as a scheduled or bounded workload\",\"Handling every event individually at arrival\",\"Masking sensitive fields\",\"Defining data ownership\"],\"answer\":0,\"rationale\":\"Batch workloads process collected data at intervals or as bounded jobs.\",\"difficulty\":\"Easy\"},{\"id\":208,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A machine emits vibration readings every millisecond. Which big-data property is most obvious?\",\"options\":[\"Normalization\",\"Taxonomy\",\"Velocity\",\"Retention\"],\"answer\":2,\"rationale\":\"The defining challenge is the high rate of data arrival.\",\"difficulty\":\"Easy\"},{\"id\":209,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A platform stores sensor readings, images, logs, and work orders. Which property is strongest?\",\"options\":[\"Variety\",\"Cardinality\",\"Uniqueness\",\"Volatility\"],\"answer\":0,\"rationale\":\"Multiple data forms and structures demonstrate variety.\",\"difficulty\":\"Easy\"},{\"id\":210,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is predictive analytics?\",\"options\":[\"Reporting only what happened\",\"Selecting a retention schedule\",\"Designing an access role\",\"Using data and models to estimate likely future outcomes\"],\"answer\":3,\"rationale\":\"Predictive methods estimate future events, probabilities, or values.\",\"difficulty\":\"Easy\"},{\"id\":211,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is prescriptive analytics?\",\"options\":[\"Describing past performance only\",\"Creating a conceptual model\",\"Collecting metadata\",\"Recommending actions based on objectives, constraints, and predicted outcomes\"],\"answer\":3,\"rationale\":\"Prescriptive analysis addresses what action should be taken.\",\"difficulty\":\"Medium\"},{\"id\":212,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is metadata essential in a data lake?\",\"options\":[\"It replaces access security\",\"It eliminates storage costs\",\"It guarantees all models are unbiased\",\"It enables discovery, interpretation, lineage, governance, and reuse\"],\"answer\":3,\"rationale\":\"Without context, large collections become difficult to use responsibly.\",\"difficulty\":\"Medium\"},{\"id\":213,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data provenance?\",\"options\":[\"Evidence about the origin and history of data\",\"A database index\",\"An encryption key\",\"A duplicate-detection rule\"],\"answer\":0,\"rationale\":\"Provenance supports trust, reproducibility, lineage, and accountability.\",\"difficulty\":\"Medium\"},{\"id\":214,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What should govern retention of high-volume sensor data?\",\"options\":[\"Use the same period for all data\",\"Business value, obligations, risk, cost, and intended analytical use\",\"Delete everything after one day\",\"Keep everything forever by default\"],\"answer\":1,\"rationale\":\"Retention requires a risk- and value-based lifecycle decision.\",\"difficulty\":\"Hard\"},{\"id\":215,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why does more data not automatically improve an analytical model?\",\"options\":[\"Volume eliminates sampling error completely\",\"Additional data may be irrelevant, biased, noisy, or poorly labeled\",\"All large datasets are accurate\",\"Models use only metadata\"],\"answer\":1,\"rationale\":\"Quality and representativeness matter as much as quantity.\",\"difficulty\":\"Medium\"},{\"id\":216,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data drift?\",\"options\":[\"Movement of data between storage tiers\",\"A change over time in input data patterns or distributions\",\"A taxonomy being revised\",\"A backup being archived\"],\"answer\":1,\"rationale\":\"Drift can reduce model performance when current data differs from training data.\",\"difficulty\":\"Hard\"},{\"id\":217,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is concept drift?\",\"options\":[\"A change in the relationship between inputs and the outcome being predicted\",\"A server migration\",\"A glossary ownership change\",\"A change in file format only\"],\"answer\":0,\"rationale\":\"Concept drift means the phenomenon or target relationship has evolved.\",\"difficulty\":\"Hard\"},{\"id\":218,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a major privacy risk in big-data analytics?\",\"options\":[\"Encryption removes all privacy concerns\",\"Large datasets are automatically anonymous\",\"Combining data may enable unexpected identification or sensitive inference\",\"Distributed systems cannot store personal data\"],\"answer\":2,\"rationale\":\"Linkage and inference can create risks beyond individual source datasets.\",\"difficulty\":\"Hard\"},{\"id\":219,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is representative training data important?\",\"options\":[\"Biased or incomplete representation can produce systematically poor outcomes\",\"It guarantees perfect predictions\",\"It reduces the need for testing\",\"It makes governance unnecessary\"],\"answer\":0,\"rationale\":\"Model outcomes depend on the populations and conditions represented in the data.\",\"difficulty\":\"Medium\"},{\"id\":220,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does reproducibility require in an analytics pipeline?\",\"options\":[\"Only a larger cluster\",\"Only the model name\",\"Traceable data, code, configuration, parameters, and execution context\",\"Only the final chart\"],\"answer\":2,\"rationale\":\"Reproduction depends on preserving the full analytical context.\",\"difficulty\":\"Hard\"},{\"id\":221,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which control best limits uncontrolled data-lake access?\",\"options\":[\"Shared administrator credentials\",\"Classification-based authorization with least privilege and logging\",\"Removal of metadata\",\"Public access for all analysts\"],\"answer\":1,\"rationale\":\"Governed access should reflect sensitivity and approved purpose.\",\"difficulty\":\"Medium\"},{\"id\":222,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is the best initial question for a big-data initiative?\",\"options\":[\"Which tool has the most features?\",\"How can we keep every event forever?\",\"What business decision or outcome should the data improve?\",\"How much data can we collect?\"],\"answer\":2,\"rationale\":\"A value-led use case should precede technology and collection decisions.\",\"difficulty\":\"Medium\"},{\"id\":223,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why monitor pipeline data quality continuously?\",\"options\":[\"Source behavior and data distributions can change over time\",\"Monitoring only affects storage\",\"One initial test proves permanent quality\",\"Big data is exempt from quality rules\"],\"answer\":0,\"rationale\":\"Dynamic sources require ongoing detection of drift, failures, and anomalies.\",\"difficulty\":\"Medium\"},{\"id\":224,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is the strongest sign that a big-data platform is governed effectively?\",\"options\":[\"It has no deletion process\",\"It contains petabytes of data\",\"It uses many technologies\",\"Assets are discoverable, owned, protected, quality-assessed, and lifecycle-managed\"],\"answer\":3,\"rationale\":\"Governance is demonstrated by controlled and useful information management.\",\"difficulty\":\"Hard\"},{\"id\":225,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A predictive-maintenance model performs well in one plant but poorly in another. What should be examined first?\",\"options\":[\"The color of the dashboard\",\"The office network name\",\"The number of glossary pages\",\"Differences in equipment, operating conditions, sensor quality, and data representation\"],\"answer\":3,\"rationale\":\"Cross-context performance can fail when data and operating conditions differ.\",\"difficulty\":\"Hard\"},{\"id\":226,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a data-management maturity assessment evaluate?\",\"options\":[\"Only regulatory compliance\",\"Only database performance\",\"Only the accuracy of individual records\",\"How consistently and effectively an organization manages data capabilities\"],\"answer\":3,\"rationale\":\"Maturity assessment examines organizational capability across people, process, governance, and technology.\",\"difficulty\":\"Easy\"},{\"id\":227,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the principal output of a maturity assessment?\",\"options\":[\"A current-state capability view, gaps, priorities, and improvement roadmap\",\"A production database\",\"A list of passwords\",\"A physical data model only\"],\"answer\":0,\"rationale\":\"Assessment should guide targeted capability improvement.\",\"difficulty\":\"Easy\"},{\"id\":228,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does an Initial maturity level usually indicate?\",\"options\":[\"All controls are automated\",\"Continuous optimization is embedded\",\"Practices are ad hoc, reactive, and dependent on individuals\",\"Processes are quantitatively managed\"],\"answer\":2,\"rationale\":\"Initial capability lacks consistent institutionalized practice.\",\"difficulty\":\"Easy\"},{\"id\":229,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a Defined level generally indicate?\",\"options\":[\"Practices and roles are documented and used consistently\",\"Every process is optimized\",\"No processes exist\",\"Only technology has been purchased\"],\"answer\":0,\"rationale\":\"Defined capability is standardized and institutionalized.\",\"difficulty\":\"Easy\"},{\"id\":230,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a Managed level generally add?\",\"options\":[\"Dependence on informal experts\",\"Elimination of metrics\",\"Measurement, monitoring, control, and accountable performance management\",\"Removal of all policies\"],\"answer\":2,\"rationale\":\"Managed capability uses evidence to control outcomes.\",\"difficulty\":\"Easy\"},{\"id\":231,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What characterizes an Optimized level?\",\"options\":[\"Continuous improvement, learning, automation, and adaptive control\",\"No changes are permitted\",\"Processes are performed differently everywhere\",\"A policy exists as a file\"],\"answer\":0,\"rationale\":\"Optimization uses measured outcomes to improve capability systematically.\",\"difficulty\":\"Easy\"},{\"id\":232,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why is a yes\/no questionnaire insufficient for a robust assessment?\",\"options\":[\"Documents cannot be reviewed\",\"Maturity cannot be measured\",\"It may show existence but not adoption, consistency, effectiveness, or evidence\",\"Yes\/no questions are always illegal\"],\"answer\":2,\"rationale\":\"Capability maturity requires examining practice in operation.\",\"difficulty\":\"Medium\"},{\"id\":233,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A policy exists but is contradictory, outdated, and unknown to staff. How should it be scored?\",\"options\":[\"Below mature levels because effectiveness and adoption are weak\",\"Level 5 because a document exists\",\"Level 4 because it is long\",\"Not assessed because policies do not matter\"],\"answer\":0,\"rationale\":\"Documentation alone is not evidence of institutionalized capability.\",\"difficulty\":\"Medium\"},{\"id\":234,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is assessment evidence?\",\"options\":[\"The assessor's preference\",\"A vendor's marketing claim\",\"Artifacts, observations, records, metrics, and interviews that substantiate a rating\",\"An undocumented assumption\"],\"answer\":2,\"rationale\":\"Evidence supports transparent and repeatable scoring.\",\"difficulty\":\"Easy\"},{\"id\":235,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why triangulate evidence?\",\"options\":[\"To validate claims using more than one source or method\",\"To increase the score automatically\",\"To avoid stakeholder interviews\",\"To eliminate professional judgment\"],\"answer\":0,\"rationale\":\"Triangulation reduces reliance on unverified self-reporting.\",\"difficulty\":\"Medium\"},{\"id\":236,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a target maturity level?\",\"options\":[\"The capability level the organization intends to reach based on need and value\",\"The highest possible score for every capability\",\"The number of assessment questions\",\"The current average score\"],\"answer\":0,\"rationale\":\"Targets should reflect business priorities rather than universal perfection.\",\"difficulty\":\"Easy\"},{\"id\":237,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why should not every capability automatically target Level 5?\",\"options\":[\"Only technology can reach Level 5\",\"The cost and complexity may exceed the business need or risk reduction\",\"Level 5 is impossible\",\"Targets must always equal current scores\"],\"answer\":1,\"rationale\":\"Maturity should be appropriate and economically justified.\",\"difficulty\":\"Medium\"},{\"id\":238,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is gap analysis?\",\"options\":[\"Comparison of current capability with the desired target state\",\"A document taxonomy\",\"Comparison of two database indexes\",\"A method of data encryption\"],\"answer\":0,\"rationale\":\"Gap analysis identifies improvement needs.\",\"difficulty\":\"Easy\"},{\"id\":239,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"How should roadmap initiatives be prioritized?\",\"options\":[\"By alphabetical order\",\"By the longest document first\",\"By business value, risk, dependencies, feasibility, and capability gaps\",\"By assessor preference only\"],\"answer\":2,\"rationale\":\"Prioritization should link improvement to strategic outcomes and constraints.\",\"difficulty\":\"Medium\"},{\"id\":240,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a leading maturity indicator?\",\"options\":[\"A retired policy\",\"A result observed only after failure\",\"A historical revenue total\",\"Evidence that enabling practices are being implemented before final outcomes appear\"],\"answer\":3,\"rationale\":\"Leading indicators track adoption and control development, such as ownership coverage.\",\"difficulty\":\"Hard\"},{\"id\":241,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a lagging maturity indicator?\",\"options\":[\"An outcome measure observed after processes have operated\",\"A draft role description\",\"A proposed catalog\",\"A planned training session\"],\"answer\":0,\"rationale\":\"Lagging indicators include defect trends, incident results, or realized compliance outcomes.\",\"difficulty\":\"Hard\"},{\"id\":242,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why assess maturity by capability rather than only one overall score?\",\"options\":[\"Capabilities cannot be compared\",\"Strengths and weaknesses differ and require different actions\",\"Roadmaps need no detail\",\"Overall scores are always false\"],\"answer\":1,\"rationale\":\"A single average can hide critical low-performing areas.\",\"difficulty\":\"Medium\"},{\"id\":243,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the danger of averaging scores without weights?\",\"options\":[\"Averages always exceed five\",\"Every capability has identical risk\",\"Weights remove all judgment\",\"Low maturity in a critical capability may be hidden by less important high scores\"],\"answer\":3,\"rationale\":\"Weighting or interpretation should reflect business criticality.\",\"difficulty\":\"Hard\"},{\"id\":244,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What should a scoring rubric contain?\",\"options\":[\"Observable criteria and evidence expectations for each level\",\"Only tool names\",\"Only chapter titles\",\"Only numeric labels\"],\"answer\":0,\"rationale\":\"Anchored descriptions improve consistency and auditability.\",\"difficulty\":\"Medium\"},{\"id\":245,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Two assessors give different ratings from the same evidence. What is the best response?\",\"options\":[\"Average the scores without discussion\",\"Calibrate against the rubric and document the rating rationale\",\"Discard the evidence\",\"Use the highest score\"],\"answer\":1,\"rationale\":\"Calibration promotes consistent interpretation and transparent judgment.\",\"difficulty\":\"Hard\"},{\"id\":246,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is assessment scope?\",\"options\":[\"The target score alone\",\"Only the interview schedule\",\"The organizational units, capabilities, data domains, systems, and period included\",\"The number of colors in the report\"],\"answer\":2,\"rationale\":\"Clear scope prevents overgeneralization and supports repeatability.\",\"difficulty\":\"Easy\"},{\"id\":247,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why identify assessment stakeholders early?\",\"options\":[\"They guarantee high scores\",\"They replace the assessor\",\"They provide evidence, context, decisions, and ownership of improvements\",\"They eliminate confidentiality requirements\"],\"answer\":2,\"rationale\":\"Broad engagement improves accuracy and adoption of the roadmap.\",\"difficulty\":\"Medium\"},{\"id\":248,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is respondent bias?\",\"options\":[\"A database constraint\",\"A reporting dimension\",\"Systematic distortion caused by incentives, perceptions, or incomplete knowledge\",\"A lineage relationship\"],\"answer\":2,\"rationale\":\"Self-assessments can overstate or understate capability.\",\"difficulty\":\"Medium\"},{\"id\":249,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"How can respondent bias be reduced?\",\"options\":[\"Remove all interviews\",\"Publish names with every answer\",\"Use evidence review, multiple roles, neutral facilitation, and clear rubrics\",\"Ask only senior leaders\"],\"answer\":2,\"rationale\":\"Multiple evidence sources and structured criteria improve reliability.\",\"difficulty\":\"Medium\"},{\"id\":250,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the purpose of an assessment workshop?\",\"options\":[\"Replace individual interviews in all cases\",\"Approve every policy exception\",\"Configure production databases\",\"Build shared understanding, validate evidence, and calibrate ratings\"],\"answer\":3,\"rationale\":\"Workshops help reconcile perspectives and establish ownership of findings.\",\"difficulty\":\"Easy\"},{\"id\":251,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What makes a recommendation actionable?\",\"options\":[\"A vendor product name only\",\"A vague statement to improve data\",\"A maturity score without context\",\"A defined outcome, owner, priority, dependencies, measures, and timeframe\"],\"answer\":3,\"rationale\":\"Actionable recommendations can be assigned, planned, and measured.\",\"difficulty\":\"Medium\"},{\"id\":252,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the best way to present maturity results to executives?\",\"options\":[\"Present technology diagrams only\",\"Link capability findings to business risk, value, and prioritized decisions\",\"Hide all weaknesses\",\"Show only detailed question responses\"],\"answer\":1,\"rationale\":\"Executives need a decision-oriented narrative rather than raw scoring detail.\",\"difficulty\":\"Medium\"},{\"id\":253,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why repeat maturity assessments?\",\"options\":[\"To replace operational metrics\",\"To avoid implementing actions\",\"Repeated scoring guarantees improvement\",\"Measure progress, detect changes, and refine the improvement roadmap\"],\"answer\":3,\"rationale\":\"Periodic reassessment checks whether capability has genuinely advanced.\",\"difficulty\":\"Easy\"},{\"id\":254,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the main risk of reassessing too frequently?\",\"options\":[\"All evidence becomes invalid\",\"Scores may reflect noise before improvements have become institutionalized\",\"Policies automatically expire\",\"The model can no longer be used\"],\"answer\":1,\"rationale\":\"Capability change needs enough time to become established and measurable.\",\"difficulty\":\"Hard\"},{\"id\":255,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A governance council exists but rarely makes decisions. Which aspect should lower the score?\",\"options\":[\"Meeting-room availability\",\"Operational effectiveness\",\"Document formatting\",\"Database capacity\"],\"answer\":1,\"rationale\":\"Formal existence without effective outcomes is weak maturity evidence.\",\"difficulty\":\"Medium\"},{\"id\":256,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A data catalog is purchased but has little metadata and few users. What does this demonstrate?\",\"options\":[\"Technology implementation without mature adoption or operating processes\",\"Automatic enterprise governance\",\"Optimized metadata capability\",\"A complete target state\"],\"answer\":0,\"rationale\":\"Tool deployment is not equivalent to institutionalized capability.\",\"difficulty\":\"Medium\"},{\"id\":257,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Which finding is more useful than 'Metadata score = 2.1'?\",\"options\":[\"The score has one decimal place\",\"Definitions lack owners, lineage covers few critical reports, and catalog adoption is low\",\"The tool should be replaced\",\"Metadata needs improvement\"],\"answer\":1,\"rationale\":\"Specific evidence explains the score and informs remediation.\",\"difficulty\":\"Hard\"},{\"id\":258,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is an interdependency in a maturity roadmap?\",\"options\":[\"Two questions share the same answer\",\"One capability improvement relies on another capability or prerequisite\",\"Two charts use the same color\",\"Two assessors attend one meeting\"],\"answer\":1,\"rationale\":\"For example, quality monitoring may depend on metadata and ownership.\",\"difficulty\":\"Medium\"},{\"id\":259,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the best response to a high maturity score with poor business outcomes?\",\"options\":[\"Increase every target to Level 5\",\"Stop measuring outcomes\",\"Re-examine the evidence, rubric, effectiveness measures, and alignment to business need\",\"Accept the score without question\"],\"answer\":2,\"rationale\":\"Maturity claims should align with actual capability effectiveness.\",\"difficulty\":\"Hard\"},{\"id\":260,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the defining principle of a useful maturity assessment?\",\"options\":[\"It replaces data strategy\",\"It produces the highest possible score\",\"It compares tool brands\",\"It supports evidence-based prioritization and continuous capability improvement\"],\"answer\":3,\"rationale\":\"The assessment is a means to improve outcomes, not an end in itself.\",\"difficulty\":\"Hard\"}];<\/script><script>\n(function(){\n const ROOT_ID='cdmp-practice-quiz'; const data=CDMP_QUESTIONS; const root=document.getElementById(ROOT_ID); if(!root)return;\n let current=[],submitted=false;\n const chapters=[...new Set(data.map(q=>q.chapter))];\n root.innerHTML=`<div class=\"cdmpq\">\n <div class=\"cdmpq-card\"><h2>CDMP Practice Quiz<\/h2><p>Choose a chapter and number of questions. Results and explanations appear immediately after submission.<\/p>\n <div class=\"cdmpq-controls\"><label>Chapter<select id=\"cdmp-ch\"><option value=\"all\">All chapters<\/option>${chapters.map(c=>`<option>${c}<\/option>`).join('')}<\/select><\/label><label>Questions<select id=\"cdmp-count\"><option>10<\/option><option>20<\/option><option>30<\/option><option>50<\/option><option value=\"all\">All available<\/option><\/select><\/label><label>Order<select id=\"cdmp-order\"><option value=\"random\">Random<\/option><option value=\"number\">Question number<\/option><\/select><\/label><\/div>\n <div class=\"cdmpq-actions\"><button id=\"cdmp-start\">Start new quiz<\/button><button class=\"secondary\" id=\"cdmp-resume\">Resume saved quiz<\/button><button class=\"danger\" id=\"cdmp-clear\">Clear saved progress<\/button><\/div><p class=\"cdmpq-note\">Unofficial study aid. Not an official DAMA International examination.<\/p><\/div>\n <div id=\"cdmp-stage\"><\/div><\/div>`;\n const $=s=>root.querySelector(s), stage=$('#cdmp-stage');\n function shuffled(a){let x=[...a];for(let i=x.length-1;i>0;i--){let j=Math.floor(Math.random()*(i+1));[x[i],x[j]]=[x[j],x[i]]}return x}\n function begin(saved){submitted=false;if(saved){current=saved.questions;render(saved.answers||{}) ;return}\n   let pool=$('#cdmp-ch').value==='all'?data:data.filter(q=>q.chapter===$('#cdmp-ch').value);\n   pool=$('#cdmp-order').value==='random'?shuffled(pool):[...pool].sort((a,b)=>a.id-b.id);\n   let n=$('#cdmp-count').value==='all'?pool.length:Math.min(+$('#cdmp-count').value,pool.length);current=pool.slice(0,n);render({});\n }\n function render(answers){stage.innerHTML=`<div class=\"cdmpq-card\"><div><strong id=\"cdmp-status\">0 of ${current.length} answered<\/strong><\/div><div class=\"cdmpq-progress\"><span id=\"cdmp-bar\"><\/span><\/div><div id=\"cdmp-list\"><\/div><div class=\"cdmpq-actions\"><button id=\"cdmp-submit\">Submit answers<\/button><button class=\"secondary\" id=\"cdmp-save\">Save progress<\/button><\/div><\/div>`;\n   const list=$('#cdmp-list'); current.forEach((q,i)=>{let d=document.createElement('div');d.className='cdmpq-q';d.dataset.id=q.id;d.innerHTML=`<div class=\"cdmpq-meta\">Question ${i+1} \u00b7 Bank #${q.id} \u00b7 ${q.chapter}${q.difficulty&&q.difficulty!=='Mixed'?' \u00b7 '+q.difficulty:''}<\/div><h3>${esc(q.question)}<\/h3>${q.options.map((o,k)=>`<label class=\"cdmpq-opt\"><input type=\"radio\" name=\"q${q.id}\" value=\"${k}\" ${String(answers[q.id])===String(k)?'checked':''}>${String.fromCharCode(65+k)}. ${esc(o)}<\/label>`).join('')}`;list.appendChild(d)});\n   root.querySelectorAll('input[type=radio]').forEach(x=>x.addEventListener('change',progress)); $('#cdmp-submit').onclick=submit; $('#cdmp-save').onclick=save; progress(); root.scrollIntoView({behavior:'smooth'});\n }\n function esc(s){return String(s).replace(\/[&<>\"]\/g,c=>({'&':'&amp;','<':'&lt;','>':'&gt;','\"':'&quot;'}[c]))}\n function collect(){let a={};current.forEach(q=>{let x=root.querySelector(`input[name=q${q.id}]:checked`);if(x)a[q.id]=+x.value});return a}\n function progress(){let n=Object.keys(collect()).length;$('#cdmp-status').textContent=`${n} of ${current.length} answered`;$('#cdmp-bar').style.width=(100*n\/current.length)+'%'}\n function save(){localStorage.setItem('cdmpQuizState',JSON.stringify({questions:current,answers:collect()}));alert('Progress saved in this browser.')}\n function submit(){if(submitted)return;let a=collect();let unanswered=current.length-Object.keys(a).length;if(unanswered&&!confirm(`${unanswered} question(s) unanswered. Submit anyway?`))return;submitted=true;let correct=0,by={};current.forEach(q=>{let chosen=a[q.id],ok=chosen===q.answer;if(ok)correct++;by[q.chapter]??={c:0,n:0};by[q.chapter].n++;if(ok)by[q.chapter].c++;let box=root.querySelector(`.cdmpq-q[data-id=\"${q.id}\"]`);box.querySelectorAll('.cdmpq-opt').forEach((el,k)=>{el.classList.toggle('cdmpq-correct',k===q.answer);el.classList.toggle('cdmpq-wrong',k===chosen&&k!==q.answer);el.querySelector('input').disabled=true});let r=document.createElement('div');r.className='cdmpq-rationale';r.innerHTML=`<strong>${ok?'Correct':'Review'}.<\/strong> ${esc(q.rationale)}`;box.appendChild(r)});let pct=Math.round(100*correct\/current.length);let result=document.createElement('div');result.className='cdmpq-card';result.innerHTML=`<h2>Results<\/h2><div class=\"cdmpq-kpis\"><div class=\"cdmpq-kpi\"><strong>${correct}\/${current.length}<\/strong>Correct<\/div><div class=\"cdmpq-kpi\"><strong>${pct}%<\/strong>Score<\/div><div class=\"cdmpq-kpi\"><strong>${current.length-correct}<\/strong>To review<\/div><\/div><h3>Chapter breakdown<\/h3><table class=\"cdmpq-breakdown\"><thead><tr><th>Chapter<\/th><th>Correct<\/th><th>Score<\/th><\/tr><\/thead><tbody>${Object.entries(by).map(([c,v])=>`<tr><td>${esc(c)}<\/td><td>${v.c}\/${v.n}<\/td><td>${Math.round(100*v.c\/v.n)}%<\/td><\/tr>`).join('')}<\/tbody><\/table><div class=\"cdmpq-actions\"><button id=\"cdmp-again\">Start another quiz<\/button><\/div>`;stage.prepend(result);result.querySelector('#cdmp-again').onclick=()=>begin(false);localStorage.removeItem('cdmpQuizState');result.scrollIntoView({behavior:'smooth'})}\n $('#cdmp-start').onclick=()=>begin(false);$('#cdmp-resume').onclick=()=>{let s=localStorage.getItem('cdmpQuizState');if(!s)return alert('No saved quiz found.');try{begin(JSON.parse(s))}catch(e){alert('Saved quiz could not be opened.')}};$('#cdmp-clear').onclick=()=>{localStorage.removeItem('cdmpQuizState');alert('Saved progress cleared.')};\n})();\n<\/script><\/body><\/html>\n\n\n\n<meta charset=\"utf-8\"><meta name=\"viewport\" content=\"width=device-width,initial-scale=1\"><title>CDMP Practice Quiz<\/title><style>body{margin:0;background:#eef3f8;padding:18px}\n.cdmpq{max-width:980px;margin:24px auto;font-family:system-ui,-apple-system,Segoe UI,sans-serif;color:#172033}.cdmpq *{box-sizing:border-box}.cdmpq-card{background:#fff;border:1px solid #dce3ec;border-radius:16px;padding:22px;box-shadow:0 5px 20px rgba(20,40,70,.08);margin-bottom:18px}.cdmpq h2,.cdmpq h3{margin-top:0}.cdmpq-controls{display:grid;grid-template-columns:2fr 1fr 1fr;gap:12px}.cdmpq label{font-weight:650;font-size:14px}.cdmpq select,.cdmpq input,.cdmpq button{font:inherit}.cdmpq select,.cdmpq input{width:100%;padding:10px;border:1px solid #b9c5d4;border-radius:9px;margin-top:5px}.cdmpq button{border:0;border-radius:9px;padding:11px 16px;background:#1967b3;color:#fff;font-weight:700;cursor:pointer}.cdmpq button.secondary{background:#e9f0f7;color:#164c7e}.cdmpq button.danger{background:#9c2f2f}.cdmpq-actions{display:flex;gap:10px;flex-wrap:wrap;margin-top:16px}.cdmpq-progress{height:10px;background:#e9eef4;border-radius:999px;overflow:hidden;margin:14px 0}.cdmpq-progress>span{height:100%;display:block;background:#1f78c1;width:0}.cdmpq-q{border-top:1px solid #e5eaf0;padding:18px 0}.cdmpq-q:first-child{border-top:0}.cdmpq-meta{color:#526274;font-size:13px;margin-bottom:6px}.cdmpq-opt{display:block;padding:10px 12px;margin:7px 0;border:1px solid #d3dbe5;border-radius:9px;cursor:pointer;font-weight:400}.cdmpq-opt:hover{background:#f5f8fb}.cdmpq-opt input{width:auto;margin:0 9px 0 0}.cdmpq-correct{background:#e9f7ee!important;border-color:#3b9a5f!important}.cdmpq-wrong{background:#fff0f0!important;border-color:#c34b4b!important}.cdmpq-rationale{padding:10px 12px;background:#f6f8fb;border-left:4px solid #547da6;margin-top:8px}.cdmpq-kpis{display:grid;grid-template-columns:repeat(3,1fr);gap:12px}.cdmpq-kpi{background:#f1f6fb;border-radius:12px;padding:16px;text-align:center}.cdmpq-kpi strong{font-size:28px;display:block;color:#14588f}.cdmpq-breakdown{width:100%;border-collapse:collapse}.cdmpq-breakdown th,.cdmpq-breakdown td{text-align:left;padding:9px;border-bottom:1px solid #e3e8ef}.cdmpq-note{font-size:13px;color:#596879}.cdmpq-hidden{display:none!important}@media(max-width:700px){.cdmpq-controls,.cdmpq-kpis{grid-template-columns:1fr}.cdmpq-card{padding:15px}}\n<\/style><div id=\"cdmp-practice-quiz\"><\/div><script>const CDMP_QUESTIONS=[{\"id\":1,\"chapter\":\"1. Data Governance\",\"question\":\"What is the primary purpose of data governance?\",\"options\":[\"Establish decision rights and accountability for data\",\"Operate backup infrastructure\",\"Develop analytical models\",\"Design database indexes\"],\"answer\":0,\"rationale\":\"Governance defines authority, accountability, policies, and decision processes for data.\",\"difficulty\":\"Mixed\"},{\"id\":2,\"chapter\":\"1. Data Governance\",\"question\":\"Who is normally accountable for the business definition and acceptable quality of a data domain?\",\"options\":[\"The database administrator\",\"The application developer\",\"The Data Owner\",\"The network engineer\"],\"answer\":2,\"rationale\":\"A Data Owner is accountable for decisions and outcomes within a business data domain.\",\"difficulty\":\"Mixed\"},{\"id\":3,\"chapter\":\"1. Data Governance\",\"question\":\"Which activity is most characteristic of a Data Steward?\",\"options\":[\"Monitoring definitions, quality issues, and compliance in daily operations\",\"Owning all enterprise applications\",\"Approving the corporate budget\",\"Configuring network firewalls\"],\"answer\":0,\"rationale\":\"Stewards perform operational coordination and monitoring under the accountability of owners.\",\"difficulty\":\"Mixed\"},{\"id\":4,\"chapter\":\"1. Data Governance\",\"question\":\"Two departments disagree on the meaning of 'active supplier.' What should happen first?\",\"options\":[\"Let each report retain its own definition\",\"Use the governance decision process to agree and approve one definition\",\"Delete the term from all reports\",\"Ask the DBA to choose a definition\"],\"answer\":1,\"rationale\":\"Conflicting enterprise definitions require an authorized governance decision, not an informal technical choice.\",\"difficulty\":\"Mixed\"},{\"id\":5,\"chapter\":\"1. Data Governance\",\"question\":\"Which is the best evidence that a governance policy is mature?\",\"options\":[\"It has many pages\",\"It exists as a draft file\",\"It is technically detailed\",\"It is approved, adopted, monitored, and periodically improved\"],\"answer\":3,\"rationale\":\"Document existence alone is insufficient; mature capability includes adoption, measurement, and improvement.\",\"difficulty\":\"Mixed\"},{\"id\":6,\"chapter\":\"1. Data Governance\",\"question\":\"What is a decision right?\",\"options\":[\"A defined authority to make or approve a data-related decision\",\"A report subscription\",\"A database permission granted to every user\",\"A legal ownership claim over software\"],\"answer\":0,\"rationale\":\"Decision rights clarify who may decide, approve, escalate, or resolve specific data matters.\",\"difficulty\":\"Mixed\"},{\"id\":7,\"chapter\":\"1. Data Governance\",\"question\":\"Which body commonly resolves cross-domain data conflicts?\",\"options\":[\"The Data Governance Council\",\"The database vendor\",\"The help desk\",\"The project scheduler\"],\"answer\":0,\"rationale\":\"A cross-functional governance body handles conflicts that exceed one domain owner's authority.\",\"difficulty\":\"Mixed\"},{\"id\":8,\"chapter\":\"1. Data Governance\",\"question\":\"Which statement best distinguishes policy from standard?\",\"options\":[\"There is no practical difference\",\"Policy states required intent; a standard specifies mandatory requirements\",\"Policy is optional; standards are always laws\",\"Policy is technical; standards are strategic\"],\"answer\":1,\"rationale\":\"Policies express direction and obligations, while standards make those obligations specific and testable.\",\"difficulty\":\"Mixed\"},{\"id\":9,\"chapter\":\"1. Data Governance\",\"question\":\"A governance program has many meetings but no recorded decisions. What is the main weakness?\",\"options\":[\"The data warehouse is too small\",\"The backup window is too long\",\"The operating model lacks effective decision execution\",\"The data model is over-normalized\"],\"answer\":2,\"rationale\":\"Governance should produce accountable decisions and outcomes, not only discussion.\",\"difficulty\":\"Mixed\"},{\"id\":10,\"chapter\":\"1. Data Governance\",\"question\":\"Which metric best measures stewardship effectiveness?\",\"options\":[\"CPU utilization\",\"Percentage of assigned data issues resolved within the agreed SLA\",\"Number of database servers\",\"Total document page count\"],\"answer\":1,\"rationale\":\"Issue resolution against an agreed service level reflects an operational stewardship outcome.\",\"difficulty\":\"Mixed\"},{\"id\":11,\"chapter\":\"1. Data Governance\",\"question\":\"Who should approve access to confidential supplier pricing data?\",\"options\":[\"The first user requesting access\",\"Any report developer\",\"The accountable Data Owner, following security policy\",\"The storage administrator alone\"],\"answer\":2,\"rationale\":\"Business access decisions belong to the accountable owner; technical teams implement them.\",\"difficulty\":\"Mixed\"},{\"id\":12,\"chapter\":\"1. Data Governance\",\"question\":\"What should determine the scope of a governance program?\",\"options\":[\"The age of the oldest database\",\"Business priorities, risk, and critical data needs\",\"Only the preferences of IT\",\"The number of available meeting rooms\"],\"answer\":1,\"rationale\":\"Governance scope should align with business value, obligations, and risk.\",\"difficulty\":\"Mixed\"},{\"id\":13,\"chapter\":\"1. Data Governance\",\"question\":\"Which deliverable clarifies who is Responsible, Accountable, Consulted, and Informed?\",\"options\":[\"A physical data model\",\"A star schema\",\"A RACI matrix\",\"A recovery log\"],\"answer\":2,\"rationale\":\"A RACI matrix assigns participation and accountability across activities.\",\"difficulty\":\"Mixed\"},{\"id\":14,\"chapter\":\"1. Data Governance\",\"question\":\"A policy exception is requested. What is the soundest governance response?\",\"options\":[\"Approve verbally with no record\",\"Delete the policy\",\"Ignore the policy permanently\",\"Document the rationale, risk, approval, duration, and compensating controls\"],\"answer\":3,\"rationale\":\"Controlled exceptions should be transparent, risk-assessed, time-bound, and accountable.\",\"difficulty\":\"Mixed\"},{\"id\":15,\"chapter\":\"1. Data Governance\",\"question\":\"What is the best relationship between data strategy and data governance?\",\"options\":[\"Strategy sets direction; governance supplies authority and control to execute it\",\"They are unrelated\",\"Strategy is only a technical architecture\",\"Governance replaces strategy\"],\"answer\":0,\"rationale\":\"Governance operationalizes strategic intent through roles, policies, decisions, and oversight.\",\"difficulty\":\"Mixed\"},{\"id\":16,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the central purpose of data architecture?\",\"options\":[\"Approve employee expenses\",\"Write every SQL query\",\"Provide an enterprise blueprint for organizing and using data assets\",\"Manage document retention alone\"],\"answer\":2,\"rationale\":\"Architecture translates business and data strategy into target structures, flows, and principles.\",\"difficulty\":\"Mixed\"},{\"id\":17,\"chapter\":\"2. Data Architecture\",\"question\":\"Which artifact presents major data domains and their relationships at enterprise level?\",\"options\":[\"A sprint burndown chart\",\"An enterprise conceptual data model\",\"A user access list\",\"A backup log\"],\"answer\":1,\"rationale\":\"An enterprise conceptual model communicates major business concepts without implementation detail.\",\"difficulty\":\"Mixed\"},{\"id\":18,\"chapter\":\"2. Data Architecture\",\"question\":\"What does an authoritative source designation clarify?\",\"options\":[\"Which source is trusted to create or maintain defined data\",\"Which team owns the network\",\"Which server is newest\",\"Which report has the brightest colors\"],\"answer\":0,\"rationale\":\"Authoritative-source decisions reduce ambiguity about trusted creation and maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":19,\"chapter\":\"2. Data Architecture\",\"question\":\"Which architecture principle is most appropriate?\",\"options\":[\"All data must be copied into spreadsheets\",\"Every project should create separate definitions\",\"Data should be shared through governed, reusable interfaces\",\"Security should be added only after deployment\"],\"answer\":2,\"rationale\":\"Principles should promote reuse, consistency, governance, and secure design.\",\"difficulty\":\"Mixed\"},{\"id\":20,\"chapter\":\"2. Data Architecture\",\"question\":\"What is a target-state data architecture?\",\"options\":[\"A physical table definition only\",\"The intended future arrangement of data capabilities and components\",\"A list of yesterday's incidents\",\"A vendor invoice\"],\"answer\":1,\"rationale\":\"Target state describes the future architecture toward which the roadmap progresses.\",\"difficulty\":\"Mixed\"},{\"id\":21,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the principal purpose of a data-flow diagram?\",\"options\":[\"Display employee reporting lines\",\"Calculate storage invoices\",\"Show movement of data among processes, stores, and external entities\",\"Define password length\"],\"answer\":2,\"rationale\":\"Data-flow diagrams emphasize movement, transformation context, and interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":22,\"chapter\":\"2. Data Architecture\",\"question\":\"A canonical model is primarily used to do what?\",\"options\":[\"Provide a common exchange representation across systems\",\"Set backup frequencies\",\"Replace all source databases\",\"Approve access requests\"],\"answer\":0,\"rationale\":\"A canonical model reduces repeated pairwise mappings and supports interoperability.\",\"difficulty\":\"Mixed\"},{\"id\":23,\"chapter\":\"2. Data Architecture\",\"question\":\"Which choice most directly reduces point-to-point integration complexity?\",\"options\":[\"Separate codes in every application\",\"Duplicate databases for each report\",\"A governed integration layer with reusable services or events\",\"More manual file transfers\"],\"answer\":2,\"rationale\":\"Reusable integration patterns reduce coupling and uncontrolled interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":24,\"chapter\":\"2. Data Architecture\",\"question\":\"What should drive architecture decisions first?\",\"options\":[\"The oldest available technology\",\"Individual developer preference\",\"A preferred vendor logo\",\"Business capabilities, requirements, principles, and constraints\"],\"answer\":3,\"rationale\":\"Architecture exists to serve business outcomes within agreed principles and constraints.\",\"difficulty\":\"Mixed\"},{\"id\":25,\"chapter\":\"2. Data Architecture\",\"question\":\"Which is normally an architecture concern rather than a detailed physical-design concern?\",\"options\":[\"Defining enterprise data domains and distribution patterns\",\"Creating a specific index\",\"Choosing a column's exact storage length\",\"Writing a stored procedure\"],\"answer\":0,\"rationale\":\"Architecture addresses enterprise structure and patterns; physical design addresses implementation detail.\",\"difficulty\":\"Mixed\"},{\"id\":26,\"chapter\":\"2. Data Architecture\",\"question\":\"Why maintain current-state architecture?\",\"options\":[\"To replace all operational monitoring\",\"To eliminate governance\",\"To avoid defining a target state\",\"To understand dependencies, risks, duplication, and migration needs\"],\"answer\":3,\"rationale\":\"A credible roadmap requires understanding the existing landscape and constraints.\",\"difficulty\":\"Mixed\"},{\"id\":27,\"chapter\":\"2. Data Architecture\",\"question\":\"What is an architecture transition state?\",\"options\":[\"An unapproved glossary term\",\"A retired document\",\"An intermediate configuration between current and target states\",\"A failed database transaction\"],\"answer\":2,\"rationale\":\"Complex transformations often require planned intermediate states.\",\"difficulty\":\"Mixed\"},{\"id\":28,\"chapter\":\"2. Data Architecture\",\"question\":\"A new analytics platform duplicates customer definitions. Which review should identify this risk?\",\"options\":[\"Payroll approval\",\"Printer maintenance review\",\"Data architecture and governance review\",\"Office safety inspection\"],\"answer\":2,\"rationale\":\"Architecture review checks alignment, reuse, authoritative sources, and enterprise consistency.\",\"difficulty\":\"Mixed\"},{\"id\":29,\"chapter\":\"2. Data Architecture\",\"question\":\"What does technology independence mean in a logical architecture?\",\"options\":[\"The design expresses required capabilities without binding them to one product\",\"All technologies are identical\",\"Implementation details are fully specified\",\"No technology will ever be used\"],\"answer\":0,\"rationale\":\"Logical architecture focuses on capabilities and relationships before product-specific realization.\",\"difficulty\":\"Mixed\"},{\"id\":30,\"chapter\":\"2. Data Architecture\",\"question\":\"What is the best measure of architecture effectiveness?\",\"options\":[\"Length of architecture documents\",\"Number of diagrams produced\",\"Degree to which solutions conform to principles and deliver intended business outcomes\",\"Number of vendors engaged\"],\"answer\":2,\"rationale\":\"Effectiveness is demonstrated by useful outcomes and consistent implementation, not artifact volume.\",\"difficulty\":\"Mixed\"},{\"id\":31,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Which model is best for discussing major business entities with executives?\",\"options\":[\"Database execution plan\",\"Conceptual data model\",\"Physical data model\",\"Index definition\"],\"answer\":1,\"rationale\":\"Conceptual models communicate high-level business concepts and relationships.\",\"difficulty\":\"Mixed\"},{\"id\":32,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What distinguishes a logical data model?\",\"options\":[\"It contains only dashboards\",\"It defines backup schedules\",\"It contains only server names\",\"It defines entities, attributes, relationships, and rules without product-specific implementation\"],\"answer\":3,\"rationale\":\"Logical models add structured detail while remaining technology independent.\",\"difficulty\":\"Mixed\"},{\"id\":33,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What does a physical data model add?\",\"options\":[\"Only data-owner names\",\"Only business vision statements\",\"Platform-specific tables, columns, data types, constraints, and indexes\",\"Only retention policies\"],\"answer\":2,\"rationale\":\"Physical models translate logical designs into implementable database structures.\",\"difficulty\":\"Mixed\"},{\"id\":34,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the purpose of a primary key?\",\"options\":[\"Schedule ETL jobs\",\"Uniquely identify each entity occurrence or row\",\"Encrypt sensitive attributes\",\"Define document ownership\"],\"answer\":1,\"rationale\":\"A primary key provides stable uniqueness within a relation.\",\"difficulty\":\"Mixed\"},{\"id\":35,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the purpose of a foreign key?\",\"options\":[\"Maintain a reference to a key in a related table\",\"Generate reports automatically\",\"Classify security levels\",\"Store unstructured content\"],\"answer\":0,\"rationale\":\"Foreign keys implement relationships and support referential integrity.\",\"difficulty\":\"Mixed\"},{\"id\":36,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"How is a many-to-many relationship normally resolved in a relational model?\",\"options\":[\"Remove all keys\",\"Delete one entity\",\"Duplicate every row\",\"Introduce an associative entity or junction table\"],\"answer\":3,\"rationale\":\"The associative entity represents each valid pairing and may hold relationship attributes.\",\"difficulty\":\"Mixed\"},{\"id\":37,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What does cardinality describe?\",\"options\":[\"The number of backups\",\"The age of a database\",\"The sensitivity of a field\",\"The permitted number of occurrences in a relationship\"],\"answer\":3,\"rationale\":\"Cardinality defines one-to-one, one-to-many, many-to-many, and optionality constraints.\",\"difficulty\":\"Mixed\"},{\"id\":38,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is the main objective of normalization?\",\"options\":[\"Eliminate all relationships\",\"Reduce redundancy and avoid update anomalies\",\"Replace business rules\",\"Increase duplicate storage\"],\"answer\":1,\"rationale\":\"Normalization separates dependencies to improve consistency and maintainability.\",\"difficulty\":\"Mixed\"},{\"id\":39,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"A table contains Order1, Order2, and Order3 repeating columns. Which principle is violated?\",\"options\":[\"Encryption at rest\",\"First Normal Form\",\"Data lineage\",\"Least privilege\"],\"answer\":1,\"rationale\":\"Repeating groups prevent each field from holding a single atomic value.\",\"difficulty\":\"Mixed\"},{\"id\":40,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Why might an analytical model be deliberately denormalized?\",\"options\":[\"To avoid defining metrics\",\"To simplify queries and improve analytical performance\",\"To remove all dimensions\",\"To prevent historical analysis\"],\"answer\":1,\"rationale\":\"Denormalization can be appropriate when controlled redundancy improves analytical usability.\",\"difficulty\":\"Mixed\"},{\"id\":41,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is a supertype\/subtype structure used for?\",\"options\":[\"Measure data quality\",\"Schedule backups\",\"Define API throttling\",\"Model common attributes and specialized entity variations\"],\"answer\":3,\"rationale\":\"Supertypes capture commonality; subtypes capture specialized characteristics.\",\"difficulty\":\"Mixed\"},{\"id\":42,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What is a natural key?\",\"options\":[\"A password hash\",\"A database file name\",\"A randomly generated technical identifier only\",\"A meaningful business attribute or combination that uniquely identifies an entity\"],\"answer\":3,\"rationale\":\"Natural keys derive from business meaning, such as a recognized registration code.\",\"difficulty\":\"Mixed\"},{\"id\":43,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Why use a surrogate key in a warehouse dimension?\",\"options\":[\"Provide a stable technical identifier independent of changing source keys\",\"Store documents\",\"Replace dimension attributes\",\"Eliminate all source mappings\"],\"answer\":0,\"rationale\":\"Surrogate keys support history and integration across changing or multiple source identifiers.\",\"difficulty\":\"Mixed\"},{\"id\":44,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"What should happen when a model conflicts with an approved business definition?\",\"options\":[\"Let each developer choose\",\"Reconcile the model with governance and the accountable business owner\",\"Delete the model\",\"Ignore the glossary\"],\"answer\":1,\"rationale\":\"Models should faithfully represent governed business meaning.\",\"difficulty\":\"Mixed\"},{\"id\":45,\"chapter\":\"3. Data Modeling and Design\",\"question\":\"Which artifact maps a logical attribute to its physical column?\",\"options\":[\"A model mapping or transformation specification\",\"A firewall rule\",\"A retention schedule\",\"A meeting agenda\"],\"answer\":0,\"rationale\":\"Mapping documentation connects logical meaning to implementation and supports traceability.\",\"difficulty\":\"Mixed\"},{\"id\":46,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is the chief objective of data storage and operations?\",\"options\":[\"Assign data owners\",\"Maintain accessible, reliable, recoverable, and performant data platforms\",\"Design corporate logos\",\"Approve business definitions\"],\"answer\":1,\"rationale\":\"Operations manages the day-to-day technical environment and service continuity.\",\"difficulty\":\"Mixed\"},{\"id\":47,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What does Recovery Time Objective measure?\",\"options\":[\"Maximum acceptable data loss\",\"Retention duration\",\"Maximum targeted time to restore a service after disruption\",\"Average query size\"],\"answer\":2,\"rationale\":\"RTO concerns elapsed recovery time.\",\"difficulty\":\"Mixed\"},{\"id\":48,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What does Recovery Point Objective measure?\",\"options\":[\"Time to rebuild a server\",\"Annual storage growth\",\"Number of recovery staff\",\"Maximum acceptable period of data loss measured backward from an incident\"],\"answer\":3,\"rationale\":\"RPO determines how current recovered data must be.\",\"difficulty\":\"Mixed\"},{\"id\":49,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Why are recovery tests necessary even when backups succeed?\",\"options\":[\"A successful backup does not prove that restoration will work within objectives\",\"Backups automatically test every application\",\"Testing replaces retention policies\",\"Testing removes cyber risk\"],\"answer\":0,\"rationale\":\"Recoverability must be demonstrated through restoration and service exercises.\",\"difficulty\":\"Mixed\"},{\"id\":50,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is capacity management?\",\"options\":[\"Managing customer consent\",\"Designing taxonomies\",\"Forecasting and providing sufficient storage and compute resources\",\"Approving data definitions\"],\"answer\":2,\"rationale\":\"Capacity management anticipates growth and workload demand.\",\"difficulty\":\"Mixed\"},{\"id\":51,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Which metric most directly reflects service availability?\",\"options\":[\"Count of conceptual entities\",\"Percentage of agreed service time that the platform is usable\",\"Number of glossary terms\",\"Number of data owners\"],\"answer\":1,\"rationale\":\"Availability measures usable service relative to its agreed operating window.\",\"difficulty\":\"Mixed\"},{\"id\":52,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is archiving?\",\"options\":[\"Deleting all old data immediately\",\"Creating a new business term\",\"Copying production data for testing without controls\",\"Moving inactive information to managed long-term storage while retaining required access\"],\"answer\":3,\"rationale\":\"Archiving separates inactive data while preserving retention, protection, and retrievability.\",\"difficulty\":\"Mixed\"},{\"id\":53,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is the main risk of retaining data indefinitely?\",\"options\":[\"Guaranteed better quality\",\"Reduced security requirements\",\"Increased cost, exposure, and regulatory or legal risk\",\"Automatic lineage\"],\"answer\":2,\"rationale\":\"Unnecessary retention expands the attack surface and compliance burden.\",\"difficulty\":\"Mixed\"},{\"id\":54,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"A critical batch fails nightly. What is the first operational need?\",\"options\":[\"Detect, log, alert, and initiate documented incident handling\",\"Change the Data Owner\",\"Create a new taxonomy\",\"Redesign the enterprise glossary\"],\"answer\":0,\"rationale\":\"Reliable operations require timely detection, evidence, escalation, and recovery.\",\"difficulty\":\"Mixed\"},{\"id\":55,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is configuration management used for?\",\"options\":[\"Approve records disposition\",\"Calculate business KPIs\",\"Control and trace approved changes to platform configurations\",\"Define customer segments\"],\"answer\":2,\"rationale\":\"Configuration control supports stable and auditable environments.\",\"difficulty\":\"Mixed\"},{\"id\":56,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Which practice best protects backup confidentiality?\",\"options\":[\"Use shared administrator accounts\",\"Remove backup logs\",\"Store all backups publicly\",\"Encrypt backups and restrict access according to classification\"],\"answer\":3,\"rationale\":\"Backup copies require protections equivalent to the source data.\",\"difficulty\":\"Mixed\"},{\"id\":57,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is a service-level agreement?\",\"options\":[\"A master-data match rule\",\"A documented commitment for measurable service performance\",\"A business glossary\",\"A conceptual data model\"],\"answer\":1,\"rationale\":\"SLAs specify measurable expectations such as availability, response, and recovery.\",\"difficulty\":\"Mixed\"},{\"id\":58,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Why separate production and non-production environments?\",\"options\":[\"Avoid documenting changes\",\"Permit unrestricted data copying\",\"Eliminate testing\",\"Reduce operational risk and limit inappropriate access to live data\"],\"answer\":3,\"rationale\":\"Environment separation protects production and supports controlled testing.\",\"difficulty\":\"Mixed\"},{\"id\":59,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"What is a database health check intended to detect?\",\"options\":[\"Employee training needs only\",\"Unapproved business vocabulary only\",\"Marketing opportunities\",\"Emerging performance, capacity, integrity, or availability risks\"],\"answer\":3,\"rationale\":\"Health checks proactively assess technical service conditions.\",\"difficulty\":\"Mixed\"},{\"id\":60,\"chapter\":\"4. Data Storage and Operations\",\"question\":\"Who generally implements database permissions after business approval?\",\"options\":[\"The Data Owner alone in the database\",\"The DBA or platform operations team\",\"Any end user\",\"The Governance Council directly\"],\"answer\":1,\"rationale\":\"Business owners approve; authorized technical administrators implement and log access.\",\"difficulty\":\"Mixed\"},{\"id\":61,\"chapter\":\"5. Data Security\",\"question\":\"What does confidentiality protect?\",\"options\":[\"Document version numbering\",\"Data from unauthorized disclosure\",\"Service uptime only\",\"Data from all changes\"],\"answer\":1,\"rationale\":\"Confidentiality limits information exposure to authorized parties.\",\"difficulty\":\"Mixed\"},{\"id\":62,\"chapter\":\"5. Data Security\",\"question\":\"What does integrity protect?\",\"options\":[\"Data from unauthorized or improper alteration\",\"Only storage cost\",\"Only file discoverability\",\"Only system availability\"],\"answer\":0,\"rationale\":\"Integrity preserves correctness and trustworthiness against improper change.\",\"difficulty\":\"Mixed\"},{\"id\":63,\"chapter\":\"5. Data Security\",\"question\":\"What does availability ensure?\",\"options\":[\"All data is public\",\"All records are permanent\",\"All databases use one vendor\",\"Authorized users can access data and services when required\"],\"answer\":3,\"rationale\":\"Availability concerns reliable, timely access for authorized use.\",\"difficulty\":\"Mixed\"},{\"id\":64,\"chapter\":\"5. Data Security\",\"question\":\"What is least privilege?\",\"options\":[\"Allowing permanent access by default\",\"Sharing service accounts\",\"Giving all managers administrator rights\",\"Granting only the minimum access needed for assigned duties\"],\"answer\":3,\"rationale\":\"Least privilege limits exposure and reduces the impact of misuse or compromise.\",\"difficulty\":\"Mixed\"},{\"id\":65,\"chapter\":\"5. Data Security\",\"question\":\"What is separation of duties?\",\"options\":[\"Giving one person end-to-end control\",\"Storing all data in separate tables\",\"Dividing conflicting responsibilities among different people or roles\",\"Removing approval steps\"],\"answer\":2,\"rationale\":\"Separation reduces fraud and error by preventing incompatible powers from residing in one role.\",\"difficulty\":\"Mixed\"},{\"id\":66,\"chapter\":\"5. Data Security\",\"question\":\"Why classify data?\",\"options\":[\"Replace metadata\",\"Apply protection based on sensitivity, value, and obligations\",\"Improve query joins\",\"Eliminate access reviews\"],\"answer\":1,\"rationale\":\"Classification connects business sensitivity to appropriate controls.\",\"difficulty\":\"Mixed\"},{\"id\":67,\"chapter\":\"5. Data Security\",\"question\":\"Which control protects data in transit?\",\"options\":[\"Encrypted communication such as approved TLS\",\"A taxonomy\",\"A conceptual model\",\"A database index\"],\"answer\":0,\"rationale\":\"Transport encryption protects data while crossing networks.\",\"difficulty\":\"Mixed\"},{\"id\":68,\"chapter\":\"5. Data Security\",\"question\":\"Which control most directly protects data at rest?\",\"options\":[\"A data-flow diagram\",\"A report filter\",\"A glossary definition\",\"Approved storage or database encryption\"],\"answer\":3,\"rationale\":\"At-rest encryption protects stored copies and media.\",\"difficulty\":\"Mixed\"},{\"id\":69,\"chapter\":\"5. Data Security\",\"question\":\"What is multi-factor authentication?\",\"options\":[\"Entering the same PIN twice\",\"Authentication using evidence from more than one factor category\",\"Using two passwords\",\"Approving two reports\"],\"answer\":1,\"rationale\":\"MFA combines distinct factors such as knowledge, possession, or inherence.\",\"difficulty\":\"Mixed\"},{\"id\":70,\"chapter\":\"5. Data Security\",\"question\":\"Why are privileged accounts monitored more closely?\",\"options\":[\"They are used only for reporting\",\"They always contain better data\",\"They can perform high-impact administrative actions\",\"They require no approval\"],\"answer\":2,\"rationale\":\"Elevated permissions create greater risk and require stronger oversight.\",\"difficulty\":\"Mixed\"},{\"id\":71,\"chapter\":\"5. Data Security\",\"question\":\"What is data masking used for?\",\"options\":[\"Create primary keys\",\"Hide or transform sensitive values while preserving permitted use\",\"Schedule backups\",\"Build taxonomies\"],\"answer\":1,\"rationale\":\"Masking reduces exposure in displays, testing, or analytics.\",\"difficulty\":\"Mixed\"},{\"id\":72,\"chapter\":\"5. Data Security\",\"question\":\"A former employee retains access. Which control failed most directly?\",\"options\":[\"Timely identity deprovisioning\",\"Dimensional modeling\",\"Metadata harvesting\",\"Data profiling\"],\"answer\":0,\"rationale\":\"Joiner-mover-leaver controls should promptly remove access after departure.\",\"difficulty\":\"Mixed\"},{\"id\":73,\"chapter\":\"5. Data Security\",\"question\":\"What is the purpose of security audit logging?\",\"options\":[\"Create evidence of access, changes, and significant events\",\"Improve normalization\",\"Define business terms\",\"Replace incident response\"],\"answer\":0,\"rationale\":\"Logs support monitoring, investigation, accountability, and compliance.\",\"difficulty\":\"Mixed\"},{\"id\":74,\"chapter\":\"5. Data Security\",\"question\":\"Who should decide the acceptable business use of sensitive data?\",\"options\":[\"A developer acting alone\",\"The software vendor\",\"The accountable business owner under governance, privacy, and security rules\",\"Any system administrator\"],\"answer\":2,\"rationale\":\"Use decisions require business accountability within applicable rules and risk controls.\",\"difficulty\":\"Mixed\"},{\"id\":75,\"chapter\":\"5. Data Security\",\"question\":\"What is defense in depth?\",\"options\":[\"Using multiple complementary security controls across layers\",\"Using only physical security\",\"Relying on one strong password\",\"Removing duplicate controls\"],\"answer\":0,\"rationale\":\"Layered controls reduce dependence on a single preventive mechanism.\",\"difficulty\":\"Mixed\"},{\"id\":76,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is the basic purpose of data integration?\",\"options\":[\"Replace data modeling\",\"Define document retention\",\"Move, combine, and synchronize data across sources and consumers\",\"Approve business budgets\"],\"answer\":2,\"rationale\":\"Integration enables coordinated data use across systems and processes.\",\"difficulty\":\"Mixed\"},{\"id\":77,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What does interoperability add beyond data movement?\",\"options\":[\"Shared ability to interpret and use exchanged information correctly\",\"Faster password resets\",\"Larger storage capacity\",\"More document versions\"],\"answer\":0,\"rationale\":\"Interoperability includes syntactic and semantic understanding.\",\"difficulty\":\"Mixed\"},{\"id\":78,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is a source-to-target mapping?\",\"options\":[\"A backup schedule\",\"A security classification list\",\"A specification linking source elements to target elements and transformations\",\"A RACI matrix\"],\"answer\":2,\"rationale\":\"Mappings make integration logic explicit and testable.\",\"difficulty\":\"Mixed\"},{\"id\":79,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What does ETL mean?\",\"options\":[\"Extract, Transform, Load\",\"Encrypt, Test, Log\",\"Evaluate, Transfer, Link\",\"Extract, Track, List\"],\"answer\":0,\"rationale\":\"ETL transforms data before loading it into the target.\",\"difficulty\":\"Mixed\"},{\"id\":80,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What distinguishes ELT?\",\"options\":[\"It eliminates quality controls\",\"It requires no extraction\",\"Data is loaded before target-platform transformations are applied\",\"It is always real time\"],\"answer\":2,\"rationale\":\"ELT uses target processing capabilities after initial loading.\",\"difficulty\":\"Mixed\"},{\"id\":81,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"When is an event-driven pattern appropriate?\",\"options\":[\"When consumers need timely notification of business state changes\",\"When systems must remain completely disconnected\",\"When no event can be defined\",\"When annual archiving is the only need\"],\"answer\":0,\"rationale\":\"Events support decoupled, near-real-time reactions to business changes.\",\"difficulty\":\"Mixed\"},{\"id\":82,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is the purpose of a dead-letter queue?\",\"options\":[\"Retain messages that cannot be processed for investigation or controlled retry\",\"Store master data permanently\",\"Replace monitoring\",\"Delete all failed messages silently\"],\"answer\":0,\"rationale\":\"Dead-letter handling prevents silent loss and supports remediation.\",\"difficulty\":\"Mixed\"},{\"id\":83,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is idempotency in integration?\",\"options\":[\"Mappings never change\",\"All messages are anonymous\",\"Every retry creates a new transaction\",\"Repeated processing of the same request has no additional unintended effect\"],\"answer\":3,\"rationale\":\"Idempotent design supports safe retry after uncertain outcomes.\",\"difficulty\":\"Mixed\"},{\"id\":84,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Why use correlation identifiers?\",\"options\":[\"Encrypt backups\",\"Create document taxonomies\",\"Trace one business transaction across services and logs\",\"Define retention periods\"],\"answer\":2,\"rationale\":\"Correlation IDs improve end-to-end observability and troubleshooting.\",\"difficulty\":\"Mixed\"},{\"id\":85,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is change data capture?\",\"options\":[\"Capturing screenshots of reports\",\"Archiving documents\",\"Changing all source keys\",\"Identifying and propagating data changes since a previous point\"],\"answer\":3,\"rationale\":\"CDC enables efficient incremental integration.\",\"difficulty\":\"Mixed\"},{\"id\":86,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What should happen to records that fail validation?\",\"options\":[\"Delete all source data\",\"Disable validation\",\"Quarantine or reject them with logged reasons and accountable remediation\",\"Load them silently\"],\"answer\":2,\"rationale\":\"Controlled exception handling prevents contamination and supports correction.\",\"difficulty\":\"Mixed\"},{\"id\":87,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Why is reconciliation performed?\",\"options\":[\"Define business ownership\",\"Confirm that expected records and values arrived accurately and completely\",\"Choose a database vendor\",\"Create a conceptual model\"],\"answer\":1,\"rationale\":\"Reconciliation detects loss, duplication, and transformation errors.\",\"difficulty\":\"Mixed\"},{\"id\":88,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is data virtualization?\",\"options\":[\"Providing governed access across sources without necessarily copying all data\",\"Replacing metadata\",\"Encrypting virtual machines\",\"Creating duplicate master records\"],\"answer\":0,\"rationale\":\"Virtualization presents integrated views while leaving data in underlying sources.\",\"difficulty\":\"Mixed\"},{\"id\":89,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"What is API versioning intended to manage?\",\"options\":[\"Database backup rotation\",\"Data-owner succession\",\"Controlled evolution of interfaces without unexpectedly breaking consumers\",\"Document disposal\"],\"answer\":2,\"rationale\":\"Versioning allows interfaces and consumers to evolve safely.\",\"difficulty\":\"Mixed\"},{\"id\":90,\"chapter\":\"6. Data Integration and Interoperability\",\"question\":\"Which artifact should connect integration requirements to the implemented flow?\",\"options\":[\"A standalone logo\",\"A printer inventory\",\"Traceability from requirement through design, mapping, tests, and monitoring\",\"An employee directory\"],\"answer\":2,\"rationale\":\"Traceability demonstrates that implemented integration satisfies approved requirements.\",\"difficulty\":\"Mixed\"},{\"id\":91,\"chapter\":\"7. Document and Content Management\",\"question\":\"What type of information is a primary focus of document and content management?\",\"options\":[\"Only database indexes\",\"Only relational keys\",\"Unstructured and semi-structured information such as documents, images, and media\",\"Only numerical measures\"],\"answer\":2,\"rationale\":\"DCM governs content that is not primarily managed as structured rows and columns.\",\"difficulty\":\"Mixed\"},{\"id\":92,\"chapter\":\"7. Document and Content Management\",\"question\":\"What makes a document a record?\",\"options\":[\"It has more than ten pages\",\"It is stored as PDF\",\"It contains a table\",\"It is retained as evidence of a business activity or obligation\"],\"answer\":3,\"rationale\":\"Record status depends on evidentiary and retention value, not file format.\",\"difficulty\":\"Mixed\"},{\"id\":93,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is version control intended to prevent?\",\"options\":[\"All document search\",\"Use of uncontrolled or obsolete document revisions\",\"All collaboration\",\"All metadata capture\"],\"answer\":1,\"rationale\":\"Version control identifies approved revisions and preserves change history.\",\"difficulty\":\"Mixed\"},{\"id\":94,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a retention schedule?\",\"options\":[\"An ETL timetable\",\"A database execution plan\",\"An access-control matrix only\",\"Rules defining how long categories of records are kept and their final disposition\"],\"answer\":3,\"rationale\":\"Retention schedules link record classes to legal, regulatory, and business requirements.\",\"difficulty\":\"Mixed\"},{\"id\":95,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a legal hold?\",\"options\":[\"A password reset\",\"A suspension of normal disposition for information relevant to a legal matter\",\"A physical data model\",\"Automatic deletion of evidence\"],\"answer\":1,\"rationale\":\"A hold preserves potentially relevant information until released.\",\"difficulty\":\"Mixed\"},{\"id\":96,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is a taxonomy?\",\"options\":[\"A database transaction\",\"A data-quality score\",\"A backup-copy type\",\"A hierarchical classification structure for organizing concepts or content\"],\"answer\":3,\"rationale\":\"Taxonomies use broader and narrower category relationships.\",\"difficulty\":\"Mixed\"},{\"id\":97,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is faceted classification?\",\"options\":[\"Encrypting each document twice\",\"Creating one category per file\",\"Classifying content using several independent metadata dimensions\",\"Using only one folder tree\"],\"answer\":2,\"rationale\":\"Facets allow filtering by dimensions such as type, department, product, and status.\",\"difficulty\":\"Mixed\"},{\"id\":98,\"chapter\":\"7. Document and Content Management\",\"question\":\"Which metadata most improves retrieval of a supplier contract?\",\"options\":[\"Supplier, document type, effective date, status, and owner\",\"CPU temperature\",\"Network hop count\",\"Database buffer size\"],\"answer\":0,\"rationale\":\"Descriptive and administrative metadata makes content discoverable and governable.\",\"difficulty\":\"Mixed\"},{\"id\":99,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is check-in\/check-out used for?\",\"options\":[\"Coordinate editing and prevent conflicting document changes\",\"Dispose of records\",\"Assign customer identifiers\",\"Design schemas\"],\"answer\":0,\"rationale\":\"The mechanism controls concurrent editing and preserves revision integrity.\",\"difficulty\":\"Mixed\"},{\"id\":100,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is records disposition?\",\"options\":[\"Renaming a file\",\"Adding a watermark\",\"Informal deletion by any user\",\"Authorized destruction or permanent transfer after retention requirements are met\"],\"answer\":3,\"rationale\":\"Disposition must be controlled, documented, and suspended when required.\",\"difficulty\":\"Mixed\"},{\"id\":101,\"chapter\":\"7. Document and Content Management\",\"question\":\"Why is full-text search alone insufficient?\",\"options\":[\"It always provides perfect results\",\"It may miss context, classification, ownership, and controlled meaning\",\"It replaces access controls\",\"It makes metadata illegal\"],\"answer\":1,\"rationale\":\"Good discovery combines content indexing with governed metadata.\",\"difficulty\":\"Mixed\"},{\"id\":102,\"chapter\":\"7. Document and Content Management\",\"question\":\"A production operator uses an obsolete work instruction. Which capability failed?\",\"options\":[\"Normalization\",\"Change data capture\",\"Controlled publication and version management\",\"Dimensional modeling\"],\"answer\":2,\"rationale\":\"Only the current approved instruction should be available for operational use.\",\"difficulty\":\"Mixed\"},{\"id\":103,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is the relationship between content management and security?\",\"options\":[\"Content access and handling must follow classification and authorization rules\",\"Public links are always acceptable\",\"Security applies only to databases\",\"Content never contains sensitive data\"],\"answer\":0,\"rationale\":\"Documents and media may contain sensitive information requiring equivalent protection.\",\"difficulty\":\"Mixed\"},{\"id\":104,\"chapter\":\"7. Document and Content Management\",\"question\":\"Why audit content access?\",\"options\":[\"Increase document length\",\"Replace retention schedules\",\"Provide evidence of viewing, editing, sharing, and disposition actions\",\"Eliminate classification\"],\"answer\":2,\"rationale\":\"Audit trails support accountability, investigations, and compliance.\",\"difficulty\":\"Mixed\"},{\"id\":105,\"chapter\":\"7. Document and Content Management\",\"question\":\"What is the best governance approach to shared-drive sprawl?\",\"options\":[\"Delete the entire drive immediately\",\"Inventory, classify, assign ownership, apply retention, and migrate or dispose systematically\",\"Allow anonymous public access\",\"Keep every file forever\"],\"answer\":1,\"rationale\":\"A risk-based information lifecycle approach avoids both uncontrolled retention and indiscriminate deletion.\",\"difficulty\":\"Mixed\"},{\"id\":106,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What does master data primarily represent?\",\"options\":[\"One-time business events only\",\"Technical logs only\",\"Core business entities shared across processes and systems\",\"Document versions only\"],\"answer\":2,\"rationale\":\"Master data describes persistent entities such as product, customer, supplier, and location.\",\"difficulty\":\"Mixed\"},{\"id\":107,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What does reference data primarily provide?\",\"options\":[\"Unstructured media\",\"Controlled values used to classify or constrain other data\",\"Complete transaction histories\",\"Database execution plans\"],\"answer\":1,\"rationale\":\"Reference data includes codes, statuses, units, and classifications.\",\"difficulty\":\"Mixed\"},{\"id\":108,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which is most likely master data?\",\"options\":[\"Supplier\",\"Invoice line\",\"Login event\",\"Purchase order\"],\"answer\":0,\"rationale\":\"A supplier is a reusable core business entity.\",\"difficulty\":\"Mixed\"},{\"id\":109,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which is most likely reference data?\",\"options\":[\"Unit-of-measure code\",\"Customer account\",\"Payment transaction\",\"Production order\"],\"answer\":0,\"rationale\":\"Units of measure form a controlled list used by master and transactional data.\",\"difficulty\":\"Mixed\"},{\"id\":110,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is a golden record?\",\"options\":[\"A glossary definition\",\"A permanent backup of every transaction\",\"The trusted, consolidated representation of a master-data entity\",\"A security audit log\"],\"answer\":2,\"rationale\":\"The golden record represents the reconciled best view of an entity.\",\"difficulty\":\"Mixed\"},{\"id\":111,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is entity resolution?\",\"options\":[\"Creating database indexes\",\"Determining which records refer to the same real-world entity\",\"Classifying documents\",\"Deleting every similar record\"],\"answer\":1,\"rationale\":\"Entity resolution uses matching evidence to identify duplicates and relationships.\",\"difficulty\":\"Mixed\"},{\"id\":112,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is survivorship in MDM?\",\"options\":[\"Deleting reference values\",\"Rules selecting trusted attribute values when sources conflict\",\"Keeping only the oldest database\",\"Choosing the cheapest vendor\"],\"answer\":1,\"rationale\":\"Survivorship determines which source or value wins for each attribute.\",\"difficulty\":\"Mixed\"},{\"id\":113,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which MDM style maintains cross-references while source systems continue to own records?\",\"options\":[\"Registry style\",\"Document archive\",\"Star schema\",\"Transactional hub only\"],\"answer\":0,\"rationale\":\"Registry MDM links identities across sources without necessarily centralizing all attributes.\",\"difficulty\":\"Mixed\"},{\"id\":114,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Which MDM style creates a central hub that authors and distributes master records?\",\"options\":[\"Document versioning\",\"Transactional or centralized authoring style\",\"Registry-only style\",\"Unmanaged replication\"],\"answer\":1,\"rationale\":\"A transactional hub acts as a central system for master-data creation and maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":115,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Why assign a master-data owner?\",\"options\":[\"Establish accountability for definitions, rules, quality, and access decisions\",\"Remove stewardship\",\"Avoid governance reviews\",\"Give one person all database passwords\"],\"answer\":0,\"rationale\":\"Ownership provides accountable business decision authority.\",\"difficulty\":\"Mixed\"},{\"id\":116,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is reference-data mapping?\",\"options\":[\"Defining backup media\",\"Relating code sets or values used by different systems\",\"Mapping office locations\",\"Creating document folders\"],\"answer\":1,\"rationale\":\"Mappings translate equivalent or related codes across sources and standards.\",\"difficulty\":\"Mixed\"},{\"id\":117,\"chapter\":\"8. Reference and Master Data\",\"question\":\"A system uses KG and another uses KGM. What is the principal requirement?\",\"options\":[\"A longer retention period\",\"Governed unit-code mapping and semantic equivalence\",\"More duplicate product records\",\"Removal of all units\"],\"answer\":1,\"rationale\":\"Interoperability requires controlled meanings and mappings for reference values.\",\"difficulty\":\"Mixed\"},{\"id\":118,\"chapter\":\"8. Reference and Master Data\",\"question\":\"Why measure duplicate rate in customer master data?\",\"options\":[\"It indicates uniqueness problems and possible fragmented customer views\",\"It measures system uptime\",\"It defines document taxonomy\",\"It proves encryption strength\"],\"answer\":0,\"rationale\":\"Duplicate rate is a core MDM quality indicator.\",\"difficulty\":\"Mixed\"},{\"id\":119,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What is hierarchy management in MDM?\",\"options\":[\"Managing governed parent-child and grouping relationships among master entities\",\"Encrypting messages\",\"Managing file folders only\",\"Scheduling ETL jobs\"],\"answer\":0,\"rationale\":\"Examples include product categories, organizational structures, and customer households or groups.\",\"difficulty\":\"Mixed\"},{\"id\":120,\"chapter\":\"8. Reference and Master Data\",\"question\":\"What should happen before merging suspected duplicate suppliers?\",\"options\":[\"Merge every similar name automatically\",\"Apply matching evidence, stewardship review, and approved merge rules\",\"Ask the DBA to guess\",\"Delete both records\"],\"answer\":1,\"rationale\":\"Merges affect identity and downstream processes, so they require controlled evidence and oversight.\",\"difficulty\":\"Mixed\"},{\"id\":121,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is the primary purpose of a data warehouse?\",\"options\":[\"Provide integrated historical data for analysis and decision support\",\"Store only document images\",\"Manage user passwords\",\"Process every operational transaction\"],\"answer\":0,\"rationale\":\"Warehouses support analytical workloads across subject areas and time.\",\"difficulty\":\"Mixed\"},{\"id\":122,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does subject-oriented mean in a warehouse?\",\"options\":[\"Data is organized by server brand\",\"Every table belongs to one user\",\"Data is stored without business context\",\"Data is organized around major business subjects such as customer or sales\"],\"answer\":3,\"rationale\":\"Subject orientation aligns analytical data with business areas.\",\"difficulty\":\"Mixed\"},{\"id\":123,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does time-variant mean?\",\"options\":[\"Only current data is retained\",\"Historical states are retained and associated with time\",\"Time zones are ignored\",\"The database clock changes often\"],\"answer\":1,\"rationale\":\"Warehouses support analysis across periods by retaining history.\",\"difficulty\":\"Mixed\"},{\"id\":124,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What does non-volatile mean in the classic warehouse definition?\",\"options\":[\"All data is immutable forever\",\"Data can never be corrected\",\"Warehouse data is mainly loaded and read rather than used for operational updates\",\"The system needs no backup\"],\"answer\":2,\"rationale\":\"Analytical repositories are optimized for stable historical use rather than transaction processing.\",\"difficulty\":\"Mixed\"},{\"id\":125,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a fact table?\",\"options\":[\"A table holding measurements at a declared business-process grain\",\"A list of user roles\",\"A document library\",\"A table of glossary definitions\"],\"answer\":0,\"rationale\":\"Facts capture measurable events such as sales quantity or production cost.\",\"difficulty\":\"Mixed\"},{\"id\":126,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a dimension table?\",\"options\":[\"A table containing only error logs\",\"A backup catalog\",\"A security policy\",\"A table providing descriptive context for facts\"],\"answer\":3,\"rationale\":\"Dimensions support slicing facts by product, customer, location, time, and other context.\",\"difficulty\":\"Mixed\"},{\"id\":127,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"Why must the grain of a fact table be declared?\",\"options\":[\"It determines password length\",\"It replaces data quality rules\",\"It defines exactly what one fact row represents\",\"It selects the BI tool\"],\"answer\":2,\"rationale\":\"Clear grain prevents mixing incompatible levels of detail.\",\"difficulty\":\"Mixed\"},{\"id\":128,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a conformed dimension?\",\"options\":[\"An encrypted fact table\",\"A deleted dimension\",\"A dimension used by one report only\",\"A consistently defined dimension shared across analytical processes\"],\"answer\":3,\"rationale\":\"Conformed dimensions enable comparable analysis across marts.\",\"difficulty\":\"Mixed\"},{\"id\":129,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a slowly changing dimension?\",\"options\":[\"A method for managing changes to descriptive dimension attributes over time\",\"A slow ETL job\",\"An archived report\",\"A rarely used fact\"],\"answer\":0,\"rationale\":\"SCD techniques determine whether history is overwritten, retained, or versioned.\",\"difficulty\":\"Mixed\"},{\"id\":130,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What characterizes a star schema?\",\"options\":[\"A central fact table connected to denormalized dimensions\",\"A network topology\",\"Only normalized operational tables\",\"Documents arranged in folders\"],\"answer\":0,\"rationale\":\"Star schemas simplify business analysis and query navigation.\",\"difficulty\":\"Mixed\"},{\"id\":131,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is a data mart?\",\"options\":[\"A backup device\",\"A metadata-only repository\",\"An analytical subset focused on a subject, process, or business community\",\"A transactional ERP module\"],\"answer\":2,\"rationale\":\"Data marts deliver focused analytical content under an enterprise integration approach.\",\"difficulty\":\"Mixed\"},{\"id\":132,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"How does Kimball's approach generally begin?\",\"options\":[\"Use only unstructured data\",\"Build one normalized enterprise warehouse before any delivery\",\"Avoid facts and dimensions\",\"Build dimensional solutions by business process using conformed dimensions\"],\"answer\":3,\"rationale\":\"Kimball emphasizes incremental dimensional delivery integrated through conformance.\",\"difficulty\":\"Mixed\"},{\"id\":133,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"How does Inmon's classic approach generally position the enterprise warehouse?\",\"options\":[\"As a document taxonomy\",\"As an API gateway\",\"As a collection of unrelated spreadsheets\",\"As an integrated enterprise repository feeding downstream analytical use\"],\"answer\":3,\"rationale\":\"Inmon emphasizes a centralized integrated enterprise warehouse.\",\"difficulty\":\"Mixed\"},{\"id\":134,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"Why govern KPI definitions?\",\"options\":[\"Avoid documenting formulas\",\"Increase dashboard color choices\",\"Eliminate measurement ownership\",\"Ensure reports calculate and interpret measures consistently\"],\"answer\":3,\"rationale\":\"Governed definitions reduce conflicting results and improve trust.\",\"difficulty\":\"Mixed\"},{\"id\":135,\"chapter\":\"9. Data Warehousing and Business Intelligence\",\"question\":\"What is self-service BI's main governance challenge?\",\"options\":[\"Prevent all business users from analyzing data\",\"Make every dataset public\",\"Replace the warehouse with email\",\"Enable user autonomy without losing definition, quality, security, and lineage controls\"],\"answer\":3,\"rationale\":\"Successful self-service balances agility with trustworthy governed data.\",\"difficulty\":\"Mixed\"},{\"id\":136,\"chapter\":\"10. Metadata Management\",\"question\":\"What is metadata?\",\"options\":[\"Only master-data values\",\"Only transactional records\",\"Only database backups\",\"Information that describes, explains, locates, or governs data and content\"],\"answer\":3,\"rationale\":\"Metadata supplies context needed to understand and manage information assets.\",\"difficulty\":\"Mixed\"},{\"id\":137,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is business metadata?\",\"options\":[\"An ETL execution duration\",\"The approved definition and owner of 'Net Revenue'\",\"A server IP address\",\"A column data type\"],\"answer\":1,\"rationale\":\"Business metadata captures meaning, rules, ownership, and business context.\",\"difficulty\":\"Mixed\"},{\"id\":138,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is technical metadata?\",\"options\":[\"A policy exception rationale\",\"A retention justification\",\"A KPI owner only\",\"Table, column, data type, and constraint definitions\"],\"answer\":3,\"rationale\":\"Technical metadata describes implemented structures and interfaces.\",\"difficulty\":\"Mixed\"},{\"id\":139,\"chapter\":\"10. Metadata Management\",\"question\":\"Which is operational metadata?\",\"options\":[\"Pipeline run time, row count, status, and error details\",\"A product taxonomy\",\"A conceptual entity\",\"The definition of Customer\"],\"answer\":0,\"rationale\":\"Operational metadata explains processing behavior and outcomes.\",\"difficulty\":\"Mixed\"},{\"id\":140,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a business glossary?\",\"options\":[\"A governed collection of business terms, definitions, and related attributes\",\"A set of source-code comments\",\"A file-system directory\",\"A database backup list\"],\"answer\":0,\"rationale\":\"A glossary establishes shared business meaning.\",\"difficulty\":\"Mixed\"},{\"id\":141,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a data catalog?\",\"options\":[\"A transaction-processing system\",\"A physical backup vault\",\"A searchable inventory of data assets enriched with metadata\",\"A document scanner\"],\"answer\":2,\"rationale\":\"Catalogs support discovery, understanding, evaluation, and governed access.\",\"difficulty\":\"Mixed\"},{\"id\":142,\"chapter\":\"10. Metadata Management\",\"question\":\"What does data lineage describe?\",\"options\":[\"Only retention periods\",\"Only reporting hierarchies\",\"Only entity ownership\",\"Origins, movements, transformations, and uses of data\"],\"answer\":3,\"rationale\":\"Lineage connects source data through processing to downstream consumption.\",\"difficulty\":\"Mixed\"},{\"id\":143,\"chapter\":\"10. Metadata Management\",\"question\":\"What is business lineage?\",\"options\":[\"A business-oriented view of how information supports processes and outcomes\",\"A network route\",\"A list of database pages\",\"A password history\"],\"answer\":0,\"rationale\":\"Business lineage expresses flow and impact in terms meaningful to stakeholders.\",\"difficulty\":\"Mixed\"},{\"id\":144,\"chapter\":\"10. Metadata Management\",\"question\":\"What is technical lineage?\",\"options\":[\"Detailed field, table, job, and transformation dependencies\",\"A taxonomy of documents\",\"A list of business sponsors only\",\"A records schedule\"],\"answer\":0,\"rationale\":\"Technical lineage supports troubleshooting, impact analysis, and controls.\",\"difficulty\":\"Mixed\"},{\"id\":145,\"chapter\":\"10. Metadata Management\",\"question\":\"What is metadata harvesting?\",\"options\":[\"Encryption of every column\",\"Automated extraction of metadata from technical sources\",\"Manual deletion of old reports\",\"Creation of transaction data\"],\"answer\":1,\"rationale\":\"Harvesting scanners collect schemas, relationships, jobs, and other technical metadata.\",\"difficulty\":\"Mixed\"},{\"id\":146,\"chapter\":\"10. Metadata Management\",\"question\":\"Why is metadata stewardship needed?\",\"options\":[\"Ensure definitions and metadata remain accurate, complete, approved, and current\",\"Replace all technical administrators\",\"Operate network devices\",\"Approve company travel\"],\"answer\":0,\"rationale\":\"Metadata degrades without accountable maintenance.\",\"difficulty\":\"Mixed\"},{\"id\":147,\"chapter\":\"10. Metadata Management\",\"question\":\"What is an impact analysis?\",\"options\":[\"A survey of office furniture\",\"Assessment of downstream assets affected by a proposed change\",\"A storage invoice calculation\",\"A backup rotation\"],\"answer\":1,\"rationale\":\"Metadata dependencies help teams identify consumers and risks before change.\",\"difficulty\":\"Mixed\"},{\"id\":148,\"chapter\":\"10. Metadata Management\",\"question\":\"What is a controlled vocabulary?\",\"options\":[\"A database transaction log\",\"An approved set of terms used consistently for description or classification\",\"Every word used by employees\",\"A list of passwords\"],\"answer\":1,\"rationale\":\"Controlled vocabularies reduce ambiguity and improve retrieval and interoperability.\",\"difficulty\":\"Mixed\"},{\"id\":149,\"chapter\":\"10. Metadata Management\",\"question\":\"A catalog shows a data set but no owner, definition, or lineage. What is the main issue?\",\"options\":[\"The catalog replaces governance\",\"The data set is automatically high quality\",\"The data set must be deleted\",\"The catalog entry is discoverable but insufficiently trustworthy and actionable\"],\"answer\":3,\"rationale\":\"Useful catalog entries need meaningful context, accountability, and traceability.\",\"difficulty\":\"Mixed\"},{\"id\":150,\"chapter\":\"10. Metadata Management\",\"question\":\"Why is metadata called a cross-cutting capability?\",\"options\":[\"It applies only to databases\",\"It eliminates the need for other disciplines\",\"It supports governance, quality, security, integration, analytics, and operations\",\"It is independent of business meaning\"],\"answer\":2,\"rationale\":\"Metadata connects and informs nearly all data-management practices.\",\"difficulty\":\"Mixed\"},{\"id\":151,\"chapter\":\"11. Data Quality\",\"question\":\"What is the most useful general definition of data quality?\",\"options\":[\"The degree to which data is fit for its intended use\",\"The speed of database processing\",\"The volume of data under management\",\"The absence of every possible defect\"],\"answer\":0,\"rationale\":\"Quality is contextual: data must satisfy agreed business and user requirements.\",\"difficulty\":\"Easy\"},{\"id\":152,\"chapter\":\"11. Data Quality\",\"question\":\"Which dimension asks whether data correctly represents the real-world object or event?\",\"options\":[\"Completeness\",\"Accuracy\",\"Availability\",\"Uniqueness\"],\"answer\":1,\"rationale\":\"Accuracy compares recorded data with reality or an authoritative source.\",\"difficulty\":\"Easy\"},{\"id\":153,\"chapter\":\"11. Data Quality\",\"question\":\"A supplier record has no tax identifier even though it is mandatory. Which dimension is affected?\",\"options\":[\"Consistency\",\"Uniqueness\",\"Completeness\",\"Timeliness\"],\"answer\":2,\"rationale\":\"Completeness measures whether required values are present.\",\"difficulty\":\"Easy\"},{\"id\":154,\"chapter\":\"11. Data Quality\",\"question\":\"CRM classifies a customer as Active while ERP classifies the same customer as Inactive. What is the primary issue?\",\"options\":[\"Accessibility\",\"Consistency\",\"Uniqueness\",\"Precision\"],\"answer\":1,\"rationale\":\"Consistency concerns agreement across representations, data stores, or rules.\",\"difficulty\":\"Easy\"},{\"id\":155,\"chapter\":\"11. Data Quality\",\"question\":\"A country field contains XX99 although only ISO country codes are allowed. Which dimension fails?\",\"options\":[\"Timeliness\",\"Accuracy\",\"Validity\",\"Completeness\"],\"answer\":2,\"rationale\":\"Validity checks conformance with permitted formats, domains, and rules.\",\"difficulty\":\"Easy\"},{\"id\":156,\"chapter\":\"11. Data Quality\",\"question\":\"The same legal supplier appears in four records. Which dimension is primarily affected?\",\"options\":[\"Completeness\",\"Timeliness\",\"Uniqueness\",\"Accuracy\"],\"answer\":2,\"rationale\":\"Uniqueness concerns inappropriate duplicate representation of the same entity.\",\"difficulty\":\"Easy\"},{\"id\":157,\"chapter\":\"11. Data Quality\",\"question\":\"An order references a customer identifier that does not exist. Which quality concern is most direct?\",\"options\":[\"Precision\",\"Referential integrity\",\"Timeliness\",\"Formatting\"],\"answer\":1,\"rationale\":\"Referential integrity requires referenced parent records to exist.\",\"difficulty\":\"Easy\"},{\"id\":158,\"chapter\":\"11. Data Quality\",\"question\":\"A production reading arrives after the decision window has closed. Which dimension is affected?\",\"options\":[\"Validity\",\"Completeness\",\"Timeliness\",\"Uniqueness\"],\"answer\":2,\"rationale\":\"Timeliness considers whether data is sufficiently current and available when required.\",\"difficulty\":\"Easy\"},{\"id\":159,\"chapter\":\"11. Data Quality\",\"question\":\"Who is normally accountable for accepting quality thresholds for a business data domain?\",\"options\":[\"The database vendor\",\"Any report developer\",\"The network administrator\",\"The Data Owner\"],\"answer\":3,\"rationale\":\"The Data Owner is accountable for business requirements and acceptable quality.\",\"difficulty\":\"Easy\"},{\"id\":160,\"chapter\":\"11. Data Quality\",\"question\":\"What is a Critical Data Element?\",\"options\":[\"A data element prioritized because of business value, risk, or obligation\",\"Every column in every database\",\"Any value containing a number\",\"Only data used by executives\"],\"answer\":0,\"rationale\":\"CDEs focus quality investment on data that matters most.\",\"difficulty\":\"Easy\"},{\"id\":161,\"chapter\":\"11. Data Quality\",\"question\":\"What is data profiling?\",\"options\":[\"Encryption of sensitive columns\",\"Systematic analysis of data values, patterns, structures, and anomalies\",\"Manual approval of every record\",\"Design of a conceptual data model\"],\"answer\":1,\"rationale\":\"Profiling establishes empirical facts about data condition and structure.\",\"difficulty\":\"Easy\"},{\"id\":162,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a preventive data-quality control?\",\"options\":[\"A steward correcting an invalid record\",\"A post-incident root-cause review\",\"A mandatory-field validation at data entry\",\"A monthly duplicate report\"],\"answer\":2,\"rationale\":\"Preventive controls stop or reduce defects before acceptance.\",\"difficulty\":\"Easy\"},{\"id\":163,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a detective data-quality control?\",\"options\":[\"A steward merging duplicates\",\"A schema design standard\",\"A drop-down list of permitted codes\",\"A dashboard showing invalid product codes\"],\"answer\":3,\"rationale\":\"Detective controls reveal defects that already exist or have entered a process.\",\"difficulty\":\"Easy\"},{\"id\":164,\"chapter\":\"11. Data Quality\",\"question\":\"Which is a corrective data-quality control?\",\"options\":[\"A reconciliation report identifies differences\",\"A steward repairs incorrect supplier classifications\",\"An input mask blocks bad formats\",\"A policy defines ownership\"],\"answer\":1,\"rationale\":\"Corrective controls remediate identified defects.\",\"difficulty\":\"Easy\"},{\"id\":165,\"chapter\":\"11. Data Quality\",\"question\":\"Why is root-cause analysis important?\",\"options\":[\"It targets the process or control that creates recurring defects\",\"It guarantees perfect data\",\"It replaces quality measurement\",\"It eliminates the need for ownership\"],\"answer\":0,\"rationale\":\"Fixing causes is more sustainable than repeatedly correcting symptoms.\",\"difficulty\":\"Medium\"},{\"id\":166,\"chapter\":\"11. Data Quality\",\"question\":\"A team corrects customer addresses monthly, but input errors continue. What is the best next action?\",\"options\":[\"Archive all customer records\",\"Increase the cleansing frequency only\",\"Identify and fix the faulty capture process and validation controls\",\"Stop measuring address quality\"],\"answer\":2,\"rationale\":\"Recurring correction without process improvement treats the symptom.\",\"difficulty\":\"Medium\"},{\"id\":167,\"chapter\":\"11. Data Quality\",\"question\":\"Which formula measures completeness for a mandatory field?\",\"options\":[\"Corrected records divided by data owners\",\"Duplicate records divided by all systems\",\"Available hours divided by total storage\",\"Populated valid records divided by applicable records\"],\"answer\":3,\"rationale\":\"Completeness is typically measured against the population for which the value is required.\",\"difficulty\":\"Medium\"},{\"id\":168,\"chapter\":\"11. Data Quality\",\"question\":\"A threshold states that at least 98% of active products must have a category. What does 98% represent?\",\"options\":[\"The data lineage depth\",\"The accepted quality target\",\"The recovery objective\",\"The retention period\"],\"answer\":1,\"rationale\":\"A threshold defines the minimum acceptable performance for a rule or dimension.\",\"difficulty\":\"Easy\"},{\"id\":169,\"chapter\":\"11. Data Quality\",\"question\":\"Why should a quality rule include its applicable population?\",\"options\":[\"It removes the need for thresholds\",\"It makes the database larger\",\"The rule may apply only to specific records or business conditions\",\"It guarantees statistical significance\"],\"answer\":2,\"rationale\":\"Scope prevents misleading measurement over irrelevant records.\",\"difficulty\":\"Medium\"},{\"id\":170,\"chapter\":\"11. Data Quality\",\"question\":\"Which sequence best reflects a sound quality-improvement cycle?\",\"options\":[\"Buy a tool, then define the problem\",\"Archive data, then assign ownership\",\"Define requirements, profile, measure, analyze causes, remediate, monitor\",\"Cleanse, ignore causes, stop measuring\"],\"answer\":2,\"rationale\":\"Effective improvement begins with requirements and continues through measurement and control.\",\"difficulty\":\"Medium\"},{\"id\":171,\"chapter\":\"11. Data Quality\",\"question\":\"What is the best evidence that a quality rule is operationalized?\",\"options\":[\"It has a complicated name\",\"It has an owner, implementation, threshold, monitoring, and issue workflow\",\"It appears in an old presentation\",\"It is known by one developer\"],\"answer\":1,\"rationale\":\"Operational rules are accountable, executable, measurable, and acted upon.\",\"difficulty\":\"Medium\"},{\"id\":172,\"chapter\":\"11. Data Quality\",\"question\":\"What is data-quality issue management?\",\"options\":[\"A process for deleting all failing records\",\"A controlled process to log, prioritize, assign, remediate, and close defects\",\"A method for designing APIs\",\"A substitute for data governance\"],\"answer\":1,\"rationale\":\"Issue management creates traceability and accountability for quality defects.\",\"difficulty\":\"Easy\"},{\"id\":173,\"chapter\":\"11. Data Quality\",\"question\":\"How should quality issues normally be prioritized?\",\"options\":[\"By alphabetical order\",\"By the number of screenshots\",\"By business impact, risk, urgency, and affected critical data\",\"By the age of the database\"],\"answer\":2,\"rationale\":\"Prioritization should align scarce remediation effort with business consequences.\",\"difficulty\":\"Medium\"},{\"id\":174,\"chapter\":\"11. Data Quality\",\"question\":\"A report shows 99% accuracy but the validation sample is undocumented. What is the concern?\",\"options\":[\"The report should contain no metadata\",\"The score must automatically be 100%\",\"Accuracy can never be sampled\",\"The metric may not be reproducible or credible\"],\"answer\":3,\"rationale\":\"Quality measures need transparent method, population, source, and evidence.\",\"difficulty\":\"Hard\"},{\"id\":175,\"chapter\":\"11. Data Quality\",\"question\":\"What is reconciliation used to assess?\",\"options\":[\"Whether passwords meet length rules\",\"Whether records are old enough to archive\",\"Whether expected records and values agree across stages or systems\",\"Whether taxonomies are hierarchical\"],\"answer\":2,\"rationale\":\"Reconciliation detects loss, duplication, and transformation differences.\",\"difficulty\":\"Medium\"},{\"id\":176,\"chapter\":\"11. Data Quality\",\"question\":\"Which quality dimension is most directly tested by a permitted-values list?\",\"options\":[\"Validity\",\"Uniqueness\",\"Timeliness\",\"Accuracy\"],\"answer\":0,\"rationale\":\"Permitted-values controls test conformance with a defined domain.\",\"difficulty\":\"Easy\"},{\"id\":177,\"chapter\":\"11. Data Quality\",\"question\":\"Why can valid data still be inaccurate?\",\"options\":[\"Accurate values never require formats\",\"A value can follow the permitted format but not reflect reality\",\"Validity and accuracy are identical\",\"Accuracy applies only to master data\"],\"answer\":1,\"rationale\":\"For example, a well-formed date can still be the wrong date.\",\"difficulty\":\"Medium\"},{\"id\":178,\"chapter\":\"11. Data Quality\",\"question\":\"Why can complete data still be poor quality?\",\"options\":[\"All fields may be populated with inaccurate, invalid, or inconsistent values\",\"Completeness proves every dimension\",\"Only null values create defects\",\"Complete data needs no governance\"],\"answer\":0,\"rationale\":\"Quality is multidimensional; presence alone does not establish fitness.\",\"difficulty\":\"Medium\"},{\"id\":179,\"chapter\":\"11. Data Quality\",\"question\":\"What is a quality scorecard?\",\"options\":[\"A physical model\",\"A document-retention schedule\",\"A structured view of measures, thresholds, trends, owners, and status\",\"A list of database passwords\"],\"answer\":2,\"rationale\":\"Scorecards communicate performance and accountability.\",\"difficulty\":\"Easy\"},{\"id\":180,\"chapter\":\"11. Data Quality\",\"question\":\"Which trend most strongly signals a weakening preventive control?\",\"options\":[\"The number of glossary terms increases\",\"Backups complete successfully\",\"New defects continue rising despite repeated cleansing\",\"Storage capacity remains stable\"],\"answer\":2,\"rationale\":\"Rising new defects indicate that creation processes are not being controlled.\",\"difficulty\":\"Hard\"},{\"id\":181,\"chapter\":\"11. Data Quality\",\"question\":\"A quality rule fails because an approved reference-code list changed. What control is missing?\",\"options\":[\"Change coordination between reference data and dependent validations\",\"Additional document scanning\",\"A new conceptual entity\",\"Longer backup retention\"],\"answer\":0,\"rationale\":\"Dependent rules must be updated when governed reference values change.\",\"difficulty\":\"Hard\"},{\"id\":182,\"chapter\":\"11. Data Quality\",\"question\":\"What is the relationship between metadata and data quality?\",\"options\":[\"Metadata supplies definitions, domains, rules, lineage, and ownership needed for quality control\",\"They are unrelated\",\"Metadata guarantees accuracy automatically\",\"Metadata replaces profiling\"],\"answer\":0,\"rationale\":\"Quality is difficult to define or investigate without contextual metadata.\",\"difficulty\":\"Medium\"},{\"id\":183,\"chapter\":\"11. Data Quality\",\"question\":\"How does lineage support quality management?\",\"options\":[\"It removes duplicate records automatically\",\"It defines recovery time\",\"It helps locate defect origins and identify affected downstream assets\",\"It encrypts bad data\"],\"answer\":2,\"rationale\":\"Lineage enables root-cause and impact analysis.\",\"difficulty\":\"Medium\"},{\"id\":184,\"chapter\":\"11. Data Quality\",\"question\":\"An organization measures hundreds of rules but resolves few failures. What is the maturity weakness?\",\"options\":[\"There are too few dashboards\",\"The taxonomy is too deep\",\"Measurement is not connected to accountable remediation\",\"The data model is too conceptual\"],\"answer\":2,\"rationale\":\"Metrics create value only when failures trigger decisions and action.\",\"difficulty\":\"Hard\"},{\"id\":185,\"chapter\":\"11. Data Quality\",\"question\":\"Why should quality requirements be defined with business users?\",\"options\":[\"IT cannot read data\",\"Fitness for use depends on business processes and decisions\",\"Business users should configure databases\",\"Quality is purely subjective\"],\"answer\":1,\"rationale\":\"Business context determines acceptable levels, impacts, and priorities.\",\"difficulty\":\"Medium\"},{\"id\":186,\"chapter\":\"11. Data Quality\",\"question\":\"What is the best response when improving one system reduces quality in another?\",\"options\":[\"Stop integration permanently\",\"Assess end-to-end impacts and agree an enterprise solution through governance\",\"Optimize only the first system\",\"Hide the second system's metrics\"],\"answer\":1,\"rationale\":\"Local optimization can damage enterprise outcomes and must be governed across boundaries.\",\"difficulty\":\"Hard\"},{\"id\":187,\"chapter\":\"11. Data Quality\",\"question\":\"Which metric best represents duplicate rate?\",\"options\":[\"Null attributes divided by all attributes\",\"Successful jobs divided by scheduled jobs\",\"Correct values divided by sampled values\",\"Records identified as inappropriate duplicates divided by assessed records\"],\"answer\":3,\"rationale\":\"Duplicate rate is a uniqueness measure based on the assessed population.\",\"difficulty\":\"Medium\"},{\"id\":188,\"chapter\":\"11. Data Quality\",\"question\":\"What is the primary risk of cleansing data without preserving an audit trail?\",\"options\":[\"The data becomes too complete\",\"Storage automatically doubles\",\"Changes may be unverifiable, irreversible, or unaccountable\",\"The taxonomy becomes flatter\"],\"answer\":2,\"rationale\":\"Controlled remediation needs before-and-after evidence, authority, and traceability.\",\"difficulty\":\"Medium\"},{\"id\":189,\"chapter\":\"11. Data Quality\",\"question\":\"When should a quality exception be accepted?\",\"options\":[\"When an authorized owner documents justification, risk, duration, and treatment\",\"Whenever a developer requests it verbally\",\"Whenever the quality score is unknown\",\"Whenever a rule is inconvenient\"],\"answer\":0,\"rationale\":\"Exceptions should be governed and time-bound rather than silently tolerated.\",\"difficulty\":\"Hard\"},{\"id\":190,\"chapter\":\"11. Data Quality\",\"question\":\"What is the strongest sign of an optimized quality capability?\",\"options\":[\"A tool has been purchased\",\"A policy document exists\",\"Data is cleansed once\",\"Quality controls are embedded, monitored, and improved using measured outcomes\"],\"answer\":3,\"rationale\":\"High maturity combines prevention, automation, accountability, and continuous improvement.\",\"difficulty\":\"Hard\"},{\"id\":191,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic of big data refers to scale?\",\"options\":[\"Value\",\"Veracity\",\"Volume\",\"Velocity\"],\"answer\":2,\"rationale\":\"Volume denotes the amount of data generated, stored, or processed.\",\"difficulty\":\"Easy\"},{\"id\":192,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic refers to the speed of generation and processing?\",\"options\":[\"Velocity\",\"Value\",\"Volume\",\"Variety\"],\"answer\":0,\"rationale\":\"Velocity concerns the rate and timeliness of data flows.\",\"difficulty\":\"Easy\"},{\"id\":193,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic refers to different formats and sources?\",\"options\":[\"Variety\",\"Value\",\"Veracity\",\"Volume\"],\"answer\":0,\"rationale\":\"Variety includes structured, semi-structured, and unstructured forms.\",\"difficulty\":\"Easy\"},{\"id\":194,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic concerns trustworthiness and uncertainty?\",\"options\":[\"Velocity\",\"Veracity\",\"Visualization\",\"Volume\"],\"answer\":1,\"rationale\":\"Veracity concerns reliability, bias, noise, and confidence.\",\"difficulty\":\"Easy\"},{\"id\":195,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which characteristic emphasizes useful business outcomes?\",\"options\":[\"Velocity\",\"Volume\",\"Variety\",\"Value\"],\"answer\":3,\"rationale\":\"Big-data investment is justified by value rather than scale alone.\",\"difficulty\":\"Easy\"},{\"id\":196,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which is semi-structured data?\",\"options\":[\"An analog paper form\",\"A normalized customer table\",\"A scanned photograph\",\"A JSON event message\"],\"answer\":3,\"rationale\":\"JSON has structural markers but does not require a fixed relational schema.\",\"difficulty\":\"Easy\"},{\"id\":197,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which is unstructured data?\",\"options\":[\"A country-code table\",\"A relational invoice table\",\"A fixed-width transaction file\",\"A maintenance video\"],\"answer\":3,\"rationale\":\"Video content does not naturally conform to rows and columns.\",\"difficulty\":\"Easy\"},{\"id\":198,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a data lake?\",\"options\":[\"A transaction-only ERP database\",\"A scalable repository that can retain diverse data, often in native form\",\"A document retention schedule\",\"A business glossary\"],\"answer\":1,\"rationale\":\"Data lakes commonly preserve structured and non-structured data for multiple uses.\",\"difficulty\":\"Easy\"},{\"id\":199,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does schema-on-read mean?\",\"options\":[\"All data is converted to one table\",\"Schema is fixed before ingestion\",\"Data has no structure under any circumstance\",\"Structure is applied or interpreted when data is accessed for use\"],\"answer\":3,\"rationale\":\"Schema-on-read allows flexible interpretation for different consumers.\",\"difficulty\":\"Easy\"},{\"id\":200,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does schema-on-write mean?\",\"options\":[\"Data is never validated\",\"Schema is chosen after every query\",\"All files remain in native form\",\"Data is shaped to an agreed schema before or during loading\"],\"answer\":3,\"rationale\":\"Warehousing commonly applies defined structures before analytical use.\",\"difficulty\":\"Easy\"},{\"id\":201,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a data swamp?\",\"options\":[\"A master-data registry\",\"A highly optimized warehouse\",\"A secure backup vault\",\"A poorly governed data lake whose assets are difficult to find, understand, or trust\"],\"answer\":3,\"rationale\":\"Weak metadata, stewardship, quality, and lifecycle controls reduce lake usability.\",\"difficulty\":\"Easy\"},{\"id\":202,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is distributed processing used?\",\"options\":[\"To replace governance\",\"To divide large processing workloads across multiple computing nodes\",\"To avoid all failures\",\"To eliminate metadata\"],\"answer\":1,\"rationale\":\"Parallel distributed computation enables scale beyond one machine.\",\"difficulty\":\"Easy\"},{\"id\":203,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is horizontal scaling?\",\"options\":[\"Reducing the number of users\",\"Compressing all data\",\"Adding more power to one node only\",\"Adding more nodes to increase capacity\"],\"answer\":3,\"rationale\":\"Scale-out architectures add machines or instances.\",\"difficulty\":\"Medium\"},{\"id\":204,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is fault tolerance in a distributed platform?\",\"options\":[\"Permanent duplication of every result\",\"The ability to continue or recover when components fail\",\"Ignoring failed jobs\",\"The absence of data-quality rules\"],\"answer\":1,\"rationale\":\"Distributed designs anticipate component failure and use replication or recovery mechanisms.\",\"difficulty\":\"Medium\"},{\"id\":205,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data partitioning?\",\"options\":[\"Renaming every file\",\"Dividing data into manageable segments for storage or processing\",\"Deleting historical data\",\"Encrypting each attribute\"],\"answer\":1,\"rationale\":\"Partitioning improves distribution, parallelism, and manageability.\",\"difficulty\":\"Medium\"},{\"id\":206,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is stream processing?\",\"options\":[\"Running one annual batch\",\"Updating a business glossary\",\"Archiving documents\",\"Processing events continuously or with very low latency as they arrive\"],\"answer\":3,\"rationale\":\"Streaming supports timely analysis of ongoing event flows.\",\"difficulty\":\"Easy\"},{\"id\":207,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is batch processing?\",\"options\":[\"Processing a accumulated set of records as a scheduled or bounded workload\",\"Handling every event individually at arrival\",\"Masking sensitive fields\",\"Defining data ownership\"],\"answer\":0,\"rationale\":\"Batch workloads process collected data at intervals or as bounded jobs.\",\"difficulty\":\"Easy\"},{\"id\":208,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A machine emits vibration readings every millisecond. Which big-data property is most obvious?\",\"options\":[\"Normalization\",\"Taxonomy\",\"Velocity\",\"Retention\"],\"answer\":2,\"rationale\":\"The defining challenge is the high rate of data arrival.\",\"difficulty\":\"Easy\"},{\"id\":209,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A platform stores sensor readings, images, logs, and work orders. Which property is strongest?\",\"options\":[\"Variety\",\"Cardinality\",\"Uniqueness\",\"Volatility\"],\"answer\":0,\"rationale\":\"Multiple data forms and structures demonstrate variety.\",\"difficulty\":\"Easy\"},{\"id\":210,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is predictive analytics?\",\"options\":[\"Reporting only what happened\",\"Selecting a retention schedule\",\"Designing an access role\",\"Using data and models to estimate likely future outcomes\"],\"answer\":3,\"rationale\":\"Predictive methods estimate future events, probabilities, or values.\",\"difficulty\":\"Easy\"},{\"id\":211,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is prescriptive analytics?\",\"options\":[\"Describing past performance only\",\"Creating a conceptual model\",\"Collecting metadata\",\"Recommending actions based on objectives, constraints, and predicted outcomes\"],\"answer\":3,\"rationale\":\"Prescriptive analysis addresses what action should be taken.\",\"difficulty\":\"Medium\"},{\"id\":212,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is metadata essential in a data lake?\",\"options\":[\"It replaces access security\",\"It eliminates storage costs\",\"It guarantees all models are unbiased\",\"It enables discovery, interpretation, lineage, governance, and reuse\"],\"answer\":3,\"rationale\":\"Without context, large collections become difficult to use responsibly.\",\"difficulty\":\"Medium\"},{\"id\":213,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data provenance?\",\"options\":[\"Evidence about the origin and history of data\",\"A database index\",\"An encryption key\",\"A duplicate-detection rule\"],\"answer\":0,\"rationale\":\"Provenance supports trust, reproducibility, lineage, and accountability.\",\"difficulty\":\"Medium\"},{\"id\":214,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What should govern retention of high-volume sensor data?\",\"options\":[\"Use the same period for all data\",\"Business value, obligations, risk, cost, and intended analytical use\",\"Delete everything after one day\",\"Keep everything forever by default\"],\"answer\":1,\"rationale\":\"Retention requires a risk- and value-based lifecycle decision.\",\"difficulty\":\"Hard\"},{\"id\":215,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why does more data not automatically improve an analytical model?\",\"options\":[\"Volume eliminates sampling error completely\",\"Additional data may be irrelevant, biased, noisy, or poorly labeled\",\"All large datasets are accurate\",\"Models use only metadata\"],\"answer\":1,\"rationale\":\"Quality and representativeness matter as much as quantity.\",\"difficulty\":\"Medium\"},{\"id\":216,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is data drift?\",\"options\":[\"Movement of data between storage tiers\",\"A change over time in input data patterns or distributions\",\"A taxonomy being revised\",\"A backup being archived\"],\"answer\":1,\"rationale\":\"Drift can reduce model performance when current data differs from training data.\",\"difficulty\":\"Hard\"},{\"id\":217,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is concept drift?\",\"options\":[\"A change in the relationship between inputs and the outcome being predicted\",\"A server migration\",\"A glossary ownership change\",\"A change in file format only\"],\"answer\":0,\"rationale\":\"Concept drift means the phenomenon or target relationship has evolved.\",\"difficulty\":\"Hard\"},{\"id\":218,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is a major privacy risk in big-data analytics?\",\"options\":[\"Encryption removes all privacy concerns\",\"Large datasets are automatically anonymous\",\"Combining data may enable unexpected identification or sensitive inference\",\"Distributed systems cannot store personal data\"],\"answer\":2,\"rationale\":\"Linkage and inference can create risks beyond individual source datasets.\",\"difficulty\":\"Hard\"},{\"id\":219,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why is representative training data important?\",\"options\":[\"Biased or incomplete representation can produce systematically poor outcomes\",\"It guarantees perfect predictions\",\"It reduces the need for testing\",\"It makes governance unnecessary\"],\"answer\":0,\"rationale\":\"Model outcomes depend on the populations and conditions represented in the data.\",\"difficulty\":\"Medium\"},{\"id\":220,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What does reproducibility require in an analytics pipeline?\",\"options\":[\"Only a larger cluster\",\"Only the model name\",\"Traceable data, code, configuration, parameters, and execution context\",\"Only the final chart\"],\"answer\":2,\"rationale\":\"Reproduction depends on preserving the full analytical context.\",\"difficulty\":\"Hard\"},{\"id\":221,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Which control best limits uncontrolled data-lake access?\",\"options\":[\"Shared administrator credentials\",\"Classification-based authorization with least privilege and logging\",\"Removal of metadata\",\"Public access for all analysts\"],\"answer\":1,\"rationale\":\"Governed access should reflect sensitivity and approved purpose.\",\"difficulty\":\"Medium\"},{\"id\":222,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is the best initial question for a big-data initiative?\",\"options\":[\"Which tool has the most features?\",\"How can we keep every event forever?\",\"What business decision or outcome should the data improve?\",\"How much data can we collect?\"],\"answer\":2,\"rationale\":\"A value-led use case should precede technology and collection decisions.\",\"difficulty\":\"Medium\"},{\"id\":223,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"Why monitor pipeline data quality continuously?\",\"options\":[\"Source behavior and data distributions can change over time\",\"Monitoring only affects storage\",\"One initial test proves permanent quality\",\"Big data is exempt from quality rules\"],\"answer\":0,\"rationale\":\"Dynamic sources require ongoing detection of drift, failures, and anomalies.\",\"difficulty\":\"Medium\"},{\"id\":224,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"What is the strongest sign that a big-data platform is governed effectively?\",\"options\":[\"It has no deletion process\",\"It contains petabytes of data\",\"It uses many technologies\",\"Assets are discoverable, owned, protected, quality-assessed, and lifecycle-managed\"],\"answer\":3,\"rationale\":\"Governance is demonstrated by controlled and useful information management.\",\"difficulty\":\"Hard\"},{\"id\":225,\"chapter\":\"12. Big Data and Analytics\",\"question\":\"A predictive-maintenance model performs well in one plant but poorly in another. What should be examined first?\",\"options\":[\"The color of the dashboard\",\"The office network name\",\"The number of glossary pages\",\"Differences in equipment, operating conditions, sensor quality, and data representation\"],\"answer\":3,\"rationale\":\"Cross-context performance can fail when data and operating conditions differ.\",\"difficulty\":\"Hard\"},{\"id\":226,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a data-management maturity assessment evaluate?\",\"options\":[\"Only regulatory compliance\",\"Only database performance\",\"Only the accuracy of individual records\",\"How consistently and effectively an organization manages data capabilities\"],\"answer\":3,\"rationale\":\"Maturity assessment examines organizational capability across people, process, governance, and technology.\",\"difficulty\":\"Easy\"},{\"id\":227,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the principal output of a maturity assessment?\",\"options\":[\"A current-state capability view, gaps, priorities, and improvement roadmap\",\"A production database\",\"A list of passwords\",\"A physical data model only\"],\"answer\":0,\"rationale\":\"Assessment should guide targeted capability improvement.\",\"difficulty\":\"Easy\"},{\"id\":228,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does an Initial maturity level usually indicate?\",\"options\":[\"All controls are automated\",\"Continuous optimization is embedded\",\"Practices are ad hoc, reactive, and dependent on individuals\",\"Processes are quantitatively managed\"],\"answer\":2,\"rationale\":\"Initial capability lacks consistent institutionalized practice.\",\"difficulty\":\"Easy\"},{\"id\":229,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a Defined level generally indicate?\",\"options\":[\"Practices and roles are documented and used consistently\",\"Every process is optimized\",\"No processes exist\",\"Only technology has been purchased\"],\"answer\":0,\"rationale\":\"Defined capability is standardized and institutionalized.\",\"difficulty\":\"Easy\"},{\"id\":230,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What does a Managed level generally add?\",\"options\":[\"Dependence on informal experts\",\"Elimination of metrics\",\"Measurement, monitoring, control, and accountable performance management\",\"Removal of all policies\"],\"answer\":2,\"rationale\":\"Managed capability uses evidence to control outcomes.\",\"difficulty\":\"Easy\"},{\"id\":231,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What characterizes an Optimized level?\",\"options\":[\"Continuous improvement, learning, automation, and adaptive control\",\"No changes are permitted\",\"Processes are performed differently everywhere\",\"A policy exists as a file\"],\"answer\":0,\"rationale\":\"Optimization uses measured outcomes to improve capability systematically.\",\"difficulty\":\"Easy\"},{\"id\":232,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why is a yes\/no questionnaire insufficient for a robust assessment?\",\"options\":[\"Documents cannot be reviewed\",\"Maturity cannot be measured\",\"It may show existence but not adoption, consistency, effectiveness, or evidence\",\"Yes\/no questions are always illegal\"],\"answer\":2,\"rationale\":\"Capability maturity requires examining practice in operation.\",\"difficulty\":\"Medium\"},{\"id\":233,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A policy exists but is contradictory, outdated, and unknown to staff. How should it be scored?\",\"options\":[\"Below mature levels because effectiveness and adoption are weak\",\"Level 5 because a document exists\",\"Level 4 because it is long\",\"Not assessed because policies do not matter\"],\"answer\":0,\"rationale\":\"Documentation alone is not evidence of institutionalized capability.\",\"difficulty\":\"Medium\"},{\"id\":234,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is assessment evidence?\",\"options\":[\"The assessor's preference\",\"A vendor's marketing claim\",\"Artifacts, observations, records, metrics, and interviews that substantiate a rating\",\"An undocumented assumption\"],\"answer\":2,\"rationale\":\"Evidence supports transparent and repeatable scoring.\",\"difficulty\":\"Easy\"},{\"id\":235,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why triangulate evidence?\",\"options\":[\"To validate claims using more than one source or method\",\"To increase the score automatically\",\"To avoid stakeholder interviews\",\"To eliminate professional judgment\"],\"answer\":0,\"rationale\":\"Triangulation reduces reliance on unverified self-reporting.\",\"difficulty\":\"Medium\"},{\"id\":236,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a target maturity level?\",\"options\":[\"The capability level the organization intends to reach based on need and value\",\"The highest possible score for every capability\",\"The number of assessment questions\",\"The current average score\"],\"answer\":0,\"rationale\":\"Targets should reflect business priorities rather than universal perfection.\",\"difficulty\":\"Easy\"},{\"id\":237,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why should not every capability automatically target Level 5?\",\"options\":[\"Only technology can reach Level 5\",\"The cost and complexity may exceed the business need or risk reduction\",\"Level 5 is impossible\",\"Targets must always equal current scores\"],\"answer\":1,\"rationale\":\"Maturity should be appropriate and economically justified.\",\"difficulty\":\"Medium\"},{\"id\":238,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is gap analysis?\",\"options\":[\"Comparison of current capability with the desired target state\",\"A document taxonomy\",\"Comparison of two database indexes\",\"A method of data encryption\"],\"answer\":0,\"rationale\":\"Gap analysis identifies improvement needs.\",\"difficulty\":\"Easy\"},{\"id\":239,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"How should roadmap initiatives be prioritized?\",\"options\":[\"By alphabetical order\",\"By the longest document first\",\"By business value, risk, dependencies, feasibility, and capability gaps\",\"By assessor preference only\"],\"answer\":2,\"rationale\":\"Prioritization should link improvement to strategic outcomes and constraints.\",\"difficulty\":\"Medium\"},{\"id\":240,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a leading maturity indicator?\",\"options\":[\"A retired policy\",\"A result observed only after failure\",\"A historical revenue total\",\"Evidence that enabling practices are being implemented before final outcomes appear\"],\"answer\":3,\"rationale\":\"Leading indicators track adoption and control development, such as ownership coverage.\",\"difficulty\":\"Hard\"},{\"id\":241,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is a lagging maturity indicator?\",\"options\":[\"An outcome measure observed after processes have operated\",\"A draft role description\",\"A proposed catalog\",\"A planned training session\"],\"answer\":0,\"rationale\":\"Lagging indicators include defect trends, incident results, or realized compliance outcomes.\",\"difficulty\":\"Hard\"},{\"id\":242,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why assess maturity by capability rather than only one overall score?\",\"options\":[\"Capabilities cannot be compared\",\"Strengths and weaknesses differ and require different actions\",\"Roadmaps need no detail\",\"Overall scores are always false\"],\"answer\":1,\"rationale\":\"A single average can hide critical low-performing areas.\",\"difficulty\":\"Medium\"},{\"id\":243,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the danger of averaging scores without weights?\",\"options\":[\"Averages always exceed five\",\"Every capability has identical risk\",\"Weights remove all judgment\",\"Low maturity in a critical capability may be hidden by less important high scores\"],\"answer\":3,\"rationale\":\"Weighting or interpretation should reflect business criticality.\",\"difficulty\":\"Hard\"},{\"id\":244,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What should a scoring rubric contain?\",\"options\":[\"Observable criteria and evidence expectations for each level\",\"Only tool names\",\"Only chapter titles\",\"Only numeric labels\"],\"answer\":0,\"rationale\":\"Anchored descriptions improve consistency and auditability.\",\"difficulty\":\"Medium\"},{\"id\":245,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Two assessors give different ratings from the same evidence. What is the best response?\",\"options\":[\"Average the scores without discussion\",\"Calibrate against the rubric and document the rating rationale\",\"Discard the evidence\",\"Use the highest score\"],\"answer\":1,\"rationale\":\"Calibration promotes consistent interpretation and transparent judgment.\",\"difficulty\":\"Hard\"},{\"id\":246,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is assessment scope?\",\"options\":[\"The target score alone\",\"Only the interview schedule\",\"The organizational units, capabilities, data domains, systems, and period included\",\"The number of colors in the report\"],\"answer\":2,\"rationale\":\"Clear scope prevents overgeneralization and supports repeatability.\",\"difficulty\":\"Easy\"},{\"id\":247,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why identify assessment stakeholders early?\",\"options\":[\"They guarantee high scores\",\"They replace the assessor\",\"They provide evidence, context, decisions, and ownership of improvements\",\"They eliminate confidentiality requirements\"],\"answer\":2,\"rationale\":\"Broad engagement improves accuracy and adoption of the roadmap.\",\"difficulty\":\"Medium\"},{\"id\":248,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is respondent bias?\",\"options\":[\"A database constraint\",\"A reporting dimension\",\"Systematic distortion caused by incentives, perceptions, or incomplete knowledge\",\"A lineage relationship\"],\"answer\":2,\"rationale\":\"Self-assessments can overstate or understate capability.\",\"difficulty\":\"Medium\"},{\"id\":249,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"How can respondent bias be reduced?\",\"options\":[\"Remove all interviews\",\"Publish names with every answer\",\"Use evidence review, multiple roles, neutral facilitation, and clear rubrics\",\"Ask only senior leaders\"],\"answer\":2,\"rationale\":\"Multiple evidence sources and structured criteria improve reliability.\",\"difficulty\":\"Medium\"},{\"id\":250,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the purpose of an assessment workshop?\",\"options\":[\"Replace individual interviews in all cases\",\"Approve every policy exception\",\"Configure production databases\",\"Build shared understanding, validate evidence, and calibrate ratings\"],\"answer\":3,\"rationale\":\"Workshops help reconcile perspectives and establish ownership of findings.\",\"difficulty\":\"Easy\"},{\"id\":251,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What makes a recommendation actionable?\",\"options\":[\"A vendor product name only\",\"A vague statement to improve data\",\"A maturity score without context\",\"A defined outcome, owner, priority, dependencies, measures, and timeframe\"],\"answer\":3,\"rationale\":\"Actionable recommendations can be assigned, planned, and measured.\",\"difficulty\":\"Medium\"},{\"id\":252,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the best way to present maturity results to executives?\",\"options\":[\"Present technology diagrams only\",\"Link capability findings to business risk, value, and prioritized decisions\",\"Hide all weaknesses\",\"Show only detailed question responses\"],\"answer\":1,\"rationale\":\"Executives need a decision-oriented narrative rather than raw scoring detail.\",\"difficulty\":\"Medium\"},{\"id\":253,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Why repeat maturity assessments?\",\"options\":[\"To replace operational metrics\",\"To avoid implementing actions\",\"Repeated scoring guarantees improvement\",\"Measure progress, detect changes, and refine the improvement roadmap\"],\"answer\":3,\"rationale\":\"Periodic reassessment checks whether capability has genuinely advanced.\",\"difficulty\":\"Easy\"},{\"id\":254,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the main risk of reassessing too frequently?\",\"options\":[\"All evidence becomes invalid\",\"Scores may reflect noise before improvements have become institutionalized\",\"Policies automatically expire\",\"The model can no longer be used\"],\"answer\":1,\"rationale\":\"Capability change needs enough time to become established and measurable.\",\"difficulty\":\"Hard\"},{\"id\":255,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A governance council exists but rarely makes decisions. Which aspect should lower the score?\",\"options\":[\"Meeting-room availability\",\"Operational effectiveness\",\"Document formatting\",\"Database capacity\"],\"answer\":1,\"rationale\":\"Formal existence without effective outcomes is weak maturity evidence.\",\"difficulty\":\"Medium\"},{\"id\":256,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"A data catalog is purchased but has little metadata and few users. What does this demonstrate?\",\"options\":[\"Technology implementation without mature adoption or operating processes\",\"Automatic enterprise governance\",\"Optimized metadata capability\",\"A complete target state\"],\"answer\":0,\"rationale\":\"Tool deployment is not equivalent to institutionalized capability.\",\"difficulty\":\"Medium\"},{\"id\":257,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"Which finding is more useful than 'Metadata score = 2.1'?\",\"options\":[\"The score has one decimal place\",\"Definitions lack owners, lineage covers few critical reports, and catalog adoption is low\",\"The tool should be replaced\",\"Metadata needs improvement\"],\"answer\":1,\"rationale\":\"Specific evidence explains the score and informs remediation.\",\"difficulty\":\"Hard\"},{\"id\":258,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is an interdependency in a maturity roadmap?\",\"options\":[\"Two questions share the same answer\",\"One capability improvement relies on another capability or prerequisite\",\"Two charts use the same color\",\"Two assessors attend one meeting\"],\"answer\":1,\"rationale\":\"For example, quality monitoring may depend on metadata and ownership.\",\"difficulty\":\"Medium\"},{\"id\":259,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the best response to a high maturity score with poor business outcomes?\",\"options\":[\"Increase every target to Level 5\",\"Stop measuring outcomes\",\"Re-examine the evidence, rubric, effectiveness measures, and alignment to business need\",\"Accept the score without question\"],\"answer\":2,\"rationale\":\"Maturity claims should align with actual capability effectiveness.\",\"difficulty\":\"Hard\"},{\"id\":260,\"chapter\":\"13. Data Management Maturity Assessment\",\"question\":\"What is the defining principle of a useful maturity assessment?\",\"options\":[\"It replaces data strategy\",\"It produces the highest possible score\",\"It compares tool brands\",\"It supports evidence-based prioritization and continuous capability improvement\"],\"answer\":3,\"rationale\":\"The assessment is a means to improve outcomes, not an end in itself.\",\"difficulty\":\"Hard\"}];<\/script><script>\n(function(){\n const ROOT_ID='cdmp-practice-quiz'; const data=CDMP_QUESTIONS; const root=document.getElementById(ROOT_ID); if(!root)return;\n let current=[],submitted=false;\n const chapters=[...new Set(data.map(q=>q.chapter))];\n root.innerHTML=`<div class=\"cdmpq\">\n <div class=\"cdmpq-card\"><h2>CDMP Practice Quiz<\/h2><p>Choose a chapter and number of questions. Results and explanations appear immediately after submission.<\/p>\n <div class=\"cdmpq-controls\"><label>Chapter<select id=\"cdmp-ch\"><option value=\"all\">All chapters<\/option>${chapters.map(c=>`<option>${c}<\/option>`).join('')}<\/select><\/label><label>Questions<select id=\"cdmp-count\"><option>10<\/option><option>20<\/option><option>30<\/option><option>50<\/option><option value=\"all\">All available<\/option><\/select><\/label><label>Order<select id=\"cdmp-order\"><option value=\"random\">Random<\/option><option value=\"number\">Question number<\/option><\/select><\/label><\/div>\n <div class=\"cdmpq-actions\"><button id=\"cdmp-start\">Start new quiz<\/button><button class=\"secondary\" id=\"cdmp-resume\">Resume saved quiz<\/button><button class=\"danger\" id=\"cdmp-clear\">Clear saved progress<\/button><\/div><p class=\"cdmpq-note\">Unofficial study aid. Not an official DAMA International examination.<\/p><\/div>\n <div id=\"cdmp-stage\"><\/div><\/div>`;\n const $=s=>root.querySelector(s), stage=$('#cdmp-stage');\n function shuffled(a){let x=[...a];for(let i=x.length-1;i>0;i--){let j=Math.floor(Math.random()*(i+1));[x[i],x[j]]=[x[j],x[i]]}return x}\n function begin(saved){submitted=false;if(saved){current=saved.questions;render(saved.answers||{}) ;return}\n   let pool=$('#cdmp-ch').value==='all'?data:data.filter(q=>q.chapter===$('#cdmp-ch').value);\n   pool=$('#cdmp-order').value==='random'?shuffled(pool):[...pool].sort((a,b)=>a.id-b.id);\n   let n=$('#cdmp-count').value==='all'?pool.length:Math.min(+$('#cdmp-count').value,pool.length);current=pool.slice(0,n);render({});\n }\n function render(answers){stage.innerHTML=`<div class=\"cdmpq-card\"><div><strong id=\"cdmp-status\">0 of ${current.length} answered<\/strong><\/div><div class=\"cdmpq-progress\"><span id=\"cdmp-bar\"><\/span><\/div><div id=\"cdmp-list\"><\/div><div class=\"cdmpq-actions\"><button id=\"cdmp-submit\">Submit answers<\/button><button class=\"secondary\" id=\"cdmp-save\">Save progress<\/button><\/div><\/div>`;\n   const list=$('#cdmp-list'); current.forEach((q,i)=>{let d=document.createElement('div');d.className='cdmpq-q';d.dataset.id=q.id;d.innerHTML=`<div class=\"cdmpq-meta\">Question ${i+1} \u00b7 Bank #${q.id} \u00b7 ${q.chapter}${q.difficulty&&q.difficulty!=='Mixed'?' \u00b7 '+q.difficulty:''}<\/div><h3>${esc(q.question)}<\/h3>${q.options.map((o,k)=>`<label class=\"cdmpq-opt\"><input type=\"radio\" name=\"q${q.id}\" value=\"${k}\" ${String(answers[q.id])===String(k)?'checked':''}>${String.fromCharCode(65+k)}. ${esc(o)}<\/label>`).join('')}`;list.appendChild(d)});\n   root.querySelectorAll('input[type=radio]').forEach(x=>x.addEventListener('change',progress)); $('#cdmp-submit').onclick=submit; $('#cdmp-save').onclick=save; progress(); root.scrollIntoView({behavior:'smooth'});\n }\n function esc(s){return String(s).replace(\/[&<>\"]\/g,c=>({'&':'&amp;','<':'&lt;','>':'&gt;','\"':'&quot;'}[c]))}\n function collect(){let a={};current.forEach(q=>{let x=root.querySelector(`input[name=q${q.id}]:checked`);if(x)a[q.id]=+x.value});return a}\n function progress(){let n=Object.keys(collect()).length;$('#cdmp-status').textContent=`${n} of ${current.length} answered`;$('#cdmp-bar').style.width=(100*n\/current.length)+'%'}\n function save(){localStorage.setItem('cdmpQuizState',JSON.stringify({questions:current,answers:collect()}));alert('Progress saved in this browser.')}\n function submit(){if(submitted)return;let a=collect();let unanswered=current.length-Object.keys(a).length;if(unanswered&&!confirm(`${unanswered} question(s) unanswered. Submit anyway?`))return;submitted=true;let correct=0,by={};current.forEach(q=>{let chosen=a[q.id],ok=chosen===q.answer;if(ok)correct++;by[q.chapter]??={c:0,n:0};by[q.chapter].n++;if(ok)by[q.chapter].c++;let box=root.querySelector(`.cdmpq-q[data-id=\"${q.id}\"]`);box.querySelectorAll('.cdmpq-opt').forEach((el,k)=>{el.classList.toggle('cdmpq-correct',k===q.answer);el.classList.toggle('cdmpq-wrong',k===chosen&&k!==q.answer);el.querySelector('input').disabled=true});let r=document.createElement('div');r.className='cdmpq-rationale';r.innerHTML=`<strong>${ok?'Correct':'Review'}.<\/strong> ${esc(q.rationale)}`;box.appendChild(r)});let pct=Math.round(100*correct\/current.length);let result=document.createElement('div');result.className='cdmpq-card';result.innerHTML=`<h2>Results<\/h2><div class=\"cdmpq-kpis\"><div class=\"cdmpq-kpi\"><strong>${correct}\/${current.length}<\/strong>Correct<\/div><div class=\"cdmpq-kpi\"><strong>${pct}%<\/strong>Score<\/div><div class=\"cdmpq-kpi\"><strong>${current.length-correct}<\/strong>To review<\/div><\/div><h3>Chapter breakdown<\/h3><table class=\"cdmpq-breakdown\"><thead><tr><th>Chapter<\/th><th>Correct<\/th><th>Score<\/th><\/tr><\/thead><tbody>${Object.entries(by).map(([c,v])=>`<tr><td>${esc(c)}<\/td><td>${v.c}\/${v.n}<\/td><td>${Math.round(100*v.c\/v.n)}%<\/td><\/tr>`).join('')}<\/tbody><\/table><div class=\"cdmpq-actions\"><button id=\"cdmp-again\">Start another quiz<\/button><\/div>`;stage.prepend(result);result.querySelector('#cdmp-again').onclick=()=>begin(false);localStorage.removeItem('cdmpQuizState');result.scrollIntoView({behavior:'smooth'})}\n $('#cdmp-start').onclick=()=>begin(false);$('#cdmp-resume').onclick=()=>{let s=localStorage.getItem('cdmpQuizState');if(!s)return alert('No saved quiz found.');try{begin(JSON.parse(s))}catch(e){alert('Saved quiz could not be opened.')}};$('#cdmp-clear').onclick=()=>{localStorage.removeItem('cdmpQuizState');alert('Saved progress cleared.')};\n})();\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>The Certified Data Management Professional (CDMP\u00ae ) certification is globally recognized as the gold standard&nbsp;in data management. It validates your expertise and enhances your credibility. This is a simple practice quiz to test your knowledge. The certification exam is considerably more complex. CDMP Practice Quiz CDMP Practice Quiz CDMP Practice Quiz<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-13703","post","type-post","status-publish","format-standard","hentry","category-data-management"],"_links":{"self":[{"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=\/wp\/v2\/posts\/13703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13703"}],"version-history":[{"count":2,"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=\/wp\/v2\/posts\/13703\/revisions"}],"predecessor-version":[{"id":13705,"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=\/wp\/v2\/posts\/13703\/revisions\/13705"}],"wp:attachment":[{"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/visaoestrategica.pt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}