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. More detailed than Conceptual Data Model - adding: Normalization - Abstraction - Still technology independent.






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






3. Data stored in Relational DB store






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






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






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






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






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






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






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






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






12. Customer - CRM Employee/workforce - HRM






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






14. Appointed trustees for data assets






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






16. Query - analysis and reporting off of the DW.






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






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






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






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






21. Data specifically constructed for query and analysis






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






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






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






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






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






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






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






29. Done by DBA - collab with DA.






30. TMAC Taxonomy - Metadata - Access - Quality






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






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






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






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






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






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






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






38. Stored in multidimensional data store






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






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






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






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






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






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






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






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






47. Expert technical custodians of data assets






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






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






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