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. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Causes for Performance problems
Location master data
DOLAP
Physical Data Models

2. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Data Policies
Data Security in an outsourced wolrd
Data Quality Management lifecycle
Data asset valuation

3. A high-level course of action to achieve data goals. Usually a data management program strategy.
Common Activity Groups for DM Functions (PDCO)
Drivers for Reference and Master Data Management
Inmon ODS - DW - DM distinction
Data Strategy

4. Created/acquired - stored - used - destroyed.
Data Lifecycle Simple
Strategic goals of data management
Data Management
Data governance programScope elements

5. 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
Metadata for unstructured data types
Data Management Functions
Strategic goals of data management
Logical Data Model

6. Customer - CRM Employee/workforce - HRM
Application DBA
Party master data
Data Management Services(GAR MQD IP)
Document Mgt.Functions

7. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Data Implementation
Components of Data Strategy (VCP GMO RIRS)
Information
AAAA

8. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Detailed Data Design
Reference Data Metadata may include...
Data Integration Services
Enterprise Data Warehouse

9. Database Support and Data Technology Management
Data Ops Mgt has 2 Subfunctions
Data Management Synonyms
Regulatory Compliance examples
Types of Data Management Organizations

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.
Data Warehouse primary components
To share consistent Reference and Master data - orgs need to understand...
Data Quality tools
Product master data

11. Stored in multidimensional data store
DMBOK Environmental Elements
MOLAP
Data Quality Dimensions
Procedural DBA

12. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Data Strategy Deliverables
Data Management Services(GAR MQD IP)
Ten Functions of Data Management
Data Management Professionals role

13. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Data Management functions breakdown into
Conceptual Data Models
Guiding Principles of data management

14. Activities and Activity Groups
DMBOK Environmental Elements
Data Management functions breakdown into
Common Activity Groups for DM Functions (PDCO)
Kimball key components

15. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Financial master data
Regulatory Compliance examples
Logical Data Model
Procedural DBA

16. Appointed trustees for data assets
Kimball DW Approach
To share consistent Reference and Master data - orgs need to understand...
Data Stewards
Data Strategy

17. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Data Policies
Data Strategy
Enterprise Data Warehouse
The PE - PPP - ACPDEV - DIA Data Management Acronym

18. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Semantic Modeling
Types of Data Management Organizations
Affiliation Relationship
Kimball DW Approach

19. Planning - set strategic and tactical course for other activities - Development - undertaken within implementation projects and recognized as part of SDLC - Control - Supervisory activities - Operational - Service and support activities
Common Activity Groups for DM Functions (PDCO)
Data Management Shared responsibility
Data Implementation
Inmon DW Approach

20. Shared between Data Management Professionals in IT - and Business Data Stewards.
DMBOK Environmental Elements
Metadata Management Functions
DMBOK Recurring Themes
Data Management Shared responsibility

21. Modeling and design standards
Data Ops Mgt has 2 Subfunctions
Data Quality Management lifecycle
Data Model/Design quality management
Inmon ODS - DW - DM distinction

22. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Semantic Modeling
Data Warehouse primary components
Procedural DBA
Data Access Services

23. SOA - ETL - Replication - Message Brokers
Knowledge
Metadata Management Functions
Data Governance Deliverables (PPS IP SQV)
Data Access Services

24. 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.
DMBOK Environmental Elements
Asset
Document Mgt.Functions
Components of Data Strategy (VCP GMO RIRS)

25. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Components of Data Strategy (VCP GMO RIRS)
Semantic Modeling
DMBOK Recurring Themes

26. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Data Development Activities (MDQI)
Data Security Management (PDE PP AAAA)
Examples of individual roles participating in Data Mgt
The PE - PPP - ACPDEV - DIA Data Management Acronym

27. High level perspective on a subject area of importance to the business.
Reference Data Management
Document
Data
Conceptual Data Models

28. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Ops Mgt has 2 Subfunctions
Metadata Management Functions
Data Warehouse primary components
Data Quality Management Functions

29. Control over defined domain values - i.e. Vocabularies.
The PE - PPP - ACPDEV - DIA Data Management Acronym
Logical Data Model
Examples of individual roles participating in Data Mgt
Reference Data Management

30. Expert technical custodians of data assets
Guiding Principles of data management
Metadata Management Functions
Reference and Master Data Management
Data Management Professionals role

31. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Data Governance Deliverables (PPS IP SQV)
DMBOK Recurring Themes
Strategic goals of data management
Data Quality Management lifecycle

32. Responsible Trustee of data - Understand and Comply with Regulations- Define data security Reqts Collaboratively - ID detailed application security reqts in each app dev project - Every user acct. has password - Use Role Groups- Formally track/approv
Data Management
Data security guiding principles
Information
Data Operations Mgt

33. The Exercise of Authority and Control over the Management of Data Assets.
Document vs. Content
Data Management Shared responsibility
Inmon DW Approach
Data Governance (EAC DMA)

34. Any file or record
Taxonomies - 4 types
Data
Logical Data Model
Document

35. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Data Ops Mgt has 2 Subfunctions
Data Ops Mgt - Guiding Principles
Goals of DMBOK
Data governance like real Government

36. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Party master data
Strategic goals of data management
Procedural DBA
Application DBA

37. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Metadata for unstructured data types
Reference and Master Data Management
Document Management
Kimball key components

38. 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.
Reference Data - Examples
DM Function Context Diagram overview (DG - ISP - T - DCM)
Product master data
Data Policies

39. Accuracy - degree data reflects real life entities] - [Completeness - both cols and rows - Consistency - Consistent data values between data sets - Currency - current with real world situation] - [Precision - level of detail - Privacy - access contr
Data governance programScope elements
Data Quality Dimensions
Asset
Drivers for Reference and Master Data Management

40. 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
Types of Metadata
Reference Data Metadata may include...
Data governance like real Government
Data Security in an outsourced wolrd

41. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
Data Security Management (PDE PP AAAA)
Business Intelligence
Data Access Services
Data Policies

42. ODS - Current-valued - volatile data for operational reporting needs - DW - Historical - non-volatile data for single source of integrated data for corporation - DM - DSS for a department analytic need
To share consistent Reference and Master data - orgs need to understand...
Metadata for unstructured data types
Master Data Management
Inmon ODS - DW - DM distinction

43. Data stored in combination of ROLAP and MOLAP
Inmon DW Approach
Data Ops Mgt - Guiding Principles
Business Intelligence
HOLAP

44. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Kimball DW Approach
Content Management
Party master data
Data Lifecycle complete

45. Data stored in Relational DB store
Causes for Performance problems
Kimball key components
Data Access Services
ROLAP

46. Formal accountability for business responsibilities ensuring effective control and use of data assets.
ROLAP
Data Stewardship
Application DBA
Party master data

47. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Reference and Master Data Management
Data
Data Quality Management Functions
HOLAP

48. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
HOLAP
Information
Reference Data Metadata may include...
Physical Data Models

49. Ongoing Reconciliation and Maintenance of reference and master data.
Data Stewards
Reference and Master Data Management
Data asset valuation
DM Function Context Diagram overview (DG - ISP - T - DCM)

50. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Goals of DMBOK
Data Security in an outsourced wolrd
Ten Functions of Data Management
Knowledge