Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
Correct Answer: A
Granting a user the MODIFY, MONITOR, and OPERATE privileges on all virtual warehouses in Snowflake is equivalent to granting the global MANAGE WAREHOUSES privilege. These privileges collectively provide comprehensive control over virtual warehouses. * MODIFY Privilege: * Allows users to change the configuration of the virtual warehouse. * Includes resizing, suspending, and resuming the warehouse. * MONITOR Privilege: * Allows users to view the status and usage metrics of the virtual warehouse. * Enables monitoring of performance and workload. * OPERATE Privilege: * Grants the ability to start and stop the virtual warehouse. * Includes pausing and resuming operations as needed. References: * Snowflake Documentation: Warehouse Privileges
Question 332
Which privilege grants the ability to set a column-level security masking policy on a table or view column?
Correct Answer: A
In Snowflake, the APPLY privilege is required to set a masking policy on a table or view column. This privilege allows a user to associate a masking policy with a specific column, thereby controlling how data in that column is masked or hidden. Create a Masking Policy: Define a masking policy using the CREATE MASKING POLICY command. Grant APPLY Privilege: Grant the APPLY privilege on the masking policy to the relevant roles or users. Apply the Masking Policy: Use the ALTER TABLE or ALTER VIEW command to apply the masking policy to a column. Reference: Snowflake Documentation: Data Masking Snowflake Documentation: CREATE MASKING POLICY Snowflake Documentation: Privileges for Masking Policies
Question 333
Which function determines the kind of value stored in a VARIANT column?
Correct Answer: D
The function used to determine the kind of value stored in a VARIANT column in Snowflake is TYPEOF. Understanding VARIANT Data Type: VARIANT is a flexible data type in Snowflake that can store semi-structured data, such as JSON, Avro, and XML. This data type can hold values of different types, including strings, numbers, objects, arrays, and more. Using TYPEOF Function: The TYPEOF function returns the data type of the value stored in a VARIANT column. It helps in identifying the type of data, which is crucial for processing and transforming semi-structured data accurately. Example Usage: SELECT TYPEOF(variant_column) FROM my_table; This query retrieves the type of data stored in variant_column for each row in my_table. Possible return values include 'OBJECT', 'ARRAY', 'STRING', 'NUMBER', etc. Benefits: Simplifies data processing: Knowing the data type helps in applying appropriate transformations and validations. Enhances query accuracy: Ensures that operations on VARIANT columns are performed correctly based on the data type. Reference: Snowflake Documentation: TYPEOF Snowflake Documentation: VARIANT Data Type
Question 334
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
Correct Answer: A,C
Question 335
Which of the following describes external functions in Snowflake?
Correct Answer: A
External functions in Snowflake are a special type of User-Defined Function (UDF) that call code executed outside of Snowflake, typically through a remote service. Unlike traditional UDFs, external functions do not contain SQL code within Snowflake; instead, they interact with external services to process data2. https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20u
