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. 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 Shared responsibility
Data Management Services(GAR MQD IP)
Reference and Master Data Management

2. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Goals of DMBOK
Rules defined by Data Governance (PSP MBN DR )
Document

3. A high-level course of action to achieve data goals. Usually a data management program strategy.
Data governance like real Government
Data Strategy
Regulatory Compliance examples
Physical Data Models

4. Data specifically constructed for query and analysis
Data Integration Services
Application DBA
Kimball DW Approach
Causes for Performance problems

5. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Data Management Professionals role
Location master data
Data Governance Deliverables (PPS IP SQV)
Asset

6. State names - codes - MedDRA code - WHO Drug Code
Data Management Functions
Semantic Modeling
Examples of individual roles participating in Data Mgt
Reference Data - Examples

7. Modeling and design standards
Data Stewardship
Data Development Activities (MDQI)
Data Model/Design quality management
Inmon ODS - DW - DM distinction

8. Data stored in combination of ROLAP and MOLAP
HOLAP
Guiding Principles of data management
Ten Functions of Data Management
Non-strategic goals of data management

9. 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 Governance Deliverables (PPS IP SQV)
Strategic goals of data management
Data Lifecycle Simple
Semantic Modeling

10. 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
Procedural DBA
AAAA
Regulatory Compliance examples
Data Management Professionals role

11. Virtual OLAP cube available as proprietary function of a classic relational database
DOLAP
Data Warehouse primary components
Knowledge
Data asset valuation

12. 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
Data security guiding principles
Product master data
Data Management

13. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Data Stewardship
Logical Data Model
Detailed Data Design
Master Data Management

14. Appointed trustees for data assets
Data
Data Development Activities (MDQI)
Party master data
Data Stewards

15. Stored in multidimensional data store
MOLAP
Document vs. Content
Application DBA
Ten Functions of Data Management

16. 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
Data governance like real Government
Taxonomies - 4 types
Data Management functions breakdown into

17. Created/acquired - stored - used - destroyed.
Data Lifecycle Simple
Asset
Data Management Synonyms
Inmon ODS - DW - DM distinction

18. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Data Lifecycle complete
Goals of DMBOK
Document vs. Content
Master Data Management

19. 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
DM Function Context Diagram overview (DG - ISP - T - DCM)
Metadata Architecture types
Business Intelligence
Financial master data

20. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Management Synonyms
Financial master data
Data Warehouse primary components
Data Ops Mgt has 2 Subfunctions

21. Activities and Activity Groups
Drivers for Reference and Master Data Management
Data Management functions breakdown into
Data governance programScope elements
Inmon ODS - DW - DM distinction

22. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Product master data
Types of Metadata
Document Management
Enterprise Data Warehouse

23. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Content Mgt Functions
Data governance programScope elements
DMBOK Recurring Themes
Data Strategy Deliverables

24. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Knowledge
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Management functions breakdown into
Data Governance (EAC DMA)

25. Expert technical custodians of data assets
Data asset valuation
Data security guiding principles
Data Management Professionals role
Knowledge

26. 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
Components of Data Strategy (VCP GMO RIRS)
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality Management lifecycle
Data Quality Management Functions

27. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Data asset valuation
Data Quality tools
Procedural DBA
Asset

28. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Logical Data Model
Reference Data Management
Data Lifecycle Simple
Data Implementation

29. DMS - Development - Maintenance - Support of structured data
Kimball DW Approach
Data Operations Mgt
Data Governance Deliverables (PPS IP SQV)
Data Strategy Deliverables

30. Customer - CRM Employee/workforce - HRM
Reference Data Metadata may include...
Data Stewards
Party master data
HOLAP

31. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Semantic Modeling
Types of Metadata
Content Management
Data Policies

32. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Inmon DW Approach
Kimball key components
ROLAP
DOLAP

33. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
Data Policies
DMBOK Environmental Elements
Data Stewardship
DMBOK Recurring Themes

34. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Financial master data
Taxonomies - 4 types
Data Lifecycle Simple
Data governance like real Government

35. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Data Warehouse primary components
Data Ops Mgt - Guiding Principles
Examples of individual roles participating in Data Mgt
Data Quality expectations

36. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Business Intelligence
Inmon DW Approach
Data Quality Management lifecycle
Data Management Synonyms

37. Discipline that fosters organizational learning and the management of intellectual capital.
Knowledge management
Document vs. Content
Procedural DBA
Data Stewardship

38. 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)
Data Management
Data Security Management (PDE PP AAAA)
Taxonomies - 4 types
Metadata Management Functions

39. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Metadata Architecture types
Ten Functions of Data Management
Inmon ODS - DW - DM distinction
Content Management

40. (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 Stewardship
Data
Content Management

41. SOA - ETL - Replication - Message Brokers
Data Warehouse primary components
Data Stewards
Data Access Services
HOLAP

42. 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.
Goals of DMBOK
Data Access Services
Regulatory Compliance examples
Components of Data Strategy (VCP GMO RIRS)

43. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Data Management Synonyms
Hierarchical Relationships
Data Development Activities (MDQI)
Document Mgt.Functions

44. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Management
Ten Functions of Data Management
Metadata Architecture types
Content Mgt Functions

45. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Enterprise Data Warehouse
Party master data
Data Management Shared responsibility
Data Stewards

46. Shared between Data Management Professionals in IT - and Business Data Stewards.
Semantic Modeling
Affiliation Relationship
Types of Data Management Organizations
Data Management Shared responsibility

47. 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
Physical Data Models
To share consistent Reference and Master data - orgs need to understand...
Data Quality Dimensions
Hierarchical Relationships

48. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
DOLAP
Inmon DW Approach
Data Quality tools
Data Ops Mgt has 2 Subfunctions

49. Ongoing Reconciliation and Maintenance of reference and master data.
Data Ops Mgt - Guiding Principles
Types of Data Management Organizations
Reference and Master Data Management
The PE - PPP - ACPDEV - DIA Data Management Acronym

50. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Data Strategy
Document Management
Common Activity Groups for DM Functions (PDCO)
Application DBA