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. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.






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






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






4. Data specifically constructed for query and analysis






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






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






7. Modeling and design standards






8. Data stored in combination of ROLAP and MOLAP






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






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






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






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






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






14. Appointed trustees for data assets






15. Stored in multidimensional data store






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






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






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






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






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






21. Activities and Activity Groups






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






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






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






25. Expert technical custodians of data assets






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






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






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






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






30. Customer - CRM Employee/workforce - HRM






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






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






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






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






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






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






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






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. Process - Tools - and Techniques for Organizing - Categorizing and Structuring access to Information Content






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






41. SOA - ETL - Replication - Message Brokers






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






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






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






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






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






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






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






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






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