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. Ongoing Reconciliation and Maintenance of reference and master data.
Reference and Master Data Management
Data Lifecycle Simple
Financial master data
Application DBA

2. 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.
Product master data
Logical Data Model
Data Policies
Data Lifecycle Simple

3. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Data Ops Mgt has 2 Subfunctions
Knowledge
Data Security in an outsourced wolrd
Logical Data Model

4. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Common Activity Groups for DM Functions (PDCO)
Guiding Principles of data management
Content Management
Metadata for unstructured data types

5. ERP
Financial master data
Master Data
Ten Functions of Data Management
Data Quality Dimensions

6. High level perspective on a subject area of importance to the business.
Conceptual Data Models
Data Warehouse primary components
Data Security in an outsourced wolrd
Reference Data - Examples

7. Query - analysis and reporting off of the DW.
Document Mgt.Functions
Knowledge management
Party master data
Business Intelligence

8. Data stored in combination of ROLAP and MOLAP
Data Warehouse primary components
Data Strategy Deliverables
Data Management
HOLAP

9. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Document vs. Content
Detailed Data Design
DOLAP
Party master data

10. 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.
Document Management
Hierarchical Relationships
Conceptual Data Models
Master Data Management

11. Activities and Activity Groups
Data Access Services
Knowledge
Ten Functions of Data Management
Data Management functions breakdown into

12. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Data Management Shared responsibility
Application DBA
DMBOK Recurring Themes
Data Quality Dimensions

13. 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
Ten Functions of Data Management
Data Governance Deliverables (PPS IP SQV)
Inmon ODS - DW - DM distinction
Types of Metadata

14. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Logical Data Model
Data Ops Mgt - Guiding Principles
Knowledge management
Goals of DMBOK

15. 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
Common Activity Groups for DM Functions (PDCO)
Metadata Architecture types
AAAA
Knowledge management

16. 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
Taxonomies - 4 types
Knowledge
Ontology

17. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Reference and Master Data Management
Data Management functions breakdown into
Drivers for Reference and Master Data Management
DM Function Context Diagram overview (DG - ISP - T - DCM)

18. State names - codes - MedDRA code - WHO Drug Code
Data Quality Management Functions
Reference Data - Examples
Metadata Management Functions
Data Stewards

19. 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
Data Stewards
Data Management
Asset
Reference Data Metadata may include...

20. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Data governance programScope elements
Data Stewardship
Data Development Activities (MDQI)
Knowledge

21. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Detailed Data Design
Inmon DW Approach
Goals of DMBOK
Data Access Services

22. 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
Inmon ODS - DW - DM distinction
Document Mgt.Functions
Metadata Architecture types
Drivers for Reference and Master Data Management

23. 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
DOLAP
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Management
Knowledge

24. DMS - Development - Maintenance - Support of structured data
Data Security in an outsourced wolrd
Data Operations Mgt
Data Management Shared responsibility
Financial master data

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

26. Control over defined domain values - i.e. Vocabularies.
Document Management
Data Strategy Deliverables
HOLAP
Reference Data Management

27. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
DMBOK Environmental Elements
Data Ops Mgt - Guiding Principles
Data
Conceptual Data Models

28. 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)
Detailed Data Design
Metadata for unstructured data types
Data security guiding principles

29. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Data Quality expectations
The PE - PPP - ACPDEV - DIA Data Management Acronym
HOLAP
Rules defined by Data Governance (PSP MBN DR )

30. 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.
Data Management Functions
Non-strategic goals of data management
Enterprise Data Warehouse
MOLAP

31. Shared between Data Management Professionals in IT - and Business Data Stewards.
Detailed Data Design
Data Management Shared responsibility
Affiliation Relationship
Logical Data Model

32. TMAC Taxonomy - Metadata - Access - Quality
Guiding Principles of data management
Causes for Performance problems
Content Mgt Functions
Data Quality Management Functions

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.
Components of Data Strategy (VCP GMO RIRS)
Data Quality Management lifecycle
Data Security in an outsourced wolrd
Kimball DW Approach

34. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Data Ops Mgt has 2 Subfunctions
Document Management
Document Mgt.Functions
Ontology

35. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Data Management functions breakdown into
Data Quality tools
Document Mgt.Functions
Types of Data Management Organizations

36. 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
Regulatory Compliance examples
Document Mgt.Functions
Data Quality Dimensions
Data Model/Design quality management

37. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Data Management Synonyms
Data Warehouse primary components
Master Data
Data Model/Design quality management

38. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data Model/Design quality management
Types of Data Management Organizations
Data governance programScope elements
Enterprise Data Warehouse

39. Customer - CRM Employee/workforce - HRM
Party master data
Non-strategic goals of data management
Guiding Principles of data management
Inmon ODS - DW - DM distinction

40. Done by DBA - collab with DA.
Detailed Data Design
Data Warehouse primary components
Data Strategy Deliverables
Enterprise Data Warehouse

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)
Taxonomies - 4 types
Detailed Data Design
Data Model/Design quality management
Data Management

42. 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
AAAA
Metadata for unstructured data types
Data Model/Design quality management
Data Management functions breakdown into

43. Appointed trustees for data assets
Data Stewards
Location master data
Data Quality Dimensions
Business Intelligence

44. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Data Management Services(GAR MQD IP)
The PE - PPP - ACPDEV - DIA Data Management Acronym
Drivers for Reference and Master Data Management
Data security guiding principles

45. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Data Stewards
Affiliation Relationship
Document Management
Data Development Activities (MDQI)

46. Database Support and Data Technology Management
To share consistent Reference and Master data - orgs need to understand...
DOLAP
Data Ops Mgt has 2 Subfunctions
Data Quality Management Functions

47. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Enterprise Data Warehouse
Data asset valuation
Reference Data - Examples
Goals of DMBOK

48. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Data Implementation
Physical Data Models
Conceptual Data Models
Rules defined by Data Governance (PSP MBN DR )

49. 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
DMBOK Environmental Elements
Kimball DW Approach
Data Quality Management Functions

50. ETL Source to target mappings
Knowledge
Data Integration Services
DMBOK Environmental Elements
Taxonomies - 4 types