What does the Activity area of Snowsight allow users to do? (Select TWO).
Correct Answer: B,C
The Activity area of Snowsight, Snowflake's web interface, allows users to perform several important tasks related to query management and performance analysis. Among the options provided, the correct ones are: * B. Explore each step of an executed query:Snowsight provides detailed insights into query execution, including the ability to explore the execution plan of a query. This helps users understand how a query was processed, identify performance bottlenecks, and optimize query performance. * C. Monitor queries executed by users in an account:The Activity area enables users to monitor the queries that have been executed by users within the Snowflake account. This includes viewing the history of queries, their execution times, resources consumed, and other relevant metrics. These features are crucial for effective query performance tuning and ensuring efficient use of Snowflake's resources. References: * Snowflake Documentation on Snowsight: Using Snowsight
Question 312
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Correct Answer: D
Snowflake recommends using the COPY command for bulk loading data batches from files already available in cloud storage. This command allows for efficient and large-scale data loading operations from files staged in cloud storage into Snowflake tables3.
Question 313
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
Correct Answer: C,D
Question 314
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Correct Answer: C
The COPY INTO <location> command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage1.
Question 315
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. Reference: Snowflake Documentation on Information Schema (https://docs.snowflake.com/en/sql-reference /info-schema/object_dependencies.html)
