Top 250+ Solved Information Systems Management MCQ Questions Answer
Q. Which of the following statement is true?
a. The data warehouse consists of data marts and operational data
b. The data warehouse is used as a source for the operational data
c. The operational data are used as a source for the data warehouse
d. All of the above
Q. The following is true of three-tier data warehouses:
a. Once created, the data marts will keep on being updated from the data warehouseat periodic times
b. Once created, the data marts will directly receive their new data from the operational databases
c. The data marts are different groups of tables in the data warehouse
d. A data mart becomes a data warehouse when it reaches a critical size
Q. The following technology is not well-suited for data mining:
a. Expert system technology
b. Data visualization
c. Technology limited to specific data types such as numeric data types
d. Parallel architecture
Q. What is true of the multidimensional model?
a. It typically requires less disk storage
b. It typically requires more disk storage
c. Typical business queries requiring aggregate functions take more time
d. Increasing the size of a dimension is difficult
Q. The most common source of change data in refreshing a data warehouse is:
a. Queryable change data
b. Cooperative change data
c. Logged change data
d. Snapshot change data
Q. Which of the following statements is not true about refreshing a data warehouse:
a. It is a process of managing timing differences between the updating of data sources and the related data warehouse objects.
b. Updates to dimension tables may occur at different times than the fact table
c. The data warehouse administrator has more control over the load time lag than the valid time lag
d. None of the above
Q. The generic two-level data warehouse architecture includes which of the following?
a. At least one data mart
b. Data that can extracted from numerous internal and external sources
c. Near real-time updates
d. All of the above.
Q. A goal of data mining includes which of the following?
a. To explain some observed event or condition
b. To confirm that data exists
c. To analyze data for expected relationships
d. To create a new data warehouse
Q. Data mining is used to aid in
a. Operational management
b. Analyzing past decision made by managers
c. Detecting patterns in operational data
d. Retrieving archival data
Q. Data mining requires
a. large quantities of operational data stored over a period of time
b. lots of tactical data
c. several tape drives to store archival data
d. large mainframe computers
Q. What is Data Mining?
a. The capability to drill down into an organization's data once a question has been raised.
b. The setting up of queries to alert management when certain criteria are met.
c. The process of performing trend analysis on the financial data of an organization.
d. The automated process of discovering patterns and relationships in an organization's data.
Q. If knowledge discovery is one aspect of data mining, ____________ is the other.
a. Prediction
b. association
c. relation
d. linking
Q. Data mining tools enable you to
a. Discover any existing natural classifications
b. Compare data mining with OLAP
c. Give a practical boost to the data mining process.
d. Uncover hidden information.
Q. ___________ & _____________ are 2 outcomes of data mining operations:
a. Data & information
b. Relationships & patterns
c. Associations & linkages
d. Unstructured & structured data