WGU C724 Unit 4 test Questions and answers, 100% Accurate, VERIFIED. 2024/25

WGU C724 Unit 4 test Questions and answers, 100% Accurate, VERIFIED. What are tuples and how are they used in databases? - -one record or data set in a row. A record in a row or table What is the description of a flat file database? - -single table database What is data integrity? - -data is accurate and consistent through its use and application time A database schema can be represented by which model? - -ERD (entity relationship model) describes the data and map processes to data requirements What takes place during the database design process to eliminate data redundancy? - -normalization Why did relational database models replace hierarchical database models in business applications? - -they are simpler table relationships than hierarchical databases What size is big data database considered? - -petabyte Why are data warehouses beneficial to business managers? - -they can be mined or analyzed for trends or patterns What is the definition of data integrity? - -a process to ensure data is not corrupted It is a good practice to _________________ data that is backed up on a regular basis. - -reduce Why is it not good practice to perform analytics on an online transaction processing database? - analytics would affect the database performance What can be used to predict future outcomes or trends, but it does not tell you what will happen in the future? - -predictive analysis Where would metadata about customer and product tables be stored? - -data dictionary