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. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.






2. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).






3. Information mgt - Enterprise Information mgt - Enterprise Data mgt - Data Resource mgt - Information Resource mgt - Information Asset mgt






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






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






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






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






8. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication






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






10. Control over defined domain values - i.e. Vocabularies.






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






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






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






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






15. Expert technical custodians of data assets






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






17. Data stored in Relational DB store






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






19. Shared between Data Management Professionals in IT - and Business Data Stewards.






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






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






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






23. DM Program Charter - SCOPE statement - Implementation Roadmap






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






25. Data stored in combination of ROLAP and MOLAP






26. Policies - Procedures - Standards - Issues - Projects - Services - Quality Data and Info - Recognized Data Value






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






28. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.






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






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






31. DSA - Descriptive metadata (Catalog information - thesauri keyword terms) - Structural metadata (Dublin core - field structures - XML schema) - ADMINISTRATIVE metadata (Source - integration/update schedule - access rights - page relationships)






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






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






34. Database Support and Data Technology Management






35. 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)






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






37. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope






38. ETL Source to target mappings






39. TMAC Taxonomy - Metadata - Access - Quality






40. A high-level course of action to achieve data goals. Usually a data management program strategy.






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






42. Modeling and design standards






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






44. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.






45. Activities and Activity Groups






46. The Exercise of Authority and Control over the Management of Data Assets.






47. SOA - ETL - Replication - Message Brokers






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






49. PIBRA Plan - Implement Doc/Record Mgt System - Backup - Retain - Audit






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