Teradata Vantage Certified Associate — Question 27

Which Vantage object contains one or more SQL statements, always executed as a single request?

Answer options

• A. Stored procedure
• B. Fallback
• C. Function
• D. Macro

Correct answer: D

Explanation

The correct answer is D, Macro, because it allows for the execution of one or more SQL statements as a single unit. In contrast, a Stored Procedure (A) is a compiled set of SQL statements that can be executed separately, Fallback (B) refers to a recovery process, and Function (C) is typically used for returning a single value or result rather than executing multiple SQL statements together.