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






2. Done by DBA - collab with DA.






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






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






5. Data stored in combination of ROLAP and MOLAP






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






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






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






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






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






11. Modeling and design standards






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






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






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






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






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






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






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






19. Governance coordination - Architecture definition and coordination - Information requirements analysis - data modeling facilitation - data quality analysis - traditional db design - implementation - production support services.






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






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






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






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






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






25. SOA - ETL - Replication - Message Brokers






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






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






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






29. Activities and Activity Groups






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






31. Database Support and Data Technology Management






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






33. Stored in multidimensional data store






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






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






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






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






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






39. TMAC Taxonomy - Metadata - Access - Quality






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






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






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






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






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






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






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






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






48. ERP






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






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