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. 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 Governance Deliverables (PPS IP SQV)
Kimball DW Approach
Data governance like real Government
Common Activity Groups for DM Functions (PDCO)

2. 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
Reference Data Management
AAAA
Data Lifecycle complete
Party master data

3. ERP
Goals of DMBOK
Kimball key components
Financial master data
Hierarchical Relationships

4. Business function of planning for - controlling - and delivering data and information assets. PDC-A
DMBOK Recurring Themes
Affiliation Relationship
Data Management
Party master data

5. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Reference and Master Data Management
Data Development Activities (MDQI)
Data Ops Mgt has 2 Subfunctions
Data Management Services(GAR MQD IP)

6. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Affiliation Relationship
Master Data Management
Document Mgt.Functions
Data Quality expectations

7. The Exercise of Authority and Control over the Management of Data Assets.
Data asset valuation
Examples of individual roles participating in Data Mgt
Data Governance (EAC DMA)
Guiding Principles of data management

8. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Common Activity Groups for DM Functions (PDCO)
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Management Functions
ROLAP

9. SOA - ETL - Replication - Message Brokers
Detailed Data Design
Reference and Master Data Management
Types of Data Management Organizations
Data Access Services

10. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Kimball key components
Data Management Services(GAR MQD IP)
Asset
Logical Data Model

11. 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 Quality Management lifecycle
Data
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Quality expectations

12. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Asset
Data Implementation
Procedural DBA
Knowledge management

13. Ongoing Reconciliation and Maintenance of reference and master data.
Inmon ODS - DW - DM distinction
Reference and Master Data Management
Hierarchical Relationships
Asset

14. Type of model that represents a set of concepts and their relationships within a domain.
Types of Metadata
Detailed Data Design
Non-strategic goals of data management
Ontology

15. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Quality Dimensions
Data Governance Deliverables (PPS IP SQV)
Affiliation Relationship

16. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Metadata Management Functions
Goals of DMBOK
Kimball key components
Document

17. 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 Ops Mgt - Guiding Principles
Metadata Architecture types
Application DBA
Data Quality Management Functions

18. Created/acquired - stored - used - destroyed.
DOLAP
Data Model/Design quality management
Data Lifecycle Simple
Data governance programScope elements

19. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data Warehouse primary components
Enterprise Data Warehouse
Data
Physical Data Models

20. State names - codes - MedDRA code - WHO Drug Code
Hierarchical Relationships
Reference Data Metadata may include...
Data Security in an outsourced wolrd
Reference Data - Examples

21. 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
Types of Metadata
Master Data
Ontology
Inmon DW Approach

22. 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
Knowledge management
Metadata Architecture types
Regulatory Compliance examples
Data Stewards

23. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Logical Data Model
Data Strategy Deliverables
Data Quality Dimensions
Metadata Management Functions

24. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Content Mgt Functions
Data Governance Deliverables (PPS IP SQV)
AAAA
Data Management Synonyms

25. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Data Implementation
Goals of DMBOK
Document
Data Ops Mgt - Guiding Principles

26. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Data Quality expectations
Reference Data Metadata may include...
Location master data
Hierarchical Relationships

27. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Metadata for unstructured data types
Data Quality Management Functions
Data Ops Mgt - Guiding Principles
Inmon ODS - DW - DM distinction

28. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Affiliation Relationship
Causes for Performance problems
Ontology
Document vs. Content

29. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Reference Data - Examples
Document
Application DBA
Data security guiding principles

30. 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
Taxonomies - 4 types
Types of Metadata
Inmon ODS - DW - DM distinction
Document Mgt.Functions

31. 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)
Information
The PE - PPP - ACPDEV - DIA Data Management Acronym
Metadata Management Functions

32. Appointed trustees for data assets
Data Stewards
Data Management
Information
Metadata Architecture types

33. Any file or record
Regulatory Compliance examples
Kimball DW Approach
Document
Data Quality expectations

34. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Guiding Principles of data management
Data Integration Services
Master Data
Kimball key components

35. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Semantic Modeling
Data Operations Mgt
Data Security Management (PDE PP AAAA)
Data Lifecycle complete

36. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Data governance like real Government
Location master data
Metadata for unstructured data types
Inmon ODS - DW - DM distinction

37. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data Governance (EAC DMA)
Data
Data governance like real Government
Data Management

38. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Document Management
Rules defined by Data Governance (PSP MBN DR )
Semantic Modeling
Data governance like real Government

39. Establishment and maintenance of Relationships between master data records.
Affiliation Relationship
Data Quality Management Functions
Types of Data Management Organizations
Metadata for unstructured data types

40. 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)
Data Management Functions
Party master data
Data Development Activities (MDQI)
Metadata for unstructured data types

41. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Data Governance Deliverables (PPS IP SQV)
Logical Data Model
DMBOK Environmental Elements
Document Management

42. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Logical Data Model
Hierarchical Relationships
Causes for Performance problems
Goals of DMBOK

43. ETL Source to target mappings
Data Lifecycle complete
Data Management Services(GAR MQD IP)
Strategic goals of data management
Data Integration Services

44. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Data Quality expectations
Reference and Master Data Management
Data Security Management (PDE PP AAAA)
Data Management Synonyms

45. 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
Inmon ODS - DW - DM distinction
Data Quality Dimensions
Data Ops Mgt - Guiding Principles
Strategic goals of data management

46. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Types of Data Management Organizations
Metadata Management Functions
Data Integration Services
Kimball DW Approach

47. Expert technical custodians of data assets
Data Security Management (PDE PP AAAA)
Metadata Management Functions
Reference and Master Data Management
Data Management Professionals role

48. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Data Lifecycle complete
Enterprise Data Warehouse
HOLAP
Business Intelligence

49. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Document vs. Content
Data Warehouse primary components
Data Management
Goals of DMBOK

50. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
HOLAP
Knowledge
Common Activity Groups for DM Functions (PDCO)
Data Management