BTE 210 Exam 2 Questions with Correct Answers Latest Update () Already Passed

BTE 210 Exam 2 Questions with Correct Answers Latest Update () Already Passed Data increases ______ with time? - Answers exponentially what is Data Degradation? - Answers Issues that happen with the quality of data. Is the data correct? customers move to new addresses, change their names what is data rot? - Answers worthless data. Data that no longer is useful or exists. Maybe a flashdrive went through the washing machine physical problems with storage media and thus make it difficult to access what are the 3 sources of data? - Answers 1) internal data sources 2) personal data sources 3) external data sources what are Internal Data Sources? - Answers corporate databases and company documents what are personal data sources? - Answers personal thoughts, opinions, experiences Professor perez worked in sales and she recorded info about all her clients, like what drink they like. Only she has this information what are external data sources? - Answers commercial databases, government reports, and corporate web sites what is data governance? - Answers managing data information across an entire organization what is master data? - Answers core data (e.g., customer, product, employee, vendor, geographic location, etc.) that spans the entire enterprise information systems what are 5 components of high quality data? - Answers Accurate complete timely accessible (you need to be able to access data anywhere, anytime, at any moment) relevant (is it relevant at the time of the report) these characteristics make data valuable what would Umiamis master data be? - Answers address, birthday, c number, social security number, email Stuff like which club you were a part of freshman year wouldn't be master data what is master data management? - Answers provides the ability to store, maintain, and manage a consistent, accurate, and timely version of the company's master data a process that spans all organizational business processes databases minimize three main problems. what are they? - Answers 1) data redundancy 2) data isolation 3) data inconsistency what is data redundancy? - Answers The same data are stored in many places what is data isolation? - Answers Applications cannot access data associated with other applications The opposite of data redundancy what is data inconsistency? - Answers Various copies of the data do not agree databases maximize three main things. What are they? - Answers 1) data security 2) data integrity 3) data independence what is data security? - Answers Keeping the organization's data safe from theft what is data integrity? - Answers data must meet organizational constraints Example: social security number can only have numbers what is data independence? - Answers Applications and data are independent of one another Each individual column in a database is called an? - Answers attribute (column for student last name) Each row for each student is called an? - Answers instance (or record) last name, first name, c #, class part grade, exam grade for an individual student Each individual cell in the spreadsheet is called? - Answers a field example: "25" is in the field for class participation what is a data file? - Answers grouping of related records similar in appearance to an excel spreadsheet what is a database? - Answers grouping of related data files what is the relational database model? - Answers based on the concept of two-dimensional tables designed with a number of related tables with each of these tables containing rows and columns what is structured query language (SQL)? - Answers language used for interacting with a database SQL allows people to perform complicated searches by using relatively simple statements or key words Who has a higher gpa, students from cali or students from boston? what are Business Rules when it comes to data? - Answers create and enforce business processes in an organization Example: the only person who can create a new account is the manager. This is a business rule what is a data dictionary? - Answers provides information on each attribute such as its name, if it is a key, part of a key what are the 3 components of big data? - Answers 1) volume (incredible amounts of data) 2) variety (formats change rapidly and can include include satellite imagery, broadcast audio streams, digital music files, Web page content) 3) velocity (The rate at which data flow into an organization is rapidly increasing) what are the varieties of big data? - Answers Include structured, unstructured, and semi-structured data 80% of data is nonstructured, so you couldn't put it in a specific row or column big data generally consists of? - Answers Traditional enterprise data Machine-generated/sensor data Social Data (twitter, facebook) Images captured by billions of devices located around the world (cameras) applying face recognition to a database to make a decision requires what? - Answers big data what is clickstream data? - Answers those data that visitors produce when they visit a Web site and click on hyperlinks User entries into the G' search box are stored into a database. This is clickstream data you type in Miami and other words start popping up. The website collects searches and sees the top searches based on a letter or word. It takes it into a database and finds the result for the _____________? - Answers clickstream data what are the issues with big data? - Answers 1) Big Data can come from untrusted sources. 2) Big Data can be dirty ( inaccurate, incomplete, incorrect) 3) Big Data changes: data quality in an analysis can change, or the data itself can change 4) veracity- Veracity refers to the trustworthiness of the data. Can you trust it? what are the ways in which big data is useful? - Answers 1) Enabling Organizations to Conduct Experiments 2) Micro-Segmentation of Customers 3) creating new business models 4) companies can analyze far more data When you talk about big data, what are you trying to find? - Answers Patterns in order to make better business decisions and PREDICTIONS what is a data warehouse? - Answers a collection of historical data that are organized by subject to support decision makers in the organization what is a data mart? - Answers A low-cost, scaled-down version of a data warehouse