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. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Detailed Data Design
Data Access Services
Kimball key components

2. 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
Data Management Services(GAR MQD IP)
Types of Metadata
Data Governance Deliverables (PPS IP SQV)
Semantic Modeling

3. 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
Application DBA
Data Management Shared responsibility
Data Quality Management lifecycle
Knowledge management

4. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Kimball key components
Data governance like real Government
Logical Data Model
Data Stewards

5. Stored in multidimensional data store
Data Policies
Guiding Principles of data management
MOLAP
Data Strategy

6. 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
Party master data
Data Quality Management lifecycle
Regulatory Compliance examples
Data Governance Deliverables (PPS IP SQV)

7. Activities and Activity Groups
Ontology
Data Management functions breakdown into
Master Data
Data Quality tools

8. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Taxonomies - 4 types
Party master data
Examples of individual roles participating in Data Mgt
Data Ops Mgt - Guiding Principles

9. Any file or record
Document
Data Quality Management Functions
Document Management
Causes for Performance problems

10. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
Data Lifecycle complete
Types of Data Management Organizations
Data Security Management (PDE PP AAAA)
Information

11. A high-level course of action to achieve data goals. Usually a data management program strategy.
Financial master data
Data Management
Data Strategy
AAAA

12. Done by DBA - collab with DA.
Detailed Data Design
Types of Metadata
Data Quality Management lifecycle
Data governance like real Government

13. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Data Management Professionals role
Data Integration Services
DMBOK Environmental Elements
Enterprise Data Warehouse

14. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Data governance like real Government
DOLAP
Hierarchical Relationships
Data Management Functions

15. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Logical Data Model
Inmon ODS - DW - DM distinction
Data Quality expectations
Business Intelligence

16. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Management
Kimball DW Approach
Data Strategy Deliverables
Detailed Data Design

17. DMS - Development - Maintenance - Support of structured data
Knowledge
Data Operations Mgt
Strategic goals of data management
Knowledge management

18. ERP
Data Integration Services
Financial master data
Types of Metadata
Knowledge

19. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
AAAA
Data governance like real Government
Data Lifecycle Simple
Data Management Professionals role

20. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Data Security Management (PDE PP AAAA)
Application DBA
Data Model/Design quality management
Business Intelligence

21. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Kimball key components
Data Management Functions
Data Management
Data Security in an outsourced wolrd

22. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
ROLAP
Location master data
Document vs. Content
Data Security in an outsourced wolrd

23. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Data Quality Dimensions
Data Management Shared responsibility
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Development Activities (MDQI)

24. 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
Business Intelligence
Conceptual Data Models
Data Strategy Deliverables
Data Quality Dimensions

25. Discipline that fosters organizational learning and the management of intellectual capital.
Data Strategy
Kimball DW Approach
Knowledge management
The PE - PPP - ACPDEV - DIA Data Management Acronym

26. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data Ops Mgt has 2 Subfunctions
Physical Data Models
Data Quality tools
DMBOK Recurring Themes

27. 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
Product master data
Knowledge management
Data Management Services(GAR MQD IP)

28. Appointed trustees for data assets
Common Activity Groups for DM Functions (PDCO)
Data Management Synonyms
Document
Data Stewards

29. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Data Security Management (PDE PP AAAA)
Taxonomies - 4 types
Data Management Synonyms
To share consistent Reference and Master data - orgs need to understand...

30. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Document vs. Content
Logical Data Model
Goals of DMBOK
Data asset valuation

31. High level perspective on a subject area of importance to the business.
Conceptual Data Models
Document
Data Ops Mgt has 2 Subfunctions
Components of Data Strategy (VCP GMO RIRS)

32. 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
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data security guiding principles
Data Strategy Deliverables
Common Activity Groups for DM Functions (PDCO)

33. Ongoing Reconciliation and Maintenance of reference and master data.
Reference and Master Data Management
Physical Data Models
Metadata Architecture types
Data Operations Mgt

34. Data specifically constructed for query and analysis
Data Implementation
Application DBA
Data Management Shared responsibility
Kimball DW Approach

35. 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
Application DBA
Data Management Professionals role
AAAA

36. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Hierarchical Relationships
Inmon DW Approach
Types of Metadata
Asset

37. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
Enterprise Data Warehouse
DMBOK Environmental Elements
Data Integration Services
Reference Data - Examples

38. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Reference and Master Data Management
Data Ops Mgt has 2 Subfunctions
Data Management Functions
Rules defined by Data Governance (PSP MBN DR )

39. 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.
DM Function Context Diagram overview (DG - ISP - T - DCM)
Non-strategic goals of data management
Logical Data Model
Data Development Activities (MDQI)

40. ETL Source to target mappings
Data Integration Services
Goals of DMBOK
Types of Data Management Organizations
Application DBA

41. 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
Kimball key components
DM Function Context Diagram overview (DG - ISP - T - DCM)
Goals of DMBOK
Data Management Functions

42. 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
Data Implementation
Data Ops Mgt - Guiding Principles
Strategic goals of data management
DOLAP

43. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Reference Data - Examples
Data Management Services(GAR MQD IP)
Metadata Architecture types
Examples of individual roles participating in Data Mgt

44. Virtual OLAP cube available as proprietary function of a classic relational database
Causes for Performance problems
DOLAP
Regulatory Compliance examples
Detailed Data Design

45. 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?
To share consistent Reference and Master data - orgs need to understand...
Product master data
Financial master data
Document Management

46. 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
Data Lifecycle Simple
Inmon ODS - DW - DM distinction
Taxonomies - 4 types
Physical Data Models

47. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data governance programScope elements
Reference Data Metadata may include...
Data Access Services
Data Warehouse primary components

48. Created/acquired - stored - used - destroyed.
Causes for Performance problems
Ontology
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Lifecycle Simple

49. 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)
Rules defined by Data Governance (PSP MBN DR )
Taxonomies - 4 types
Data Quality Management lifecycle
Content Management

50. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Inmon ODS - DW - DM distinction
Data security guiding principles
Examples of individual roles participating in Data Mgt
Information