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. Modeling and design standards






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






3. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






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






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






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






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. Sarbanes-Oxley - financial reporting and auditing - HIPPA - privacy and security of health information - Basel II - Solvency II - PCI-DSS - Payment Card Industry Data Security Standards






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






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






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






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






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






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






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






19. Activities and Activity Groups






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






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






22. ERP






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






24. Appointed trustees for data assets






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






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






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






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






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






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






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






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






33. Information in perspective - integrated into a viewpoint based on the recognition of Patterns - trnends - assumptions - etc.






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






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






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






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






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






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






40. Policies - Standards - Procedures - Metrics - Business data Names - business Definitions - business Rules






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






42. Any file or record






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






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






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






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






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






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






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






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