BCOR 2205 INFORMATION MANAGEMENT FINAL EXAM QUESTIONS WITH CORRECT ANSWERS

BCOR 2205 INFORMATION MANAGEMENT FINAL EXAM
QUESTIONS WITH CORRECT ANSWERS


Internal Data -- Answer ✔✔ Data that is procured and consolidated from different
.l .l .l .l .l .l .l .l .l .l .l .l




branches within your organization
.l .l .l .l




External Data -- Answer ✔✔ Data that is not collected by your organization (can be public
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




or bought)
.l .l




The Four Primary Traits of the Value of data -- Answer ✔✔ data type, data timeliness, data
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




quality, data governance
.l .l .l




Data base -- Answer ✔✔ Maintains data about various types of objects (inventory),events
.l .l .l .l .l .l .l .l .l .l .l .l




(transactions), people (employees), and places (warehouses) as well as data about data
.l .l .l .l .l .l .l .l .l .l .l .l




(metadata)
.l




Data-Based Management System (DBM) -- Answer ✔✔ Allows users to create, read,
.l .l .l .l .l .l .l .l .l .l .l




update, and delete data in a relational database
.l .l .l .l .l .l .l .l




relational database -- Answer ✔✔ contains many tables of data that relate to one another
.l .l .l .l .l .l .l .l .l .l .l .l .l .l




through special key fields
.l .l .l .l




flat file database -- Answer ✔✔ contains a single table of data (ex: zip file)
.l .l .l .l .l .l .l .l .l .l .l .l .l .l




CSVs -- Answer ✔✔ comma separated values
.l .l .l .l .l .l




Entity Relationship (ER) modeling -- Answer ✔✔ the process of designing a database by
.l .l .l .l .l .l .l .l .l .l .l .l .l




organizing data entities to be used and identifying the relationships among them
.l .l .l .l .l .l .l .l .l .l .l .l

,ER Modeling: "Entities" -- Answer ✔✔ a person, place, think, transaction, or event about
.l .l .l .l .l .l .l .l .l .l .l .l .l




which data is stored; entity describes a set of attributes
.l .l .l .l .l .l .l .l .l .l




ER Modeling: "Relationships" -- Answer ✔✔ an association among entities
.l .l .l .l .l .l .l .l .l




Attributes (fields, columns) -- Answer ✔✔ the data elements associated with an entity
.l .l .l .l .l .l .l .l .l .l .l .l




attribute instance -- Answer ✔✔ a single value of an attribute for an instance of an entity
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




Primary key -- Answer ✔✔ A field (or group of fields) that uniquely identifies a given entity in
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




a table (ex: SSN/customer ID)
.l .l .l .l .l




Foreign Key -- Answer ✔✔ A primary key of one table that appears as an attribute in
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




another table and acts to provide a logical relationship between the two tables
.l .l .l .l .l .l .l .l .l .l .l .l .l




Entities/Attributes and Primary/Foreign Keys -- Answer ✔✔ .l .l .l .l .l .l .l




Access level -- Answer ✔✔ Determines who has access to the different types of data
.l .l .l .l .l .l .l .l .l .l .l .l .l .l




Access control -- Answer ✔✔ Determines types of user access, such as read-only access
.l .l .l .l .l .l .l .l .l .l .l .l .l




limitations of data from databases -- Answer ✔✔ Inconsistent, poor quality, etc
.l .l .l .l .l .l .l .l .l .l .l




SQL (Structured Query Language) -- Answer ✔✔ an international standard language for
.l .l .l .l .l .l .l .l .l .l .l




processing a database
.l .l .l




Data Granularity -- Answer ✔✔ Refers to the extend of detail within the data (fine and
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




detailed vs. coarse granular and abstract)
.l .l .l .l .l .l




Transactional data -- Answer ✔✔ Encompasses all of the data contained within a single .l .l .l .l .l .l .l .l .l .l .l .l .l




business process or unit of work, and its primary purpose is to support the performing of
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




daily operational tasks
.l .l .l




Analytical data -- Answer ✔✔ Encompasses all organizational data, and its primary purpose
.l .l .l .l .l .l .l .l .l .l .l .l




is to support the performing of managerial analysis tasks
.l .l .l .l .l .l .l .l .l

, Data governance -- Answer ✔✔ Refers to the overall management of the availability,
.l .l .l .l .l .l .l .l .l .l .l .l




usability, integrity, and security of company data
.l .l .l .l .l .l .l




Master data management (MDM) -- Answer ✔✔ The practice of gathering data and ensuring
.l .l .l .l .l .l .l .l .l .l .l .l .l




that it is uniform, accurate, consistent, and complete, including such entities as customers,
.l .l .l .l .l .l .l .l .l .l .l .l .l




suppliers, products, sales, employees, and other critical entities that are commonly
.l .l .l .l .l .l .l .l .l .l .l




integrated across organizational systems
.l .l .l .l




Data warehouse -- Answer ✔✔ A logical collection of data - gathered from many different
.l .l .l .l .l .l .l .l .l .l .l .l .l .l




operational databases - that supports business analysis activities and decision-making tasks
.l .l .l .l .l .l .l .l .l .l .l




Data cube -- Answer ✔✔ The common term for the representation of multidimensional
.l .l .l .l .l .l .l .l .l .l .l .l




data
.l




Data Lake -- Answer ✔✔ A storage repository that holds a vast amount of raw data in its
.l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l .l




original format until the business needs it
.l .l .l .l .l .l .l




Business Intelligence Dashboards -- Answer ✔✔ Track corporate metrics such as critical
.l .l .l .l .l .l .l .l .l .l .l




success factors and key performance indicators and include advanced capabilities such as
.l .l .l .l .l .l .l .l .l .l .l .l




interactive controls allowing users to manipulate data for analysis
.l .l .l .l .l .l .l .l .l




Customer Resource Management (CRM) -- Answer ✔✔ Involves managing all aspects of a
.l .l .l .l .l .l .l .l .l .l .l .l




customer's relationship with an organization to increase customer loyalty and retention
.l .l .l .l .l .l .l .l .l .l .l




and an organization's profitability
.l .l .l .l




Lead -- Answer ✔✔ A person or company that is unknown to your business
.l .l .l .l .l .l .l .l .l .l .l .l .l




Account -- Answer ✔✔ An existing business relationship exists and can include customers,
.l .l .l .l .l .l .l .l .l .l .l .l




prospects, partners, and competitions
.l .l .l .l




Contact -- Answer ✔✔ Specific individual representing an account
.l .l .l .l .l .l .l .l




Sales Opportunity -- Answer ✔✔ An opportunity exists for a potential sale of goods or
.l .l .l .l .l .l .l .l .l .l .l .l .l .l




services related to an account or contact
.l .l .l .l .l .l .l