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. Accuracy - degree data reflects real life entities] - [Completeness - both cols and rows - Consistency - Consistent data values between data sets - Currency - current with real world situation] - [Precision - level of detail - Privacy - access contr






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






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






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






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






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






7. TMAC Taxonomy - Metadata - Access - Quality






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






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






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






11. Data stored in Relational DB store






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






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






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






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






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






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






18. Data specifically constructed for query and analysis






19. Data in context. Business meaning - Format of data presentation - Timeframe - Relevance of data for a given usage.






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






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






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






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






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






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






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






27. Activities and Activity Groups






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






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






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






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






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






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






34. DMS - Development - Maintenance - Support of structured data






35. Appointed trustees for data assets






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






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






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






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






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






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






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






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






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






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






46. Database Support and Data Technology Management






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






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






49. DM Program Charter - SCOPE statement - Implementation Roadmap






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