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. Done by DBA - collab with DA.
Detailed Data Design
Conceptual Data Models
Product master data
Physical Data Models

2. 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
Data Integration Services
Enterprise Data Warehouse
Data Management Functions

3. 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
Reference and Master Data Management
Ontology
Inmon ODS - DW - DM distinction
Kimball key components

4. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Location master data
DMBOK Recurring Themes
Data Quality Management Functions
Data Management Functions

5. Modeling and design standards
Data governance programScope elements
Data security guiding principles
Data Model/Design quality management
Data Management Synonyms

6. Data stored in combination of ROLAP and MOLAP
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality tools
DMBOK Recurring Themes
HOLAP

7. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
HOLAP
DMBOK Recurring Themes
Data Quality Management Functions
Physical Data Models

8. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Procedural DBA
Guiding Principles of data management
Data Development Activities (MDQI)

9. 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)
Metadata for unstructured data types
Data Strategy Deliverables
Data Access Services
Non-strategic goals of data management

10. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data Governance (EAC DMA)
Content Management
Data governance programScope elements
Data Security in an outsourced wolrd

11. Establishment and maintenance of Relationships between master data records.
Affiliation Relationship
Data Management
Common Activity Groups for DM Functions (PDCO)
Data Management Functions

12. 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.
Data Lifecycle Simple
Metadata Management Functions
Kimball key components
Master Data Management

13. Appointed trustees for data assets
Data Stewards
DMBOK Recurring Themes
AAAA
Data Quality tools

14. Formal accountability for business responsibilities ensuring effective control and use of data assets.
To share consistent Reference and Master data - orgs need to understand...
Data Management Professionals role
Data Stewardship
Ontology

15. 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
Procedural DBA
Reference Data Management
Information
DM Function Context Diagram overview (DG - ISP - T - DCM)

16. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Data governance programScope elements
Knowledge
Data Quality Dimensions
AAAA

17. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Logical Data Model
Data governance like real Government
Data Implementation
Financial master data

18. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
MOLAP
Data Security Management (PDE PP AAAA)
Asset
Data Management Professionals role

19. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Physical Data Models
Data Governance (EAC DMA)
Master Data Management
Data Management Shared responsibility

20. 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.
Content Mgt Functions
Hierarchical Relationships
Product master data
Components of Data Strategy (VCP GMO RIRS)

21. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Document Management
Hierarchical Relationships
Information
Reference and Master Data Management

22. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Application DBA
Guiding Principles of data management
Regulatory Compliance examples
Reference Data - Examples

23. Discipline that fosters organizational learning and the management of intellectual capital.
Non-strategic goals of data management
Data Stewardship
Knowledge management
Types of Data Management Organizations

24. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Document vs. Content
Drivers for Reference and Master Data Management
Business Intelligence
DMBOK Recurring Themes

25. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Ten Functions of Data Management
DOLAP
Types of Data Management Organizations
Metadata Management Functions

26. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
Goals of DMBOK
Conceptual Data Models
Master Data Management
DMBOK Environmental Elements

27. 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)
Metadata Architecture types
Kimball DW Approach
Causes for Performance problems

28. Control over defined domain values - i.e. Vocabularies.
Application DBA
Reference Data Management
Master Data
Location master data

29. Data specifically constructed for query and analysis
Kimball DW Approach
Asset
Data Management Synonyms
Data Integration Services

30. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Data Integration Services
Kimball key components
Data Quality Dimensions
Location master data

31. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Master Data Management
Types of Metadata
Document Mgt.Functions
Data Lifecycle complete

32. 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 Quality tools
Data Management Functions
Data Policies
Data Management

33. 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 Access Services
Master Data
Regulatory Compliance examples
Conceptual Data Models

34. 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 Policies
AAAA
Reference and Master Data Management

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
Data Management Shared responsibility
Master Data
Common Activity Groups for DM Functions (PDCO)
Inmon DW Approach

36. 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
HOLAP
Strategic goals of data management
Asset
Data Warehouse primary components

37. TMAC Taxonomy - Metadata - Access - Quality
Data Management Shared responsibility
Data Stewardship
Data asset valuation
Content Mgt Functions

38. 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
Metadata Architecture types
Data Policies
Master Data Management
Non-strategic goals of data management

39. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Data Implementation
Master Data
Data Integration Services
Content Management

40. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
DMBOK Environmental Elements
Data Warehouse primary components
Common Activity Groups for DM Functions (PDCO)
AAAA

41. Responsible Trustee of data - Understand and Comply with Regulations- Define data security Reqts Collaboratively - ID detailed application security reqts in each app dev project - Every user acct. has password - Use Role Groups- Formally track/approv
Data Management Services(GAR MQD IP)
Data security guiding principles
MOLAP
Data Quality Dimensions

42. State names - codes - MedDRA code - WHO Drug Code
Data Strategy
Conceptual Data Models
Reference Data - Examples
DMBOK Environmental Elements

43. Shared between Data Management Professionals in IT - and Business Data Stewards.
Inmon ODS - DW - DM distinction
Data Management Shared responsibility
Logical Data Model
Data Strategy

44. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Conceptual Data Models
Inmon DW Approach
Data Management Functions
Data Governance (EAC DMA)

45. Activities and Activity Groups
Reference Data Management
Data governance programScope elements
Data Management functions breakdown into
Data governance like real Government

46. 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 security guiding principles
Business Intelligence
Data Quality Management lifecycle
Data Development Activities (MDQI)

47. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Inmon ODS - DW - DM distinction
Rules defined by Data Governance (PSP MBN DR )
Types of Metadata
Master Data

48. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Document Management
Data Ops Mgt - Guiding Principles
Ten Functions of Data Management
Data Management Synonyms

49. Business function of planning for - controlling - and delivering data and information assets. PDC-A
To share consistent Reference and Master data - orgs need to understand...
Common Activity Groups for DM Functions (PDCO)
Data Ops Mgt - Guiding Principles
Data Management

50. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Strategy Deliverables
Content Mgt Functions
Data Implementation
Data Ops Mgt - Guiding Principles