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. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Data asset valuation
Information
Data Policies
DM Function Context Diagram overview (DG - ISP - T - DCM)

2. 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
Data Governance Deliverables (PPS IP SQV)
Data Quality Management Functions
Metadata Architecture types
Data governance like real Government

3. Data stored in Relational DB store
Ontology
Data Ops Mgt - Guiding Principles
ROLAP
Product master data

4. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Data Operations Mgt
Content Management
Metadata for unstructured data types
Location master data

5. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
AAAA
Data Quality Management Functions
Reference Data Metadata may include...
Causes for Performance problems

6. 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?
Data asset valuation
To share consistent Reference and Master data - orgs need to understand...
Data governance programScope elements
Data Governance (EAC DMA)

7. ETL Source to target mappings
Product master data
Data Integration Services
Ten Functions of Data Management
Data Operations Mgt

8. Shared between Data Management Professionals in IT - and Business Data Stewards.
Data Management Shared responsibility
Data Security Management (PDE PP AAAA)
ROLAP
HOLAP

9. 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
Reference Data Metadata may include...
Data Management functions breakdown into
Data asset valuation
Common Activity Groups for DM Functions (PDCO)

10. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Data Security in an outsourced wolrd
Data Integration Services
ROLAP
Document Management

11. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Conceptual Data Models
Data Management Synonyms
Logical Data Model
Physical Data Models

12. Appointed trustees for data assets
Data Stewards
Data Governance (EAC DMA)
Data Warehouse primary components
Non-strategic goals of data management

13. Establishment and maintenance of Relationships between master data records.
Data security guiding principles
Affiliation Relationship
Drivers for Reference and Master Data Management
Content Mgt Functions

14. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Security in an outsourced wolrd
Data governance programScope elements
Data Management
Affiliation Relationship

15. Activities and Activity Groups
Application DBA
Data Quality Dimensions
Data Management functions breakdown into
Data Security Management (PDE PP AAAA)

16. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Content Management
Procedural DBA
Data Management functions breakdown into
Strategic goals of data management

17. 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
Affiliation Relationship
Common Activity Groups for DM Functions (PDCO)
Data Integration Services
Types of Metadata

18. 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 Development Activities (MDQI)
Application DBA
Data Security Management (PDE PP AAAA)
Data Quality Management lifecycle

19. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Reference Data Metadata may include...
Logical Data Model
Data Security in an outsourced wolrd
Data Access Services

20. DM Program Charter - SCOPE statement - Implementation Roadmap
Inmon DW Approach
Data Strategy Deliverables
DOLAP
Data asset valuation

21. SOA - ETL - Replication - Message Brokers
Data governance programScope elements
Data Access Services
Ten Functions of Data Management
Data Quality tools

22. 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
Product master data
Taxonomies - 4 types
Knowledge

23. Database Support and Data Technology Management
Data Ops Mgt has 2 Subfunctions
Data governance programScope elements
Data governance like real Government
Data Management Professionals role

24. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Kimball key components
Data Quality Management Functions
Data Ops Mgt - Guiding Principles
Data Management Functions

25. 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
Content Management
Reference and Master Data Management
Regulatory Compliance examples
DMBOK Recurring Themes

26. 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
DOLAP
Application DBA
Inmon ODS - DW - DM distinction
Master Data Management

27. 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.
Master Data Management
Document Mgt.Functions
Master Data
Product master data

28. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Common Activity Groups for DM Functions (PDCO)
Document vs. Content
Data Policies
ROLAP

29. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data Management Shared responsibility
Data Stewardship
Logical Data Model
Data Stewards

30. 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 security guiding principles
Data Governance (EAC DMA)
Rules defined by Data Governance (PSP MBN DR )
Reference and Master Data Management

31. Expert technical custodians of data assets
Data Management Professionals role
To share consistent Reference and Master data - orgs need to understand...
Data Management Services(GAR MQD IP)
Data Stewardship

32. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Reference and Master Data Management
Data
Metadata Architecture types
Data Integration Services

33. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Goals of DMBOK
Content Mgt Functions
Inmon DW Approach
Content Management

34. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Inmon DW Approach
Document Mgt.Functions
Physical Data Models
Data Quality Management lifecycle

35. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Data Management Professionals role
Strategic goals of data management
Data

36. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Reference and Master Data Management
Logical Data Model
Content Mgt Functions
Data governance programScope elements

37. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Semantic Modeling
Data Ops Mgt has 2 Subfunctions
Data Quality expectations
Data Quality tools

38. 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
Knowledge
Strategic goals of data management
Data Security in an outsourced wolrd
Data Quality Management Functions

39. Created/acquired - stored - used - destroyed.
Master Data
Document Management
Non-strategic goals of data management
Data Lifecycle Simple

40. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Semantic Modeling
Kimball key components
Data Quality expectations
Reference Data Management

41. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
DOLAP
Application DBA
Document vs. Content
Regulatory Compliance examples

42. 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.
ROLAP
Location master data
Rules defined by Data Governance (PSP MBN DR )
Components of Data Strategy (VCP GMO RIRS)

43. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Document Management
MOLAP
Data Security in an outsourced wolrd
Non-strategic goals of data management

44. 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
Data Management functions breakdown into
DMBOK Environmental Elements
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Warehouse primary components

45. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Data Policies
Logical Data Model
Asset
Data Implementation

46. Data specifically constructed for query and analysis
Data Model/Design quality management
Kimball DW Approach
Kimball key components
Metadata Architecture types

47. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Knowledge
Data Lifecycle Simple
Document vs. Content
Inmon ODS - DW - DM distinction

48. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Conceptual Data Models
Master Data
Data Quality Management Functions
Data Management functions breakdown into

49. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Policies
Data Security in an outsourced wolrd
Kimball key components
Data Warehouse primary components

50. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
DMBOK Recurring Themes
AAAA
Guiding Principles of data management
ROLAP