ISTM 210 - Exam 3 (Phinney) With Questions with 100% Correct Answers

ISTM 210 - Exam 3 (Phinney) With Questions with 100% Correct Answers Cloud Service Providers (CSP) - answerGoogle, DropBox, and Microsoft are company examples of what type of providers? Structured Query Language (SQL) - answerUsing data visualization instead of _______________________, makes business programming much easier to understand. Can be described as computer applications that change data into significant, meaningful information that helps organizations make better decisions. - answerBusiness Intelligence Database Management Systems (DBMS) - answerA well thought-out collection of computer files Filing Cabinets - answerDatabase systems are extremely similar to _______ _______ in that they organize information based on a set of rules. Tables - answerWhere a database holds data Relation - answerTechnical term for a table Records - answerThe rows of a table Fields - answerThe columns of a table Entity Relationship Modeling (ERM) - answera database-modeling method used to construct a theoretical and conceptual representation of data to produce a schema Database Schema - answera "map" of data tables and their relationships to one another One-to-One Relationship - answerWhere a record of one table can only be associated with one record from another table One-to-Many Relationship - answerWhere a single record from a table can be associated with more than one record from another table, but a record from the second table can only be associated with the one record from the first table Many-to-Many Relationship - answerWhere a record from one table may be associated with more than one record from the other table and a record from the second table may also be associated with more than one record from the first table Data Validation Rules - answerHelp avoid input errors to ensure the data's integrity 1970; Edgar Codd - answerThe relational database model was first proposed in _______ by _______ _______. Structured Query Language (SQL) - answerThe most widely used standard computer language for relational databases as it allows a programmer to manipulate and query data SQL Functions - answerDelete, Append, Update Fluid - answerData is _______ because it changes all the time. Oracle - answer_______ is the world's most widely used database. Real Estate Owned - answerREO is an acronym for... Alibaba Group - answerChinese e-commerce company that provides sales services via web portals Cloud - answerUsing computer resources like a hard drive or software that exists on another computer connected by a network, typically the Internet Cloud Drive - answerA hard drive in the Cloud Cloud Service Provider - answerCSP is an acronym for... Terms of Service - answerTOS is an acronym for... Infrastructure as a Service (IaaS) - answerHosts supply hardware, software applications, servers, and storage via the internet On-Demand - answerIaaS can quickly adjust and supply more computing power because it is considered _______-________. IaaS - answerWindows Azure is an example of an... Storage as a Service (StaaS) - answerStoring or renting space from a CSP Staas - answerDropBox is an example of a... Software as a Service (SaaS) - answerWhen the CSP installs and operates application software in the Cloud that the Cloud user can use On-Demand Software - answerSaas is also known as.... Saas - answerApache OpenOffice is an example of a... Writer - answerWhat is the name of the OpenOffice word processor? Calc - answerWhat is the name of the OpenOffice spreadsheet? Impress - answerWhat is the name of the OpenOffice presentation software? Base - answerWhat is the name of the OpenOffice database application? Draw - answerWhat is the name of the OpenOffice graphics editor? It was free - answerHow much does OpenOffice cost? Platform as a Service (PaaS) - answerWhen a Cloud provider supplies a computer platform through the Internet PaaS - answerAmazon Elastic Beanstalk is an example of a... Business Intelligence (BI) - answerThe set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes Return on Investment - answerROI is an acronym for... Decision Support Systems (DSS) - answerComputer-based systems that support an organization's decision-making activities 1950s - answerWhat decade did businesses start DSS? Big Data - answerLarge collected datasets Structured Data - answerData that resides in fixed formats, is typically well labeled, and often has traditional fields and records of common data tables Unstructured Data - answerDisorganized data that cannot be easily read or processed by a computer because it is not stored in rows and columns like traditional data tables 80% - answerWhat percentage of all data is unstructured? Semi-Structured Data - answerIn-between Structured and Unstructured data, and can possibly be converted into structured data, but not without a lot of work Four V's of Big Data - answerVolume, Velocity, Variety, & Veracity Volume - answerRefers to the amount of data collected by an organization Velocity - answerHow fast an organization can collect and analyze data Variety - answerThe kinds of data an organization is dealing with Veracity - answerRefers to the quality of the data