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. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.






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






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






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






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






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






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






8. Data stored in combination of ROLAP and MOLAP






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






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






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






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






13. Database Support and Data Technology Management






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






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






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






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






18. Stored in multidimensional data store






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






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






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






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






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






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






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






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






27. ODS - Current-valued - volatile data for operational reporting needs - DW - Historical - non-volatile data for single source of integrated data for corporation - DM - DSS for a department analytic need






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






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






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






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






32. SOA - ETL - Replication - Message Brokers






33. Data stored in Relational DB store






34. Discipline that fosters organizational learning and the management of intellectual capital.






35. ETL Source to target mappings






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






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






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






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






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






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






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






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






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






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






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






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






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






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