WGU C724 Unit 4 Exam with Complete Solutions

What are tuples and how are they used in databases? - ANSWER one record or data set in a row. A record in a row or table What is the description of a flat file database? - ANSWER single table database What is data ...

What are tuples and how are they used in databases? - ANSWER one record or data set in a row. A record in a row or table What is the description of a flat file database? - ANSWER single table database What is data integrity? - ANSWER data is accurate and consistent through its use and application time A database schema can be represented by which model? - ANSWER 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? - ANSWER normalization Why did relational database models replace hierarchical database models in business applications? - ANSWER they are simpler table relationships than hierarchical databases What size is big data database considered? - ANSWER petabyte Why are data warehouses beneficial to business managers? - ANSWER they can be mined or analyzed for trends or patterns What is the definition of data integrity? - ANSWER a process to ensure data is not corrupted It is a good practice to _________________ data that is backed up on a regular basis. - ANSWER reduce Why is it not good practice to perform analytics on an online transaction processing database? - ANSWER 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? - ANSWER predictive analysis Where would metadata about customer and product tables be stored? - ANSWER data dictionary What is data inconsistency - ANSWER what happens when the same attribute has different values because the data is stored in more than one location What does classification do? - ANSWER looks for patterns that indicate customers' shopping behavior in order to target marketing efforts What do the letters CIA stand for? - ANSWER confidentiality, integrity, and availability What data should be scrubbed so that they are consistent with the design of the database? - ANSWER corrupted data What is supply chain management software used for? - ANSWER channels and analyzes to assist executives in making orders, pricing, and inventory decision. What does EMS (energy management system) manage? - ANSWER energy usage and reduces the operating costs in an organization What is used to retrieve specific data from a database? - ANSWER Query language What are OLAP databases used for? - ANSWER reporting- generate reports that have information or business intelligence What is the definition of clickstream? - ANSWER records where a user clicks on a web page What is the definition of an entity in a database? - ANSWER What are reasons to normalize a database? - ANSWER eliminates data redundancy, reduces data complexity What kind of database is a tree-like structure? - ANSWER hierarchical What are the 3 V's used to describe big data? - ANSWER volume, velocity, variety What is a data mart business application? - ANSWER Used to analyze a business unit, or a single unit What are two key elements that make up the data warehouse? - ANSWER presentation and staging What is the difference between data mining and analytics? - ANSWER What are the categories of business intelligence? - ANSWER data mining, predictive analytics, OLAP You have created a database to store the products sold in a department store so they can be managed, updated, and manipulated more easily. The store manager wants to create a query to show the items that are selling today. What would be an appropriate field to sort the data? - ANSWER Product ID Sarah is a sales associate at a major bookstore. A customer calls the store to order a book, but he could only remember part of the book title