How can you avoid result truncation when the string_agg aggregation result exceeds the limit of 8000 bytes in SQL?
a. Use LOB (Large Object) types
b. Increase the limit in the database settings
c. Split the results into multiple columns
d. Use a different aggregation function