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. Data stored in combination of ROLAP and MOLAP






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






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






4. Database Support and Data Technology Management






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






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






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






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






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






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






11. Data stored in Relational DB store






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






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






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






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






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






17. Customer - CRM Employee/workforce - HRM






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






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






20. Data specifically constructed for query and analysis






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






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






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






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






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






26. FDPPOS - Functions - Definitions - Principles - Practices - Organization - Scope






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






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






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






30. ERP






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






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






33. The planning and execution of...policies - practices - and projects that...acquire - control - protect - deliver - and enhance the value of...data and information assets.






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






35. TMAC Taxonomy - Metadata - Access - Quality






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






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






38. ETL Source to target mappings






39. Any file or record






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






41. Appointed trustees for data assets






42. SQIEC "Squiec" - Stewardship - Quality - Integration - Enterprise - Cultural change leadership






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






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






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






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






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






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






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






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






Sorry, Topic not found.:)Seach or Brouse Basicversity:


Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT
//