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. Ongoing Reconciliation and Maintenance of reference and master data.






2. Data about the business entities that provide context for busines stransactions. e.g. Parties - Products - Financial Structures - Locations






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. The Exercise of Authority and Control over the Management of Data Assets.






5. Expert technical custodians of data assets






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






7. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






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






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






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






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






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






15. Activities and Activity Groups






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






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






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






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






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






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






22. Data stored in Relational DB store






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






24. SOA - ETL - Replication - Message Brokers






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






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






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






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






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






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






31. TMAC Taxonomy - Metadata - Access - Quality






32. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.






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






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






35. Done by DBA - collab with DA.






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






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






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






39. Appointed trustees for data assets






40. Modeling and design standards






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






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






43. Data stored in combination of ROLAP and MOLAP






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






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






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






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






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






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






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