ISA 235 LATEST EXAMS TEST PAPER QUESTIONS
AND ANSWERS SURE A+
✔✔Foreign Key - ✔✔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
✔✔Primary key - ✔✔A field (or group of fields) that uniquely identifies a given entity in a
table
✔✔information redundancy - ✔✔is the duplication of data, or the storage of the same
data in multiple places.
✔✔Information integrity - ✔✔a measure of the quality of information
✔✔Data-driven website - ✔✔an interactive website kept constantly updated and
relevant to the needs of its customers using a database
✔✔Structured data - ✔✔Data already in a database or a spreadsheet
✔✔Unstructured data - ✔✔Not defined and does not follow a specified format
, ✔✔Data warehouse - ✔✔A logical collection of information - gathered from many
different operational databases - that supports business analysis activities and decision-
making tasks
✔✔Data mart - ✔✔contains a subset of data warehouse information for a department
ususally
✔✔Information cleansing or scrubbing - ✔✔is a process that weeds out and fixes or
discards inconsistent, incorrect, or incomplete information.
✔✔record - ✔✔A collection of fields that appear as a row in a database or table.
✔✔Big data - ✔✔is a collection of large, complex data sets, including structured and
unstructured data, which cannot be analyzed using traditional database methods and
tools.
✔✔4 V's of Big data - ✔✔Variety, Veracity, Volume, Velocity
✔✔Transactional Data - ✔✔all information contained to a single business process or
unit of work.
✔✔Analytical data - ✔✔Captures data to support analysis and reporting
An aggregated view of the business
Historical
✔✔Business intelligence dashboard - ✔✔Tracks corporate metrics such as critical
success factors and key performance indicators and includes advanced capabilities
such as interactive controls, allowing users to manipulate data for analysis.
✔✔Data mining - ✔✔the process of analyzing data to extract information not offered by
the raw data alone
✔✔Estimation Analysis - ✔✔determines values for an unknown continuous variable
behavior or estimated future value
✔✔Cluster analysis - ✔✔a technique used to divide an information set into mutually
exclusive groups such that the members of each group are as close together as
possible to one another and the different groups are as far apart as possible
✔✔Affinity grouping analysis - ✔✔reveals the relationship between variables along with
the nature and frequency of the relationships
✔✔Classification analysis - ✔✔the process of organizing data into categories or groups
for its most effective and efficient use
AND ANSWERS SURE A+
✔✔Foreign Key - ✔✔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
✔✔Primary key - ✔✔A field (or group of fields) that uniquely identifies a given entity in a
table
✔✔information redundancy - ✔✔is the duplication of data, or the storage of the same
data in multiple places.
✔✔Information integrity - ✔✔a measure of the quality of information
✔✔Data-driven website - ✔✔an interactive website kept constantly updated and
relevant to the needs of its customers using a database
✔✔Structured data - ✔✔Data already in a database or a spreadsheet
✔✔Unstructured data - ✔✔Not defined and does not follow a specified format
, ✔✔Data warehouse - ✔✔A logical collection of information - gathered from many
different operational databases - that supports business analysis activities and decision-
making tasks
✔✔Data mart - ✔✔contains a subset of data warehouse information for a department
ususally
✔✔Information cleansing or scrubbing - ✔✔is a process that weeds out and fixes or
discards inconsistent, incorrect, or incomplete information.
✔✔record - ✔✔A collection of fields that appear as a row in a database or table.
✔✔Big data - ✔✔is a collection of large, complex data sets, including structured and
unstructured data, which cannot be analyzed using traditional database methods and
tools.
✔✔4 V's of Big data - ✔✔Variety, Veracity, Volume, Velocity
✔✔Transactional Data - ✔✔all information contained to a single business process or
unit of work.
✔✔Analytical data - ✔✔Captures data to support analysis and reporting
An aggregated view of the business
Historical
✔✔Business intelligence dashboard - ✔✔Tracks corporate metrics such as critical
success factors and key performance indicators and includes advanced capabilities
such as interactive controls, allowing users to manipulate data for analysis.
✔✔Data mining - ✔✔the process of analyzing data to extract information not offered by
the raw data alone
✔✔Estimation Analysis - ✔✔determines values for an unknown continuous variable
behavior or estimated future value
✔✔Cluster analysis - ✔✔a technique used to divide an information set into mutually
exclusive groups such that the members of each group are as close together as
possible to one another and the different groups are as far apart as possible
✔✔Affinity grouping analysis - ✔✔reveals the relationship between variables along with
the nature and frequency of the relationships
✔✔Classification analysis - ✔✔the process of organizing data into categories or groups
for its most effective and efficient use
