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. 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.
Non-strategic goals of data management
Data Warehouse primary components
Data Ops Mgt has 2 Subfunctions
Ontology

2. Database Support and Data Technology Management
Kimball DW Approach
Data Management functions breakdown into
Metadata Architecture types
Data Ops Mgt has 2 Subfunctions

3. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Location master data
Detailed Data Design
Data Security in an outsourced wolrd
Data governance like real Government

4. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Application DBA
Location master data
Data Management Functions
Examples of individual roles participating in Data Mgt

5. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Strategy Deliverables
Data Warehouse primary components
Kimball DW Approach
Semantic Modeling

6. Type of model that represents a set of concepts and their relationships within a domain.
Enterprise Data Warehouse
Content Management
Ontology
Data Security Management (PDE PP AAAA)

7. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Application DBA
Inmon DW Approach
Common Activity Groups for DM Functions (PDCO)
Data Management functions breakdown into

8. SOA - ETL - Replication - Message Brokers
Data Access Services
Content Mgt Functions
Logical Data Model
Data Management Services(GAR MQD IP)

9. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
To share consistent Reference and Master data - orgs need to understand...
Data Ops Mgt - Guiding Principles
Data governance like real Government
Ontology

10. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Document vs. Content
Data Management
Metadata Management Functions
Common Activity Groups for DM Functions (PDCO)

11. 1. Data and info are valuable enterprise ASSETs 2. Manage data/info carefully - like any other asset - by ensuring Quality - Security - Integrity - Protection - Availability - Understanding - and Effective Use. 3. Share responsibility between busines
Reference and Master Data Management
Data Stewards
DMBOK Environmental Elements
Guiding Principles of data management

12. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Data Access Services
Data Quality Dimensions
Content Management
Data Lifecycle complete

13. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Conceptual Data Models
Master Data
Data governance programScope elements
Semantic Modeling

14. TMAC Taxonomy - Metadata - Access - Quality
Content Mgt Functions
Data Quality Management Functions
DMBOK Environmental Elements
Data Security in an outsourced wolrd

15. 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
To share consistent Reference and Master data - orgs need to understand...
Knowledge management
AAAA
Data Management Shared responsibility

16. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Semantic Modeling
Data Access Services
Reference and Master Data Management
Data asset valuation

17. Virtual OLAP cube available as proprietary function of a classic relational database
Rules defined by Data Governance (PSP MBN DR )
DOLAP
Data Development Activities (MDQI)
Data Warehouse primary components

18. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Data Development Activities (MDQI)
Data Management Services(GAR MQD IP)
Party master data
Taxonomies - 4 types

19. 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?
Financial master data
ROLAP
Detailed Data Design
To share consistent Reference and Master data - orgs need to understand...

20. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Data Operations Mgt
Application DBA
Reference and Master Data Management
To share consistent Reference and Master data - orgs need to understand...

21. Query - analysis and reporting off of the DW.
Content Management
To share consistent Reference and Master data - orgs need to understand...
Data Lifecycle Simple
Business Intelligence

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
Procedural DBA
Regulatory Compliance examples
Enterprise Data Warehouse
Components of Data Strategy (VCP GMO RIRS)

23. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Data
Document
Logical Data Model
HOLAP

24. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Data asset valuation
Metadata Architecture types
Document Mgt.Functions

25. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Data Access Services
ROLAP
Enterprise Data Warehouse
Types of Data Management Organizations

26. High level perspective on a subject area of importance to the business.
Content Mgt Functions
Conceptual Data Models
Knowledge management
Party master data

27. Expert technical custodians of data assets
Conceptual Data Models
Data Security in an outsourced wolrd
DOLAP
Data Management Professionals role

28. 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 Management Shared responsibility
Inmon ODS - DW - DM distinction
MOLAP
Goals of DMBOK

29. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data governance programScope elements
MOLAP
Data Operations Mgt
Drivers for Reference and Master Data Management

30. ERP
Business Intelligence
Financial master data
Inmon ODS - DW - DM distinction
Examples of individual roles participating in Data Mgt

31. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Goals of DMBOK
DMBOK Environmental Elements
Data Quality Dimensions
Data Quality Management lifecycle

32. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Document Mgt.Functions
Product master data
Data governance like real Government
Data Management functions breakdown into

33. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Data Development Activities (MDQI)
Business Intelligence
Kimball key components
The PE - PPP - ACPDEV - DIA Data Management Acronym

34. Customer - CRM Employee/workforce - HRM
Data Management Services(GAR MQD IP)
Product master data
Data Implementation
Party master data

35. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data Quality tools
Data governance programScope elements
Types of Metadata
HOLAP

36. 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
Reference Data - Examples
Non-strategic goals of data management
Metadata Management Functions
DM Function Context Diagram overview (DG - ISP - T - DCM)

37. (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
Goals of DMBOK
Data Management Shared responsibility
Reference Data Metadata may include...
Ten Functions of Data Management

38. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Ten Functions of Data Management
Data Lifecycle Simple
Information
Document

39. 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
Common Activity Groups for DM Functions (PDCO)
Types of Data Management Organizations
Information
The PE - PPP - ACPDEV - DIA Data Management Acronym

40. ETL Source to target mappings
Knowledge
Data Integration Services
Regulatory Compliance examples
Data Lifecycle Simple

41. Created/acquired - stored - used - destroyed.
Goals of DMBOK
Data Management Synonyms
Data Development Activities (MDQI)
Data Lifecycle Simple

42. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Asset
DMBOK Recurring Themes
Data Security in an outsourced wolrd
Regulatory Compliance examples

43. Done by DBA - collab with DA.
Document Mgt.Functions
Data asset valuation
Detailed Data Design
Types of Data Management Organizations

44. Appointed trustees for data assets
Content Management
Data Stewards
Data asset valuation
Components of Data Strategy (VCP GMO RIRS)

45. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Taxonomies - 4 types
Logical Data Model
DMBOK Recurring Themes
Metadata Management Functions

46. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Common Activity Groups for DM Functions (PDCO)
Data
Physical Data Models
Data Development Activities (MDQI)

47. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Data Stewardship
Data Stewards
Data Quality expectations
Data Quality Management lifecycle

48. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
DMBOK Environmental Elements
Data Management
Data
Data Management Synonyms

49. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Reference Data - Examples
Ontology
Causes for Performance problems
Inmon ODS - DW - DM distinction

50. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Data Model/Design quality management
Examples of individual roles participating in Data Mgt
Enterprise Data Warehouse
Business Intelligence