SnowPro Core Certification — Question 551

Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Choose two.)

Answer options

• A. Search optimization service
• B. Automatic clustering
• C. Row access policies
• D. Multi-cluster virtual warehouses
• E. Secure views

Correct answer: A, B

Explanation

The Search optimization service and Automatic clustering are designed to enhance query performance by optimizing data retrieval and organizing data more efficiently. The other options, while they may offer benefits in different scenarios, do not specifically target the performance of queries that fetch a small subset of data from large tables.