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 is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?






2. Control over master data values to enable consistent - shared - contextual use across systems - of the most Accurate - Current - Relevant version of truth about Essential business entitites.






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






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






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






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






7. Modeling and design standards






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






9. Data stored in Relational DB store






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






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






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






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






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






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






16. Activities and Activity Groups






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






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






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






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






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






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






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






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






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






26. Plan - Specify - Enable - Create - Use - Retrieve - Purge






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






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






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






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






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






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






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






34. 1. Data and info are valuable enterprise ASSETs 2. Manage data/info carefully - like any other asset - by ensuring Quality - Security - Integrity - Protection - Availability - Understanding - and Effective Use. 3. Share responsibility between busines






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






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






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






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






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






40. Done by DBA - collab with DA.






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






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






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






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






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






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






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






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






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






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