Question

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

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

Answer 1

External databases in a data warehouse include Competitor data, Stock market data, and Mailing lists, as these are sourced from outside the organization. Marketing, Sales, Accounting, and Inventory data are usually internal.

Step-by-step explanation:

To identify which options represent external databases in a data warehouse, let's first clarify that an external database refers to data sourced from outside the organization itself. In the list provided, the external databases would include:

• E) Competitor data – This is information collected from sources that are external to the business. It gives insights into what competitors are doing, their pricing, marketing strategies, and more.
• F) Stock market data – This kind of data is collected from financial markets and is external to the business. It offers crucial information about stock prices, market trends, and economic indicators that are valuable for strategic decision-making.
• G) Mailing lists – Mailing lists can be acquired from external sources and used to target potential customers. These lists can include customer demographics and contact information that is not generated internally.

Options A), B), C), and D) represent internal data since they are likely to be generated and collected within the organization itself. Marketing, sales, accounting, and inventory data are typically sourced from the company's own operational systems.