SOL-C01 · Question #273
SOL-C01 Question #273: Real Exam Question with Answer & Explanation
The correct answer is C: using the 'Text' filter in Query History with the search string 'INSERT INTO. The 'Text' filter allows searching for specific strings within the SQL text of the queries. Searching for 'INSERT INTO SALES_DB.PUBLIC.SALES_TABLE' directly targets the queries inserting data into the specified table. While other filters may help narrow down the results, the 'Tex
Question
A data engineer executed several queries in Snowflake using Snowsight, and now needs to identify the specific queries that inserted data into the 'SALES TABLE' table within the 'SALES DB' database and 'PUBLIC' schema. Which Snowsight feature or filtering option within the Query History interface is MOST effective for achieving this?
Options
- AFiltering the Query History by the 'User' who executed the queries.
- BFiltering the Query History by the 'Warehouse' used during query execution.
- Cusing the 'Text' filter in Query History with the search string 'INSERT INTO
- DFiltering the Query History by 'Status' to only show 'Successful' queries.
- EFiltering the Query History using the 'Query ID' field to narrow down the list.
Explanation
The 'Text' filter allows searching for specific strings within the SQL text of the queries. Searching for 'INSERT INTO SALES_DB.PUBLIC.SALES_TABLE' directly targets the queries inserting data into the specified table. While other filters may help narrow down the results, the 'Text' filter provides the most direct and efficient way to identify the relevant queries.
Topics
Community Discussion
No community discussion yet for this question.