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






2. ETL Source to target mappings






3. Data stored in Relational DB store






4. LEGISLATIVE branch - Policies and standards - JUDICIAL branch - Issue management - EXECUTIVE branch - administration - services - and compliance






5. DB implementation and change management - Test Data creation - Data migration/conversion programs - User training - Documentation






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






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






8. GADR PTO "Gatter Riptoe" - Goals/Principles - Activities - Deliverables - Roles - Practices - Technology - Org/Culture






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






10. Activities and Activity Groups






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






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






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






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






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






17. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.






18. Security - DB Recovery and Retention - Access and Use of Externally Sourced Data - Sharingdata internally and externally - DW/BI policies






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






20. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.






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






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






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






24. State names - codes - MedDRA code - WHO Drug Code






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






40. Data stored in combination of ROLAP and MOLAP






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






42. TMAC Taxonomy - Metadata - Access - Quality






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






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






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






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






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






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






49. DM Program Charter - SCOPE statement - Implementation Roadmap






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