DATA MANAGEMENT FOUNDATIONS - WGU C175 QUESTIONS WITH CORRECT ANSWERS

ad hoc query Correct Answer A "spur-of-the-moment" question analytical database Correct Answer A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability Correct 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 Correct Answer A database located at a single site cloud database Correct Answer A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS data Correct Answer Raw facts, or facts that have not yet been processed to reveal their meaning to the end user data anomaly Correct 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 Correct Answer A data condition in which data representation and manipulation are dependent on the physical data storage characteristics data dictionary Correct Answer A DBMS component that stores metadata. Contains the data definition, as well as their characteristics and relationships data inconsistency Correct Answer A condition in which different versions of the same data yield different results data independence Correct Answer A condition in which data access is unaffected by changes in the physical data storage characteristics data integrity Correct Answer In a relational database, a condition in which the data in the database complies with all entity and referential integrity constraints data management Correct Answer A process that focuses on data collection, storage, and retrieval. data processing (DP) specialist Correct Answer The person responsible for developing and managing a computerized file processing system