What database object type is used to hold the computed results for the pricing group in the example 'ProductsWithPricingGroup'?

• A. TABLE
• B. VIEW
• C. FUNCTION
• D. STORED PROCEDURE

Answer: (A)

Holding computed results for reuse means storing them in a persistent container that keeps the data as rows. A table is exactly that: a physical structure that holds the results of the computation so they can be queried quickly without recomputing every time. In the example, ProductsWithPricingGroup is envisioned as a stored collection of product rows with their associated pricing group, which you can access directly and rely on being current until you update it.

A view, in contrast, is just a saved query that presents data from underlying tables without storing the result set itself. A function (including table-valued ones) returns data when invoked, but it doesn’t serve as a stored, persistent dataset. A stored procedure runs code to perform actions (often including updates or fills of tables) but is a runnable object, not the persistent storage itself.