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. SITNSH - Subject oriented - Integrated - Time-variant (snapshots of data) - Non-volatile (no updates) - Summarized and Detailed data - Historical






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






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






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






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






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






7. Expert technical custodians of data assets






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






9. DM Program Charter - SCOPE statement - Implementation Roadmap






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






11. Data specifically constructed for query and analysis






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






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






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






15. Done by DBA - collab with DA.






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






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






18. Any file or record






19. ERP






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






21. Customer - CRM Employee/workforce - HRM






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






38. Responsible Trustee of data - Understand and Comply with Regulations- Define data security Reqts Collaboratively - ID detailed application security reqts in each app dev project - Every user acct. has password - Use Role Groups- Formally track/approv






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






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






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






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






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






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






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






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






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






48. ETL Source to target mappings






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






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