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. (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
Document
Detailed Data Design
Data Warehouse primary components
2. Query - analysis and reporting off of the DW.
Logical Data Model
Strategic goals of data management
Data Quality tools
Business Intelligence
3. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Data Quality expectations
Data Management Services(GAR MQD IP)
Master Data
Data Development Activities (MDQI)
4. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data governance programScope elements
Kimball key components
Ontology
Data Stewards
5. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
DMBOK Recurring Themes
Ontology
Data Policies
Rules defined by Data Governance (PSP MBN DR )
6. DM Program Charter - SCOPE statement - Implementation Roadmap
Data Strategy Deliverables
Information
Reference and Master Data Management
Data Quality expectations
7. BTPD Business (Definitions - rules - data lineage - quality statements - report lists - etc.) - Targetd at Business - Technical and operational (Information about SYSTEMS. DBs - column names - files - etls - etc) - Targeted at IT Operations users' n
Types of Metadata
Examples of individual roles participating in Data Mgt
Location master data
Data Management Services(GAR MQD IP)
8. Expert technical custodians of data assets
Data Management Professionals role
Data security guiding principles
Drivers for Reference and Master Data Management
Ontology
9. 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
Detailed Data Design
Data security guiding principles
Data Management
Reference Data Metadata may include...
10. 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
Application DBA
Data Governance Deliverables (PPS IP SQV)
Data Lifecycle Simple
Metadata Architecture types
11. 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
Guiding Principles of data management
Goals of DMBOK
Data Lifecycle complete
12. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Data Management Services(GAR MQD IP)
Data Lifecycle complete
Data Management Shared responsibility
Ontology
13. 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...
Financial master data
Data Development Activities (MDQI)
Data governance like real Government
14. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Data Implementation
Product master data
Data Quality Management Functions
DM Function Context Diagram overview (DG - ISP - T - DCM)
15. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Location master data
Guiding Principles of data management
AAAA
Data Management Shared responsibility
16. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Data Lifecycle Simple
Logical Data Model
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Governance Deliverables (PPS IP SQV)
17. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Kimball DW Approach
DMBOK Environmental Elements
Data Management Functions
Reference Data Management
18. Data stored in Relational DB store
Reference Data Management
ROLAP
DMBOK Environmental Elements
Data Management Shared responsibility
19. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
DMBOK Environmental Elements
Asset
Data Quality expectations
Inmon ODS - DW - DM distinction
20. Type of model that represents a set of concepts and their relationships within a domain.
Ontology
Procedural DBA
Document vs. Content
Data Management Professionals role
21. 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
Semantic Modeling
Inmon ODS - DW - DM distinction
Data Model/Design quality management
22. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Data Management Functions
Data Lifecycle complete
Semantic Modeling
The PE - PPP - ACPDEV - DIA Data Management Acronym
23. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Data Management Synonyms
Data Quality Dimensions
Enterprise Data Warehouse
Inmon ODS - DW - DM distinction
24. 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
Data Quality Management lifecycle
Regulatory Compliance examples
Data Stewards
Data Integration Services
25. Modeling and design standards
Data governance like real Government
Data Strategy
Semantic Modeling
Data Model/Design quality management
26. Done by DBA - collab with DA.
Asset
Logical Data Model
Examples of individual roles participating in Data Mgt
Detailed Data Design
27. 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.
Master Data Management
Content Management
MOLAP
Kimball DW Approach
28. 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 security guiding principles
Data Model/Design quality management
Inmon DW Approach
29. 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.
DOLAP
Document vs. Content
Inmon ODS - DW - DM distinction
Data Policies
30. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Inmon DW Approach
Knowledge
Data Security Management (PDE PP AAAA)
Application DBA
31. Control over defined domain values - i.e. Vocabularies.
Reference Data Management
Party master data
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Implementation
32. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
The PE - PPP - ACPDEV - DIA Data Management Acronym
DMBOK Recurring Themes
Data governance like real Government
Data Operations Mgt
33. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Metadata for unstructured data types
Asset
Inmon ODS - DW - DM distinction
Data Management Services(GAR MQD IP)
34. Created/acquired - stored - used - destroyed.
Data Lifecycle Simple
Data Policies
Types of Data Management Organizations
Application DBA
35. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Goals of DMBOK
Ten Functions of Data Management
Data Quality expectations
Types of Metadata
36. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Types of Metadata
Information
Ten Functions of Data Management
MOLAP
37. 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
Detailed Data Design
Data Quality Management Functions
DM Function Context Diagram overview (DG - ISP - T - DCM)
Reference Data Management
38. Appointed trustees for data assets
Data Stewardship
Reference and Master Data Management
Data Stewards
Data Lifecycle Simple
39. A high-level course of action to achieve data goals. Usually a data management program strategy.
Data Ops Mgt - Guiding Principles
Data
Data Strategy
Content Management
40. Data specifically constructed for query and analysis
Kimball DW Approach
Examples of individual roles participating in Data Mgt
Data Ops Mgt has 2 Subfunctions
Data Lifecycle complete
41. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Physical Data Models
DMBOK Environmental Elements
Data Management Professionals role
Data Quality tools
42. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Types of Data Management Organizations
Data Quality Management Functions
Reference Data Metadata may include...
Content Management
43. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Application DBA
Master Data Management
Regulatory Compliance examples
Data Stewardship
44. Ongoing Reconciliation and Maintenance of reference and master data.
Reference and Master Data Management
Logical Data Model
Data Lifecycle Simple
Hierarchical Relationships
45. 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
Metadata for unstructured data types
Logical Data Model
Data Quality Dimensions
Data Security Management (PDE PP AAAA)
46. 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?
Knowledge
DMBOK Environmental Elements
AAAA
To share consistent Reference and Master data - orgs need to understand...
47. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Metadata Architecture types
Rules defined by Data Governance (PSP MBN DR )
Metadata for unstructured data types
Data asset valuation
48. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Document Management
Data Quality Dimensions
The PE - PPP - ACPDEV - DIA Data Management Acronym
Taxonomies - 4 types
49. State names - codes - MedDRA code - WHO Drug Code
Inmon DW Approach
Reference Data - Examples
Data Quality expectations
Document vs. Content
50. 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 Development Activities (MDQI)
Data security guiding principles
Data Ops Mgt has 2 Subfunctions
Kimball DW Approach