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. Activities and Activity Groups
Master Data
Logical Data Model
Data Management functions breakdown into
AAAA

2. 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.
Metadata Architecture types
Product master data
Components of Data Strategy (VCP GMO RIRS)
Knowledge management

3. 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
Ontology
Kimball key components
Regulatory Compliance examples
Document Mgt.Functions

4. Shared between Data Management Professionals in IT - and Business Data Stewards.
Data Governance (EAC DMA)
Non-strategic goals of data management
Data Management Shared responsibility
Inmon ODS - DW - DM distinction

5. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
DMBOK Environmental Elements
DOLAP
Master Data
DMBOK Recurring Themes

6. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Drivers for Reference and Master Data Management
Data Security in an outsourced wolrd
Information
Common Activity Groups for DM Functions (PDCO)

7. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Affiliation Relationship
Document Mgt.Functions
Data Ops Mgt - Guiding Principles
Knowledge management

8. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data Lifecycle complete
Data
Data Security in an outsourced wolrd
HOLAP

9. ERP
Financial master data
Reference and Master Data Management
Data Security Management (PDE PP AAAA)
Data Stewards

10. DM Program Charter - SCOPE statement - Implementation Roadmap
DMBOK Recurring Themes
Data Strategy Deliverables
AAAA
Data Policies

11. The Exercise of Authority and Control over the Management of Data Assets.
Asset
Data Governance (EAC DMA)
HOLAP
Document

12. High level perspective on a subject area of importance to the business.
Conceptual Data Models
Data Management functions breakdown into
Knowledge management
Data Quality Management lifecycle

13. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Data Implementation
Physical Data Models
Data Ops Mgt - Guiding Principles
Data Policies

14. 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
Affiliation Relationship
Drivers for Reference and Master Data Management
Guiding Principles of data management
Document vs. Content

15. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Procedural DBA
Guiding Principles of data management
DM Function Context Diagram overview (DG - ISP - T - DCM)
Application DBA

16. Modeling and design standards
Regulatory Compliance examples
Data Model/Design quality management
Goals of DMBOK
Document Mgt.Functions

17. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Information
Logical Data Model
Data Integration Services
ROLAP

18. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Application DBA
Enterprise Data Warehouse
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Security Management (PDE PP AAAA)

19. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Detailed Data Design
Data governance programScope elements
Information
Rules defined by Data Governance (PSP MBN DR )

20. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Stewardship
Business Intelligence
Guiding Principles of data management
Drivers for Reference and Master Data Management

21. ETL Source to target mappings
Data Integration Services
Guiding Principles of data management
DM Function Context Diagram overview (DG - ISP - T - DCM)
DMBOK Recurring Themes

22. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Inmon ODS - DW - DM distinction
Asset
Application DBA
Kimball key components

23. 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
Goals of DMBOK
Inmon ODS - DW - DM distinction
Business Intelligence
HOLAP

24. DMS - Development - Maintenance - Support of structured data
Data Development Activities (MDQI)
Data Security in an outsourced wolrd
Data Quality tools
Data Operations Mgt

25. 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 Dimensions
Document Management
Asset
Ontology

26. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Master Data
Data Development Activities (MDQI)
Asset
Document Mgt.Functions

27. 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
Information
Logical Data Model
Strategic goals of data management
Knowledge management

28. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Strategy
Master Data Management
Goals of DMBOK

29. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Knowledge
Detailed Data Design
Guiding Principles of data management

30. Data specifically constructed for query and analysis
Kimball DW Approach
Master Data Management
Procedural DBA
Data Stewards

31. Appointed trustees for data assets
Hierarchical Relationships
Data Stewards
Rules defined by Data Governance (PSP MBN DR )
Data Management Services(GAR MQD IP)

32. Expert technical custodians of data assets
Data Ops Mgt - Guiding Principles
Business Intelligence
Data Security in an outsourced wolrd
Data Management Professionals role

33. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Document Management
Data Management
MOLAP
Content Management

34. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data Stewardship
Taxonomies - 4 types
Drivers for Reference and Master Data Management
Data Management Shared responsibility

35. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Logical Data Model
Data Warehouse primary components
Asset
Hierarchical Relationships

36. Ongoing Reconciliation and Maintenance of reference and master data.
Reference and Master Data Management
Data Operations Mgt
Conceptual Data Models
Data Policies

37. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Strategic goals of data management
Data Quality Management Functions
Physical Data Models
Ontology

38. Control COST of data mgt. - Promote wider understanding of value of data assets. - Manage info consistently across enterprise - Align data mgt efforts and technology with Business Needs.
Non-strategic goals of data management
Data Quality Dimensions
Guiding Principles of data management
Data Management Professionals role

39. 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 Quality expectations
Data asset valuation
Taxonomies - 4 types
Goals of DMBOK

40. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Data governance like real Government
Procedural DBA
Document
Metadata Management Functions

41. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Rules defined by Data Governance (PSP MBN DR )
Data Development Activities (MDQI)
Data Management Professionals role
Data Implementation

42. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Master Data Management
Inmon DW Approach
Data Implementation
Data governance like real Government

43. Data stored in Relational DB store
Data Access Services
Data Stewards
ROLAP
Information

44. Stored in multidimensional data store
Content Mgt Functions
Reference and Master Data Management
MOLAP
Data Strategy

45. Type of model that represents a set of concepts and their relationships within a domain.
Regulatory Compliance examples
Ontology
Data
Logical Data Model

46. Done by DBA - collab with DA.
Detailed Data Design
Data Management Services(GAR MQD IP)
Rules defined by Data Governance (PSP MBN DR )
AAAA

47. State names - codes - MedDRA code - WHO Drug Code
Reference Data - Examples
Financial master data
Data Stewards
Reference and Master Data Management

48. 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)
Data Quality Management Functions
Asset
Data Lifecycle Simple

49. 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 Implementation
Conceptual Data Models
Data Policies
Master Data

50. (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
Metadata for unstructured data types
Data Management Functions
Document vs. Content
Ten Functions of Data Management