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






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






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






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






5. Appointed trustees for data assets






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






7. TMAC Taxonomy - Metadata - Access - Quality






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






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






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






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






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






13. ETL Source to target mappings






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






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






16. Modeling and design standards






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






18. SOA - ETL - Replication - Message Brokers






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






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






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






22. Database Support and Data Technology Management






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






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






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






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






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






28. Data stored in combination of ROLAP and MOLAP






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






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






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






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






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






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






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






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






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






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






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






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






41. Customer - CRM Employee/workforce - HRM






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






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






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






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






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






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






48. Understand info Needs of enterprise and its stakeholders. - Capture - store - protect - and ensure integrity of Data Assets. - Continually improve Quality of data and information. - Ensure Privacy and Confidentiality - Maximize Effective use and VALU






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






50. DSA - Descriptive metadata (Catalog information - thesauri keyword terms) - Structural metadata (Dublin core - field structures - XML schema) - ADMINISTRATIVE metadata (Source - integration/update schedule - access rights - page relationships)