SOLVED

31) 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) discover “hidden” predictive relationships in the data E) allow managers to learn query language for the effective maintenance of the database 32) ________ 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 33) 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. 34) 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. 35) ________ 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 36) 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. 37) ________ 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 38) 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) analyze 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 39) Which of the following statements is true about 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 is organized in the database and has special functions for analyzing the data. 40) 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.