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. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Content Management
Data Management Synonyms
Master Data
Business Intelligence

2. DSA - Descriptive metadata (Catalog information - thesauri keyword terms) - Structural metadata (Dublin core - field structures - XML schema) - ADMINISTRATIVE metadata (Source - integration/update schedule - access rights - page relationships)
Data Lifecycle Simple
Reference Data Management
Metadata for unstructured data types
Taxonomies - 4 types

3. ERP
Master Data Management
Taxonomies - 4 types
Financial master data
Inmon ODS - DW - DM distinction

4. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data Stewards
Physical Data Models
Data governance programScope elements
Knowledge management

5. Data stored in combination of ROLAP and MOLAP
AAAA
Regulatory Compliance examples
Data Model/Design quality management
HOLAP

6. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Data Policies
Non-strategic goals of data management
ROLAP
Kimball key components

7. 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
DMBOK Environmental Elements
Reference Data Metadata may include...
Data Ops Mgt has 2 Subfunctions
Data Lifecycle complete

8. 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.
Master Data Management
Metadata Management Functions
Content Management
Reference Data - Examples

9. Stored in multidimensional data store
Enterprise Data Warehouse
HOLAP
MOLAP
Data Security in an outsourced wolrd

10. Virtual OLAP cube available as proprietary function of a classic relational database
DOLAP
Taxonomies - 4 types
Data Management Professionals role
Physical Data Models

11. 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)
Document Mgt.Functions
Data Management functions breakdown into
Components of Data Strategy (VCP GMO RIRS)

12. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Types of Metadata
Data Management Services(GAR MQD IP)
Document Management
Data Management

13. Customer - CRM Employee/workforce - HRM
Taxonomies - 4 types
Data Policies
Party master data
Types of Data Management Organizations

14. FFHN Flat - No relationship among controlled set of categories (e.g. List of Countries) - Facet - Star - attributes of an object (Metadata) - Hierarchical - TREE structure (Geography) - Network - Hierarchy And Facet (Thesaurus)
Data Access Services
Content Mgt Functions
Taxonomies - 4 types
Data Management Shared responsibility

15. TMAC Taxonomy - Metadata - Access - Quality
Content Mgt Functions
Data Ops Mgt has 2 Subfunctions
DMBOK Environmental Elements
Document

16. (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 Management functions breakdown into
Data security guiding principles
Ten Functions of Data Management
Data Quality tools

17. Modeling and design standards
Data Policies
Kimball DW Approach
Data Model/Design quality management
Data Management functions breakdown into

18. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Data asset valuation
Document Mgt.Functions
Data Quality expectations
Data Management

19. Establishment and maintenance of Relationships between master data records.
Reference Data - Examples
Common Activity Groups for DM Functions (PDCO)
Affiliation Relationship
Data Ops Mgt - Guiding Principles

20. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
AAAA
Location master data
Types of Data Management Organizations
HOLAP

21. State names - codes - MedDRA code - WHO Drug Code
Reference Data - Examples
Conceptual Data Models
Content Mgt Functions
Data Strategy

22. High level perspective on a subject area of importance to the business.
Drivers for Reference and Master Data Management
Conceptual Data Models
Data Access Services
Information

23. Type of model that represents a set of concepts and their relationships within a domain.
Guiding Principles of data management
Data Stewardship
Ontology
Types of Data Management Organizations

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
Kimball key components
Data governance programScope elements
Data Quality Management lifecycle
Data Lifecycle complete

25. Expert technical custodians of data assets
Location master data
Data Management Professionals role
Document vs. Content
Kimball DW Approach

26. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Data asset valuation
Data Ops Mgt has 2 Subfunctions
Data
Data governance like real Government

27. WHO needs WHAT info? - What data is available from different sources? - How does data from different sources DIFFER? - How can inconsistencies be RECONCILED? - How should most valid values be SHARED effectively and efficiently?
Goals of DMBOK
Semantic Modeling
Metadata Management Functions
To share consistent Reference and Master data - orgs need to understand...

28. 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 Quality Management lifecycle
Data Implementation
Detailed Data Design
Data Quality Dimensions

29. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
HOLAP
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Management Functions
Inmon DW Approach

30. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Components of Data Strategy (VCP GMO RIRS)
Asset
Data Model/Design quality management
Data Quality expectations

31. 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 Management
Metadata Architecture types
Data Lifecycle complete
AAAA

32. 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
Information
Guiding Principles of data management
Rules defined by Data Governance (PSP MBN DR )
Data Integration Services

33. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Data Implementation
Data Ops Mgt has 2 Subfunctions
Data Management
Rules defined by Data Governance (PSP MBN DR )

34. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Non-strategic goals of data management
Taxonomies - 4 types
Document Mgt.Functions
Data governance programScope elements

35. DM Program Charter - SCOPE statement - Implementation Roadmap
Data Strategy Deliverables
Data Ops Mgt has 2 Subfunctions
Data Stewardship
Detailed Data Design

36. Appointed trustees for data assets
Metadata for unstructured data types
Semantic Modeling
Inmon ODS - DW - DM distinction
Data Stewards

37. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Master Data Management
Document Management
Causes for Performance problems
Data Strategy

38. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Components of Data Strategy (VCP GMO RIRS)
Hierarchical Relationships
Data Operations Mgt
DOLAP

39. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Document Mgt.Functions
Data Security Management (PDE PP AAAA)
Application DBA
DMBOK Environmental Elements

40. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Data Quality Management Functions
Data Security Management (PDE PP AAAA)
Data Lifecycle complete
Data Management Synonyms

41. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Reference and Master Data Management
Drivers for Reference and Master Data Management
Data
DMBOK Recurring Themes

42. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Data Strategy
Rules defined by Data Governance (PSP MBN DR )
Data governance like real Government

43. Control over defined domain values - i.e. Vocabularies.
Reference Data Management
MOLAP
The PE - PPP - ACPDEV - DIA Data Management Acronym
Kimball key components

44. Data specifically constructed for query and analysis
Knowledge
Non-strategic goals of data management
Kimball DW Approach
Hierarchical Relationships

45. 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.
Data governance like real Government
DM Function Context Diagram overview (DG - ISP - T - DCM)
Reference Data Management
Components of Data Strategy (VCP GMO RIRS)

46. Any file or record
HOLAP
Document Mgt.Functions
Document
Data Quality Management Functions

47. DMS - Development - Maintenance - Support of structured data
Data Operations Mgt
Party master data
Reference Data - Examples
Affiliation Relationship

48. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Location master data
Data Quality expectations
Information
Reference Data Metadata may include...

49. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Data Management Functions
Inmon ODS - DW - DM distinction
Enterprise Data Warehouse
Data Security Management (PDE PP AAAA)

50. Data stored in Relational DB store
Data security guiding principles
Data governance programScope elements
ROLAP
Financial master data