adplus-dvertising
frame-decoration

Question

What is the top-down approach in building a data warehouse?

a.

Starting with individual data marts and building them one by one

b.

Building an enterprise-wide data warehouse first and then deploying data marts

c.

Using a practical approach of conformed data marts

d.

Quick deployment of a few data marts for specific reasons

Answer: (b).Building an enterprise-wide data warehouse first and then deploying data marts Explanation:The top-down approach involves starting with an enterprise-wide data warehouse and possibly building it iteratively before deploying data marts.

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 top-down approach in building a data warehouse?

Similar Questions

Discover Related MCQs

Q. What is the bottom-up approach in building a data warehouse?

Q. When considering the "build or buy" decision in data warehousing, what are organizations trying to determine?

Q. What does the planning stage of a data warehouse project involve regarding the "build or buy" decision?

Q. What are the major advantages of choosing a single vendor solution for a data warehouse?

Q. What are the major advantages of the best-of-breed solution that combines products from multiple vendors?

Q. What should drive a data warehouse project?

Q. What should you focus on before building a data warehouse?

Q. What kind of information should you gather in the preliminary survey for a data warehouse project?

Q. Why is top management support crucial for a data warehouse project?

Q. What should be used to justify the total cost of a data warehouse project?

Q. Which of the following is one of the typical approaches to justify a data warehouse project?

Q. What is the role of top management support in a data warehouse project?

Q. In the context of data warehousing, what does ROI stand for?

Q. Which component of data warehouse costs is typically the highest?

Q. In companies where data warehousing is introduced without a full cost-justification analysis, what is the basis for justification?

Q. What is the purpose of calculating the business value of a proposed data warehouse in the justification process?

Q. Why is top management support crucial for a data warehouse project?

Q. What is the primary purpose of an overall plan for a data warehousing initiative?

Q. How do data warehouse projects differ from OLTP application projects?

Q. Which of the following is NOT a suggestion for managing the differences in data warehouse projects?