Which view should you use to identify commonly run queries in your data warehouse?

• A. queryinsights.exec_requests_history
• B. queryinsights.frequently_run_queries
• C. queryinsights.long_running_queries
• D. queryinsights.query_logs

Answer: (B)

To identify commonly run queries, you want the view that shows how often each query is executed. This makes it easy to see which queries appear most frequently across your workload, which is exactly what you need to identify patterns to optimize or cache. The frequently_run_queries view provides that frequency data, so you can quickly surface the top repeated queries and decide where to focus optimization efforts.

Other views serve different purposes: exec_requests_history shows a broader history of query executions, but not a clear focus on frequency; long_running_queries highlights queries that take a long time to run, which helps with performance tuning of slow queries; query_logs contains raw query execution logs, which is more granular than needed for spotting commonly run queries.