IST EXAM 2 QUESTIONS AND ANSWERS
28) ________ involves standardizing the format of data retrieved from different systems.
A) Data cleansing
B) Data mining
C) Normalization
D) Content mining
E) Clustering - CORRECT ANSWER✅✅✅A. Data Cleansing
29) A ________ is a data warehouse that is limited in scope.
A) metadata repository
B) master data
C) data model
D) data reduction
E) data mart - CORRECT ANSWER✅✅✅E. Data Mart
30) Which of the following statements is true about a data mart?
A) It standardizes the format of data retrieved from different systems.
B) It contains selected data from the data warehouse.
C) It stores master data only.
D) It is a compilation of data from the database that is organized and produced in printed format.
E) It helps to eliminate data duplication. - CORRECT ANSWER✅✅✅B. It contains selected data from
the data warehouse.
Information and knowledge discovery tools are used primarily to ________.
,A) standardize the format of data retrieved from different systems
B) reduce the complexity of the data to be analyzed
C) extract information from existing data
D) analyze for decision-making support
E) allow managers to learn query language for the effective maintenance of the database - CORRECT
ANSWER✅✅✅C. Extract information from existing data
________ are produced at predefined intervals to support routine decisions.
A) Ad hoc queries
B) Exception reports
C) Drill-down reports
D) Scheduled reports
E) Key-indicator reports - CORRECT ANSWER✅✅✅Scheduled Reports
Which of the following statements is true about key-indicator reports?
A) They provide a summary of critical information on a recurring schedule.
B) They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
C) They are produced at predefined intervals to support routine decisions.
D) They highlight situations that are out of the normal range.
E) They answer unplanned information requests to support a nonroutine decision. - CORRECT
ANSWER✅✅✅A. They provide a summary of critical information on a recurring schedule.
Which of the following statements is true about exception reports?
A) They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
B) They are produced at predefined intervals to support routine decisions.
,C) They answer unplanned information requests to support a nonroutine decision.
D) They provide a summary of critical information on a recurring schedule.
E) They highlight situations that are out of the normal range. - CORRECT ANSWER✅✅✅A. They help
analyze why a key indicator is not at an appropriate level or why an exception occurred
________ help analyze why a key indicator is not at an appropriate level or why an exception occurred.
A) Ad hoc queries
B) Exception reports
C) Drill-down reports
D) Scheduled reports
E) Key-indicator reports - CORRECT ANSWER✅✅✅C. Drill-down reports
Which of the following statements is true about ad hoc queries?
A) They are produced at predefined intervals to support routine decisions.
B) They provide a summary of critical information on a recurring schedule.
C) They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
D) They answer unplanned information requests to support a nonroutine decision. E) They highlight
situations that are out of the normal range. - CORRECT ANSWER✅✅✅D. They answer unplanned
information requests to support a non-routine decision
________ refers to the process of quickly conducting complex, multidimensional analyses of data stored
in a database that is optimized for retrieval, typically using graphical software tools.
A) Inferencing
B) Online analytical processing
C) Normalization
D) Data mining
E) Predictive analysis - CORRECT ANSWER✅✅✅B. Online analytical processing.
Online analytical processing tools enable users to ________.
A) discover "hidden" predictive relationships in the data
, B) find associations or correlations among sets of items
C) scrutinize different dimensions of data beyond simple data summaries
D) group related records together on the basis of having similar values for attributes
E) extract textual information from Web documents - CORRECT ANSWER✅✅✅C. Scrutinize different
dimensions of data beyond simple data summaries. .
Which of the following statements is true about an online analytical processing server?
A) It is a data structure allowing for multiple dimensions to be added to a traditional two- dimensional
table.
B) It groups related records together on the basis of having similar values for attributes.
C) It allows you to make hypothetical changes to the data associated with a problem and observe how
these changes influence the results.
D) It uses reasoning methods based on knowledge about a specific problem domain in order to provide
advice.
E) It understands how data are organized in the database and has special functions for analyzing the
data. - CORRECT ANSWER✅✅✅E. It understands how data are organized in the database and has
special functions for analyzing the data.
How do online analytical processing systems improve performance?
A) They preaggregate data so that only the subset of the data necessary for the queries is extracted.
B) They use reasoning methods based on knowledge about a specific problem domain.
C) They make hypothetical changes to the data associated with a problem.
D) They allow for multiple dimensions to be added to a traditional two-dimensional table.
E) They provide capabilities for discovering "hidden" predictive relationships in the data. - CORRECT
ANSWER✅✅✅A. They pre aggregate data so that the only subset of the data necessary for the
queries is extracted.
n online analytic processing systems, ________ are the values or numbers the user wants to analyze.
A) dimensions B) forms
C) measures D) queries
E) entities - CORRECT ANSWER✅✅✅C. Measures
28) ________ involves standardizing the format of data retrieved from different systems.
A) Data cleansing
B) Data mining
C) Normalization
D) Content mining
E) Clustering - CORRECT ANSWER✅✅✅A. Data Cleansing
29) A ________ is a data warehouse that is limited in scope.
A) metadata repository
B) master data
C) data model
D) data reduction
E) data mart - CORRECT ANSWER✅✅✅E. Data Mart
30) Which of the following statements is true about a data mart?
A) It standardizes the format of data retrieved from different systems.
B) It contains selected data from the data warehouse.
C) It stores master data only.
D) It is a compilation of data from the database that is organized and produced in printed format.
E) It helps to eliminate data duplication. - CORRECT ANSWER✅✅✅B. It contains selected data from
the data warehouse.
Information and knowledge discovery tools are used primarily to ________.
,A) standardize the format of data retrieved from different systems
B) reduce the complexity of the data to be analyzed
C) extract information from existing data
D) analyze for decision-making support
E) allow managers to learn query language for the effective maintenance of the database - CORRECT
ANSWER✅✅✅C. Extract information from existing data
________ are produced at predefined intervals to support routine decisions.
A) Ad hoc queries
B) Exception reports
C) Drill-down reports
D) Scheduled reports
E) Key-indicator reports - CORRECT ANSWER✅✅✅Scheduled Reports
Which of the following statements is true about key-indicator reports?
A) They provide a summary of critical information on a recurring schedule.
B) They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
C) They are produced at predefined intervals to support routine decisions.
D) They highlight situations that are out of the normal range.
E) They answer unplanned information requests to support a nonroutine decision. - CORRECT
ANSWER✅✅✅A. They provide a summary of critical information on a recurring schedule.
Which of the following statements is true about exception reports?
A) They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
B) They are produced at predefined intervals to support routine decisions.
,C) They answer unplanned information requests to support a nonroutine decision.
D) They provide a summary of critical information on a recurring schedule.
E) They highlight situations that are out of the normal range. - CORRECT ANSWER✅✅✅A. They help
analyze why a key indicator is not at an appropriate level or why an exception occurred
________ help analyze why a key indicator is not at an appropriate level or why an exception occurred.
A) Ad hoc queries
B) Exception reports
C) Drill-down reports
D) Scheduled reports
E) Key-indicator reports - CORRECT ANSWER✅✅✅C. Drill-down reports
Which of the following statements is true about ad hoc queries?
A) They are produced at predefined intervals to support routine decisions.
B) They provide a summary of critical information on a recurring schedule.
C) They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
D) They answer unplanned information requests to support a nonroutine decision. E) They highlight
situations that are out of the normal range. - CORRECT ANSWER✅✅✅D. They answer unplanned
information requests to support a non-routine decision
________ refers to the process of quickly conducting complex, multidimensional analyses of data stored
in a database that is optimized for retrieval, typically using graphical software tools.
A) Inferencing
B) Online analytical processing
C) Normalization
D) Data mining
E) Predictive analysis - CORRECT ANSWER✅✅✅B. Online analytical processing.
Online analytical processing tools enable users to ________.
A) discover "hidden" predictive relationships in the data
, B) find associations or correlations among sets of items
C) scrutinize different dimensions of data beyond simple data summaries
D) group related records together on the basis of having similar values for attributes
E) extract textual information from Web documents - CORRECT ANSWER✅✅✅C. Scrutinize different
dimensions of data beyond simple data summaries. .
Which of the following statements is true about an online analytical processing server?
A) It is a data structure allowing for multiple dimensions to be added to a traditional two- dimensional
table.
B) It groups related records together on the basis of having similar values for attributes.
C) It allows you to make hypothetical changes to the data associated with a problem and observe how
these changes influence the results.
D) It uses reasoning methods based on knowledge about a specific problem domain in order to provide
advice.
E) It understands how data are organized in the database and has special functions for analyzing the
data. - CORRECT ANSWER✅✅✅E. It understands how data are organized in the database and has
special functions for analyzing the data.
How do online analytical processing systems improve performance?
A) They preaggregate data so that only the subset of the data necessary for the queries is extracted.
B) They use reasoning methods based on knowledge about a specific problem domain.
C) They make hypothetical changes to the data associated with a problem.
D) They allow for multiple dimensions to be added to a traditional two-dimensional table.
E) They provide capabilities for discovering "hidden" predictive relationships in the data. - CORRECT
ANSWER✅✅✅A. They pre aggregate data so that the only subset of the data necessary for the
queries is extracted.
n online analytic processing systems, ________ are the values or numbers the user wants to analyze.
A) dimensions B) forms
C) measures D) queries
E) entities - CORRECT ANSWER✅✅✅C. Measures
