SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
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. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Document
Data Access Services
Data Stewardship
The PE - PPP - ACPDEV - DIA Data Management Acronym
2. Any file or record
Knowledge management
Data Management Services(GAR MQD IP)
AAAA
Document
3. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Location master data
Semantic Modeling
Data Management Services(GAR MQD IP)
Knowledge
4. Meaning and purpose of each reference data value domain - Reference tables and databases where the reference data appears. - Source of the data in each table. - Version currently available. - When data was last updated. - How the data in each table i
Reference Data Metadata may include...
Inmon ODS - DW - DM distinction
Financial master data
Master Data
5. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Data governance programScope elements
Types of Data Management Organizations
Data governance like real Government
Drivers for Reference and Master Data Management
6. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Master Data
Product master data
Ontology
Asset
7. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Content Mgt Functions
Ten Functions of Data Management
Rules defined by Data Governance (PSP MBN DR )
Knowledge management
8. A high-level course of action to achieve data goals. Usually a data management program strategy.
Data Lifecycle complete
Data Strategy
Data Operations Mgt
Data Quality Dimensions
9. Done by DBA - collab with DA.
Strategic goals of data management
Document
Physical Data Models
Detailed Data Design
10. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Management functions breakdown into
Procedural DBA
ROLAP
Data Warehouse primary components
11. Data is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?
Data asset valuation
Data Access Services
Product master data
Types of Data Management Organizations
12. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Knowledge
Metadata for unstructured data types
Drivers for Reference and Master Data Management
HOLAP
13. High level perspective on a subject area of importance to the business.
Information
Conceptual Data Models
Data Ops Mgt has 2 Subfunctions
To share consistent Reference and Master data - orgs need to understand...
14. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Content Management
Document vs. Content
Drivers for Reference and Master Data Management
Metadata Architecture types
15. 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
Kimball DW Approach
Data security guiding principles
Information
Types of Data Management Organizations
16. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Data governance like real Government
Detailed Data Design
Data asset valuation
Data
17. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Data Management Synonyms
Product master data
Data Management Functions
Inmon DW Approach
18. 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.
Strategic goals of data management
Product master data
Reference Data - Examples
Data Quality Management Functions
19. 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 Ops Mgt - Guiding Principles
Ten Functions of Data Management
Content Mgt Functions
20. ETL Source to target mappings
Data Management Services(GAR MQD IP)
Data
Data Integration Services
Data Ops Mgt has 2 Subfunctions
21. Appointed trustees for data assets
Data Access Services
Data Stewards
Master Data Management
Data Warehouse primary components
22. Customer - CRM Employee/workforce - HRM
Taxonomies - 4 types
Procedural DBA
Conceptual Data Models
Party master data
23. 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?
Data Management functions breakdown into
Data Quality tools
To share consistent Reference and Master data - orgs need to understand...
Financial master data
24. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Metadata for unstructured data types
Enterprise Data Warehouse
Rules defined by Data Governance (PSP MBN DR )
To share consistent Reference and Master data - orgs need to understand...
25. 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.
Document
Examples of individual roles participating in Data Mgt
Knowledge management
Components of Data Strategy (VCP GMO RIRS)
26. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Kimball key components
Knowledge
Reference and Master Data Management
Strategic goals of data management
27. Created/acquired - stored - used - destroyed.
Taxonomies - 4 types
Data Lifecycle Simple
ROLAP
Hierarchical Relationships
28. 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 asset valuation
Data Policies
Document vs. Content
Metadata Architecture types
29. 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)
Types of Data Management Organizations
Affiliation Relationship
Data Development Activities (MDQI)
Location master data
30. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Financial master data
Types of Metadata
Knowledge
Master Data Management
31. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
ROLAP
Guiding Principles of data management
Metadata Management Functions
Data Strategy
32. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Document Management
Non-strategic goals of data management
Data Implementation
Knowledge
33. Establishment and maintenance of Relationships between master data records.
Data Quality Dimensions
Data Policies
Affiliation Relationship
Data Lifecycle complete
34. Expert technical custodians of data assets
Reference Data Management
Data Management functions breakdown into
Data Management Professionals role
Regulatory Compliance examples
35. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Content Mgt Functions
Conceptual Data Models
AAAA
Information
36. Database Support and Data Technology Management
Document vs. Content
Data Ops Mgt has 2 Subfunctions
DMBOK Recurring Themes
Data Ops Mgt - Guiding Principles
37. 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
Master Data Management
Data Quality Dimensions
To share consistent Reference and Master data - orgs need to understand...
Business Intelligence
38. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Data Stewards
Types of Metadata
Metadata Architecture types
Data Implementation
39. Control over master data values to enable consistent - shared - contextual use across systems - of the most Accurate - Current - Relevant version of truth about Essential business entitites.
Data Management Synonyms
Master Data Management
Inmon ODS - DW - DM distinction
DMBOK Environmental Elements
40. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Data Lifecycle Simple
Data asset valuation
Document Mgt.Functions
Data Stewards
41. Discipline that fosters organizational learning and the management of intellectual capital.
Regulatory Compliance examples
Knowledge management
Data Quality Management Functions
Reference Data Management
42. 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
DMBOK Recurring Themes
Data Development Activities (MDQI)
Strategic goals of data management
Party master data
43. 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
AAAA
Document vs. Content
Data security guiding principles
Data Quality Management lifecycle
44. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
ROLAP
Data Security Management (PDE PP AAAA)
Data Quality Management lifecycle
Data Stewards
45. 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
Application DBA
Types of Data Management Organizations
Guiding Principles of data management
DM Function Context Diagram overview (DG - ISP - T - DCM)
46. TMAC Taxonomy - Metadata - Access - Quality
Kimball DW Approach
Financial master data
Metadata Management Functions
Content Mgt Functions
47. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
MOLAP
Location master data
Reference Data - Examples
Drivers for Reference and Master Data Management
48. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Location master data
Document vs. Content
Data Quality expectations
Data Security in an outsourced wolrd
49. 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
Reference Data - Examples
Data Model/Design quality management
Inmon ODS - DW - DM distinction
Procedural DBA
50. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data governance programScope elements
Data Stewardship
Data Ops Mgt - Guiding Principles
Data Governance Deliverables (PPS IP SQV)