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. Customer - CRM Employee/workforce - HRM






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






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






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






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






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






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






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






9. Modeling and design standards






10. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






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






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






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






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






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






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






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. Source Systems - Staging Area - Data Presentation Area/DW - Data Access Tools






21. Database Support and Data Technology Management






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






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






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






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






26. Data stored in Relational DB store






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






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






29. TMAC Taxonomy - Metadata - Access - Quality






30. Improve data Quality and Integration... Provide onsolidated 360 degree view of information about important business entities (Party - Product - Location - Financial Structure).






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






33. SOA - ETL - Replication - Message Brokers






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






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






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






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






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






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






40. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.






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






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






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






44. Data stored in combination of ROLAP and MOLAP






45. ETL Source to target mappings






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






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






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






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






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