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. Representation of facts - as Text - Numbers - Graphics - Images - Sound - or Video.






2. ETL Source to target mappings






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






4. Modeling and design standards






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






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






7. Done by DBA - collab with DA.






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






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






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






11. Any file or record






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






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






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






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






16. TMAC Taxonomy - Metadata - Access - Quality






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






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






19. Data stored in combination of ROLAP and MOLAP






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






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






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






24. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






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






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






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






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






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






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






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






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






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






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






37. Top - Definition and List of Goals - Center - List of that function's Activities - Left - Inputs - Suppliers - Participants - Below - Tools used for activities - Right - Primary DELIVERABLES - Consumers - Metrics






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






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






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






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. A high-level course of action to achieve data goals. Usually a data management program strategy.






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






44. Activities and Activity Groups






45. Data stored in Relational DB store






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






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






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






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






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