Test your basic knowledge |

DMBOK

Instructions:

Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can study here.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.

1. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Data asset valuation
Types of Data Management Organizations
Location master data
Product master data

2. Authentication - User is who they say they are. - Authorization - List of privileges that a user has to data - Access - Enable privileges in a timely manner - Auditing - Review security actions and user activity to ensure compliance
AAAA
Components of Data Strategy (VCP GMO RIRS)
Causes for Performance problems
Regulatory Compliance examples

3. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data Stewards
Physical Data Models
Rules defined by Data Governance (PSP MBN DR )
Reference Data - Examples

4. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Logical Data Model
Data Warehouse primary components
Data Management Synonyms
Master Data Management

5. Centralized - gather and store centrally - periodic batch updates - Distributed - Query it in realtime from source - Hybrid - Header/common info stored centrally - more detailed info gathered in realtime from source
Data
Examples of individual roles participating in Data Mgt
Metadata Architecture types
Data Model/Design quality management

6. Vision - business case - guiding principles - long-term goal of Data Management - Measures of success - SMART program Objectives - descriptions of Roles - description of INITIATIVES (projects) - ROADMAP - boundaries of SCOPE.
Metadata for unstructured data types
Components of Data Strategy (VCP GMO RIRS)
Causes for Performance problems
Data security guiding principles

7. Expert technical custodians of data assets
Document Management
Data Management Professionals role
Data Quality Management lifecycle
Taxonomies - 4 types

8. DM Program Charter - SCOPE statement - Implementation Roadmap
Inmon ODS - DW - DM distinction
HOLAP
DMBOK Recurring Themes
Data Strategy Deliverables

9. A high-level course of action to achieve data goals. Usually a data management program strategy.
Content Management
Data Strategy
Master Data Management
MOLAP

10. PLM - Product lifecycle management systems - enable cross-process cost and legal agreements tracking as product concepts evolve from one idea to many potential products under different names and potentially different licensing agreements.
Product master data
Financial master data
MOLAP
Taxonomies - 4 types

11. Virtual OLAP cube available as proprietary function of a classic relational database
DOLAP
Party master data
Data Implementation
Metadata for unstructured data types

12. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Data Operations Mgt
The PE - PPP - ACPDEV - DIA Data Management Acronym
Asset
Document vs. Content

13. Control over master data values to enable consistent - shared - contextual use across systems - of the most Accurate - Current - Relevant version of truth about Essential business entitites.
Data Management Services(GAR MQD IP)
Financial master data
Logical Data Model
Master Data Management

14. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Application DBA
The PE - PPP - ACPDEV - DIA Data Management Acronym
Semantic Modeling
Logical Data Model

15. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Rules defined by Data Governance (PSP MBN DR )
DOLAP
Data Access Services
Data Quality Management lifecycle

16. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Product master data
Data Warehouse primary components
Data Management Synonyms
Drivers for Reference and Master Data Management

17. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Enterprise Data Warehouse
Reference Data - Examples
Common Activity Groups for DM Functions (PDCO)
Data Policies

18. Meaning and purpose of each reference data value domain - Reference tables and databases where the reference data appears. - Source of the data in each table. - Version currently available. - When data was last updated. - How the data in each table i
Data Ops Mgt - Guiding Principles
Reference Data Management
Data Quality expectations
Reference Data Metadata may include...

19. Short statements of Management Intent and fundamental Rules governing creation - acquisition - integrity - security - quality - and use of data and information. Describe WHATs - and What NOTs; do not describe HOWs.
Hierarchical Relationships
Data Policies
Detailed Data Design
Reference Data - Examples

20. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Inmon DW Approach
Logical Data Model
Procedural DBA
Party master data

21. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Data Quality Dimensions
Data governance like real Government
Data Strategy
Data Lifecycle complete

22. Database Support and Data Technology Management
Data Ops Mgt has 2 Subfunctions
Hierarchical Relationships
Data Management Services(GAR MQD IP)
Semantic Modeling

23. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Procedural DBA
Data Quality Management Functions
Data Lifecycle Simple
Reference Data - Examples

