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. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Knowledge
Data Operations Mgt
Logical Data Model
Rules defined by Data Governance (PSP MBN DR )
2. 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.
Information
Data Policies
Data governance like real Government
Data Management Synonyms
3. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Content Mgt Functions
Document Mgt.Functions
Document Management
Components of Data Strategy (VCP GMO RIRS)
4. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Semantic Modeling
To share consistent Reference and Master data - orgs need to understand...
Financial master data
Procedural DBA
5. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Data Management Services(GAR MQD IP)
Reference Data Management
Document Management
Document Mgt.Functions
6. 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 Strategy
Data Ops Mgt has 2 Subfunctions
Party master data
AAAA
7. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Goals of DMBOK
Data Warehouse primary components
Data Management Services(GAR MQD IP)
DMBOK Environmental Elements
8. Data stored in combination of ROLAP and MOLAP
Data Stewardship
Master Data Management
Data Integration Services
HOLAP
9. 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.
Data Stewards
Data Quality Management lifecycle
Regulatory Compliance examples
Product master data
10. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
Data Strategy
Information
DMBOK Environmental Elements
Data Operations Mgt
11. A high-level course of action to achieve data goals. Usually a data management program strategy.
Non-strategic goals of data management
Inmon ODS - DW - DM distinction
Document vs. Content
Data Strategy
12. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Financial master data
Data Management Services(GAR MQD IP)
Data Implementation
Inmon ODS - DW - DM distinction
13. Database Support and Data Technology Management
Types of Metadata
Data Ops Mgt has 2 Subfunctions
Enterprise Data Warehouse
Data Quality Management Functions
14. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -
Physical Data Models
Data Warehouse primary components
Data Lifecycle Simple
DMBOK Environmental Elements
15. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Data Management functions breakdown into
Data Management Professionals role
Semantic Modeling
Data Governance Deliverables (PPS IP SQV)
16. Shared between Data Management Professionals in IT - and Business Data Stewards.
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Management Shared responsibility
Data Implementation
Data Lifecycle Simple
17. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Management functions breakdown into
Data Management
Application DBA
Master Data Management
18. Stored in multidimensional data store
MOLAP
Detailed Data Design
Hierarchical Relationships
Master Data
19. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Content Mgt Functions
Data Quality Management Functions
AAAA
Data Ops Mgt - Guiding Principles
20. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Data Development Activities (MDQI)
Data Governance Deliverables (PPS IP SQV)
Inmon ODS - DW - DM distinction
Causes for Performance problems
21. State names - codes - MedDRA code - WHO Drug Code
Data Governance Deliverables (PPS IP SQV)
Data Policies
Data Lifecycle Simple
Reference Data - Examples
22. Ongoing Reconciliation and Maintenance of reference and master data.
Examples of individual roles participating in Data Mgt
Inmon ODS - DW - DM distinction
Data Lifecycle Simple
Reference and Master Data Management
23. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data Management functions breakdown into
Data
Data Security in an outsourced wolrd
Product master data
24. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
Data Security Management (PDE PP AAAA)
Types of Metadata
Document Management
Examples of individual roles participating in Data Mgt
25. Establishment and maintenance of Relationships between master data records.
MOLAP
Affiliation Relationship
Content Management
Drivers for Reference and Master Data Management
26. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership
Business Intelligence
Procedural DBA
Non-strategic goals of data management
DMBOK Recurring Themes
27. 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 Quality Management Functions
Data Strategy
Data Quality expectations
Inmon ODS - DW - DM distinction
28. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Types of Metadata
Data security guiding principles
Data Quality Management lifecycle
Data governance programScope elements
29. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Location master data
Party master data
ROLAP
Data Quality Management Functions
30. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
DMBOK Environmental Elements
Data Quality Management lifecycle
Content Mgt Functions
Data Quality expectations
31. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Asset
Types of Data Management Organizations
Data Operations Mgt
Components of Data Strategy (VCP GMO RIRS)
32. SOA - ETL - Replication - Message Brokers
Data Access Services
Kimball key components
Inmon DW Approach
Taxonomies - 4 types
33. Data stored in Relational DB store
ROLAP
Data Management Professionals role
Data Strategy
Data
34. Discipline that fosters organizational learning and the management of intellectual capital.
Information
Ontology
Knowledge management
Detailed Data Design
35. ETL Source to target mappings
Data Integration Services
Procedural DBA
Inmon ODS - DW - DM distinction
Data Management Services(GAR MQD IP)
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
Causes for Performance problems
To share consistent Reference and Master data - orgs need to understand...
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality Management lifecycle
37. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Stewards
Drivers for Reference and Master Data Management
Party master data
Goals of DMBOK
38. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Regulatory Compliance examples
Data Governance Deliverables (PPS IP SQV)
Causes for Performance problems
Data Management Synonyms
39. 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
ROLAP
Data security guiding principles
Detailed Data Design
Data Lifecycle Simple
40. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Information
DOLAP
Enterprise Data Warehouse
Data Strategy Deliverables
41. 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)
Asset
Master Data Management
Data Ops Mgt - Guiding Principles
42. 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 Functions
Data Access Services
To share consistent Reference and Master data - orgs need to understand...
AAAA
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
Data Quality expectations
Guiding Principles of data management
Physical Data Models
Metadata Management Functions
44. ERP
Data Stewardship
Data governance programScope elements
Detailed Data Design
Financial master data
45. The Exercise of Authority and Control over the Management of Data Assets.
Data governance like real Government
Data Security Management (PDE PP AAAA)
Document Mgt.Functions
Data Governance (EAC DMA)
46. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Semantic Modeling
Data Access Services
Kimball key components
Data Ops Mgt - Guiding Principles
47. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Types of Metadata
Data Development Activities (MDQI)
MOLAP
Goals of DMBOK
48. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Data security guiding principles
Metadata Management Functions
Data Quality Management Functions
Data Quality Dimensions
49. Created/acquired - stored - used - destroyed.
Data Lifecycle Simple
Product master data
Taxonomies - 4 types
Data governance programScope elements
50. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Taxonomies - 4 types
Physical Data Models
Reference Data Metadata may include...
Inmon DW Approach