ISDS 351 FINAL - CSUF Questions and Answers (100% Correct Answers) Already Graded A+

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization. Ch5 [ Ans: ] Enterprise data modeling Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing. Ch5 [ Ans: ] True A group of programs used to access and manage a database as well as provide an interface between the database and its users and other application programs is called a _____. Ch5 [ Ans: ] database management system A DaaS arrangement _____. Ch5 [ Ans: ] reduces hardware, software, and staffing related costs for the client A database management system (DBMS) serves as an interface between an application program and a database. Ch5 [ Ans: ] True Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to 2 create his new database. Ch5 [ Ans: ] True (projection involves eliminating columns in a table) Haley needs to query her firm's database, Jeff needs to generate a report for his next project status meeting, and Karen needs to make some modifications to update the data in the database. Which of the following tools can they all use to complete their current task? Ch5 [ Ans: ] data manipulation language You would use Query by Example if _____. Ch5 [ Ans: ] you wish to use a visual approach to query building Each attribute in a relational database model can be constrained to a range of allowable values called a _____. Ch5 [ Ans: ] domain A collection of characteristics that belong to a single person, place, or thing for which data is maintained is a(n) _____. Ch5 [ Ans: ] record Between 2017 and 2025, _____. [ Ans: ] the volume of data in the digital universe is expected to grow tenfold Which of the following is NOT a component required for effective BI and analytics? [ Ans: ] well-maintained NoSQL databases A conversion funnel is a visual depiction of a set of words that have been grouped together because of the frequency of their occurrence. [ Ans: ] False 3 A conversion funnel is a graphical representation that summarizes the steps a consumer takes in making the decision to buy your product and become a customer. [ Ans: ] True Data scientists do not need much business domain knowledge. [ Ans: ] False A data scientist is an individual who combines strong business acumen, a deep understanding of analytics, and a healthy appreciation of the limitations of data, tools, and techniques to deliver real improvements in decision making. [ Ans: ] True A word cloud is a visual depiction of a set of words that have been grouped together because of the frequency of their occurrence. [ Ans: ] True Data scientists do not need much business domain knowledge [ Ans: ] False According to the McKinsey Global Institute, _____. [ Ans: ] the demand for data scientists could outpace supply by up to 250,00