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. Modeling and design standards
Rules defined by Data Governance (PSP MBN DR )
Data Strategy
Data Model/Design quality management
Types of Data Management Organizations
2. Data stored in combination of ROLAP and MOLAP
HOLAP
Data asset valuation
Data
Kimball DW Approach
3. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Data Development Activities (MDQI)
Content Mgt Functions
Data Operations Mgt
Hierarchical Relationships
4. A high-level course of action to achieve data goals. Usually a data management program strategy.
Drivers for Reference and Master Data Management
Data Implementation
Document Mgt.Functions
Data Strategy
5. Stored in multidimensional data store
Data Ops Mgt has 2 Subfunctions
MOLAP
Data Governance (EAC DMA)
Inmon ODS - DW - DM distinction
6. 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
Data Integration Services
Data Governance Deliverables (PPS IP SQV)
To share consistent Reference and Master data - orgs need to understand...
7. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Governance Deliverables (PPS IP SQV)
Asset
Goals of DMBOK
Data Quality tools
8. Customer - CRM Employee/workforce - HRM
Data governance programScope elements
Party master data
Data Governance Deliverables (PPS IP SQV)
Physical Data Models
9. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Kimball key components
Data Quality Management Functions
Data Warehouse primary components
Data Access Services
10. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Party master data
Causes for Performance problems
Content Management
Physical Data Models
11. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Procedural DBA
Data Integration Services
Data Stewardship
DM Function Context Diagram overview (DG - ISP - T - DCM)
12. Data stored in Relational DB store
Drivers for Reference and Master Data Management
Data Lifecycle Simple
Product master data
ROLAP
13. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Knowledge
Data
Data Quality Dimensions
DMBOK Environmental Elements
14. 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
DOLAP
The PE - PPP - ACPDEV - DIA Data Management Acronym
Content Mgt Functions
15. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.
Kimball DW Approach
Data Management Functions
Data Security Management (PDE PP AAAA)
Data Implementation
16. DM Program Charter - SCOPE statement - Implementation Roadmap
Master Data
Data Strategy Deliverables
Strategic goals of data management
Drivers for Reference and Master Data Management
17. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Ten Functions of Data Management
Data Implementation
Data Warehouse primary components
Reference Data - Examples
18. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
To share consistent Reference and Master data - orgs need to understand...
HOLAP
Types of Metadata
Data Governance Deliverables (PPS IP SQV)
19. 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 security guiding principles
Enterprise Data Warehouse
Metadata Management Functions
Data governance like real Government
20. (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
DMBOK Environmental Elements
Ten Functions of Data Management
Affiliation Relationship
The PE - PPP - ACPDEV - DIA Data Management Acronym
21. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Data Ops Mgt has 2 Subfunctions
Inmon DW Approach
Information
Kimball DW Approach
22. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Metadata Management Functions
Enterprise Data Warehouse
Data Integration Services
Document Management
23. 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)
Inmon DW Approach
MOLAP
Data Development Activities (MDQI)
Data Management Shared responsibility
24. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Data Model/Design quality management
Physical Data Models
Goals of DMBOK
Master Data
25. 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
Knowledge management
Common Activity Groups for DM Functions (PDCO)
Data asset valuation
Inmon DW Approach
26. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Asset
Reference Data Management
Strategic goals of data management
Data Development Activities (MDQI)
27. SOA - ETL - Replication - Message Brokers
Examples of individual roles participating in Data Mgt
Data Access Services
Kimball DW Approach
Knowledge management
28. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
DMBOK Recurring Themes
Inmon DW Approach
Document Management
Data Management Synonyms
29. Shared between Data Management Professionals in IT - and Business Data Stewards.
Data Integration Services
Content Management
Knowledge
Data Management Shared responsibility
30. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Data Strategy Deliverables
ROLAP
Data Quality expectations
Master Data
31. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.
Location master data
Application DBA
Kimball key components
Data Stewards
32. Database Support and Data Technology Management
Data Management Professionals role
Business Intelligence
Data Ops Mgt has 2 Subfunctions
ROLAP
33. TMAC Taxonomy - Metadata - Access - Quality
Data Management Synonyms
Data Management Functions
Regulatory Compliance examples
Content Mgt Functions
34. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Common Activity Groups for DM Functions (PDCO)
Components of Data Strategy (VCP GMO RIRS)
HOLAP
Information
35. Business function of planning for - controlling - and delivering data and information assets. PDC-A
ROLAP
Reference Data Metadata may include...
MOLAP
Data Management
36. Data is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?
Drivers for Reference and Master Data Management
Content Management
Reference Data Management
Data asset valuation
37. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Ontology
Data Lifecycle complete
Goals of DMBOK
Hierarchical Relationships
38. 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)
Types of Data Management Organizations
Affiliation Relationship
Data Governance Deliverables (PPS IP SQV)
Taxonomies - 4 types
39. Expert technical custodians of data assets
Data Management Professionals role
Data Policies
Ten Functions of Data Management
Data Management Functions
40. State names - codes - MedDRA code - WHO Drug Code
DMBOK Environmental Elements
Data Integration Services
Reference Data - Examples
Data Quality expectations
41. High level perspective on a subject area of importance to the business.
Data Management functions breakdown into
Kimball DW Approach
Taxonomies - 4 types
Conceptual Data Models
42. 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
Data governance like real Government
Party master data
Strategic goals of data management
Document
43. 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
Data Governance Deliverables (PPS IP SQV)
Kimball key components
Data
44. 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
Content Management
Data Quality Management lifecycle
Asset
Data Management Synonyms
45. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Reference and Master Data Management
Inmon DW Approach
Data Implementation
Knowledge management
46. Establishment and maintenance of Relationships between master data records.
Document
Data Strategy
Affiliation Relationship
Information
47. Data specifically constructed for query and analysis
Data Security Management (PDE PP AAAA)
Kimball DW Approach
Affiliation Relationship
Data Quality Management Functions
48. Appointed trustees for data assets
Data
Data Stewards
Reference and Master Data Management
Ontology
49. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
The PE - PPP - ACPDEV - DIA Data Management Acronym
Master Data
Data Quality expectations
Document
50. 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
Inmon ODS - DW - DM distinction
Document Management
Data
Non-strategic goals of data management