Certified Pega System Architect v7.2 — Question 13

In which of the following situations would you use a SQL connector?

Answer options

• A. Update a table in an external database
• B. Write to a table as part of a distributed transaction
• C. Retrieve a large list of reference data
• D. Execute a complex SQL statement such as a stored procedure

Correct answer: A

Explanation

The correct answer is A because a SQL connector is specifically used to update tables in external databases. Options B, C, and D describe different operations that may not necessarily require a SQL connector, such as distributed transactions, fetching data, or executing complex statements.