Information System Management MCQs and Notes

V

Vikash Gupta • 33.56K Points
Instructor I

Q 81. 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.

S

Shiva Ram • 30.44K Points
Instructor I

Q 82. 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

P

Praveen Singh • 36.81K Points
Coach

Q 83. 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

R

Rakesh Kumar • 28.44K Points
Instructor II

Q 84. 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

R

Ranjeet • 34.60K Points
Instructor I

Q 85. 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

A

Admin • 36.94K Points
Coach

Q 86. 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

R

Ranjeet • 34.60K Points
Instructor I

Q 87. 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

S

Shiva Ram • 30.44K Points
Instructor I

Q 88. Which of the following features usually applies to data in a data warehouse?

(A) Data are often deleted

(B) Most applications consist of transactions

(C) Data are rarely deleted

(D) Relatively few records are processed by applications

V

Vikash Gupta • 33.56K Points
Instructor I

Q 89. Which one manages historic transactions?

(A) OLTP

(B) OLAP

(C) SPREAD SHEET

(D) XML

S

Shiva Ram • 30.44K Points
Instructor I

Q 90. The process of removing the deficiencies and loopholes in the data is called as

(A) Aggregation of data

(B) Extracting of data

(C) Cleaning up of data.

(D) Loading of data