SnowPro Advanced: Architect — Question 82

What step will improve the performance of queries executed against an external table?

Answer options

• A. Partition the external table.
• B. Shorten the names of the source files.
• C. Convert the source files' character encoding to UTF-8.
• D. Use an internal stage instead of an external stage to store the source files.

Correct answer: A

Explanation

Partitioning the external table allows for more efficient data retrieval by enabling the database to scan only relevant segments of the data, thus improving query performance. The other options do not directly address query execution efficiency; shortening file names and changing character encoding do not impact the way data is queried, and using an internal stage might not be necessary for performance improvement.