Question

Which of the following represent external databases in a data warehouse? (Check all that apply.)

Check all that apply:

A. Marketing data
B. Sales data
C. Accounting data
D. Inventory data
E. Competitor data
F. Stock market data
Mailing lists

Answer 1

In the context of a data warehouse, external databases refer to data sourced from outside the organization. Competitor data and Stock market data are examples of external databases, and Mailing lists can be external if they are not internally generated.

Step-by-step explanation:

External databases in a data warehouse refer to sources of data that are outside the organization's internal systems. When considering the options provided:

• Marketing data (A) is often collected from internal campaigns and customer interactions but can also come externally from market research firms.
• Sales data (B) is typically internal, reflecting the organization's own sales records.
• Accounting data (C) usually originates within the company, reflecting its financial transactions.
• Inventory data (D) is typically internal, monitoring the company's stock levels.
• Competitor data (E) certainly comes from external sources, as it is information about other companies in the industry.
• Stock market data (F) is external and includes information about stock prices, market trends, and financial news.
• Mailing lists can be internal or external but are often purchased from external providers.

In summary, the external databases in this list are Competitor data (E) and Stock market data (F), and potentially the Mailing lists if they are sourced externally.

Correct option:- The external databases in a data warehouse from the provided options are Competitor data (E), Stock market data (F), and potentially Mailing lists if they are externally sourced.