A business analyst queries the same few tables every quarter and does not want to write new SQL code every time. Which of the following would best support the business analyst's needs and allow the da

The correct answer is B. View. A View is a saved SQL query stored in the database that the analyst can call by name - no rewriting required - and since it stores only the query definition (not the data itself), it consumes minimal disk space compared to duplicating table data. A Table stores actual data and wo

Database Fundamentals

Question

A business analyst queries the same few tables every quarter and does not want to write new SQL code every time. Which of the following would best support the business analyst's needs and allow the database administrator to optimize disk space?

Options

ATable
BView
CFunction
DStored procedure

How the community answered

(28 responses)

A
7% (2)
B
79% (22)
C
11% (3)
D
4% (1)

Explanation

A View is a saved SQL query stored in the database that the analyst can call by name - no rewriting required - and since it stores only the query definition (not the data itself), it consumes minimal disk space compared to duplicating table data. A Table stores actual data and would require the analyst to manually populate and maintain it each quarter, wasting disk space. A Function is designed to accept parameters and return computed values, not to simplify repetitive SELECT queries across multiple tables. A Stored Procedure can execute complex logic and DML statements, but it is overkill for read-only reporting needs and doesn't inherently offer the disk-space efficiency of a view.

Memory tip: Think of a View as a "window" into your tables - it shows you the data without copying it, so it's lightweight (disk-friendly) and reusable (no new SQL needed).

Topics

#Database Views#Saved Queries#Disk Space Optimization#Database Objects

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice