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. Responsible for development and support of procedural logic controlled and executed by the DBMS. Triggers - sprocs - functions.






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






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






4. ETL Source to target mappings






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






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






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






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






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






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






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






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






13. Data stored in Relational DB store






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






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






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






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






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






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






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






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






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






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






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






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






26. Stored in multidimensional data store






27. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






30. TMAC Taxonomy - Metadata - Access - Quality






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






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






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






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






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






36. Data is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?






37. Appointed trustees for data assets






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






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






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






41. Plan - Specify - Enable - Create - Use - Retrieve - Purge






42. Modeling and design standards






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






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






45. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.






46. Database Support and Data Technology Management






47. Data specifically constructed for query and analysis






48. Activities and Activity Groups






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






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