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. Modeling and design standards






2. Data stored in combination of ROLAP and MOLAP






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






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






5. Stored in multidimensional data store






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






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






8. Customer - CRM Employee/workforce - HRM






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






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






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






12. Data stored in Relational DB store






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






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






15. Planning - Development and Execution of - Policies and Procedures to provide proper - Authentication - Authorization - Access - and Auditing of - Information Assets.






16. DM Program Charter - SCOPE statement - Implementation Roadmap






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






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






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






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






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






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






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






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






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. Resources with recognized valued under the control of an individual or organization. Data and information are enterprise assets.






27. SOA - ETL - Replication - Message Brokers






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






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






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






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






32. Database Support and Data Technology Management






33. TMAC Taxonomy - Metadata - Access - Quality






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






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






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. Plan - Specify - Enable - Create - Use - Retrieve - Purge






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






39. Expert technical custodians of data assets






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






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






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






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






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






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






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






47. Data specifically constructed for query and analysis






48. Appointed trustees for data assets






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






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