Data Management Foundations - WGU C175 Practice Questions |100% Correct|

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