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
Data Management Professionals role
Data Lifecycle complete
Data Governance (EAC DMA)
Inmon DW Approach
2. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.
Data Integration Services
DMBOK Recurring Themes
Content Management
Knowledge
3. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content
Data Quality tools
Content Management
Data Stewardship
Application DBA
4. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.
Information
MOLAP
Data governance programScope elements
Data Management Functions
5. Database Support and Data Technology Management
Data Ops Mgt has 2 Subfunctions
Document
Data security guiding principles
To share consistent Reference and Master data - orgs need to understand...
6. 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
Guiding Principles of data management
Data governance programScope elements
Causes for Performance problems
Ontology
7. (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
Data Model/Design quality management
Data Stewardship
Data Ops Mgt - Guiding Principles
Ten Functions of Data Management
8. Expert technical custodians of data assets
ROLAP
Data Strategy
Data Governance (EAC DMA)
Data Management Professionals role
9. Done by DBA - collab with DA.
To share consistent Reference and Master data - orgs need to understand...
Metadata Management Functions
Inmon ODS - DW - DM distinction
Detailed Data Design
10. Query - analysis and reporting off of the DW.
Procedural DBA
Data Ops Mgt has 2 Subfunctions
Business Intelligence
Document
11. SOA - ETL - Replication - Message Brokers
Data Policies
Data Access Services
Causes for Performance problems
Document Mgt.Functions
12. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules
AAAA
Data Integration Services
Rules defined by Data Governance (PSP MBN DR )
Data Quality tools
13. 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 Stewardship
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality Management lifecycle
Document Mgt.Functions
14. Control over defined domain values - i.e. Vocabularies.
Data Strategy
Data Model/Design quality management
Reference Data Management
ROLAP
15. Modeling and design standards
Data Model/Design quality management
Document Management
MOLAP
Data Stewards
16. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.
Procedural DBA
Detailed Data Design
Inmon ODS - DW - DM distinction
HOLAP
17. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies
Data Quality expectations
Data Lifecycle Simple
Conceptual Data Models
The PE - PPP - ACPDEV - DIA Data Management Acronym
18. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.
Logical Data Model
To share consistent Reference and Master data - orgs need to understand...
Data governance like real Government
Causes for Performance problems
19. Data stored in Relational DB store
Affiliation Relationship
Party master data
Types of Data Management Organizations
ROLAP
20. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies
Data Security in an outsourced wolrd
Knowledge
Examples of individual roles participating in Data Mgt
Reference Data - Examples
21. Plan - Specify - Enable - Create - Use - Retrieve - Purge
Data Integration Services
Data Lifecycle complete
Data security guiding principles
Guiding Principles of data management
22. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility
DMBOK Environmental Elements
Causes for Performance problems
Ontology
Data Warehouse primary components
23. Activities and Activity Groups
HOLAP
Strategic goals of data management
Data Management functions breakdown into
Data Management Services(GAR MQD IP)
24. 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.
Inmon DW Approach
Reference and Master Data Management
Product master data
DOLAP
25. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)
Data Management Professionals role
Data Integration Services
Data Quality Management Functions
Semantic Modeling
26. Stored in multidimensional data store
MOLAP
Conceptual Data Models
Data Ops Mgt - Guiding Principles
Location master data
27. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance
DOLAP
Data governance like real Government
Data Quality Management Functions
Data Governance Deliverables (PPS IP SQV)
28. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting
Data Quality tools
Detailed Data Design
Procedural DBA
Data Lifecycle complete
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
Business Intelligence
Content Mgt Functions
Data Model/Design quality management
Regulatory Compliance examples
30. 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
Data Quality Management Functions
Conceptual Data Models
Affiliation Relationship
31. 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 Governance Deliverables (PPS IP SQV)
Content Management
Knowledge
Data Policies
32. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.
Document
Location master data
The PE - PPP - ACPDEV - DIA Data Management Acronym
Kimball DW Approach
33. TMAC Taxonomy - Metadata - Access - Quality
Data Strategy Deliverables
Document
Hierarchical Relationships
Content Mgt Functions
34. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation
Data Implementation
MOLAP
Ten Functions of Data Management
Data Model/Design quality management
35. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate
Data Ops Mgt - Guiding Principles
Drivers for Reference and Master Data Management
DOLAP
Metadata Management Functions
36. 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.
Rules defined by Data Governance (PSP MBN DR )
Components of Data Strategy (VCP GMO RIRS)
Examples of individual roles participating in Data Mgt
Non-strategic goals of data management
37. Knowledge modeling. Ontology is a semantic model that describes Knowledge.
Content Mgt Functions
Data Security Management (PDE PP AAAA)
Data Lifecycle Simple
Semantic Modeling
38. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication
Data governance programScope elements
Data Management Synonyms
Data Ops Mgt - Guiding Principles
Data Model/Design quality management
39. State names - codes - MedDRA code - WHO Drug Code
Metadata Management Functions
Kimball key components
Procedural DBA
Reference Data - Examples
40. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.
Common Activity Groups for DM Functions (PDCO)
DMBOK Recurring Themes
Document Management
Data Ops Mgt has 2 Subfunctions
41. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.
Enterprise Data Warehouse
Data Security in an outsourced wolrd
Data Policies
Regulatory Compliance examples
42. Any file or record
Document
Data Stewardship
Non-strategic goals of data management
Asset
43. 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
Non-strategic goals of data management
Physical Data Models
Data
44. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt
Data Warehouse primary components
Data Management Synonyms
Data Quality Management lifecycle
Goals of DMBOK
45. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data
ROLAP
Non-strategic goals of data management
Data Warehouse primary components
Semantic Modeling
46. Type of model that represents a set of concepts and their relationships within a domain.
DM Function Context Diagram overview (DG - ISP - T - DCM)
Data Quality Dimensions
DMBOK Environmental Elements
Ontology
47. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).
Data Governance (EAC DMA)
DOLAP
Enterprise Data Warehouse
Components of Data Strategy (VCP GMO RIRS)
48. 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 Stewards
Inmon ODS - DW - DM distinction
Document Mgt.Functions
Business Intelligence
49. ERP
Kimball key components
Data Implementation
Examples of individual roles participating in Data Mgt
Financial master data
50. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools
Guiding Principles of data management
Reference Data Metadata may include...
Kimball key components
Data Quality expectations