Which types of SQL templates does Talend Studio provide? Choose 2 answers

Which types of SQL templates does Talend Studio provide? Choose 2 answers
A . Custom SQL templates
B . Use-defined SQL templates
C . System SQL templates
D . System-defined SQL templates

View Answer

Answer: B, C

Explanation:

Talend Studio provides two types of SQL templates: system SQL templates and user-defined SQL templates. SQL templates are predefined SQL queries that can be used in various components that execute SQL statements, such as tDBInput, tDBRow, tDBOutput, etc. System SQL templates are provided by Talend Studio and cover common SQL operations, such as creating, dropping, or altering tables, inserting, updating, or deleting data, etc. User-defined SQL templates are created by the user and can be customized according to specific needs. User-defined SQL templates can be created by using the SQL Templates view in Talend Studio and can be organized into categories and subcategories. There are no custom SQL templates or system-defined SQL templates in Talend Studio.

Reference: Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [SQL Templates – 7.3]