What are common data sources for reports in relational databases?

What are common data sources for reports in relational databases?

• A. Tables and Queries
• B. Spreadsheets only
• C. CSV files only
• D. External web pages

Answer: (A)

In relational databases, the data used for reports comes from what lives inside the database itself: tables store the raw data, while queries pull that data together, shaping it through filtering, joining, and aggregating for the report. A report often depends on a base table or on a predefined query (or view) that defines exactly what data to present. Spreadsheets or CSV files are external formats that might be used in broader data workflows, and external web pages are not typical in-database sources for reporting. Because tables and queries are the primary, built-in sources for retrieving and organizing data within a relational database, they are the most common data sources for reports.

In relational databases, the data used for reports comes from what lives inside the database itself: tables store the raw data, while queries pull that data together, shaping it through filtering, joining, and aggregating for the report. A report often depends on a base table or on a predefined query (or view) that defines exactly what data to present. Spreadsheets or CSV files are external formats that might be used in broader data workflows, and external web pages are not typical in-database sources for reporting. Because tables and queries are the primary, built-in sources for retrieving and organizing data within a relational database, they are the most common data sources for reports.