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. SOA - ETL - Replication - Message Brokers






2. Write everything down - Keep everything - Automate - Purpose (Why?) for each task - Don't panic - Business interest - Collaborate






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






4. Customer - CRM Employee/workforce - HRM






5. SIC - Storage - Inventory - and Control of EPD - Electronic and Paper Documents.






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






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






8. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -






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






10. Responsibility for a Specific Database(s) in all of its environments - rather than database System administration.






11. Stored in multidimensional data store






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






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






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






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






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






17. Modeling and design standards






18. ETL Source to target mappings






19. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.






20. Any file or record






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






22. Type of model that represents a set of concepts and their relationships within a domain.






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






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






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






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






27. Data Architect - Business Process Analyst- Chief Knowledge Officer (CKO) - IT Auditor - Government and Regulatory Bodies






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






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






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






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






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






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






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






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






36. Establishment and maintenance of Relationships between master data records.






37. CRUD matrices that map data responsibilities across bus process - applications - roles - and organizations. - RACI matrix with clearn accountability and ownership.






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






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






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






41. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.






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






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






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






45. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






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






49. Data stored in Relational DB store






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