WGU C175 Data Management Foundations – Exam with Guaranteed 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 data redundancy - correct answer Exists when the same data is stored unnecessarily at different places database - correct 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 - correct answer The process that yields the description of the database structure and determines the database components. The second phase of the database life cycle database management system (DBMS) - correct answer The collection of programs that manages the database structure and controls access to the data stored in the database database system - correct answer An organization of components that defines and regulates the collection, storage,