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. SOA - ETL - Replication - Message Brokers
Reference and Master Data Management
DM Function Context Diagram overview (DG - ISP - T - DCM)
Location master data
Data Access Services

2. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Metadata Management Functions
Location master data
Data Quality Management Functions
Data Ops Mgt - Guiding Principles

3. 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?
To share consistent Reference and Master data - orgs need to understand...
Non-strategic goals of data management
Data Governance (EAC DMA)
Data asset valuation

4. Customer - CRM Employee/workforce - HRM
Application DBA
Data Access Services
Party master data
Financial master data

5. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Document Management
Goals of DMBOK
Knowledge
Data Management

6. 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
DMBOK Environmental Elements
DMBOK Recurring Themes
Strategic goals of data management
Data governance programScope elements

7. 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.
Data Policies
Drivers for Reference and Master Data Management
To share consistent Reference and Master data - orgs need to understand...
Data governance programScope elements

8. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data Management functions breakdown into
Semantic Modeling
Types of Metadata
Physical Data Models

9. 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
Master Data
Asset
Data Quality Management lifecycle
Content Mgt Functions

10. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Causes for Performance problems
HOLAP
Application DBA
Enterprise Data Warehouse

11. Stored in multidimensional data store
Strategic goals of data management
Master Data Management
MOLAP
Data Lifecycle complete

12. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Goals of DMBOK
HOLAP
Data asset valuation
Data Management

13. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Data Implementation
DMBOK Recurring Themes
Reference Data Management
Data Warehouse primary components

14. 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
Document
Components of Data Strategy (VCP GMO RIRS)
Goals of DMBOK

15. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Information
Data Management Synonyms
Content Management
AAAA

16. High level perspective on a subject area of importance to the business.
Information
Guiding Principles of data management
Conceptual Data Models
Kimball DW Approach

17. Modeling and design standards
Data Model/Design quality management
Components of Data Strategy (VCP GMO RIRS)
Document vs. Content
Data Warehouse primary components

18. ETL Source to target mappings
Location master data
Data Integration Services
Data Management
Metadata Architecture types

19. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Kimball DW Approach
Reference and Master Data Management
Data
Drivers for Reference and Master Data Management

20. Any file or record
Document Management
Document
Data Management Services(GAR MQD IP)
Document vs. Content

21. 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
Data Management
Location master data
The PE - PPP - ACPDEV - DIA Data Management Acronym

22. Type of model that represents a set of concepts and their relationships within a domain.
Data Implementation
Data Lifecycle complete
Ontology
Data Quality Management lifecycle

23. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Party master data
The PE - PPP - ACPDEV - DIA Data Management Acronym
Financial master data
DM Function Context Diagram overview (DG - ISP - T - DCM)

24. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Logical Data Model
Procedural DBA
Causes for Performance problems
Hierarchical Relationships

25. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data Stewardship
MOLAP
ROLAP
AAAA

26. Control over defined domain values - i.e. Vocabularies.
Kimball key components
Types of Metadata
Reference Data Management
Ten Functions of Data Management

27. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Examples of individual roles participating in Data Mgt
DOLAP
Content Management
AAAA

28. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Drivers for Reference and Master Data Management
Product master data
Causes for Performance problems
Data Warehouse primary components

29. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Taxonomies - 4 types
Information
Document Mgt.Functions
Data Ops Mgt - Guiding Principles

30. 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)
Components of Data Strategy (VCP GMO RIRS)
Data Security Management (PDE PP AAAA)
Document vs. Content
Metadata for unstructured data types

31. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Components of Data Strategy (VCP GMO RIRS)
Data Quality expectations
Semantic Modeling
Information

32. Virtual OLAP cube available as proprietary function of a classic relational database
Affiliation Relationship
DOLAP
Data Ops Mgt - Guiding Principles
DM Function Context Diagram overview (DG - ISP - T - DCM)

33. 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)
Taxonomies - 4 types
Data Governance Deliverables (PPS IP SQV)
Affiliation Relationship
Content Mgt Functions

34. 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
Examples of individual roles participating in Data Mgt
Ontology
Semantic Modeling
Inmon ODS - DW - DM distinction

35. 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 Operations Mgt
Master Data
Data

36. Establishment and maintenance of Relationships between master data records.
Strategic goals of data management
Application DBA
Affiliation Relationship
Examples of individual roles participating in Data Mgt

37. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Knowledge management
Data Model/Design quality management
Data Integration Services
Data Security in an outsourced wolrd

38. Top - Definition and List of Goals - Center - List of that function's Activities - Left - Inputs - Suppliers - Participants - Below - Tools used for activities - Right - Primary DELIVERABLES - Consumers - Metrics
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality Dimensions
Data Lifecycle Simple
Data Implementation

39. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Location master data
Data Management
Document Management
Data Warehouse primary components

40. Discipline that fosters organizational learning and the management of intellectual capital.
Data Strategy
Data Ops Mgt has 2 Subfunctions
Ten Functions of Data Management
Knowledge management

41. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Components of Data Strategy (VCP GMO RIRS)
Data Management Functions
Data Quality Dimensions
Knowledge management

42. 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)
Data Management functions breakdown into
Location master data
The PE - PPP - ACPDEV - DIA Data Management Acronym

43. The Exercise of Authority and Control over the Management of Data Assets.
Data Governance (EAC DMA)
Content Mgt Functions
Data Quality tools
DM Function Context Diagram overview (DG - ISP - T - DCM)

44. (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
Strategic goals of data management
Knowledge
Ten Functions of Data Management
Data Lifecycle Simple

45. DM Program Charter - SCOPE statement - Implementation Roadmap
Content Management
Rules defined by Data Governance (PSP MBN DR )
Data Strategy Deliverables
Data Management Professionals role

46. Shared between Data Management Professionals in IT - and Business Data Stewards.
Data Management Shared responsibility
Data Security in an outsourced wolrd
Common Activity Groups for DM Functions (PDCO)
Asset

47. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Kimball key components
Drivers for Reference and Master Data Management
Knowledge management
Rules defined by Data Governance (PSP MBN DR )

48. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Procedural DBA
Application DBA
Data Governance Deliverables (PPS IP SQV)
Physical Data Models

49. Data stored in Relational DB store
Metadata Management Functions
ROLAP
Data Management Functions
Taxonomies - 4 types

50. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Metadata Management Functions
Data Policies
Kimball key components
Data Development Activities (MDQI)