Which Snowflake feature can be used to find sensitive data in a table or column?
Data classification in Snowflake is a feature that allows organizations to identify and categorize data stored in tables or columns based on its sensitivity level or content type. This feature can be used to find sensitive data within the database by classifying data as confidential, personal, public, etc., making it easier to apply appropriate security measures, such as masking policies or row-level security, to protect sensitive information.
Snowflake Documentation: Data Classification
What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?
In Snowflake, when a query execution requires more memory than what is available, Snowflake handles these situations by spilling the intermediate results to disk. This process is known as 'spilling.' The Query Profile in Snowflake includes a metric that helps users identify when and how much data spilling occurs during the execution of a query. This information is crucial for optimizing queries as excessive spilling can significantly slow down query performance. The value that provides this information about disk usage due to intermediate results not fitting in memory is appropriately labeled as 'Spilling' in the Query Profile.
Snowflake Documentation on Query Profile and Performance: This section explains the various components of the query profile, including the spilling metric, which indicates disk usage for operations where intermediate results exceed available memory.
What can the Snowflake SCIM API be used to manage? (Select TWO).
The Snowflake SCIM (System for Cross-domain Identity Management) API is used for automated user and role management. It enables integration with identity providers (IdPs) for the provisioning and deprovisioning of user accounts and roles in Snowflake. This helps in managing access control and permissions systematically and aligns with identity governance practices.
Snowflake Documentation: Managing Users and Roles with SCIM API
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
Sol
22 hours agoAntione
3 days agoTheola
7 days agoDemetra
14 days agoTy
19 days agoVeronique
1 months agoRaul
1 months agoOretha
1 months agoSlyvia
2 months agoAntione
2 months agoJoaquin
2 months agoCarin
2 months agoCatina
3 months agoValentin
3 months agoTamra
3 months agoCherelle
3 months agoMadalyn
3 months agoValentine
4 months agoToi
4 months agoJillian
5 months agoToi
6 months agoElvera
6 months agoRegenia
6 months agoSonia
6 months ago