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. Data specifically constructed for query and analysis
Data Development Activities (MDQI)
Kimball DW Approach
Data Management
Asset
2. Discipline that fosters organizational learning and the management of intellectual capital.
Knowledge management
Rules defined by Data Governance (PSP MBN DR )
Reference Data - Examples
Reference and Master Data Management
3. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
Data Warehouse primary components
Data Operations Mgt
Enterprise Data Warehouse
Data Policies
4. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Data Ops Mgt has 2 Subfunctions
Information
Enterprise Data Warehouse
Party master data
5. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Logical Data Model
Rules defined by Data Governance (PSP MBN DR )
Common Activity Groups for DM Functions (PDCO)
Data Stewardship
6. 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
Application DBA
Metadata for unstructured data types
Data Ops Mgt - Guiding Principles
7. 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.
Product master data
Metadata Management Functions
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Management
8. Establishment and maintenance of Relationships between master data records.
Business Intelligence
Detailed Data Design
Procedural DBA
Affiliation Relationship
9. Query - analysis and reporting off of the DW.
Business Intelligence
Taxonomies - 4 types
Rules defined by Data Governance (PSP MBN DR )
Data Operations Mgt
10. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Kimball key components
The PE - PPP - ACPDEV - DIA Data Management Acronym
Non-strategic goals of data management
Data Implementation
11. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value
Location master data
Data Access Services
Data Governance Deliverables (PPS IP SQV)
Physical Data Models
12. Business function of planning for - controlling - and delivering data and information assets. PDC-A
Data Management
Data Strategy
Data Quality Dimensions
Master Data
13. 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
Regulatory Compliance examples
Strategic goals of data management
Common Activity Groups for DM Functions (PDCO)
Data Policies
14. 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 Management
Reference Data Management
Data security guiding principles
DMBOK Recurring Themes
15. SOA - ETL - Replication - Message Brokers
Enterprise Data Warehouse
Data Access Services
Data security guiding principles
Knowledge management
16. 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
Reference Data Management
Types of Metadata
Reference Data Metadata may include...
Knowledge
17. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Procedural DBA
Ontology
Party master data
Data Management
18. 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)
Drivers for Reference and Master Data Management
Data Quality tools
19. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.
Data Access Services
Data Model/Design quality management
Hierarchical Relationships
Types of Metadata
20. Control over defined domain values - i.e. Vocabularies.
Strategic goals of data management
Ontology
Document Management
Reference Data Management
21. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Application DBA
Data governance programScope elements
Data Operations Mgt
22. Stored in multidimensional data store
Goals of DMBOK
Data Governance (EAC DMA)
Reference Data - Examples
MOLAP
23. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]
Kimball DW Approach
Enterprise Data Warehouse
Metadata Management Functions
Semantic Modeling
24. 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)
Data Strategy Deliverables
Taxonomies - 4 types
Knowledge management
Data Implementation
25. 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)
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Quality expectations
Data Development Activities (MDQI)
Data Warehouse primary components
26. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical
Party master data
Inmon DW Approach
Data Strategy
Data Governance Deliverables (PPS IP SQV)
27. The Exercise of Authority and Control over the Management of Data Assets.
Metadata Architecture types
Data Management functions breakdown into
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Governance (EAC DMA)
28. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Kimball key components
Metadata for unstructured data types
Data Warehouse primary components
The PE - PPP - ACPDEV - DIA Data Management Acronym
29. Shared between Data Management Professionals in IT - and Business Data Stewards.
To share consistent Reference and Master data - orgs need to understand...
Inmon DW Approach
Data Management Shared responsibility
Data Quality tools
30. 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 governance programScope elements
Data Security Management (PDE PP AAAA)
Data Management Professionals role
AAAA
31. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Examples of individual roles participating in Data Mgt
Affiliation Relationship
Types of Data Management Organizations
Master Data
32. 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 asset valuation
Inmon ODS - DW - DM distinction
Rules defined by Data Governance (PSP MBN DR )
Common Activity Groups for DM Functions (PDCO)
33. 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.
Goals of DMBOK
HOLAP
Data Management Synonyms
Non-strategic goals of data management
34. 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
Detailed Data Design
Data Management functions breakdown into
Data Stewards
Data Quality Dimensions
35. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.
Data Quality Management Functions
The PE - PPP - ACPDEV - DIA Data Management Acronym
Data Quality tools
Asset
36. 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
Kimball key components
Data Quality Management lifecycle
Guiding Principles of data management
Data Model/Design quality management
37. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).
Data Ops Mgt has 2 Subfunctions
Inmon ODS - DW - DM distinction
Types of Data Management Organizations
Drivers for Reference and Master Data Management
38. Appointed trustees for data assets
Data Stewards
Logical Data Model
MOLAP
Data governance programScope elements
39. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.
The PE - PPP - ACPDEV - DIA Data Management Acronym
Business Intelligence
Data Management Services(GAR MQD IP)
Data Integration Services
40. State names - codes - MedDRA code - WHO Drug Code
DMBOK Recurring Themes
Data Management
Reference Data - Examples
Rules defined by Data Governance (PSP MBN DR )
41. Database Support and Data Technology Management
Rules defined by Data Governance (PSP MBN DR )
Data Ops Mgt has 2 Subfunctions
Document
Data Model/Design quality management
42. 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
Content Mgt Functions
Examples of individual roles participating in Data Mgt
Data Governance Deliverables (PPS IP SQV)
43. DM Program Charter - SCOPE statement - Implementation Roadmap
Data governance like real Government
Data Strategy Deliverables
Inmon DW Approach
Data Stewardship
44. 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
Inmon DW Approach
Strategic goals of data management
Metadata Architecture types
45. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
Data Quality tools
Types of Metadata
Causes for Performance problems
MOLAP
46. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Metadata Architecture types
Reference and Master Data Management
To share consistent Reference and Master data - orgs need to understand...
Data Management Functions
47. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations
Rules defined by Data Governance (PSP MBN DR )
DMBOK Recurring Themes
Master Data
Data Management functions breakdown into
48. 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
ROLAP
Metadata Architecture types
Guiding Principles of data management
Metadata Management Functions
49. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
Rules defined by Data Governance (PSP MBN DR )
Asset
Affiliation Relationship
Knowledge
50. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Data Security in an outsourced wolrd
DMBOK Recurring Themes
Semantic Modeling
Kimball key components