MIS Chapter 6 Actual Exam Questions With Correct Detailed Answers.

Transactional Data - correct answer Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks Analytical data - correct answer Encompasses all organizational data, and its primary purpose is to support the performing of managerial analysis tasks The four primary traits of the value of data - correct answer Type, Timeliness, Quality, Governance Real-time data - correct answer Immediate, up-to-date data. Real-time system - correct answer Provides real-time information in response to requests Data governance - correct answer refers to the overall management of the availability, usability, integrity, and security of company data master data management - correct answer The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems Data validation - correct answer includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data Database - correct answer maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Database management systems - correct answer Allows users to create, read, update, and delete data in a relational database Data element - correct answer smallest basic unit of information Data model - correct answer logical data structures that detail the relationships among data elements using graphics or pictures Metadata - correct answer details about data data dictionary - correct answer compiles all of the metadata about the data elements in the data model Entity - correct answer A person, place, thing, transaction, or event about which data is stored Attribute - correct answer the data elements associated with an entity Record - correct answer a collection of related data elements Primary key - correct answer A field (or group of fields) that uniquely identifies a given entity in a table Foreign key - correct answer A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables Scalability - correct answer Refers to how well a system can adapt to increased demands Data redundancy - correct answer The duplication of data or storing the same data in multiple places Data integrity - correct answer measures the quality of data Integrity constraint - correct answer rules that help ensure the quality of information Password - correct answer Provides authentication of the user access level - correct answer Determines who has access to the different types of information Access Control - correct answer Determines types of user access, such as read-only access data warehouse - correct answer A logical collection of data - gathered from many different operational databases - that supports business analysis activities and decision-making tasks data aggregation - correct answer the collection of data from various sources for the purpose of data processing Extraction, transformation, and loading (ETL) - correct answer A process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse Data mart - correct answer Contains a subset of data warehouse data Data cube - correct answer common term for the representation of multidimensional information Data lake - correct answer a storage repository that holds a vast amount of raw data in its original format until the business needs it Dirty data - correct answer erroneous or flawed data Data cleansing or scrubbing - correct answer a process that weeks out and fixes or discards inconsistent incorrect, or incomplete data data visualization - correct answer describes technologies that allow users to see or visualize data to transform information into a business perspective Data visualization tools - correct answer move beyond Excel graphs and charts into sophisticated analysis techniques such as controls, instruments, maps, time-series graphs, and more Business intelligence dashboards - correct answer track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls, allowing users to manipulate data for analysis Distributed computing - correct answer process and manages algorithms across many machines in a computing environment Ledger - correct answer Records classified and summarized transactional data Blockchain - correct answer A type of distributed ledger technology consisting of data structure blocks that may contain data or programs, with each block holding batches of individual transactions and the results of any executables. Each block contains a time stamp and a link to a previous block. Proof-of-work - correct answer A requirement to define an expensive computer calculation, also called mining, that needs to be performed in order to create a new group of trustless transactions (blocks) on the distributed ledger or blockchain Blockchain - correct answer Formed by linking together blocks, data structures containing previous hash and data Genesis block - correct answer The first block created in the blockchain Hash - correct answer a function that converts an input of letters and numbers into an encrypted output of a fixed length Proof-of-stake - correct answer a way to validate transactions and achieve a distributed consensus data inconsistency - correct answer occurs when the same data element has different values data integrity issues - correct answer occur when a system produces incorrect, inconsistent, or duplicate