Exam Prep 2

What is the MINIMUM Snowflake edition required to use the column-level security feature?

• Standard

• Enterprise

• Business Critical

• Virtual Private Snowflake (VPS)

What objects can be cloned within Snowflake? (Choose two.)

• Schemas

• Users

• External tables

• Internal named stages

• External named stages

Which command should be used to generate a single file when unloading data from a Snowflake table into a file?

• PARTITION BY

• MAX_FILE_SIZE = 0

• SINGLE = TRUE

• OVERWRITE = TRUE

If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

• 60

• 91

• 120

• 121

How can a data provider share their Snowflake data? (Choose two.)

• External table

• Snowpark API

• Direct share

• External function

• Snowflake Marketplace listing

A Snowflake account has activated federated authentication.

What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

• The user will be unable to enter a password.

• The user will encounter an error, and will not be able to log in.

• The user will be able to log into Snowflake successfully.

• After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

What is the MINIMUM Snowflake edition that supports database replication?

• Standard

• Enterprise

• Business Critical

• Virtual Private Snowflake (VPS)

What are the possible values within a METADATA$ACTION column in a Snowflake stream? (Choose two.)

• INSERT

• UPDATE

• DELETE

• TRUNCATE

• UPSERT

Which operation can be performed on Snowflake external tables?

• INSERT

• JOIN

• RENAME

• ALTER

Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

• SnowSQL

• Snowflake Python connector

• Snowsight

• SnowCD