CIS 2010 FINAL EXAM || WITH A+ GRADED
SOLUTIONS!!
Entities correct answers Stores info about a person, place, thing, idea, transaction or event
(table).
Attributes correct answers Data element associated with an entity.
Records correct answers Collection of data elements
Database Management System (DBMS) correct answers Creates, reads, updates, and deletes
data in a database while controlling access and security
Relational Databases correct answers DBMS data model for organizing information. Stores
info in the form of logically related two dimensional tables.
Advantages of relational databases correct answers 1. Increased flexibility
2. Increased info integrity
3. increased scalability and performance
4. increased info security
5. Reduced info redundancy
Redundant Data correct answers The duplication of data or the storage of the same data in
multiple places.
Can cause issues as well as data integrity issues making it difficult to determine which values
are the most current and accurate.
Metadata correct answers Provides details about data
i.e. Metadata for an image could be the image size. Metadata for a text document could be the
document length, data created, author, ect.
Data element (Data field) correct answers the smallest most basic unit of info. Can include
customer name, address, email, discount rate, preferred shipping method, product names, ect.
Foreign Key correct answers 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
Metadata correct answers Provides data about data
Primary Key correct answers A field (or group of fields) that uniquely identifies a given
entity in a table
Redundant Data correct answers Can cause storage issues as well as data integrity issues
making it difficult to determine which values are the most accurate and current
Structured Query Language (SQL) correct answers asks users to write lines of code to answer
questions against a database
, Blockchain correct answers a distributed ledger that provides a way for information to be
recorded and shared by a community. Each member maintains his or her own copy of the info
and all members must validate any updates collectively. The information could represent
transactions, contracts, assets, identities, or anything that can be described in digital form.
Bitcoin correct answers The primary instance of blockchain tech is found in bitcoin. It has
been around the longest, has greatest market share and is supported the most.
advantages of blockchain/bitcoin correct answers collection of cryptographic hash, public key
encryption, merkle tree data structures or proof of work.
Hash correct answers Computer science and advanced mathematics protect the blockchains
integrity and anonymity. Each transaction has a digital has calculated and attached. The hash
includes digital signatures from the blockchain as well as the new transaction.
Internal databases correct answers Marketing, sales, inventory, and billing
External Databases correct answers Competitor inf, industry info, mailing lists, stock market
analysis.
Data warehouses correct answers Combines info more specifically strategic info throughout
an organization into a single repository so that ppl who need that info can make a decision
and undertake business analysis.
Dirty data correct answers flawed data
Info Scrubbing correct answers process that weeds out and fixes or discards inconsistent,
incorrect, or incomplete info.
ETL correct answers extraction, transformation, and loading. A process that extracts info
from internal and external databases. Transforms the info using a common set of enterprise
definitions, and loads the info into data warehouse.
Data warehouse correct answers Logical collection of info gathered from many different
operational databases and supports business analytics activities and decision making tasks.
Virtualization correct answers Creation of a virtual version of computing resources, such as
an operating system, server, storage device, or network resources
Info cube correct answers representation of multidimensional info. Once the cube is created,
user can slice the cube to drill down the info.
Analytics correct answers science of fact based decision making. uses software based
algorithms and stats to derive meaning from data.
data visualization correct answers describes tech that allow users to see or visualize data to
transform info into a business perspective
Data analytics correct answers process of inspecting, cleansing, transforming, and modeling
data with the goal of discovering useful info for better decision making
SOLUTIONS!!
Entities correct answers Stores info about a person, place, thing, idea, transaction or event
(table).
Attributes correct answers Data element associated with an entity.
Records correct answers Collection of data elements
Database Management System (DBMS) correct answers Creates, reads, updates, and deletes
data in a database while controlling access and security
Relational Databases correct answers DBMS data model for organizing information. Stores
info in the form of logically related two dimensional tables.
Advantages of relational databases correct answers 1. Increased flexibility
2. Increased info integrity
3. increased scalability and performance
4. increased info security
5. Reduced info redundancy
Redundant Data correct answers The duplication of data or the storage of the same data in
multiple places.
Can cause issues as well as data integrity issues making it difficult to determine which values
are the most current and accurate.
Metadata correct answers Provides details about data
i.e. Metadata for an image could be the image size. Metadata for a text document could be the
document length, data created, author, ect.
Data element (Data field) correct answers the smallest most basic unit of info. Can include
customer name, address, email, discount rate, preferred shipping method, product names, ect.
Foreign Key correct answers 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
Metadata correct answers Provides data about data
Primary Key correct answers A field (or group of fields) that uniquely identifies a given
entity in a table
Redundant Data correct answers Can cause storage issues as well as data integrity issues
making it difficult to determine which values are the most accurate and current
Structured Query Language (SQL) correct answers asks users to write lines of code to answer
questions against a database
, Blockchain correct answers a distributed ledger that provides a way for information to be
recorded and shared by a community. Each member maintains his or her own copy of the info
and all members must validate any updates collectively. The information could represent
transactions, contracts, assets, identities, or anything that can be described in digital form.
Bitcoin correct answers The primary instance of blockchain tech is found in bitcoin. It has
been around the longest, has greatest market share and is supported the most.
advantages of blockchain/bitcoin correct answers collection of cryptographic hash, public key
encryption, merkle tree data structures or proof of work.
Hash correct answers Computer science and advanced mathematics protect the blockchains
integrity and anonymity. Each transaction has a digital has calculated and attached. The hash
includes digital signatures from the blockchain as well as the new transaction.
Internal databases correct answers Marketing, sales, inventory, and billing
External Databases correct answers Competitor inf, industry info, mailing lists, stock market
analysis.
Data warehouses correct answers Combines info more specifically strategic info throughout
an organization into a single repository so that ppl who need that info can make a decision
and undertake business analysis.
Dirty data correct answers flawed data
Info Scrubbing correct answers process that weeds out and fixes or discards inconsistent,
incorrect, or incomplete info.
ETL correct answers extraction, transformation, and loading. A process that extracts info
from internal and external databases. Transforms the info using a common set of enterprise
definitions, and loads the info into data warehouse.
Data warehouse correct answers Logical collection of info gathered from many different
operational databases and supports business analytics activities and decision making tasks.
Virtualization correct answers Creation of a virtual version of computing resources, such as
an operating system, server, storage device, or network resources
Info cube correct answers representation of multidimensional info. Once the cube is created,
user can slice the cube to drill down the info.
Analytics correct answers science of fact based decision making. uses software based
algorithms and stats to derive meaning from data.
data visualization correct answers describes tech that allow users to see or visualize data to
transform info into a business perspective
Data analytics correct answers process of inspecting, cleansing, transforming, and modeling
data with the goal of discovering useful info for better decision making
