WGU C175 Data Management-Foundations answers and questions 100% verified.

WGU C175 Data Management-Foundations answers and questions 100% verified. Flat files - correct answers.What is a file having no internal hierarchy Heap files - correct answers.What are files containing an unsorted set of records that are uniquely identified by a record id which allows them to be inserted or deleted using that id Index files - correct answers.What are files that store a list of lookup field values from a data file - along with the location (address) in the data file of the corresponding record. Because the lookup field is much smaller than the entire record, the entire index will usually fit in main memory for quick look up. Once the address of the record is obtained from the index, the entire record can then be directly accessed from the data file instead of reading in the entire data file - record by record, in order to locate the desired one. Hashed files - correct answers.What are files are encrypted using hash functions that convert data consisting of various formats into numeric values. This allows for faster data lookup without the use of an index file -Improved data sharing -Improved data security -Better data integration -Minimized data inconsistency -Improved data access -Improved decision making -Increased end-user productivity - correct answers.What are some advantages of a DBMS