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






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






3. Expert technical custodians of data assets






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






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






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






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






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






9. SOA - ETL - Replication - Message Brokers






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






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






12. Data specifically constructed for query and analysis






13. Modeling and design standards






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






15. Data stored in Relational DB store






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






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






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






19. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






22. Done by DBA - collab with DA.






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






24. Customer - CRM Employee/workforce - HRM






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






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






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






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






29. Data stored in combination of ROLAP and MOLAP






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






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






32. ETL Source to target mappings






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






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






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






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






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






38. Stored in multidimensional data store






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






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






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






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






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






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






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






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






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






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






49. ERP






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