WGU 4426 DATA MANAGEMENT FOUNDATIONS PRACTICE EXAM/ WGU D426 DATA MANAGEMENT FOUNDATIONS STUDY GUIDE ALL QUESTIONS AND CORRECT ANSWERS/ BEST GRADED A+

Page 1 of 16 WGU 4426 DATA MANAGEMENT FOUNDATIONS PRACTICE EXAM/ WGU D426 DATA MANAGEMENT FOUNDATIONS STUDY GUIDE ALL QUESTIONS AND CORRECT ANSWERS/ BEST GRADED A+ An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. - ANSWER: Associative Entity An attribute is a property or characteristic of an entity. - ANSWER: Attribute A binary relationship is a relationship between two entity types. - ANSWER: Binary relationship Is any column or a combination of columns that can qualify as unique key in database. - ANSWER: Candidate Key Cardinality represents the maximum number of entities that can be involved in a particular relationship. - ANSWER: Cardinality Usually the result of a missing join condition or a method of expanding the data of 1 table by the number of rows in the second table. - ANSWER: Cartesian product What is a file having no internal hierarchy - ANSWER: Flat files 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 - ANSWER: Heap files Page 2 of 16 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. - ANSWER: Index files 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 - ANSWER: Hashed files What are some advantages of a DBMS - ANSWER: -Improved data sharing -Improved data security -Better data integration -Minimized data inconsistency -Improved data access -Improved decision making -Increased end-user productivity What is a database that is designed primarily to support a company's day-to-day operations - ANSWER: Operational database, also known as an online transaction processing (OLTP) database, transactional database, or production database What type of database focuses primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making - ANSWER: Analytical database What are the two components of a analytical database - ANSWER: Data warehouse, Online analytical processing (OLAP) front end