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. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Logical Data Model
Knowledge
Data Access Services
Types of Metadata
2. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Management Professionals role
Data Management Functions
Data Operations Mgt
Data Ops Mgt - Guiding Principles
3. Data stored in Relational DB store
Asset
Data Lifecycle Simple
ROLAP
Non-strategic goals of data management
4. Shared between Data Management Professionals in IT - and Business Data Stewards.
Data Management Shared responsibility
Affiliation Relationship
Data asset valuation
Asset
5. 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
Data Development Activities (MDQI)
Data asset valuation
Data Quality tools
Data Quality Dimensions
6. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Goals of DMBOK
ROLAP
Drivers for Reference and Master Data Management
Inmon ODS - DW - DM distinction
7. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Types of Metadata
Data Quality Dimensions
Data Quality expectations
Data Stewardship
8. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Semantic Modeling
Data Implementation
Data asset valuation
Reference and Master Data Management
9. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Procedural DBA
Affiliation Relationship
Semantic Modeling
Kimball key components
10. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Physical Data Models
Product master data
Asset
AAAA
11. 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
Metadata Architecture types
Hierarchical Relationships
Document Mgt.Functions
Drivers for Reference and Master Data Management
12. Customer - CRM Employee/workforce - HRM
Party master data
Document
Semantic Modeling
Data Management functions breakdown into
13. 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)
Data Quality Management Functions
Data Strategy Deliverables
Data Access Services
14. Appointed trustees for data assets
Data Stewards
Detailed Data Design
Asset
Knowledge management
15. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Data Ops Mgt has 2 Subfunctions
Document Mgt.Functions
Data Quality Dimensions
Inmon DW Approach
16. Query - analysis and reporting off of the DW.
Business Intelligence
Data Integration Services
Ten Functions of Data Management
Reference Data Management
17. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Drivers for Reference and Master Data Management
Data governance programScope elements
Party master data
Data Quality Management lifecycle
18. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Data security guiding principles
Semantic Modeling
Party master data
19. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Data Security in an outsourced wolrd
Reference Data Metadata may include...
Reference Data Management
Application DBA
20. High level perspective on a subject area of importance to the business.
Data governance programScope elements
Data Stewards
Party master data
Conceptual Data Models
21. Data specifically constructed for query and analysis
Data Quality tools
Document Mgt.Functions
Kimball DW Approach
Data Operations Mgt
22. A high-level course of action to achieve data goals. Usually a data management program strategy.
Metadata Management Functions
Data Strategy
Data Quality Dimensions
MOLAP
23. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.
Data asset valuation
Document Management
Data Strategy
Application DBA
24. Virtual OLAP cube available as proprietary function of a classic relational database
DOLAP
Metadata for unstructured data types
Data Security in an outsourced wolrd
Strategic goals of data management
25. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Document Management
Application DBA
Data Operations Mgt
Kimball DW Approach
26. Discipline that fosters organizational learning and the management of intellectual capital.
Ontology
Reference and Master Data Management
Data Security Management (PDE PP AAAA)
Knowledge management
27. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Data Management Professionals role
Document
Affiliation Relationship
Master Data
28. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Reference Data Metadata may include...
Data Governance Deliverables (PPS IP SQV)
Data Policies
Data security guiding principles
29. Done by DBA - collab with DA.
Enterprise Data Warehouse
Detailed Data Design
Metadata Management Functions
Data security guiding principles
30. TMAC Taxonomy - Metadata - Access - Quality
Data Management Services(GAR MQD IP)
Content Mgt Functions
Data asset valuation
Data Stewards
31. 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
Data Security in an outsourced wolrd
Data Integration Services
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Management functions breakdown into
32. 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 Quality Management lifecycle
Business Intelligence
DMBOK Recurring Themes
Data Governance Deliverables (PPS IP SQV)
33. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.
Document Mgt.Functions
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Ops Mgt - Guiding Principles
Data
34. The Exercise of Authority and Control over the Management of Data Assets.
Data Governance (EAC DMA)
Reference Data Metadata may include...
DM Function Context Diagram overview (DG - ISP - T - DCM)
Enterprise Data Warehouse
35. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture
DM Function Context Diagram overview (DG - ISP - T - DCM)
Reference Data - Examples
DMBOK Environmental Elements
Data Management Shared responsibility
36. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.
Rules defined by Data Governance (PSP MBN DR )
Document vs. Content
Types of Data Management Organizations
Data Ops Mgt has 2 Subfunctions
37. Control over defined domain values - i.e. Vocabularies.
Reference Data Management
Data Ops Mgt has 2 Subfunctions
Kimball DW Approach
Document Management
38. Stored in multidimensional data store
MOLAP
Document Management
Data Ops Mgt - Guiding Principles
HOLAP
39. DMS - Development - Maintenance - Support of structured data
Metadata Architecture types
Affiliation Relationship
Data Security Management (PDE PP AAAA)
Data Operations Mgt
40. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Data Development Activities (MDQI)
Information
Content Management
Causes for Performance problems
41. 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
Business Intelligence
Data security guiding principles
Rules defined by Data Governance (PSP MBN DR )
Semantic Modeling
42. Ongoing Reconciliation and Maintenance of reference and master data.
Data Lifecycle Simple
Reference and Master Data Management
Data Lifecycle complete
Data Warehouse primary components
43. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Data Access Services
Guiding Principles of data management
Data Implementation
Rules defined by Data Governance (PSP MBN DR )
44. 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
Types of Metadata
Guiding Principles of data management
Ten Functions of Data Management
DMBOK Recurring Themes
45. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Non-strategic goals of data management
Data Ops Mgt has 2 Subfunctions
Data Stewardship
Data
46. 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...
Strategic goals of data management
Kimball DW Approach
Inmon DW Approach
47. Expert technical custodians of data assets
Data Management Professionals role
Data Lifecycle Simple
Data Management functions breakdown into
Procedural DBA
48. Type of model that represents a set of concepts and their relationships within a domain.
Ontology
Causes for Performance problems
Document vs. Content
Taxonomies - 4 types
49. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Reference Data - Examples
Components of Data Strategy (VCP GMO RIRS)
Affiliation Relationship
Types of Data Management Organizations
50. 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 Policies
Strategic goals of data management
Data Governance (EAC DMA)
DM Function Context Diagram overview (DG - ISP - T - DCM)