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. Control over defined domain values - i.e. Vocabularies.






2. Customer - CRM Employee/workforce - HRM






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






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






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






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






7. Data stored in combination of ROLAP and MOLAP






8. Data stored in Relational DB store






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






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






11. Data specifically constructed for query and analysis






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






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






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






15. Any file or record






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






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






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






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






20. Appointed trustees for data assets






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






22. Expert technical custodians of data assets






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






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






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






26. TMAC Taxonomy - Metadata - Access - Quality






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






28. WHO needs WHAT info? - What data is available from different sources? - How does data from different sources DIFFER? - How can inconsistencies be RECONCILED? - How should most valid values be SHARED effectively and efficiently?






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






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






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






32. Stored in multidimensional data store






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






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






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






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






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






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






39. SOA - ETL - Replication - Message Brokers






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






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






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






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






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






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






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






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






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






49. Memory allocation - Locking/blocking - Failure to update Stats - Poor SQL - Insufficient Indexing - Application Activity - Increase in Number/Size of DBs - Db Volatility






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