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. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Reference and Master Data Management
Data Management Synonyms
Data Governance Deliverables (PPS IP SQV)
Data Strategy Deliverables

2. 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.
Hierarchical Relationships
Inmon DW Approach
Data Ops Mgt - Guiding Principles
Product master data

3. BTPD Business (Definitions - rules - data lineage - quality statements - report lists - etc.) - Targetd at Business - Technical and operational (Information about SYSTEMS. DBs - column names - files - etls - etc) - Targeted at IT Operations users' n
Types of Metadata
Metadata Management Functions
Data Management Services(GAR MQD IP)
Reference Data - Examples

4. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
The PE - PPP - ACPDEV - DIA Data Management Acronym
Party master data
Data Security Management (PDE PP AAAA)
Data Management Synonyms

5. 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?
Types of Data Management Organizations
Data Governance Deliverables (PPS IP SQV)
Data Governance (EAC DMA)
To share consistent Reference and Master data - orgs need to understand...

6. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Guiding Principles of data management
Data Lifecycle complete
Knowledge
Document Mgt.Functions

7. Data is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?
Data asset valuation
To share consistent Reference and Master data - orgs need to understand...
Asset
Data security guiding principles

8. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Inmon DW Approach
Data Management functions breakdown into
Procedural DBA
Components of Data Strategy (VCP GMO RIRS)

9. Data stored in Relational DB store
Data Quality tools
DMBOK Recurring Themes
Examples of individual roles participating in Data Mgt
ROLAP

10. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Rules defined by Data Governance (PSP MBN DR )
AAAA
Application DBA
Data Governance (EAC DMA)

11. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Management Functions
Kimball key components
Drivers for Reference and Master Data Management
Asset

12. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Hierarchical Relationships
DMBOK Recurring Themes
Data Operations Mgt
Data Implementation

13. State names - codes - MedDRA code - WHO Drug Code
Non-strategic goals of data management
Physical Data Models
Reference Data - Examples
Components of Data Strategy (VCP GMO RIRS)

14. Shared between Data Management Professionals in IT - and Business Data Stewards.
MOLAP
Data Management Shared responsibility
Detailed Data Design
Procedural DBA

15. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Content Mgt Functions
Data Governance Deliverables (PPS IP SQV)
Components of Data Strategy (VCP GMO RIRS)
Inmon ODS - DW - DM distinction

16. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Data governance like real Government
Examples of individual roles participating in Data Mgt
Data Ops Mgt - Guiding Principles
Document Management

17. SOA - ETL - Replication - Message Brokers
Master Data
Data Access Services
Business Intelligence
Affiliation Relationship

18. High level perspective on a subject area of importance to the business.
Conceptual Data Models
Data Access Services
DMBOK Environmental Elements
Procedural DBA

19. 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 Management functions breakdown into
Metadata for unstructured data types
Content Mgt Functions
Data Quality Management Functions

20. Type of model that represents a set of concepts and their relationships within a domain.
Data Security Management (PDE PP AAAA)
DM Function Context Diagram overview (DG - ISP - T - DCM)
Ontology
Master Data Management

21. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data Management Services(GAR MQD IP)
Party master data
To share consistent Reference and Master data - orgs need to understand...
Data Stewardship

22. 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 Governance (EAC DMA)
Information
Master Data
Strategic goals of data management

23. 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
Taxonomies - 4 types
Asset
Ontology

24. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Data Operations Mgt
ROLAP
Document vs. Content
Logical Data Model

25. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Security Management (PDE PP AAAA)
Document
Data Implementation
Data Warehouse primary components

26. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Rules defined by Data Governance (PSP MBN DR )
Document vs. Content
Data Governance Deliverables (PPS IP SQV)
Taxonomies - 4 types

27. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Data Quality expectations
Data Security in an outsourced wolrd
Components of Data Strategy (VCP GMO RIRS)
Data security guiding principles

28. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Types of Metadata
Data Operations Mgt
Data Ops Mgt has 2 Subfunctions

29. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Data Management Services(GAR MQD IP)
Detailed Data Design
Product master data
Master Data Management

30. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Management functions breakdown into
Enterprise Data Warehouse
Data Ops Mgt - Guiding Principles
Semantic Modeling

31. DM Program Charter - SCOPE statement - Implementation Roadmap
Data Quality tools
Data Management
Data Strategy Deliverables
Data governance programScope elements

32. DMS - Development - Maintenance - Support of structured data
Data Operations Mgt
DOLAP
Conceptual Data Models
Asset

33. 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 Integration Services
Components of Data Strategy (VCP GMO RIRS)
Data Lifecycle complete
Location master data

34. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Semantic Modeling
Knowledge management
Metadata for unstructured data types
Ontology

35. 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.
Common Activity Groups for DM Functions (PDCO)
Master Data Management
Data asset valuation
Data Stewardship

36. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
DMBOK Recurring Themes
Enterprise Data Warehouse
Data Management Professionals role
Data Implementation

37. (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 Quality Management lifecycle
Ten Functions of Data Management
Guiding Principles of data management
Data Governance (EAC DMA)

38. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data Stewardship
DMBOK Environmental Elements
Physical Data Models
Ontology

39. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Types of Data Management Organizations
Data Management Shared responsibility
Physical Data Models
AAAA

40. Data specifically constructed for query and analysis
DMBOK Environmental Elements
Data Strategy Deliverables
Data Management Shared responsibility
Kimball DW Approach

41. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Non-strategic goals of data management
Data Quality expectations
Rules defined by Data Governance (PSP MBN DR )
Information

42. Activities and Activity Groups
Data Ops Mgt has 2 Subfunctions
Reference Data Metadata may include...
Data
Data Management functions breakdown into

43. A high-level course of action to achieve data goals. Usually a data management program strategy.
Data Lifecycle Simple
Data Quality Management Functions
Detailed Data Design
Data Strategy

44. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Types of Metadata
Master Data
To share consistent Reference and Master data - orgs need to understand...
Data Management Shared responsibility

45. Customer - CRM Employee/workforce - HRM
To share consistent Reference and Master data - orgs need to understand...
Data Warehouse primary components
Procedural DBA
Party master data

46. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality Management Functions
Types of Metadata
Detailed Data Design

47. Database Support and Data Technology Management
Data Ops Mgt has 2 Subfunctions
Hierarchical Relationships
Data Management Functions
Metadata Management Functions

48. ETL Source to target mappings
Asset
Rules defined by Data Governance (PSP MBN DR )
Data Integration Services
Metadata for unstructured data types

49. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Data Development Activities (MDQI)
Kimball key components
Data asset valuation
Content Mgt Functions

50. 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 Development Activities (MDQI)
Data
Reference Data - Examples
Non-strategic goals of data management