Data Management Foundations - WGU C175 exam (100% correct and graded A+)

ad hoc query - Answer-A "spur-of-the-moment" question analytical database - Answer-A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability - Answer-In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database - Answer-A database located at a single site cloud database - Answer-A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS data - Answer-Raw facts, or facts that have not yet been processed to reveal their meaning to the end user data anomaly - Answer-An abnormality of the data in which inconsistent changes have been made to a database (For example, an employee moves, but the address changes is not corrected in all files in the database) data dependence - Answer-A data condition in which data representation and manipulation are dependent on the physical data storage characteristics data dictionary - Answer-A DBMS component that stores metadata. Contains the data definition, as well as their characteristics and relationships data inconsistency - Answer-A condition in which different versions of the same data yield different results data independence - Answer-A condition in which data access is unaffected by changes in the physical data storage characteristicsdata integrity - Answer-In a relational database, a condition in which the data in the database complies with all entity and referential integrity constraints data management - Answer-A process that focuses on data collection, storage, and retrieval. data processing (DP) specialist - Answer-The person responsible for developing and managing a computerized file processing system data redundancy - Answer-Exists when the same data is stored unnecessarily at different places database - Answer-A shared, integrated computer structure that houses a collection of related data including end-user data (raw facts) and metadata (data about the data) database design - Answer-The process that yields the description of the database structure and determines the database components. The second phase of the database life cycle