ISA 235 UPDATED EXAMINERS SET QUESTIONS AND
ANSWERS SURE A+
✔✔Data Model - ✔✔Logical data structures that detail the relationship among data
elements using graphics or pictures
✔✔Data Dictionary - ✔✔Compiles all of the metadata about the data elements in a data
model
✔✔Foreign key - ✔✔A primary key of one table that appears as an attribute in another
table and acts to provide a logial relationship between two tables
✔✔Metadata - ✔✔details about data
✔✔Record - ✔✔A colletion of related data elements
✔✔Database - ✔✔Maintains informations about various types of objects, events,
people, and places
✔✔Data Warehouse - ✔✔A logical collection of information, gathered from many
different operational databases, that supports business analysis activities and decisions
, ✔✔Information scrubbing - ✔✔A process that weeds out and fixes or discards
inconsistent, incorrect, or imcomplete information
✔✔Data Mart - ✔✔Contains a subset of data warehouse information
✔✔Information Granularity - ✔✔The extent of detail within the information (fine and
detailed or coarse and abstract)
✔✔Wide area network (WAN) - ✔✔Spans a large geographic area such as a state,
province, or country
✔✔Local area network (LAN) - ✔✔Connects a group of computers in a proximity, such
as in an office building, school, or home
✔✔Metropolitan area network (MAN) - ✔✔A large computer network usually spanning a
city
✔✔National Servie Providers (NSPs) - ✔✔Private companies that own and maintain the
worldwide backbone that supports the internet
✔✔Regional Service Providers (RSPs) - ✔✔Offer internet service by connecting NSPs,
but they also can connect directly to eachother
✔✔Intranet - ✔✔A restricted network that relies on internet technologies to provide an
internet-like environment within a company
✔✔Extranet - ✔✔An extension of an intranet that is only available to authorized
outsiders
✔✔WI-FI infrastructure - ✔✔Includes the inner workings of a Wi-Fi service or utility,
including the signal transmitters, towers, or poles, along with additional equipment
✔✔Bandwidth - ✔✔The amount of data that can pass from one point to another in a unit
of time
✔✔Bit - ✔✔Smallest element of data and has a value of 0 or 1
✔✔IP adress - ✔✔a unique string of numbers separated by periods that identifies each
computer using the Internet Protocol to communicate over a network
✔✔telecommuting - ✔✔Working from home Via Internet
✔✔Streaming - ✔✔the process of transmitting or receiving data over a computer
network
ANSWERS SURE A+
✔✔Data Model - ✔✔Logical data structures that detail the relationship among data
elements using graphics or pictures
✔✔Data Dictionary - ✔✔Compiles all of the metadata about the data elements in a data
model
✔✔Foreign key - ✔✔A primary key of one table that appears as an attribute in another
table and acts to provide a logial relationship between two tables
✔✔Metadata - ✔✔details about data
✔✔Record - ✔✔A colletion of related data elements
✔✔Database - ✔✔Maintains informations about various types of objects, events,
people, and places
✔✔Data Warehouse - ✔✔A logical collection of information, gathered from many
different operational databases, that supports business analysis activities and decisions
, ✔✔Information scrubbing - ✔✔A process that weeds out and fixes or discards
inconsistent, incorrect, or imcomplete information
✔✔Data Mart - ✔✔Contains a subset of data warehouse information
✔✔Information Granularity - ✔✔The extent of detail within the information (fine and
detailed or coarse and abstract)
✔✔Wide area network (WAN) - ✔✔Spans a large geographic area such as a state,
province, or country
✔✔Local area network (LAN) - ✔✔Connects a group of computers in a proximity, such
as in an office building, school, or home
✔✔Metropolitan area network (MAN) - ✔✔A large computer network usually spanning a
city
✔✔National Servie Providers (NSPs) - ✔✔Private companies that own and maintain the
worldwide backbone that supports the internet
✔✔Regional Service Providers (RSPs) - ✔✔Offer internet service by connecting NSPs,
but they also can connect directly to eachother
✔✔Intranet - ✔✔A restricted network that relies on internet technologies to provide an
internet-like environment within a company
✔✔Extranet - ✔✔An extension of an intranet that is only available to authorized
outsiders
✔✔WI-FI infrastructure - ✔✔Includes the inner workings of a Wi-Fi service or utility,
including the signal transmitters, towers, or poles, along with additional equipment
✔✔Bandwidth - ✔✔The amount of data that can pass from one point to another in a unit
of time
✔✔Bit - ✔✔Smallest element of data and has a value of 0 or 1
✔✔IP adress - ✔✔a unique string of numbers separated by periods that identifies each
computer using the Internet Protocol to communicate over a network
✔✔telecommuting - ✔✔Working from home Via Internet
✔✔Streaming - ✔✔the process of transmitting or receiving data over a computer
network
