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. Virtual OLAP cube available as proprietary function of a classic relational database






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






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






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






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






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






7. Expert technical custodians of data assets






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. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.






10. Data stored in Relational DB store






11. Modeling and design standards






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






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






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






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






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






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






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






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






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






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






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






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






24. Done by DBA - collab with DA.






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






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






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






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






29. Data stored in combination of ROLAP and MOLAP






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






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






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






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






34. Database Support and Data Technology Management






35. DM Program Charter - SCOPE statement - Implementation Roadmap






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






37. Location REFERENCE data includes geopolitical data - countries - states - provinces - counties...Location MASTER data includes business party addresses - geographic positioning coordinates - etc.






38. Meaning and purpose of each reference data value domain - Reference tables and databases where the reference data appears. - Source of the data in each table. - Version currently available. - When data was last updated. - How the data in each table i






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






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






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






42. Stored in multidimensional data store






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






44. TMAC Taxonomy - Metadata - Access - Quality






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






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






47. Customer - CRM Employee/workforce - HRM






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






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






50. SOA - ETL - Replication - Message Brokers