SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
Search
Test your basic knowledge |
DMBOK
Start Test
Study First
Subjects
:
certifications
,
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. Customer - CRM Employee/workforce - HRM
DMBOK Recurring Themes
Metadata Management Functions
Metadata for unstructured data types
Party master data
2. Virtual OLAP cube available as proprietary function of a classic relational database
Data Warehouse primary components
DOLAP
Strategic goals of data management
Metadata Architecture types
3. (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
Financial master data
Data Policies
Data governance like real Government
Ten Functions of Data Management
4. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Data asset valuation
Strategic goals of data management
Metadata for unstructured data types
Inmon DW Approach
5. 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
Strategic goals of data management
Data Management Synonyms
Data Ops Mgt has 2 Subfunctions
Data Quality Management lifecycle
6. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Location master data
MOLAP
Regulatory Compliance examples
Data Lifecycle complete
7. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
MOLAP
Content Management
Physical Data Models
Strategic goals of data management
8. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Application DBA
Conceptual Data Models
Goals of DMBOK
Master Data
9. Modeling and design standards
Location master data
Ten Functions of Data Management
Enterprise Data Warehouse
Data Model/Design quality management
10. DM Program Charter - SCOPE statement - Implementation Roadmap
Data
Data Strategy Deliverables
Data Warehouse primary components
To share consistent Reference and Master data - orgs need to understand...
11. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Common Activity Groups for DM Functions (PDCO)
MOLAP
Data Model/Design quality management
Procedural DBA
12. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Data Management Services(GAR MQD IP)
Semantic Modeling
Data Operations Mgt
Data Quality Management lifecycle
13. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Data Strategy
Data Governance Deliverables (PPS IP SQV)
Causes for Performance problems
Content Mgt Functions
14. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Regulatory Compliance examples
Data Management Shared responsibility
Taxonomies - 4 types
Data Implementation
15. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data security guiding principles
Data Ops Mgt - Guiding Principles
Data Security in an outsourced wolrd
Data Warehouse primary components
16. High level perspective on a subject area of importance to the business.
Data Lifecycle complete
Data Management functions breakdown into
Conceptual Data Models
Regulatory Compliance examples
17. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data Management Functions
Data governance programScope elements
DM Function Context Diagram overview (DG - ISP - T - DCM)
HOLAP
18. 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
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Stewards
Ten Functions of Data Management
Data Model/Design quality management
19. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Types of Data Management Organizations
Kimball DW Approach
DMBOK Environmental Elements
Procedural DBA
20. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
To share consistent Reference and Master data - orgs need to understand...
Kimball key components
Data Lifecycle complete
Non-strategic goals of data management
21. Database Support and Data Technology Management
Semantic Modeling
Data governance programScope elements
Data Ops Mgt has 2 Subfunctions
MOLAP
22. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Logical Data Model
Knowledge management
Knowledge
Data Management Services(GAR MQD IP)
23. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Data Management
Data Security in an outsourced wolrd
Product master data
Data Quality Management lifecycle
24. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Types of Data Management Organizations
To share consistent Reference and Master data - orgs need to understand...
Data Quality tools
Data governance like real Government
25. 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
Document Management
Information
Product master data
Metadata Architecture types
26. Data stored in Relational DB store
Data Ops Mgt - Guiding Principles
Taxonomies - 4 types
ROLAP
Data Management
27. Control over defined domain values - i.e. Vocabularies.
Reference Data Management
DOLAP
Document Mgt.Functions
Data Stewards
28. Created/acquired - stored - used - destroyed.
Data Management Functions
Data Stewardship
Data Lifecycle Simple
Data Management Services(GAR MQD IP)
29. TMAC Taxonomy - Metadata - Access - Quality
Data Ops Mgt - Guiding Principles
Content Mgt Functions
DM Function Context Diagram overview (DG - ISP - T - DCM)
ROLAP
30. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Management Shared responsibility
Procedural DBA
Content Mgt Functions
Drivers for Reference and Master Data Management
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
Examples of individual roles participating in Data Mgt
Ten Functions of Data Management
Types of Data Management Organizations
Data Quality Management lifecycle
32. 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)
Affiliation Relationship
Master Data
Physical Data Models
Taxonomies - 4 types
33. SOA - ETL - Replication - Message Brokers
Data Access Services
DMBOK Environmental Elements
Information
Data Management Synonyms
34. 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.
Common Activity Groups for DM Functions (PDCO)
Reference Data Metadata may include...
Non-strategic goals of data management
Types of Metadata
35. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Data Lifecycle Simple
Data Operations Mgt
Kimball DW Approach
Location master data
36. 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 Access Services
Procedural DBA
Data Policies
Non-strategic goals of data management
37. 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)
Data asset valuation
Data Development Activities (MDQI)
Master Data Management
MOLAP
38. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Application DBA
Data Governance Deliverables (PPS IP SQV)
Hierarchical Relationships
DMBOK Recurring Themes
39. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Procedural DBA
Document Mgt.Functions
Metadata Management Functions
Inmon ODS - DW - DM distinction
40. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
Location master data
Data Quality Dimensions
Data Security Management (PDE PP AAAA)
Types of Metadata
41. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Components of Data Strategy (VCP GMO RIRS)
Data Management
Data Governance (EAC DMA)
Semantic Modeling
42. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Hierarchical Relationships
Document Mgt.Functions
Data Management functions breakdown into
DOLAP
43. 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
Knowledge
Guiding Principles of data management
Data Management Services(GAR MQD IP)
Data Stewardship
44. Data stored in combination of ROLAP and MOLAP
Document Mgt.Functions
Types of Metadata
Data Management Functions
HOLAP
45. ETL Source to target mappings
Content Mgt Functions
Detailed Data Design
Drivers for Reference and Master Data Management
Data Integration Services
46. Query - analysis and reporting off of the DW.
To share consistent Reference and Master data - orgs need to understand...
Physical Data Models
Metadata Management Functions
Business Intelligence
47. Ongoing Reconciliation and Maintenance of reference and master data.
Metadata Management Functions
Metadata Architecture types
Reference and Master Data Management
Data Implementation
48. 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
Components of Data Strategy (VCP GMO RIRS)
Data asset valuation
Data Stewards
49. The Exercise of Authority and Control over the Management of Data Assets.
Kimball DW Approach
Data Governance (EAC DMA)
Data Governance Deliverables (PPS IP SQV)
Data Lifecycle Simple
50. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Kimball key components
Examples of individual roles participating in Data Mgt
Procedural DBA
Data Governance Deliverables (PPS IP SQV)