A query succeeds on one engine and fails on another with a function-related error. What should be examined?
Select an answer to reveal the explanation.
Short Explanation
When the same query works on one engine but fails on another with a function error, you should check the selected engine's capabilities. Engines differ in supported functions and features, so the engine is the variable you're troubleshooting.
Full Explanation
When the only thing that changed is which engine ran the statement, the selected engine's capabilities are the variable to examine. Engines differ in supported functions and features, and a function available on one may not exist on another. The storage-tier explanation is incorrect because storage tiering affects cost and access performance, never SQL semantics. The user-permissions explanation is incorrect because policy is evaluated against the identity and the object, not per engine, and a permission problem produces an access error rather than a function error. The table-format explanation is incorrect because the table format governs table semantics such as commits and schema evolution; the SQL dialect comes from the engine. For the exam, include engine selection alongside syntax, permissions and source availability in the failure checklist.