adplus-dvertising
frame-decoration

Question

What is the primary reason for mainframes being rarely used for data warehousing?

a.

Cost-effectiveness

b.

Compatibility with OLTP

c.

Scalability

d.

Robustness

Answer: (b).Compatibility with OLTP Explanation:Mainframes are primarily designed for OLTP and not for decision support applications, which is why they are rarely used for data warehousing.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is the primary reason for mainframes being rarely used for data warehousing?

Similar Questions

Discover Related MCQs

Q. Which option is generally robust and adapted for parallel processing, making it a common choice for data warehouses?

Q. What does a computing platform typically consist of?

Q. In the single platform option for data warehousing, where are all functions from data extraction to query processing performed?

Q. What is a benefit of the single platform option for data warehousing?

Q. In the context of the single platform option for data warehousing, what type of legacy systems are often used?

Q. Why do many companies not adopt the single-platform option for data warehousing?

Q. What is a critical consideration for adopting the single-platform solution for data warehousing?

Q. What is the main challenge when trying to implement a single-platform solution for data warehousing in corporations with multiple legacy platforms?

Q. What do most corporations follow in terms of the path of computing platforms?

Q. What is the conclusion that most companies come to after examining legacy systems and modern applications in their corporations?

Q. Where is it best to perform the data extraction function in a data warehouse?

Q. In which step is the data from all sources reconciled and consolidated in some data warehouses?

Q. Where is the best place to perform the Transformation and Consolidation step in data acquisition?

Q. Where is the Validation and Final Quality Check step usually performed in data acquisition?

Q. Which step creates load images for the database files of the data warehouse repository?

Q. What is the ideal platform for the staging area in a data warehouse?

Q. If most of your legacy data sources are on the same platform with extra capacity, where should you consider keeping your data staging area?

Q. What advantage can be gained by keeping the data staging area on the Data Storage Platform in a data warehouse?

Q. Why might a separate platform for data staging be advantageous in a data warehouse?

Q. What is the shared disk method used for in data movement between computing platforms?