1|Page
IST EXAM QUESTIONS & ANSWERS SOLVED
100% CORRECT!!
28) ________ involves standardizing the format of data
retrieved from different systems.
A) Data cleansing
B) Data mining
C) Normalization
D) Content mining
E) Clustering - ....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 - ....ANSWER ....✔✔ E. Data Mart
30) Which of the following statements is true about a
data mart?
,2|Page
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. - ....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
,3|Page
D) analyze for decision-making support
E) allow managers to learn query language for the
effective maintenance of the database - ....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 - ....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.
, 4|Page
D) They highlight situations that are out of the normal
range.
E) They answer unplanned information requests to
support a nonroutine decision. - ....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. - ....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
IST EXAM QUESTIONS & ANSWERS SOLVED
100% CORRECT!!
28) ________ involves standardizing the format of data
retrieved from different systems.
A) Data cleansing
B) Data mining
C) Normalization
D) Content mining
E) Clustering - ....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 - ....ANSWER ....✔✔ E. Data Mart
30) Which of the following statements is true about a
data mart?
,2|Page
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. - ....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
,3|Page
D) analyze for decision-making support
E) allow managers to learn query language for the
effective maintenance of the database - ....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 - ....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.
, 4|Page
D) They highlight situations that are out of the normal
range.
E) They answer unplanned information requests to
support a nonroutine decision. - ....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. - ....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
