What is the outcome of querying a VARIANT column using an invalid path?
Correct Answer: D
Question 622
How does Snowflake reorganize data when it is loaded? (Select TWO).
Correct Answer: D,E
Question 623
What can be used to improve the performance of queries that are run on an external table?
Correct Answer: D
To optimize query performance on external tables, you can define a materialized view on top of the external table. Snowflake will manage and cache the result for faster retrieval. Reference: Snowflake Docs: External Tables with Materialized Views
Question 624
Which governance feature is supported by all Snowflake editions?
Correct Answer: D
Snowflake's governance features vary across different editions, but the OBJECT_DEPENDENCIES view is supported by all Snowflake editions. This feature is part of Snowflake's Information Schema and is designed to help users understand the dependencies between various objects in their Snowflake environment. The OBJECT_DEPENDENCIES view provides a way to query and analyze the relationships and dependencies among different database objects, such as tables, views, and stored procedures. This is crucial for governance, as it allows administrators and data engineers to assess the impact of changes, understand object relationships, and ensure proper management of data assets. Object tags, masking policies, and row access policies are more advanced features that offer fine-grained data governance capabilities such as tagging objects for classification, dynamically masking sensitive data based on user roles, and controlling row-level access to data. These features may have varying levels of support across different Snowflake editions, with some features being exclusive to higher-tier editions.
Question 625
Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?
Correct Answer: A
TheACCOUNTADMINrole in Snowflake has the highest level of privileges, including the ability to manage accounts, users, roles, and all objects within the account. This role is specifically granted the permission to rename an account and specify whether the original URL can be used to access the renamed account. The ACCOUNTADMINrole encompasses broad administrative capabilities, ensuring that users assigned this role can perform critical account management tasks. References: Snowflake Documentation on Roles and Permissions
