WGU C175 Data Management Foundations Questions and Answers Already Passed

Document Content and Description Below

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

Last updated: 2 years ago

Preview 1 out of 28 pages

Buy Now

Instant download

We Accept: