Test your basic knowledge |

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. Control over defined domain values - i.e. Vocabularies.






2. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.






3. SOA - ETL - Replication - Message Brokers






4. 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.






5. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules






6. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.






7. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical






8. High level perspective on a subject area of importance to the business.






9. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership






10. Data stored in Relational DB store






11. Often formed between vocabulary terms - either as a KIND-OF or a PART-OF relationship.






12. 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






13. Centralized Data Warehouse designed to serve the BI needs of the entire organization. Adheres to the Enterprise Data Model (EDM).






14. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office






15. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.






16. 1. Integrated Decision Support Database 2. All the software used to collect - cleanse - transform - store data






17. 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






18. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]






19. Business function of planning for - controlling - and delivering data and information assets. PDC-A






20. PPTIER Profiling - Parsing/Standardization - Transformation - Identity Resolution and Mapping - Enhancement - Reporting






21. 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






22. 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






23. Created/acquired - stored - used - destroyed.






24. 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.






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






26. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility






27. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools






28. 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?






29. DM Program Charter - SCOPE statement - Implementation Roadmap






30. Query - analysis and reporting off of the DW.






31. Data specifically constructed for query and analysis






32. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.






33. (ARPM Bit Mikes PP) ARPM (Awareness - Requirements - Profile - Metrics) - BTS (Business Rules - Test requirements - Service levels) - PP (Measure/monitor - Issues - Clean - Procedures - Performance)






34. Data is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?






35. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content






36. TMAC Taxonomy - Metadata - Access - Quality






37. 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






38. Formal accountability for business responsibilities ensuring effective control and use of data assets.






39. ERP






40. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.






41. Data stored in combination of ROLAP and MOLAP






42. Appointed trustees for data assets






43. Virtual OLAP cube available as proprietary function of a classic relational database






44. Knowledge modeling. Ontology is a semantic model that describes Knowledge.






45. Customer - CRM Employee/workforce - HRM






46. 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






47. Database Support and Data Technology Management






48. 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.






49. Discipline that fosters organizational learning and the management of intellectual capital.






50. DMS - Development - Maintenance - Support of structured data