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






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






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






4. Modeling and design standards






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






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






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






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






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






10. Data specifically constructed for query and analysis






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






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






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






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






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






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






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






18. SOA - ETL - Replication - Message Brokers






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






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






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






22. Database Support and Data Technology Management






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






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






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






26. Data stored in Relational DB store






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






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






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






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






31. ETL Source to target mappings






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






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






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






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






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






37. ERP






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






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






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






41. Done by DBA - collab with DA.






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






43. Appointed trustees for data assets






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






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






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






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






48. Customer - CRM Employee/workforce - HRM






49. Expert technical custodians of data assets






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