Application Engine programs can be used for:
-
row-by-row processing
-
set-based processing
-
SQL statements
-
both 1 and 2
Application Engine programs support both row-by-row processing (option 1) and set-based processing (option 2), making 'both 1 and 2' the correct answer. Set-based processing is generally preferred for performance, while row-by-row is used when business logic requires it. SQL statements are used within both approaches but are not a processing method themselves.
Application Engine programs support both row-by-row processing (iterating record by record, useful for complex per-row logic) and set-based processing (issuing bulk SQL operations across a set of rows at once for performance), so 'both 1 and 2' correctly captures the tool's dual capability. Restricting the answer to only one processing style would understate what Application Engine is actually designed to do.