A financial services firm is using Snowflake's Search Optimization Service on a large transactions table to accelerate point-lookup queries. A data architect notices that while performance has improved, the storage costs associated with the search access paths are higher than anticipated. Which action would be most effective in managing these costs without completely disabling the service?
A data engineering team wants to build a declarative data pipeline that automatically updates a summary table whenever the underlying base tables change. They want to avoid writing complex procedural code using tasks and streams. The pipeline should define the final state of the target table using a SQL query. Which Snowflake feature is designed specifically for this use case?
A DevOps team is adopting Git-based workflows for their Snowflake environment. They want to store their SQL scripts, UDFs, and stored procedures in a Git repository and have them accessible directly within Snowflake for version control and CI/CD integration. Which two objects must be created in Snowflake to enable this workflow? (Select TWO).
True or False: When a resource monitor is configured with a 'Suspend & Notify' action, it will immediately terminate all running queries on the assigned warehouses once the credit quota is reached.
A data science team needs to deploy a complex machine learning model, packaged as a Docker container, for inference directly within Snowflake. They want to avoid managing external infrastructure and ensure the model runs securely next to their data. Which recently introduced Snowflake feature allows them to achieve this?
A marketing analytics company and a retail company want to collaborate on a dataset containing customer purchase history and demographic information. Due to privacy regulations, neither party can move or see the other's raw data. They need a secure environment to run joint queries that analyze the combined data without exposing the underlying PII. Which Snowflake feature is specifically designed for this privacy-preserving collaboration?
A development team is building an application that requires both transactional and analytical queries on the same dataset. They need low-latency point lookups and fast analytical scans without managing two separate systems or dealing with data movement latency. Which Snowflake table type is engineered to handle this hybrid workload?
A security administrator needs to create a masking policy that redacts a string value differently based on the user's role. For users with the `ANALYST` role, it should show the last four characters (e.g., '*********1234'). For all other roles, it should be fully masked (e.g., '**********'). Which SQL function or construct would be used within the masking policy body to determine the current user's role?
A data analyst needs to build an interactive web application on top of data stored in Snowflake. The goal is to create and share data apps quickly without extensive web development experience. The application must be hosted and run securely within the Snowflake environment. Which Snowflake capability should the analyst use?
An administrator is investigating query history and observes that some queries are being fulfilled by the `RESULT_SCAN` command. What does this indicate about those queries?