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. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Kimball key components
Logical Data Model
Inmon DW Approach
DOLAP
2. Control over defined domain values - i.e. Vocabularies.
Types of Metadata
Reference Data Management
Regulatory Compliance examples
Data Ops Mgt has 2 Subfunctions
3. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
The PE - PPP - ACPDEV - DIA Data Management Acronym
Components of Data Strategy (VCP GMO RIRS)
Data Implementation
Data Security Management (PDE PP AAAA)
4. 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.
Ten Functions of Data Management
Non-strategic goals of data management
Data governance programScope elements
Document vs. Content
5. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Document Mgt.Functions
Data Management
The PE - PPP - ACPDEV - DIA Data Management Acronym
Reference Data Metadata may include...
6. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Data Lifecycle complete
Common Activity Groups for DM Functions (PDCO)
Metadata Architecture types
Location master data
7. Expert technical custodians of data assets
Knowledge
Data Strategy
Data Management Professionals role
Data Warehouse primary components
8. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Management
Data Management Services(GAR MQD IP)
Procedural DBA
Reference Data Management
9. DM Program Charter - SCOPE statement - Implementation Roadmap
Data Security in an outsourced wolrd
Inmon ODS - DW - DM distinction
Data Strategy Deliverables
Metadata Architecture types
10. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
DMBOK Environmental Elements
Data Governance (EAC DMA)
Affiliation Relationship
Document Management
11. Data specifically constructed for query and analysis
Master Data Management
Kimball DW Approach
Data Management
Data security guiding principles
12. 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
Data Security in an outsourced wolrd
Data Stewardship
Knowledge
13. 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 Model/Design quality management
HOLAP
Data Development Activities (MDQI)
Semantic Modeling
14. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Data Management Services(GAR MQD IP)
Data Quality Management lifecycle
Asset
Master Data Management
15. Done by DBA - collab with DA.
Data Warehouse primary components
Data Development Activities (MDQI)
Data Management Functions
Detailed Data Design
16. 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.
DOLAP
Strategic goals of data management
Master Data Management
Data Security in an outsourced wolrd
17. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Data Development Activities (MDQI)
Procedural DBA
Data Quality Management Functions
Data Quality tools
18. Any file or record
Document
Data
Semantic Modeling
Data Policies
19. ERP
Guiding Principles of data management
Components of Data Strategy (VCP GMO RIRS)
Financial master data
Data governance programScope elements
20. 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
Data governance like real Government
Metadata Architecture types
Data Quality Management lifecycle
DMBOK Recurring Themes
21. Customer - CRM Employee/workforce - HRM
Reference and Master Data Management
To share consistent Reference and Master data - orgs need to understand...
Party master data
Causes for Performance problems
22. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Document Mgt.Functions
Asset
Data Management functions breakdown into
Procedural DBA
23. Planning - set strategic and tactical course for other activities - Development - undertaken within implementation projects and recognized as part of SDLC - Control - Supervisory activities - Operational - Service and support activities
Financial master data
Guiding Principles of data management
Metadata Architecture types
Common Activity Groups for DM Functions (PDCO)
24. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Data Quality Management lifecycle
DM Function Context Diagram overview (DG - ISP - T - DCM)
Enterprise Data Warehouse
Data Lifecycle complete
25. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Data Management
Document Mgt.Functions
Data
Knowledge
26. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Data governance like real Government
Information
Master Data
Financial master data
27. The Exercise of Authority and Control over the Management of Data Assets.
Semantic Modeling
Data Management Services(GAR MQD IP)
Data Governance (EAC DMA)
Reference Data - Examples
28. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Taxonomies - 4 types
Data Access Services
Application DBA
Document
29. 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)
Location master data
Data Strategy Deliverables
Metadata Architecture types
30. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Examples of individual roles participating in Data Mgt
Semantic Modeling
HOLAP
Goals of DMBOK
31. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Detailed Data Design
Data Implementation
Taxonomies - 4 types
Rules defined by Data Governance (PSP MBN DR )
32. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Types of Metadata
Examples of individual roles participating in Data Mgt
Goals of DMBOK
DMBOK Recurring Themes
33. 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 Stewardship
Procedural DBA
ROLAP
Guiding Principles of data management
34. (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
Kimball DW Approach
Causes for Performance problems
Ten Functions of Data Management
Data Management Synonyms
35. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Kimball key components
Types of Metadata
MOLAP
To share consistent Reference and Master data - orgs need to understand...
36. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit
Knowledge management
Document Mgt.Functions
Components of Data Strategy (VCP GMO RIRS)
Document Management
37. 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 Stewardship
Ontology
Product master data
Data Development Activities (MDQI)
38. 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
Data Stewardship
Ontology
Hierarchical Relationships
Data security guiding principles
39. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Causes for Performance problems
Drivers for Reference and Master Data Management
Ontology
Content Management
40. 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 Stewardship
Components of Data Strategy (VCP GMO RIRS)
Knowledge management
Data Lifecycle Simple
41. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
ROLAP
Product master data
Data Ops Mgt - Guiding Principles
Knowledge
42. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
Data Management Services(GAR MQD IP)
Data Management Functions
Product master data
Physical Data Models
43. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Detailed Data Design
Data Model/Design quality management
Data Stewardship
Data Stewards
44. Shared between Data Management Professionals in IT - and Business Data Stewards.
Data Lifecycle Simple
Reference Data - Examples
DOLAP
Data Management Shared responsibility
45. Ongoing Reconciliation and Maintenance of reference and master data.
Business Intelligence
Reference and Master Data Management
Regulatory Compliance examples
Content Management
46. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Data Quality expectations
Data Implementation
Hierarchical Relationships
Procedural DBA
47. 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 Strategy Deliverables
Data Policies
Asset
Data Ops Mgt - Guiding Principles
48. ETL Source to target mappings
Enterprise Data Warehouse
Semantic Modeling
Data Security Management (PDE PP AAAA)
Data Integration Services
49. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Master Data Management
Types of Data Management Organizations
HOLAP
Logical Data Model
50. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Data asset valuation
Data Management Synonyms
Data Governance Deliverables (PPS IP SQV)
Product master data