The correct answer is A collection of one or more SQL statements stored on the database server and invoked with parameters.

A collection of one or more SQL statements stored on the database server and invoked with parameters describes a stored procedure because it bundles SQL and procedural logic on the database side and it is executed by the database engine when called. A stored procedure can accept input and output parameters and it runs under the database process so it can manage transactions, enforce permissions, and reduce client server round trips.

A serverless function executed in Cloud Functions is incorrect because Cloud Functions are external serverless compute resources and not SQL routines stored inside the database. They run in a cloud runtime and are managed separately from the database engine.

A virtual table whose rows are produced by a query is incorrect because that definition matches a view rather than a stored procedure. A view represents query results as a virtual table and it does not encapsulate procedural logic or accept invocation parameters in the same way.

A schema object that stores all of the data in the database is incorrect because tables and storage structures hold data and a schema is a namespace. No single schema object stores all data, and that description does not match the purpose of a stored procedure.

Full AWS Practitioner Certification Question