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. Any file or record






2. Activities and Activity Groups






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






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






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






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






7. Done by DBA - collab with DA.






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






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






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






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






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






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






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






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






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






17. Appointed trustees for data assets






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






19. Data specifically constructed for query and analysis






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






21. SOA - ETL - Replication - Message Brokers






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






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






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






25. Customer - CRM Employee/workforce - HRM






26. Data stored in combination of ROLAP and MOLAP






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






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






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






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






31. Stored in multidimensional data store






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






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






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






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






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






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






38. DM Program Charter - SCOPE statement - Implementation Roadmap






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






40. Ongoing Reconciliation and Maintenance of reference and master data.






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






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






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






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






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






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






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






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






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






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