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. (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
Reference and Master Data Management
Ten Functions of Data Management
Logical Data Model
Data Lifecycle Simple
2. 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 Governance Deliverables (PPS IP SQV)
Document
Kimball DW Approach
Inmon ODS - DW - DM distinction
3. 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
Document Management
Data Lifecycle complete
Metadata Management Functions
4. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Security Management (PDE PP AAAA)
MOLAP
Drivers for Reference and Master Data Management
Data Model/Design quality management
5. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
Inmon DW Approach
Data governance like real Government
Ten Functions of Data Management
Data Warehouse primary components
6. 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 Quality Management Functions
Metadata Management Functions
Document
Types of Metadata
7. TMAC Taxonomy - Metadata - Access - Quality
Content Mgt Functions
Reference and Master Data Management
MOLAP
Data Stewards
8. Expert technical custodians of data assets
Data Management functions breakdown into
Types of Data Management Organizations
Data Management Professionals role
Rules defined by Data Governance (PSP MBN DR )
9. Virtual OLAP cube available as proprietary function of a classic relational database
Data Strategy Deliverables
Data security guiding principles
DOLAP
Enterprise Data Warehouse
10. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data governance programScope elements
Data Model/Design quality management
Goals of DMBOK
MOLAP
11. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Examples of individual roles participating in Data Mgt
Content Mgt Functions
Data Lifecycle complete
Goals of DMBOK
12. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Financial master data
Data Management Synonyms
Data Security in an outsourced wolrd
Data Management
13. Done by DBA - collab with DA.
Content Management
Data Access Services
Detailed Data Design
Data Quality Management lifecycle
14. ETL Source to target mappings
Location master data
Data Management
Data Integration Services
Data
15. Formal accountability for business responsibilities ensuring effective control and use of data assets.
Semantic Modeling
Data Management Professionals role
Conceptual Data Models
Data Stewardship
16. 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
Types of Metadata
Data security guiding principles
Data Development Activities (MDQI)
Data Governance (EAC DMA)
17. Ongoing Reconciliation and Maintenance of reference and master data.
Data Quality expectations
Hierarchical Relationships
Application DBA
Reference and Master Data Management
18. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Goals of DMBOK
Document Mgt.Functions
Data Implementation
Data Model/Design quality management
19. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Types of Data Management Organizations
Data Quality Dimensions
Types of Metadata
Metadata Management Functions
20. ERP
Data governance programScope elements
Procedural DBA
Financial master data
Common Activity Groups for DM Functions (PDCO)
21. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Product master data
Data Stewardship
Data Quality Management Functions
Reference Data Metadata may include...
22. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Data Management Synonyms
Data Integration Services
Regulatory Compliance examples
Data Operations Mgt
23. 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
Data Lifecycle complete
Regulatory Compliance examples
Knowledge management
24. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Data asset valuation
Non-strategic goals of data management
Data Security Management (PDE PP AAAA)
Data Quality expectations
25. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Data governance programScope elements
Hierarchical Relationships
Data Management Services(GAR MQD IP)
Semantic Modeling
26. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Procedural DBA
Information
Content Management
Reference Data Management
27. SOA - ETL - Replication - Message Brokers
Document vs. Content
Affiliation Relationship
Data Access Services
Data asset valuation
28. Discipline that fosters organizational learning and the management of intellectual capital.
Data Security Management (PDE PP AAAA)
Document
Knowledge management
Application DBA
29. Sarbanes-Oxley - financial reporting and auditing - HIPPA - privacy and security of health information - Basel II - Solvency II - PCI-DSS - Payment Card Industry Data Security Standards
Data asset valuation
Regulatory Compliance examples
Application DBA
Data Integration Services
30. 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.
Components of Data Strategy (VCP GMO RIRS)
Data Governance (EAC DMA)
Party master data
Business Intelligence
31. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Strategic goals of data management
Master Data
Metadata Architecture types
Inmon DW Approach
32. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office
Types of Data Management Organizations
Causes for Performance problems
Goals of DMBOK
Data Governance Deliverables (PPS IP SQV)
33. 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
Location master data
Data Management Synonyms
Kimball DW Approach
AAAA
34. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
To share consistent Reference and Master data - orgs need to understand...
Causes for Performance problems
Data Ops Mgt has 2 Subfunctions
Data Governance (EAC DMA)
35. 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
Location master data
ROLAP
Causes for Performance problems
DM Function Context Diagram overview (DG - ISP - T - DCM)
36. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope
Goals of DMBOK
Examples of individual roles participating in Data Mgt
DMBOK Recurring Themes
Asset
37. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.
Data Management
Ontology
Information
Physical Data Models
38. Stored in multidimensional data store
MOLAP
Kimball DW Approach
Affiliation Relationship
Common Activity Groups for DM Functions (PDCO)
39. 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.
Metadata for unstructured data types
Drivers for Reference and Master Data Management
Non-strategic goals of data management
Data Quality expectations
40. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Master Data Management
Metadata for unstructured data types
DM Function Context Diagram overview (DG - ISP - T - DCM)
41. DMS - Development - Maintenance - Support of structured data
Rules defined by Data Governance (PSP MBN DR )
Data Strategy Deliverables
Document
Data Operations Mgt
42. State names - codes - MedDRA code - WHO Drug Code
Inmon DW Approach
Reference Data - Examples
Reference Data Management
Data Integration Services
43. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Business Intelligence
Data
The PE - PPP - ACPDEV - DIA Data Management Acronym
Regulatory Compliance examples
44. 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)
Data Lifecycle complete
Conceptual Data Models
Data Management Professionals role
45. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Content Management
Conceptual Data Models
Inmon DW Approach
Data Management Professionals role
46. Customer - CRM Employee/workforce - HRM
Semantic Modeling
Common Activity Groups for DM Functions (PDCO)
Content Management
Party master data
47. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Common Activity Groups for DM Functions (PDCO)
Kimball DW Approach
DOLAP
Logical Data Model
48. 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 Ops Mgt has 2 Subfunctions
Conceptual Data Models
Guiding Principles of data management
Application DBA
49. Data stored in combination of ROLAP and MOLAP
Goals of DMBOK
Ten Functions of Data Management
Data Management
HOLAP
50. 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
Reference Data Metadata may include...
ROLAP
Data Quality Dimensions
Types of Data Management Organizations