Details around the privileges that have been granted for all objects in an account. The ACCESS_HISTORY view in Snowflake provides a comprehensive log of access control changes, including grants and revocations of privileges on all securable objects within the account. This information is crucial for auditing and monitoring the security posture of your Snowflake environment.
Here's how to understand and use the ACCESS_HISTORY view:
* Purpose of ACCESS_HISTORY View: It is designed to track changes in access controls, such as when a user or role is granted or revoked privileges on various Snowflake objects. This includes tables, schemas, databases, and more.
* Querying ACCESS_HISTORY: To access this view, you can use the following SQL query pattern:
SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY WHERE EVENT_TYPE =
'GRANT' OR EVENT_TYPE = 'REVOKE';
* Interpreting the Results: The results from the ACCESS_HISTORY view include the object type, the specific privilege granted or revoked, the grantee (who received or lost the privilege), and the timestamp of the event. This data is invaluable for audits and compliance checks.
Reference: For detailed information on the ACCESS_HISTORY view and how to interpret its data, please visit the official Snowflake documentation: https://docs.snowflake.com/en/sql-reference/account-usage
/access_history.html

The correct answer is B. Snowflake CLI is primarily used for managing workloads and applications, while SnowSQL is used for executing operations .
SnowSQL is Snowflake's command-line client that is primarily used to connect to Snowflake and execute SQL statements. It is commonly used for SQL operations, including running queries, loading data, unloading data, and executing scripts.
Snowflake CLI is a broader command-line tool designed for managing Snowflake workloads and application development workflows. It supports tasks related to Snowflake Native Apps, Snowpark, Streamlit, stages, tasks, and other development or deployment activities.
Why B is correct:
Snowflake CLI is more focused on managing Snowflake workloads, projects, and applications. SnowSQL is primarily used as a SQL command-line client to execute SQL operations against Snowflake.
Why the other options are incorrect:
A). This reverses the primary purposes of the tools. SnowSQL is not mainly for managing workloads and applications.
C). SnowSQL is not limited to DDL, and Snowflake CLI is not limited to DML.
D). Snowflake CLI is not limited to query execution, and SnowSQL is not a Python package management tool.
Official Snowflake documentation reference:
Snowflake documentation describes SnowSQL as the command-line client for connecting to Snowflake and executing SQL queries. Snowflake CLI is described as a command-line tool for developer workflows and managing Snowflake workloads and applications.
Reference: Snowflake Documentation - SnowSQL; Snowflake Documentation - Snowflake CLI; SnowPro Core Study Guide - Snowflake Account and Resource Management.

stage name=>'bronzestage1));
Explanation:
According to the Snowflake documentation1, a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve the Snowflake-hosted file URL to each file in the stage. A file URL has the following format:
https://<account_identifier>/api/files/<db_name>.<schema_name>.<stage_name>/<relative_path> Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage is B. select * from directory(@bronzestage);

* In SQL, NULL values are not equal to other NULL values. To make comparisons work in join operations, the NVL function can replace NULL with a non-NULL value.
* Example:
SELECT *
FROM table1 t1
JOIN table2 t2
ON NVL(t1.col, 'default') = NVL(t2.col, 'default');
Why Other Options Are Incorrect:
* B. Equal_null function: No such function exists in Snowflake SQL.
* C. NULLIF function: Used to return NULL when two values are equal, not for handling NULL in joins.
* D. IFNULL function: Similar to NVL but less commonly used in this context.
References:
* NVL Function Documentation