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. State names - codes - MedDRA code - WHO Drug Code






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






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






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






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






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






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






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






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. Activities and Activity Groups






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






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






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






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






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






17. Data specifically constructed for query and analysis






18. Stored in multidimensional data store






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






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






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






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






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






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






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






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






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






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






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






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






32. Data stored in Relational DB store






33. Expert technical custodians of data assets






34. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






37. Customer - CRM Employee/workforce - HRM






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






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






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






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






42. SOA - ETL - Replication - Message Brokers






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






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






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






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






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






48. 1. Modeling - Analysis - Design (Reqts - Conc - Log - Phys Models) 2. Detailed Data Design (Phys DBs - Info Products - Access - Integration Services) 3. Quality Management (Modeling/Design Standards - Review Models - Versioning/Integration of Models)






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






50. ERP