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. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data Quality Management Functions
Data governance like real Government
Data
Rules defined by Data Governance (PSP MBN DR )

2. ETL Source to target mappings
Data Management Professionals role
Data Policies
Taxonomies - 4 types
Data Integration Services

3. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Document vs. Content
Metadata Architecture types
Data Quality tools
Asset

4. Modeling and design standards
Hierarchical Relationships
Data Management Shared responsibility
Data Model/Design quality management
Data Integration Services

5. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Metadata Management Functions
Physical Data Models
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Development Activities (MDQI)

6. 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.
Rules defined by Data Governance (PSP MBN DR )
DM Function Context Diagram overview (DG - ISP - T - DCM)
Drivers for Reference and Master Data Management
Components of Data Strategy (VCP GMO RIRS)

7. Done by DBA - collab with DA.
Reference and Master Data Management
Document Management
Detailed Data Design
The PE - PPP - ACPDEV - DIA Data Management Acronym

8. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Document Management
Kimball key components
The PE - PPP - ACPDEV - DIA Data Management Acronym
Enterprise Data Warehouse

9. High level perspective on a subject area of importance to the business.
Conceptual Data Models
Financial master data
Data Management
Content Management

10. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Data Ops Mgt has 2 Subfunctions
Causes for Performance problems
Data Access Services
Information

11. Any file or record
Data Governance Deliverables (PPS IP SQV)
Application DBA
AAAA
Document

12. Establishment and maintenance of Relationships between master data records.
Guiding Principles of data management
Data Management Functions
Affiliation Relationship
Ontology

13. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Reference Data Metadata may include...
Data Governance Deliverables (PPS IP SQV)
Information
Data

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
Guiding Principles of data management
Semantic Modeling
Data Security Management (PDE PP AAAA)
Procedural DBA

15. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Application DBA
Regulatory Compliance examples
Data Security Management (PDE PP AAAA)
Data Policies

16. TMAC Taxonomy - Metadata - Access - Quality
Inmon ODS - DW - DM distinction
Content Mgt Functions
Data Strategy Deliverables
Data Stewards

17. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
DMBOK Environmental Elements
Data Governance (EAC DMA)
Content Mgt Functions
Location master data

18. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data Strategy
The PE - PPP - ACPDEV - DIA Data Management Acronym
Physical Data Models
Party master data

19. Data stored in combination of ROLAP and MOLAP
Hierarchical Relationships
Data Quality expectations
HOLAP
Inmon DW Approach

20. 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
Document Management
Affiliation Relationship
Data governance programScope elements

21. 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
Product master data
Document vs. Content
Ontology

22. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Master Data
Location master data
Data Lifecycle complete
Data Management Professionals role

23. Query - analysis and reporting off of the DW.
Metadata for unstructured data types
Financial master data
Business Intelligence
Party master data

24. DM Program Charter - SCOPE statement - Implementation Roadmap
Data
Data Stewardship
Data Strategy Deliverables
Master Data Management

25. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Data Management Functions
Causes for Performance problems
Data Warehouse primary components
Types of Metadata

26. 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
Guiding Principles of data management
Data
Data Quality Dimensions
Components of Data Strategy (VCP GMO RIRS)

27. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Data Operations Mgt
DMBOK Environmental Elements
DOLAP
Inmon DW Approach

28. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Inmon ODS - DW - DM distinction
Master Data
Content Management
Data Management functions breakdown into

29. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Information
Metadata Architecture types
Data Warehouse primary components
Product master data

30. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
To share consistent Reference and Master data - orgs need to understand...
Document
Logical Data Model
Data Lifecycle complete

31. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Ontology
Detailed Data Design
Knowledge

32. Type of model that represents a set of concepts and their relationships within a domain.
Location master data
Ontology
Document
DM Function Context Diagram overview (DG - ISP - T - DCM)

33. Shared between Data Management Professionals in IT - and Business Data Stewards.
Knowledge management
Data governance programScope elements
Regulatory Compliance examples
Data Management Shared responsibility

34. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Conceptual Data Models
DOLAP
Document vs. Content
ROLAP

35. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Document Mgt.Functions
Content Management
Components of Data Strategy (VCP GMO RIRS)
Data Quality Management Functions

36. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Asset
DMBOK Environmental Elements
Knowledge management
Data Management Services(GAR MQD IP)

37. 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
DM Function Context Diagram overview (DG - ISP - T - DCM)
Inmon ODS - DW - DM distinction
Enterprise Data Warehouse
Data Management functions breakdown into

38. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data Quality Dimensions
Taxonomies - 4 types
Data Stewardship
Strategic goals of data management

39. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Data Quality expectations
Document
Data Access Services
Examples of individual roles participating in Data Mgt

40. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Ontology
Procedural DBA
Data Management Synonyms
Data Management Functions

41. (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
Application DBA
Ten Functions of Data Management
Metadata for unstructured data types
Data Management Services(GAR MQD IP)

42. A high-level course of action to achieve data goals. Usually a data management program strategy.
Data Security Management (PDE PP AAAA)
Product master data
Strategic goals of data management
Data Strategy

43. 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 Security in an outsourced wolrd
Data Management Shared responsibility
Non-strategic goals of data management
Metadata Architecture types

44. Activities and Activity Groups
Data Management functions breakdown into
Common Activity Groups for DM Functions (PDCO)
Metadata Management Functions
Metadata Architecture types

45. Data stored in Relational DB store
Kimball DW Approach
ROLAP
Data Access Services
Document

46. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Data asset valuation
Data governance like real Government
Data Lifecycle complete
Document Mgt.Functions

47. 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?
Guiding Principles of data management
Data Management Synonyms
To share consistent Reference and Master data - orgs need to understand...
DMBOK Environmental Elements

48. Created/acquired - stored - used - destroyed.
Asset
Information
Master Data Management
Data Lifecycle Simple

49. 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
HOLAP
Application DBA
Document Mgt.Functions
Data Quality Management lifecycle

50. Ongoing Reconciliation and Maintenance of reference and master data.
Data
Reference and Master Data Management
Data Quality expectations
Data Ops Mgt has 2 Subfunctions