Which command will identify the names of files that are in a Snowflake stage?
Correct Answer: A
Question 492
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. Snowflake Documentation: Warehouse Privileges
Question 493
Fail-safe is unavailable on which table types?
Correct Answer: B,D
Question 494
What kind of authentication do Snowpipe REST endpoints use?
Correct Answer: B
Snowpipe uses key-based authentication for its REST endpoints. This involves generating and using a key pair (public and private keys) to securely authenticate API requests. Generate Key Pair: Generate a public and private key pair. Register Public Key: Register the public key with the Snowflake user that will be making the API requests. Authenticate Requests: Use the private key to sign API requests sent to Snowpipe REST endpoints. Reference: Snowflake Documentation: Key Pair Authentication & Key Rotation Snowflake Documentation: Using Snowpipe REST API
Question 495
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 invariant_columnfor each row inmy_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. : Snowflake Documentation: TYPEOF Snowflake Documentation: VARIANT Data Type
