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. 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)
Master Data
Data Development Activities (MDQI)
Common Activity Groups for DM Functions (PDCO)
Logical Data Model

2. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Lifecycle complete
Data Quality tools
Inmon ODS - DW - DM distinction
Data Operations Mgt

3. Expert technical custodians of data assets
Master Data
Data Management Professionals role
Inmon ODS - DW - DM distinction
Location master data

4. State names - codes - MedDRA code - WHO Drug Code
To share consistent Reference and Master data - orgs need to understand...
Reference Data - Examples
Procedural DBA
Affiliation Relationship

5. 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
DMBOK Environmental Elements
Data security guiding principles
Ontology
Logical Data Model

6. DMS - Development - Maintenance - Support of structured data
Content Mgt Functions
Data Operations Mgt
Master Data
Party master data

7. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Data Lifecycle complete
Kimball key components
Hierarchical Relationships
Data Implementation

8. 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
AAAA
Inmon DW Approach
Physical Data Models
Inmon ODS - DW - DM distinction

9. SOA - ETL - Replication - Message Brokers
Data Access Services
Inmon ODS - DW - DM distinction
Types of Metadata
Data Lifecycle complete

10. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Information
Data Ops Mgt has 2 Subfunctions
Financial master data
Data Strategy

11. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Reference Data - Examples
Location master data
Data Strategy
Data Warehouse primary components

12. Data specifically constructed for query and analysis
Financial master data
ROLAP
Data Policies
Kimball DW Approach

13. Modeling and design standards
Affiliation Relationship
Data Model/Design quality management
DMBOK Environmental Elements
Data Quality expectations

14. 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.
Party master data
Data Implementation
Non-strategic goals of data management
Ontology

15. Data stored in Relational DB store
Document Mgt.Functions
Data Operations Mgt
DOLAP
ROLAP

16. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
DMBOK Environmental Elements
Inmon DW Approach
Document vs. Content
Data Operations Mgt

17. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Types of Metadata
Examples of individual roles participating in Data Mgt
Procedural DBA
Data Implementation

18. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Data Governance Deliverables (PPS IP SQV)
Semantic Modeling
Data Access Services
Data Operations Mgt

19. DM Program Charter - SCOPE statement - Implementation Roadmap
Document vs. Content
Metadata for unstructured data types
Data Strategy Deliverables
HOLAP

20. 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)
Asset
Taxonomies - 4 types
Strategic goals of data management
Data Strategy

21. Establishment and maintenance of Relationships between master data records.
Data Management Functions
Affiliation Relationship
DMBOK Recurring Themes
Metadata Architecture types

22. Done by DBA - collab with DA.
Data Stewardship
Kimball key components
Data Lifecycle complete
Detailed Data Design

23. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Management
Knowledge
Data Lifecycle complete
Data asset valuation

24. Customer - CRM Employee/workforce - HRM
Knowledge
Data Lifecycle complete
Causes for Performance problems
Party master data

25. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data Security in an outsourced wolrd
Data governance programScope elements
Guiding Principles of data management
Data

26. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
DMBOK Recurring Themes
Data Quality Management lifecycle
Financial master data
Content Mgt Functions

27. 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?
Types of Metadata
To share consistent Reference and Master data - orgs need to understand...
Data Strategy
Enterprise Data Warehouse

28. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Data asset valuation
Data
Data Lifecycle complete

29. Data stored in combination of ROLAP and MOLAP
Ten Functions of Data Management
Data Management Synonyms
Data Governance Deliverables (PPS IP SQV)
HOLAP

30. Virtual OLAP cube available as proprietary function of a classic relational database
Knowledge management
Taxonomies - 4 types
Data Access Services
DOLAP

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

32. ETL Source to target mappings
Data Integration Services
Data Management
Data Operations Mgt
Reference Data Metadata may include...

33. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data Development Activities (MDQI)
ROLAP
AAAA
Data Stewardship

34. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Data governance programScope elements
Data Management Synonyms
ROLAP
Affiliation Relationship

35. The Exercise of Authority and Control over the Management of Data Assets.
Data Governance (EAC DMA)
Knowledge
To share consistent Reference and Master data - orgs need to understand...
Reference Data Management

36. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Data governance programScope elements
Examples of individual roles participating in Data Mgt
Data Management functions breakdown into
Rules defined by Data Governance (PSP MBN DR )

37. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
ROLAP
Procedural DBA
The PE - PPP - ACPDEV - DIA Data Management Acronym
Hierarchical Relationships

38. Stored in multidimensional data store
Data Lifecycle complete
Kimball DW Approach
Data Management functions breakdown into
MOLAP

39. 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 Security in an outsourced wolrd
Rules defined by Data Governance (PSP MBN DR )
AAAA

40. 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
Types of Data Management Organizations
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality Management Functions
Master Data

41. 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 Quality Management lifecycle
Enterprise Data Warehouse
Metadata for unstructured data types
Knowledge management

42. Control over defined domain values - i.e. Vocabularies.
Data Quality Management lifecycle
Ten Functions of Data Management
Reference Data Management
Logical Data Model

43. Created/acquired - stored - used - destroyed.
Taxonomies - 4 types
Common Activity Groups for DM Functions (PDCO)
Data Lifecycle Simple
Document Management

44. 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
Kimball key components
Data Quality Dimensions
Conceptual Data Models
Product master data

45. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Data Management Services(GAR MQD IP)
Strategic goals of data management
Content Management
Inmon ODS - DW - DM distinction

46. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Location master data
Rules defined by Data Governance (PSP MBN DR )
Data Operations Mgt
Data Strategy

47. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Inmon DW Approach
Data Management Services(GAR MQD IP)
Enterprise Data Warehouse
Business Intelligence

48. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Document
DMBOK Environmental Elements
Regulatory Compliance examples
Application DBA

49. ERP
Document Management
Financial master data
Causes for Performance problems
Data Strategy

50. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Master Data Management
Document Management
Types of Data Management Organizations
Ontology