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. Discipline that fosters organizational learning and the management of intellectual capital.
Data Strategy
Financial master data
Knowledge management
Data Access Services

2. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data
Content Mgt Functions
Data Stewardship
Data Quality expectations

3. Data stored in Relational DB store
Data Management Functions
Logical Data Model
Reference Data Metadata may include...
ROLAP

4. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Components of Data Strategy (VCP GMO RIRS)
Application DBA
Kimball key components
Physical Data Models

5. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Semantic Modeling
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Implementation
Data governance programScope elements

6. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Application DBA
Examples of individual roles participating in Data Mgt
Asset
Information

7. DMS - Development - Maintenance - Support of structured data
Conceptual Data Models
Data Operations Mgt
Content Mgt Functions
Data Governance (EAC DMA)

8. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Causes for Performance problems
Document Mgt.Functions
Procedural DBA
Data Quality Management Functions

9. Short statements of Management Intent and fundamental Rules governing creation - acquisition - integrity - security - quality - and use of data and information. Describe WHATs - and What NOTs; do not describe HOWs.
Data Policies
Data governance programScope elements
Physical Data Models
Affiliation Relationship

10. DM Program Charter - SCOPE statement - Implementation Roadmap
Non-strategic goals of data management
Data Implementation
Data Strategy Deliverables
Data Management

11. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Kimball key components
Logical Data Model
Enterprise Data Warehouse
Master Data

12. Query - analysis and reporting off of the DW.
Data Management functions breakdown into
Semantic Modeling
Document vs. Content
Business Intelligence

13. 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.
Components of Data Strategy (VCP GMO RIRS)
Knowledge management
Detailed Data Design
Data Management Services(GAR MQD IP)

14. Virtual OLAP cube available as proprietary function of a classic relational database
Goals of DMBOK
Types of Data Management Organizations
DOLAP
Regulatory Compliance examples

15. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Content Mgt Functions
Data Integration Services
Semantic Modeling
Data Quality Dimensions

16. Database Support and Data Technology Management
Data Governance (EAC DMA)
Inmon ODS - DW - DM distinction
Data Management functions breakdown into
Data Ops Mgt has 2 Subfunctions

17. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Data governance programScope elements
Data Management Synonyms
DMBOK Recurring Themes
Data Stewardship

18. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Guiding Principles of data management
Data Strategy Deliverables
Data Security in an outsourced wolrd
Product master data

19. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Warehouse primary components
Data Access Services
Reference Data - Examples
Data Strategy Deliverables

20. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Rules defined by Data Governance (PSP MBN DR )
Data Management Services(GAR MQD IP)
Data Lifecycle complete
The PE - PPP - ACPDEV - DIA Data Management Acronym

21. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Examples of individual roles participating in Data Mgt
Taxonomies - 4 types
Non-strategic goals of data management
Components of Data Strategy (VCP GMO RIRS)

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
Data Implementation
Data Stewards
Regulatory Compliance examples
Data Quality expectations

23. Any file or record
Document
Rules defined by Data Governance (PSP MBN DR )
Kimball key components
Data Quality expectations

24. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Kimball key components
Location master data
Logical Data Model
Affiliation Relationship

25. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Master Data
Common Activity Groups for DM Functions (PDCO)
MOLAP
Semantic Modeling

26. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Management
Location master data
Party master data
The PE - PPP - ACPDEV - DIA Data Management Acronym

27. Data specifically constructed for query and analysis
Kimball DW Approach
Data Management functions breakdown into
Data governance programScope elements
Logical Data Model

28. High level perspective on a subject area of importance to the business.
Conceptual Data Models
Detailed Data Design
Metadata for unstructured data types
Data Quality Management lifecycle

29. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Reference Data Metadata may include...
Data Development Activities (MDQI)
Location master data
Data Governance Deliverables (PPS IP SQV)

30. State names - codes - MedDRA code - WHO Drug Code
Metadata Architecture types
Guiding Principles of data management
Reference Data - Examples
Data Strategy

31. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Data governance programScope elements
Causes for Performance problems
Location master data
Physical Data Models

32. Data stored in combination of ROLAP and MOLAP
Data Implementation
HOLAP
Rules defined by Data Governance (PSP MBN DR )
Non-strategic goals of data management

33. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Affiliation Relationship
Metadata Management Functions
Application DBA
Inmon DW Approach

34. Activities and Activity Groups
Application DBA
Common Activity Groups for DM Functions (PDCO)
Data Management functions breakdown into
Data Strategy

35. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Strategic goals of data management
Data Management
Data Quality Management Functions
Hierarchical Relationships

36. Appointed trustees for data assets
Data Strategy Deliverables
Data Governance (EAC DMA)
Data Stewards
Data governance like real Government

37. 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.
Rules defined by Data Governance (PSP MBN DR )
Data Integration Services
Product master data
Master Data Management

38. (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
Data Management Synonyms
Ten Functions of Data Management
Regulatory Compliance examples
Data Management Functions

39. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Data Strategy Deliverables
Metadata Management Functions
Data governance like real Government
Hierarchical Relationships

40. 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
DOLAP
Data Management Functions
AAAA
Common Activity Groups for DM Functions (PDCO)

41. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Affiliation Relationship
HOLAP
Data security guiding principles
Data Implementation

42. 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 Integration Services
Inmon ODS - DW - DM distinction
Procedural DBA
Data Model/Design quality management

43. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
DOLAP
Product master data
Document vs. Content
Hierarchical Relationships

44. 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 Management
Ten Functions of Data Management
Drivers for Reference and Master Data Management

45. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
AAAA
Data governance programScope elements
Data Quality tools
Document vs. Content

46. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Content Management
DOLAP
Data Management Services(GAR MQD IP)
Data governance programScope elements

47. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Data Strategy Deliverables
Types of Metadata
Metadata for unstructured data types
Knowledge

48. Control over defined domain values - i.e. Vocabularies.
Data Management Synonyms
Information
Ontology
Reference Data Management

49. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Data Access Services
Data Policies
Data Quality Dimensions
Causes for Performance problems

50. Customer - CRM Employee/workforce - HRM
Regulatory Compliance examples
Party master data
Master Data
Ontology