C724-M5-MANAGING DATA Quiz

C724-M5-MANAGING DATA QuizM5: MANAGING DATA Attempt 1 Question 1 of 10 One of the capabilities of a database management system is that it allows users to easily modify the data using which of the following? Data def ...

C724-M5-MANAGING DATA QuizM5: MANAGING DATA Attempt 1 Question 1 of 10 One of the capabilities of a database management system is that it allows users to easily modify the data using which of the following? Data definition language Any computer language Hypertext markup language Data manipulation language Correct. DBMS can be modified using only the data manipulation language. Question 2 of 10 The traditional file environment is not usually as efficient as a database management system. What is typically NOT a challenge when using the traditional file environment? Data redundancy Data inconsistency Data complexity Correct. Traditional file systems are typically very simple and not complex because they are usually smaller in size and have a lot less computer requirements than a DBMS. Question 3 of 10 "Fill in the blank" question: select the correct answer. Business intelligence is defined as the infrastructure, data, and software tools to help mine collected data. Correct. Business intelligence refers to the infrastructure, data set, and relevant software tools that managers used on their company’s databases to help them make better and more informed decisions. Question 4 of 10 [True/False] In many organizations, employees are allowed different levels of access to the data in the database. Database access rights can be assigned based on their seniority, duties, and responsibilities. True False software This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA Correct. Companies can assign employees with different levels of access rights, which include the rights to read, write (save), delete, or modify the data in the database. Usually, employees are given the access rights to fulfill their duties and job responsibilities. Question 5 of 10 Maintaining the integrity of a company’s database is the responsibility of which person below? Data administrator Information policy administrator Database administrator Data auditor Correct. A data administrator is an employee who is in charge of determining and monitoring the employees’ access to the company’s DBMS Question 6 of 10 [True/False] In a healthcare organization, policies concerning data governance of clients’ information would include creating information policy, planning for the types and quantities of data, designing the database, and predicting or monitoring how users utilize the data. True False Correct. Procedures concerned with the proper governance in a healthcare organization would include creating information policy, planning for the types and quantities of data, designing the database, and predicting or monitoring how users utilize the data. Question 7 of 10 [True/False] When a retailer acquires another retail store, the two companies’ databases can be easily merged into one database without any problem after performing a data quality audit, since they are both in the same industry. True False Correct. The data and data structure of the two separate databases might not be compatible with each other; therefore, the combined database might need to be cleansed and normalized; data auditing alone may not be sufficient. Question 8 of 10 This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA Web data mining helps businesses gather intelligence data and make important decisions. Which of the following statements is TRUE regarding web mining? Web mining can only identify associations, correlations, and significant relationships from data collected from the Internet. Web mining analyzes a website’s traffic by keeping track of the clicks that a user makes. Web mining can handle one database stored in one location at a time. Web mining uses clickstream applications to analyze the data collected from the Internet. Correct. Web mining collects and analyzes data that they collected from the Internet. Question 9 of 10 [True/False] Businesses can integrate both Supply Chain Management (SCM) and Customer Relationship Management (CRM) into their organizations to merge, mine, organize, and manage their data. For instance, point-of-sale (POS) orders from the CRM can immediately trigger a restock request in the SCM. True False Correct. Both the SCM and CRM perform different functions and yield different benefits. However, they can both be integrated into the organization’s infrastructure to harness and optimize sales performance by channeling the customer data from the CRM into the SCM. Question 10 of 10 [True/False] A Geographic Information Systems (GIS) is a system developed to collect, process, analyze, and store all types of data. True False Correct. A GIS does not store all types of data. Examples of data that are not stored in a GIS includes business data such as products and customers. Attempt 2 Question 1 of 10 Which item below is a graphical representation of the relationships and provides a description of the entities in a database? This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA Entity-relationship diagram Structured query language Graphical user interface Data dictionary Correct. A entity-relationship diagram illustrates the relationships among all the tables in a database. Question 2 of 10 What is an advantage of using the traditional file environment? Users can perform advanced queries on the tables. It is simpler to use than a DBMS. There is a dependency between the software program and the data. Correct. Traditional file system is very simple because it is usually smaller in size and has a lot less computer requirements than a DBMS. Question 3 of 10 [True/False] In-memory computing is a business intelligence tool that uses increased memory for data processing to provide an alternative to data warehouses. A computer's ROM is used for in-memory computing. True False Correct. The additional memory for in-memory computing is stored in the RAM (read access memory), not ROM (read only memory). Question 4 of 10 "Fill in the blank" question: select the correct answer. The Central Intelligence Agency is responsible for high level data integrity and security for the nation. One of the key points in the CIA triad is to maintain confidentiality and keep the data from those who don’t need to have access to it. Correct. One of the three points in the CIA triad is confidentiality and keeping data away from those who shouldn’t have access to it. confidentiality This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA Question 5 of 10 Maintaining employees’ usage of a company’s database is the responsibility of what role below? Information policy administrator Data auditor Database administrator Data administrator Correct. A data administrator is an employee who is in charge of determining and monitoring the employees’ access to the company’s DBMS. Question 6 of 10 "Fill in the blank" question: select the correct answer. Consider all the different people who might have access to data in a financial organization, from the president to the managers to the tellers. In a financial DBMS, using data governance procedures, controlling who can have access to what data will affect how the data is used. Correct. Controlling who can have access to which data will affect how the data is used. Question 7 of 10 "Fill in the blank" question: select the correct answer. Your FICO score is one of the factors used in determining your ability to get a mortgage loan. If credit bureaus such as Equifax and TransUnion contain outdated and inaccurate financial information of individuals, they should immediately conduct data quality audit to survey the accuracy and completeness of the data in the database. Correct. A data quality audit is conducted to ensure that the information stored in a database is efficient, consistent, and accurate. Question 8 of 10 [True/False] Financial corporations, such as CitiGroup, Inc., employ web mining to reveal any correlations and associations among customer variables in their database, and to predict future customers’ banking behaviors. used data quality audit This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA True False Correct. Web mining creates databases which are mined to understand customer behavior and improve customer intimacy. Data mining would be a more appropriate technique for CitiGroup to use because data mining can define correlative or causal associations, identify event sequencing, classify patterns, cluster similar records, and predict future outcomes, including outcomes for multi-dimensional and non-obvious relationships. Question 9 of 10 Supply Chain Management (SCM) is a popular analytics application that can help a manufacturing company control its operating costs. Which of the following does not contribute to inefficiencies in the supply chain activities? High demand High inventory level Parts shortage Underutilized plant capacity Correct. Inefficiencies in the supply chain activities can result in high operating costs. Such inefficiencies include a shortage in the parts, underutilized plant capacity, an excessive inventory level, and high transportation costs. High demand of a particular product does not contribute to the inefficiencies in the supply chain activities. Question 10 of 10 A GIS is an example of a semi-automatic decision support system. Which of the following is NOT a benefit of the GIS to the county administrators? To change ordinances To enact legislations To act, redirect, and redistribute funds To implement future changes Correct. A GIS can provide analyses to help county administrators make decisions and enact legislation. Attempt 3 Question 1 of 10 This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA For a DBMS to be efficient and more functional, data redundancy needs to be eliminated. This can be accomplished by creating smaller tables, with stable data structures, using what process? Data dictionary Data retrieval Data normalization Data administration Correct. Normalization breaks down a big and complex table into several smaller, but stable, tables with flexible data structures to minimize data redundancy and maintain data integrity. Question 2 of 10 [True/False] The local Amish furniture store in a small country town uses a traditional file system to keep track of their sales. This is a good way to store their sales records and inventory since this is a small business, and therefore, it is more cost-effective for the store owner. True False Correct. The traditional file system, whether paper or digital, often results in data inaccuracy and data inconsistency. The DBMS might be more expensive to develop, but the store owner can easily create a database using Microsoft Access or WordPerfect Paradox. In the long run, it could be more cost-effective with a DBMS. Question 3 of 10 "Fill in the blank" question: select the correct answer. Maintaining historical records allows managers to analyze the data to help improve their business. Data collected from all internal and external sources are extracted, transformed, and then loaded into a data warehouse for additional analysis. Correct. Data are collected, extracted, transformed, and loaded into a data warehouse so that they can be further analyzed to help managers make informed decisions. Question 4 of 10 If you receive two copies of the same catalog from a clothing company in your mailbox with a little variation in the first name on the address label, this would be a violation of what rule? analysis This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA Data reliability Data integrity Data redundancy Correct. Data integrity ensures that all data values are correct, accurate, and consistent. Question 5 of 10 [True/False] Among all the administrators’ roles (the database administrator, the data administrator, the information policy administrator, and the data auditor) the database administrator is the most important role since s/he is in charge of designing the physical database for the organization. True False Correct. All the roles mentioned are equally important in an organization since each role performs different functions vital to the survival of the organization. Question 6 of 10 "Fill in the blank" question: select the correct answer. In a Fortune 500 company such as IBM is concerned with the management of data, including maximizing quality through effective utilization, availability, and protection. Correct. The database administration function creates and manages the whole database management system. Question 7 of 10 "Fill in the blank" question: select the correct answer. Financial institutions perform data mining on visitors’ data they collect on their websites to detect and create a list of potential customers whom they will send invitations to apply for credit cards or line of equity loans. Correct! Data mining is a technique that companies use on their business data to find hidden relationships in customer data; they use this information to develop more effective marketing strategies. data governance data mining This study source was downloaded by 100000824449084 from CourseHero.com on 04-27-2021 07:48:15 GMT -05:00 https://www.coursehero.com/file/67325449/C724-M5-MANAGING-DATA-Quizdocx/ This study resource was shared via CourseHero.com M5: MANAGING DATA Question 8 of 10 "Fill in the blank" question: select the correct answer. Databases are used extensively on the Internet and in business to help managers make more informed decisions. Text mining is a popular business concept used on the Internet because it can sieve through a huge amount of unstructured data and transform it into a structured and organized format. Correct. Text mining performs big data analysis on unstructured data such as e-mails, survey questionnaires, and memos to reveal consistent patterns and relationships. Question 9 of 10 "Fill in the blank" question: select the correct answer. Healthcare companies can use the data collected from Health Analytics tools to help their customers design a fitness activity plan. Correct. Health analytics tools are usually apps created for smart phones or portable devices to keep track of device owner's health and exercising stats. Question 10 of 10 Which application below uses data patterns to fill numbers in a column? Word Access Excel Correct. Instead of entering data manually on a worksheet, the Autofill feature in Excel will fill cells with data that follows a pattern or that is based on data in other cells. C724-M5-MANAGING DATA Quiz