24. PPPDMA Plan - assess scope of known issues - Deploy - profile the data - and employ inspections and monitors - Monitor - actively monitor data quality against defined business rules - Act - Take action to address and resolve emerging issues
Content Management
Reference Data Management
Data Governance Deliverables (PPS IP SQV)
Data Quality Management lifecycle

25. Understand info Needs of enterprise and its stakeholders. - Capture - store - protect - and ensure integrity of Data Assets. - Continually improve Quality of data and information. - Ensure Privacy and Confidentiality - Maximize Effective use and VALU
Data Development Activities (MDQI)
Data governance programScope elements
Strategic goals of data management
Data Operations Mgt

26. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Document vs. Content
Data Security in an outsourced wolrd
Strategic goals of data management
Ontology

27. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Application DBA
Product master data
Document Management
DM Function Context Diagram overview (DG - ISP - T - DCM)

28. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Conceptual Data Models
Knowledge
Non-strategic goals of data management
Data Management

29. ERP
Location master data
Financial master data
Data Development Activities (MDQI)
Data Ops Mgt has 2 Subfunctions

30. Type of model that represents a set of concepts and their relationships within a domain.
Ontology
Data Management Shared responsibility
Conceptual Data Models
Common Activity Groups for DM Functions (PDCO)

31. Discipline that fosters organizational learning and the management of intellectual capital.
Knowledge management
Data Strategy Deliverables
Data asset valuation
Data security guiding principles

32. Data specifically constructed for query and analysis
Data Implementation
Kimball DW Approach
Guiding Principles of data management
DMBOK Recurring Themes

33. Ongoing Reconciliation and Maintenance of reference and master data.
Reference and Master Data Management
AAAA
Data Management Professionals role
Kimball DW Approach

34. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Data Policies
Content Mgt Functions
Goals of DMBOK
Common Activity Groups for DM Functions (PDCO)

35. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Types of Data Management Organizations
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Implementation
Business Intelligence

36. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Rules defined by Data Governance (PSP MBN DR )
Data Management Services(GAR MQD IP)
Data Model/Design quality management
Data Policies

37. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Data governance like real Government
Content Mgt Functions
Data Integration Services
Metadata Management Functions

38. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Data Management Functions
Information
Reference Data Management
Data Management Synonyms

39. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Reference Data - Examples
Document Mgt.Functions
Document
Data Management Functions

40. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Management Functions
Data Access Services
Data Security Management (PDE PP AAAA)
Drivers for Reference and Master Data Management

41. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Data Management Professionals role
Data Management Shared responsibility
Data governance like real Government

42. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Data Ops Mgt - Guiding Principles
Data governance programScope elements
Party master data
Data Governance Deliverables (PPS IP SQV)

43. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data asset valuation
Reference Data Management
Data Stewardship
Location master data

44. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Common Activity Groups for DM Functions (PDCO)
Document
Data Strategy
Causes for Performance problems

45. 1. Data and info are valuable enterprise ASSETs 2. Manage data/info carefully - like any other asset - by ensuring Quality - Security - Integrity - Protection - Availability - Understanding - and Effective Use. 3. Share responsibility between busines
Ontology
Guiding Principles of data management
Data Management
Document

46. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Application DBA
Data Model/Design quality management
Reference Data - Examples
Reference Data Management

47. (GADO SQ RIDM) 1. Governance 2. Architecture Management 3. Development 4. Operations Management 5. Security Management 6. Quality Management 7. Reference/Master Data Management 8. Data Warehousing/Business Intelligence 9. Document and Content Manage
Data Governance (EAC DMA)
Data Lifecycle Simple
Data Model/Design quality management
Ten Functions of Data Management

48. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Data Management Functions
MOLAP
Conceptual Data Models
Data Lifecycle Simple

49. 1. Modeling - Analysis - Design (Reqts - Conc - Log - Phys Models) 2. Detailed Data Design (Phys DBs - Info Products - Access - Integration Services) 3. Quality Management (Modeling/Design Standards - Review Models - Versioning/Integration of Models)
Data Policies
Ten Functions of Data Management
Kimball DW Approach
Data Development Activities (MDQI)

50. Control over defined domain values - i.e. Vocabularies.
Data governance programScope elements
Reference Data Management
MOLAP
Reference and Master Data Management