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. Technology specific - denormalized for performance - Surrogate keys - Indexing - Views -






2. Activities and Activity Groups






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






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






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






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






7. ERP






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






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






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






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






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






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






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






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






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






17. Any file or record






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






19. SOA - ETL - Replication - Message Brokers






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






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






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






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






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






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






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






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






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






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






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






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






32. Modeling and design standards






33. Data is Intangible Asset - usually in Goodwill category. ways to value: Cost of Loss of data..What would Competitors pay for this data?






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






35. Customer - CRM Employee/workforce - HRM






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






37. Appointed trustees for data assets






38. TMAC Taxonomy - Metadata - Access - Quality






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






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






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






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






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






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






45. PLM - Product lifecycle management systems - enable cross-process cost and legal agreements tracking as product concepts evolve from one idea to many potential products under different names and potentially different licensing agreements.






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






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






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






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






50. Done by DBA - collab with DA.