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. Expert technical custodians of data assets






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






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






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






5. Data specifically constructed for query and analysis






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






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






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






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






10. Data Strategy and Policies - Standards and Architecture - Regulatory Compliance - Issue management - PROJECTS - Valuation - Communication






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






12. SOA - ETL - Replication - Message Brokers






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






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






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






16. G ADO SQ RIDM - Governance - Architecture - Development - Operations - Security - Quality - Reference/Master Data Mgt - DW/Business Intelligence - Document and Content Management - Metadata Management.






17. RAS - ICIM - DR [Requirements - Architecture - Standards] - [Implement Managed Metadata Environment Capture Metadata - Integrate Metadata - Metrics on Metadata[ - [Deliver Metadata - Report on Metadata]






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






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






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






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






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






23. Any file or record






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






25. 1. Data Mgt Service orgs (EIM COE) 2. Data Governance Council 3. Data Stewardship Steering Committee 4. Data Stewardship Teams 5. Data Governance Office






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






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






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






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






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






31. Stored in multidimensional data store






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






33. Short statements of Management Intent and fundamental Rules governing creation - acquisition - integrity - security - quality - and use of data and information. Describe WHATs - and What NOTs; do not describe HOWs.






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






35. Data stored in Relational DB store






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






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






38. ETL Source to target mappings






39. BTPD Business (Definitions - rules - data lineage - quality statements - report lists - etc.) - Targetd at Business - Technical and operational (Information about SYSTEMS. DBs - column names - files - etls - etc) - Targeted at IT Operations users' n






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






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






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. Document mgt- not concerned with insides of the file. - Content mgt - looks at inside of file and tries to identify the content.






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






45. Modeling and design standards






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






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






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






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






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