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. Query - analysis and reporting off of the DW.
Product master data
Business Intelligence
Data Management Professionals role
Detailed Data Design

2. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Location master data
Data Operations Mgt
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Stewards

3. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Financial master data
Procedural DBA
Conceptual Data Models
Data Warehouse primary components

4. (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
Reference Data - Examples
Ten Functions of Data Management
Data Stewardship
Location master data

5. Created/acquired - stored - used - destroyed.
Document
Examples of individual roles participating in Data Mgt
Data Warehouse primary components
Data Lifecycle Simple

6. Done by DBA - collab with DA.
Detailed Data Design
Reference Data Metadata may include...
Reference Data - Examples
Inmon ODS - DW - DM distinction

7. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Asset
Financial master data
Enterprise Data Warehouse
Location master data

8. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Application DBA
Strategic goals of data management
Kimball DW Approach
Causes for Performance problems

9. The Exercise of Authority and Control over the Management of Data Assets.
Content Management
Data Governance (EAC DMA)
DMBOK Environmental Elements
Reference Data Metadata may include...

10. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Information
Data Operations Mgt
Data Model/Design quality management
Data Quality tools

11. DM Program Charter - SCOPE statement - Implementation Roadmap
Data Lifecycle complete
Data Strategy Deliverables
Strategic goals of data management
Metadata Architecture types

12. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Document Management
Non-strategic goals of data management
Data Stewardship
Affiliation Relationship

13. DMS - Development - Maintenance - Support of structured data
Data Operations Mgt
Strategic goals of data management
Document
Content Management

14. 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
Data Ops Mgt has 2 Subfunctions
Data Governance Deliverables (PPS IP SQV)
AAAA
Data Management Functions

15. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
Data Implementation
Data Security Management (PDE PP AAAA)
Semantic Modeling
Data security guiding principles

16. 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
Taxonomies - 4 types
Semantic Modeling
HOLAP

17. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Lifecycle Simple
Data Warehouse primary components
Reference and Master Data Management
Data Quality Management lifecycle

18. Control over defined domain values - i.e. Vocabularies.
Inmon ODS - DW - DM distinction
Data governance like real Government
Reference Data Management
Content Mgt Functions

19. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Regulatory Compliance examples
Data governance like real Government
Taxonomies - 4 types
Data Quality tools

20. 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
Guiding Principles of data management
Data governance programScope elements
Physical Data Models
Data

21. 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
Metadata Management Functions
Types of Metadata
Data Quality Management lifecycle
DOLAP

22. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Application DBA
Master Data
AAAA
Guiding Principles of data management

23. Discipline that fosters organizational learning and the management of intellectual capital.
Business Intelligence
Knowledge management
Data Access Services
Data Security Management (PDE PP AAAA)

24. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Metadata Architecture types
Data Ops Mgt - Guiding Principles
Types of Data Management Organizations
Document

25. 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
Enterprise Data Warehouse
DOLAP
Business Intelligence

26. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Data Governance Deliverables (PPS IP SQV)
Data Security in an outsourced wolrd
Data Governance (EAC DMA)
The PE - PPP - ACPDEV - DIA Data Management Acronym

27. Customer - CRM Employee/workforce - HRM
Data Management functions breakdown into
Party master data
Financial master data
Data Strategy

28. Ongoing Reconciliation and Maintenance of reference and master data.
Reference and Master Data Management
DOLAP
Reference Data Metadata may include...
Rules defined by Data Governance (PSP MBN DR )

29. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
DM Function Context Diagram overview (DG - ISP - T - DCM)
Ontology
Data Implementation
Reference and Master Data Management

30. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Document vs. Content
Goals of DMBOK
To share consistent Reference and Master data - orgs need to understand...
Data Management Functions

31. Sarbanes-Oxley - financial reporting and auditing - HIPPA - privacy and security of health information - Basel II - Solvency II - PCI-DSS - Payment Card Industry Data Security Standards
Data Lifecycle complete
Affiliation Relationship
Regulatory Compliance examples
Guiding Principles of data management

32. A high-level course of action to achieve data goals. Usually a data management program strategy.
Master Data Management
Data Strategy
Types of Data Management Organizations
Data Quality expectations

33. 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.
Procedural DBA
Data Policies
Types of Metadata
Data governance like real Government

34. 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?
Common Activity Groups for DM Functions (PDCO)
Content Management
Location master data
To share consistent Reference and Master data - orgs need to understand...

35. Modeling and design standards
Conceptual Data Models
Data Model/Design quality management
Application DBA
Data Lifecycle complete

36. 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
Ontology
Drivers for Reference and Master Data Management
Data Ops Mgt - Guiding Principles
DM Function Context Diagram overview (DG - ISP - T - DCM)

37. 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
To share consistent Reference and Master data - orgs need to understand...
Strategic goals of data management
Content Management
Data Management Functions

38. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Hierarchical Relationships
Data Operations Mgt
Inmon DW Approach
Guiding Principles of data management

39. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Rules defined by Data Governance (PSP MBN DR )
Regulatory Compliance examples
Ten Functions of Data Management
Financial master data

40. 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.
Components of Data Strategy (VCP GMO RIRS)
Reference Data - Examples
Location master data
Causes for Performance problems

41. 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 Policies
Data Strategy
DM Function Context Diagram overview (DG - ISP - T - DCM)
Taxonomies - 4 types

42. Establishment and maintenance of Relationships between master data records.
Affiliation Relationship
Data Access Services
Content Management
MOLAP

43. 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)
Reference Data - Examples
Data Model/Design quality management
Data governance programScope elements

44. 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
DM Function Context Diagram overview (DG - ISP - T - DCM)
Inmon ODS - DW - DM distinction
Non-strategic goals of data management
Detailed Data Design

45. 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
Data Governance Deliverables (PPS IP SQV)
Ten Functions of Data Management
Data asset valuation
Data Quality Management lifecycle

46. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
HOLAP
Data Quality Management Functions
Logical Data Model
Master Data

47. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Causes for Performance problems
Data Ops Mgt has 2 Subfunctions
Components of Data Strategy (VCP GMO RIRS)
Semantic Modeling

48. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Logical Data Model
Data Management Shared responsibility
Kimball key components
Location master data

49. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Physical Data Models
Data Ops Mgt - Guiding Principles
Data Access Services
Data Ops Mgt has 2 Subfunctions

50. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data Lifecycle complete
Data governance programScope elements
Content Management
Knowledge