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 Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Information
Examples of individual roles participating in Data Mgt
Kimball key components
Physical Data Models

2. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Data Governance Deliverables (PPS IP SQV)
Logical Data Model
Data Security in an outsourced wolrd
Master Data Management

3. 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
Detailed Data Design
Data Stewards
Semantic Modeling

4. Database Support and Data Technology Management
Data Security in an outsourced wolrd
Knowledge
Location master data
Data Ops Mgt has 2 Subfunctions

5. 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.
Data Stewards
Components of Data Strategy (VCP GMO RIRS)
Data Management Shared responsibility
Data security guiding principles

6. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Warehouse primary components
Ten Functions of Data Management
Financial master data
Data Stewards

7. Data specifically constructed for query and analysis
Types of Metadata
Kimball DW Approach
MOLAP
Data Management

8. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Procedural DBA
Inmon DW Approach
Data Management functions breakdown into
To share consistent Reference and Master data - orgs need to understand...

9. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Document Mgt.Functions
Data Quality Dimensions
Information
Data governance programScope elements

10. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data Lifecycle Simple
Reference Data Metadata may include...
Data
Data Integration Services

11. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Data Quality Management Functions
Data Strategy Deliverables
Data Management Services(GAR MQD IP)
Causes for Performance problems

12. 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
Kimball DW Approach
Data governance programScope elements
Document
Strategic goals of data management

13. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Data Management Functions
Data asset valuation
Data Governance Deliverables (PPS IP SQV)
Data Policies

14. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Knowledge
Affiliation Relationship
DMBOK Environmental Elements
Inmon DW Approach

15. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Knowledge
Causes for Performance problems
Application DBA
The PE - PPP - ACPDEV - DIA Data Management Acronym

16. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
DM Function Context Diagram overview (DG - ISP - T - DCM)
Goals of DMBOK
Enterprise Data Warehouse
Data Management Functions

17. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Data governance programScope elements
Data
Data Operations Mgt
Logical Data Model

18. State names - codes - MedDRA code - WHO Drug Code
Reference Data - Examples
DOLAP
Content Mgt Functions
Data Integration Services

19. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Document Management
Data Lifecycle complete
Data Quality Dimensions
Data Strategy

20. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Management Synonyms
Procedural DBA
Drivers for Reference and Master Data Management
Data

21. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Goals of DMBOK
Taxonomies - 4 types
Non-strategic goals of data management
Data Ops Mgt has 2 Subfunctions

22. 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 Development Activities (MDQI)
DOLAP
AAAA

23. 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.
Guiding Principles of data management
Master Data Management
Data governance programScope elements
Common Activity Groups for DM Functions (PDCO)

24. 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)
Asset
Conceptual Data Models
Data Security Management (PDE PP AAAA)
Data Development Activities (MDQI)

25. Data stored in combination of ROLAP and MOLAP
Data Integration Services
HOLAP
Hierarchical Relationships
Procedural DBA

26. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Guiding Principles of data management
Data Management Professionals role
Hierarchical Relationships
Affiliation Relationship

27. Data is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?
DM Function Context Diagram overview (DG - ISP - T - DCM)
Semantic Modeling
Data asset valuation
Data Operations Mgt

28. ERP
Data Model/Design quality management
Financial master data
Data security guiding principles
Ten Functions of Data Management

29. Query - analysis and reporting off of the DW.
Reference and Master Data Management
Financial master data
Taxonomies - 4 types
Business Intelligence

30. Any file or record
Business Intelligence
Document
Semantic Modeling
Data asset valuation

31. 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
AAAA
Data
Data Quality Management lifecycle
Data Security in an outsourced wolrd

32. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Management Professionals role
Data Ops Mgt - Guiding Principles
Data Development Activities (MDQI)
Data security guiding principles

33. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Data Access Services
Data Management Functions
Semantic Modeling
Data Governance (EAC DMA)

34. Shared between Data Management Professionals in IT - and Business Data Stewards.
Data Management Shared responsibility
Kimball DW Approach
Data asset valuation
Ontology

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
Taxonomies - 4 types
Data Governance Deliverables (PPS IP SQV)
Reference Data - Examples
Common Activity Groups for DM Functions (PDCO)

36. 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.
Product master data
MOLAP
Hierarchical Relationships
Regulatory Compliance examples

37. Done by DBA - collab with DA.
Data Management Services(GAR MQD IP)
Data Strategy
Detailed Data Design
Knowledge

38. DMS - Development - Maintenance - Support of structured data
Data Quality Management lifecycle
Data Operations Mgt
Content Mgt Functions
Types of Metadata

39. Activities and Activity Groups
Party master data
Document
Master Data Management
Data Management functions breakdown into

40. 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
Regulatory Compliance examples
Data Governance (EAC DMA)
Data Model/Design quality management
Data Quality Dimensions

41. Data stored in Relational DB store
Master Data
ROLAP
Data Quality expectations
Drivers for Reference and Master Data Management

42. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Rules defined by Data Governance (PSP MBN DR )
Master Data Management
Semantic Modeling
Business Intelligence

43. ETL Source to target mappings
Rules defined by Data Governance (PSP MBN DR )
Data Management Shared responsibility
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Integration Services

44. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Document vs. Content
Data Management Services(GAR MQD IP)
Master Data
Information

45. DM Program Charter - SCOPE statement - Implementation Roadmap
Types of Metadata
Rules defined by Data Governance (PSP MBN DR )
Examples of individual roles participating in Data Mgt
Data Strategy Deliverables

46. 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 Management Synonyms
Metadata Architecture types
Data governance programScope elements
Content Management

47. 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
Data Management Services(GAR MQD IP)
Data Management
Examples of individual roles participating in Data Mgt

48. SOA - ETL - Replication - Message Brokers
Data Access Services
Causes for Performance problems
Reference Data Metadata may include...
Data Management Shared responsibility

49. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Party master data
Data governance programScope elements
Data Quality tools
Content Mgt Functions

50. (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
Ten Functions of Data Management
Data governance programScope elements
Data Quality expectations
Data Management functions breakdown into