A view is a virtual table whose contents are produced by a SQL query is the correct option.

A view is defined by a query and presents results as if they were a table without necessarily storing the rows separately in the database. When you reference a view the underlying query is executed and the result set is returned which is why it is called a virtual table.

An index is a data structure that speeds up lookups on table columns is incorrect because that statement describes a performance structure used to speed queries rather than a virtual table produced by a query. An index stores pointers to rows to make searches faster and does not itself present query results as a table.

A materialized view is a physical snapshot of a query result stored for faster access is incorrect in this context because that option describes a stored copy of query results. A materialized view stores data and typically requires refresh operations so it is not the same concept as a virtual view produced on demand.

A stored procedure is a saved routine that performs a set of SQL operations is incorrect because a stored procedure is a programmatic object that executes logic and can perform many actions. It is not defined as a virtual table produced by a query even though it can sometimes return result sets.

Full AWS Practitioner Certification Question