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. Stored in multidimensional data store
MOLAP
Affiliation Relationship
Data Quality expectations
Conceptual Data Models
2. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Product master data
Metadata Architecture types
Data Warehouse primary components
Hierarchical Relationships
3. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Ontology
Physical Data Models
Ten Functions of Data Management
Metadata Architecture types
4. 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)
DMBOK Recurring Themes
Data security guiding principles
Guiding Principles of data management
Data Development Activities (MDQI)
5. 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
Data Warehouse primary components
Ontology
Metadata Architecture types
Data Lifecycle Simple
6. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Data Strategy Deliverables
Content Management
Non-strategic goals of data management
Logical Data Model
7. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
DMBOK Environmental Elements
Data Management Professionals role
Logical Data Model
Data Security Management (PDE PP AAAA)
8. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Inmon ODS - DW - DM distinction
Data Policies
Drivers for Reference and Master Data Management
Data Ops Mgt - Guiding Principles
9. Control over defined domain values - i.e. Vocabularies.
Data Management Functions
Reference Data Management
Data Lifecycle Simple
Data Implementation
10. Expert technical custodians of data assets
Data Management Professionals role
Data Ops Mgt - Guiding Principles
Procedural DBA
MOLAP
11. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Content Management
Knowledge
Data Quality Dimensions
Taxonomies - 4 types
12. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Data Implementation
Metadata Architecture types
Data Lifecycle complete
Data Management Professionals role
13. Database Support and Data Technology Management
Business Intelligence
Causes for Performance problems
Guiding Principles of data management
Data Ops Mgt has 2 Subfunctions
14. Establishment and maintenance of Relationships between master data records.
Data Security in an outsourced wolrd
Financial master data
Affiliation Relationship
Application DBA
15. 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
Knowledge management
Knowledge
Taxonomies - 4 types
16. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Taxonomies - 4 types
Data Management
Detailed Data Design
Application DBA
17. 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
Data Warehouse primary components
Types of Metadata
Inmon ODS - DW - DM distinction
Data Model/Design quality management
18. 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.
Data Ops Mgt - Guiding Principles
Components of Data Strategy (VCP GMO RIRS)
Examples of individual roles participating in Data Mgt
Knowledge management
19. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Document Mgt.Functions
Asset
Metadata for unstructured data types
Financial master data
20. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Master Data
Types of Data Management Organizations
Enterprise Data Warehouse
Location master data
21. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
HOLAP
Reference Data Management
Examples of individual roles participating in Data Mgt
Types of Data Management Organizations
22. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Reference Data - Examples
DMBOK Recurring Themes
Data Quality Management lifecycle
Goals of DMBOK
23. Virtual OLAP cube available as proprietary function of a classic relational database
Enterprise Data Warehouse
Ten Functions of Data Management
DOLAP
HOLAP
24. 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
Data Implementation
Strategic goals of data management
AAAA
To share consistent Reference and Master data - orgs need to understand...
25. Formal accountability for business responsibilities ensuring effective control and use of data assets.
DOLAP
Metadata Architecture types
Knowledge management
Data Stewardship
26. 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
DMBOK Recurring Themes
Data
Document vs. Content
Data Quality Management lifecycle
27. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Reference Data Management
Data Security Management (PDE PP AAAA)
Data Lifecycle complete
Data Security in an outsourced wolrd
28. Query - analysis and reporting off of the DW.
Business Intelligence
Data Management Shared responsibility
Information
Reference and Master Data Management
29. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Data Governance Deliverables (PPS IP SQV)
Logical Data Model
Data Security Management (PDE PP AAAA)
MOLAP
30. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Master Data
DMBOK Environmental Elements
Kimball key components
Data Warehouse primary components
31. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
AAAA
Data Lifecycle complete
Location master data
DM Function Context Diagram overview (DG - ISP - T - DCM)
32. 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
Content Mgt Functions
To share consistent Reference and Master data - orgs need to understand...
Information
33. 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 Integration Services
Data Quality Dimensions
Business Intelligence
Inmon ODS - DW - DM distinction
34. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Kimball key components
Data Quality tools
Metadata Management Functions
AAAA
35. (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
Metadata Architecture types
Physical Data Models
Ten Functions of Data Management
Data Stewardship
36. Type of model that represents a set of concepts and their relationships within a domain.
Information
DMBOK Recurring Themes
Ontology
Data asset valuation
37. State names - codes - MedDRA code - WHO Drug Code
Ten Functions of Data Management
Reference Data - Examples
Party master data
Goals of DMBOK
38. ERP
Financial master data
Data Development Activities (MDQI)
Metadata Management Functions
Procedural DBA
39. 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
ROLAP
Strategic goals of data management
Data Management Synonyms
40. The Exercise of Authority and Control over the Management of Data Assets.
MOLAP
Data Management Shared responsibility
Data Governance (EAC DMA)
Data Lifecycle complete
41. A high-level course of action to achieve data goals. Usually a data management program strategy.
Data Security in an outsourced wolrd
Document vs. Content
Metadata for unstructured data types
Data Strategy
42. 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)
Procedural DBA
Data security guiding principles
Taxonomies - 4 types
Data Security Management (PDE PP AAAA)
43. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data Management
Kimball key components
Data governance programScope elements
Data Management functions breakdown into
44. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Data Access Services
Application DBA
Enterprise Data Warehouse
Data governance like real Government
45. Customer - CRM Employee/workforce - HRM
Data Quality Dimensions
Types of Data Management Organizations
Party master data
Drivers for Reference and Master Data Management
46. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Reference Data - Examples
DOLAP
Data Governance (EAC DMA)
Data Quality Management Functions
47. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Data Quality Management lifecycle
Data Management functions breakdown into
Semantic Modeling
Logical Data Model
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.
Regulatory Compliance examples
Knowledge management
Product master data
Conceptual Data Models
49. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Data Quality Dimensions
Document Management
Content Mgt Functions
Document vs. Content
50. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Kimball DW Approach
Kimball key components
AAAA
Content Mgt Functions