bcor 2205 exam with complete solutions

internal data - Answer- data that is procured and consolidated from different branches within your organization (ex: purchase orders from sales terms) external data - Answer- data that is not collected by your organization (public, bought) ex: twitter handles four primary traits of the value of data - Answer- data type, data timeliness, data quality, data governance data base - Answer- maintains data about various types of objects (inventory), events (transactions), people (employees), places (warehouses) as well as data about data (metadata) data base management system - Answer- create, read, update and delete data in a relational database while controlling access and security SQL (Structured Query Language) - Answer- select (what is the attribute you're pulling from the tables) , From (the table) , where (specific) relational database - Answer- contains many tables of data that relate to one another through special key fields flat file database - Answer- contains a single table of data (stored as an unstructured file until its read by a program) ex: zip file, CSV csv - Answer- coma separated value (year, make, model) entities - Answer- a person, place, thing, transaction, event about which data is stored. Described using a set of attributes (rows in a table contain entities) relationships - Answer- an association among entities attribute - Answer- (field, column) the data elements associated with an entity (name and hire date are attributes of the entity EMPLOYEE) attribute instance - Answer- a single value of an attribute for an instance of an entity ("Jane Hathaway" and "December 12 2020") ER database structure - Answer- table with primary key, attributes, foreign key primary key - Answer- a field or group of fields that uniquely identifies a given entity in a table (Customer_ID, SSN) what does a primary key need - Answer- non-null value and needs to be unique foreign key - Answer- primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among 2 tables advantages of relational databases - Answer- flexible, data integrity, scalability/performance, data security and lower redundancy DRIP (data rich information poor) solutions - Answer- data warehouse - allows for more analysis, can aggregate data throughout an organization into a single repository data aggregation - Answer- collection of data from various sources for the purpose of data processing ETL - Answer- extract (pull data out of wherever it resides), transform (covert data into homogeneous format/clean data), Load (put clean data into final location) multi-dimensional data analysis - Answer- relational database shows 2D tables ex: Big Data data cube - Answer- representation of multi-dimensional data (enables drill down) data lake - Answer- a storage repository that holds a vast amount of raw data in its original format until the business needs it Data Visualization - Answer- describes technologies that allow users to see or visualize data to transform information into a business perspective (use infographics to show) three primary enterprise systems - Answer- supply chain management, customer relationship management, enterprise resource planning CRM (customer relationship management) - Answer- aims at tracking and analysis of all interactions of the firm with the customers to optimize sales volume, customer effectiveness, customer satisfaction and customer loyalty who is the process owner fo CRM - Answer- the supplier ERP (Enterprise Resource Planning) system - Answer- integrated process that consolidates data for real-time sharing, data isolated in separate systems can be accessed ERP examples - Answer- - supply chain - what do i need to be cost efficient? - how do i know how to plan for demand? *how to keep a customer CRM examples - Answer- - solution delivery - who is my customer? - can the data drive my supply chain decisions? *how to get a customer cloud ERP - Answer- offers new ways to store, access, process, and analyze information and connect people and resources from any location in the world datamart - Answer- subset of data warehouse (might only be able to read - not write) can be currently used operational CRM - Answer- front side of the house, looking at the data (which move was watched the most of Monday) analytical CRM - Answer- taking the data to the next level, more advanced (what was the most liked movie across the month of December?) astroturfing - Answer- the practice of artificially simulation online conversation and positive reviews about a product, service or brand sock puppet marketing - Answer- false identification (catfish) to artificially simulate demand for a product, brand or service privilege escalation - Answer- network intrusion attack that takes advantage of programming errors or design flaws to grant attacker elevated access to the network data and apps vertical privilege escalation - Answ