Account & Security
A central view of all accounts within your organization
What is organization?
With this setting enabled, Snowflake automatically resumes the warehouse when any statement that requires a warehouse is submitted and the warehouse is the current warehouse for the session.
What is auto-resume?
The command to load data from staged files to an existing table.
What is the COPY INTO command?
The three cloud platforms that Snowflake runs on.
What are Google Cloud Platform, AWS, and Microsoft Azure?
Snowflake feature that allows querying of data at a specific time in history for up to 90 days.
What is Time Travel?
Returns the name of the database in use for the current session
What is CURRENT_DATABASE?
The organization administrator system role is responsible for managing operations at the organization level.
What is an OrgAdmin?
In a virtual warehouse, updating rows in a table is an example of this type of operation.
What is DML?
A named object that specifies the format of the input files (for data loading) or output files (for data unloading).
What is a FILE_FORMAT?
These three key layers make up Snowflake's architecture.
What are database storage, query processing, and cloud services?
Ensures historical data is protected in the event of a system failure or other event.
What is Fail-Safe?
This function returns the name of the primary role in use for the current session.
What is CURRENT_ROLE?
Examples include: SnowSQL and other clients, URLs for accessing any of the Snowflake web interfaces.
What are Account identifiers?
Resizing a warehouse from Medium to Large is an example of this activity.
What is scaling up?
A pre-computed data set derived from a query and stored for later use.
What is a Materialized View?
The three table types in Snowflake
What is transient, temporary, permanent
A comprehensive set of features that help protect data stored in Snowflake against human error, malicious acts, and software failure.
What is Continuous Data Protection?
Use these two characters to CAST a value
What is ::?
You ask all of your Snowflake users to enroll in MFA. They will need this application on their mobile devices to authenticate after enrolling.
What is Duo Mobile?
This mode is enabled by specifying different values for maximum and minimum number of clusters. In this mode, Snowflake starts and stops clusters as needed to dynamically manage the load on the warehouse
What is Auto-scale Mode?
This Snowflake-native tool continuously loads micro-batches of data from an external stage location (Amazon S3, Google Cloud Storage, or Microsoft Azure) into a staging table.
What is Snowpipe?
This table tells you which table's data resides in what micro-partition.
What is a directory table?
All ingested data stored in Snowflake tables is encrypted using AES-256 strong encryption.
What is Data Encryption?
In a SELECT statement, this clause filters the results of window functions
What is QUALIFY?
A quick, easy, and cost-effective way to share data without requiring the consumer to become a Snowflake customer.
What is a reader account?
This policy conserves credits by favoring keeping running clusters fully-loaded rather than starting additional clusters, which may result in queries being queued and taking longer to complete.
What is Economy scaling policy?
The 4 currently supported languages for writing User Defined Functions in Snowflake.
HINT: User-defined functions (UDFs) let you extend the system to perform operations that are not available through the built-in, system-defined functions provided by Snowflake.
What is:
- Java
- Javascript
- Python
- SQL
The amount of downtime when Snowflake releases a new feature.
What is zero down time?
This command is used for bulk data loading into Snowflake tables from internal and external stages.
What is COPY INTO?
The NULL-safe function compares whether two expressions are equal.
What is EQUAL_NULL?
The maximum number of consumer accounts that can be added to a Share object
What is unlimited?
This warehouse size consumes 16 credits per hour.
What is X-Large?
This type of statement includes those such as SELECT, INSERT, UPDATE, DELETE, etc, and is used to store, modify, retrieve, delete and update data in a database.
What is Data Manipulation Language (DML)?
This object is not cloned when a database or schema is cloned.
What are internal named stages?
This allows restricting access to your account based on user IP address.
What is Network Policy?
This function returns a JSON encoded string that lists all roles granted to the current user.
What is CURRENT_AVAILABLE_ROLES?
It is possible to have different roles attached to different worksheets in the Snowflake Web UI. True/False
What is true?
This edition of Snowflake is the minimum required edition that supports multi-cluster warehouses.
What is Enterprise Edition?
This character is used to reference a named internal or a named external stage when writing a COPY INTO statement.
What is "@"?
The lowest Snowflake edition to support private connectivity to Snowflake services including: AWS PrivateLink, Azure Private Link, or Google Cloud Private Service Connect.
This command is used to download unloaded files from an internal stage to your local machine.
What is GET?
Use this to concatenate input values, separated with a delimiter string
What is LISTAGG?
This view should be queried in order to get information on what Roles can access which objects.
What is GRANTS?
With this command the current warehouse for a session can be specified or changed at any time.
What is the USE WAREHOUSE command?
The 5 supported "semi-structured" file formats for loading data to Snowflake.
What is:
- JSON
- Avro
- ORC
- Parquet
- XML
There are a number of queuing queries which are being cancelled by the system. You want Snowflake to wait longer before cancelling them. This parameter helps.
What is STATEMENT_QUEUED_TIMEOUT_IN_SECONDS ?
This command is used for bulk data UNLOADING into Snowflake tables from external stages.
What is COPY INTO?
Windowing functions used access data in a preceding or subsequent rows in the same result set without having to join the table to itself.
What are LEAD and LAG?
The default roles in Snowflake.
What are ACCOUNTADMIN, SECURITYADMIN, PUBLIC, SYSADMIN?
This can be used to calculate virtual warehouse performance metrics such as throughput and latency for specific statement types.
What is the QUERY_HISTORY view?
In Snowflake, this type of table differs from a transient table only in that it exists within the session in which it is created, persists only for the remainder of that session, and is not available to other users or sessions.
What Is a Temporary Table?
The maximum amount of time a result set will persist in the result set cache.
What is 24 hours?
_________ inherit any object parameters that were set on the source object when that object was cloned.
What is a Cloned Object?
This is a table function that takes a VARIANT, OBJECT, or ARRAY column and produces a lateral view
What is FLATTEN?
Snowflake roles that can create network policies.
What are SECURITY ADMIN and ACCOUNTADMIN?
These warehouse sizes are Generally available in Amazon Web Services regions, and in preview in US Government and Azure regions.
What are 5X-Large and 6X-Large?
The NAME of the organizational model for a series of User Created tasks in Snowflake.
HINT: In this model, a series of tasks are composed of a single root task and additional tasks, organized by their dependencies. In this model, tasks flow in a single direction, meaning a task later in the series cannot prompt the run of an earlier task (i.e. a loop). Each task (except the root task) can have multiple predecessor tasks (dependencies); likewise, each task can have multiple subsequent (child) tasks that depend on it. A task runs only after all of its predecessor tasks have run successfully to completion.
WHAT is a Directed Acyclical Graph (or DAG)?
The three types of caches in Snowflake.
What are local disc cache, remote disc cache, and query result cache?
This type of stages cannot be cloned.
What are Internal Named Stages?
Use this statement and option to specify the target table should be truncated before inserting values into the table.
What is INSERT INTO with the OVERWRITE clause?