What is the output of the SHOW VIEWS command in Snowflake?
AA list of all views in User-Defined Functions (UDFs)
BA list of the schemas that contain a given view
CA list of the tables that contain a given view
DA list all views in the current database schema
What is the ALTER TABLE SQL command used for in Snowflake?
AInsert a new row into an existing table.
BDelete a standard Snowflake table.
CSynchronize the table metadata.
DModify the structure of an existing table.
What SQL command can be used to list the contents of a named stage called my_table?
ALIST @my_table;
BLIST @%my_table;
CLIST @~my_table;
DLIST %my_table;
What are the benefits of using the Snowsight data loading interface? (Choose two.)
AIt will try to detect data types.
BIt lets a user merge file rows into the table records.
CIt allows a user to optimize data loading into a table.
DIt allows a user to insert the records of a supported file into a table.
EIt creates permanent file formats that can be used to load data in the future.
What task can be completed using Time Travel?
AUndrop tables that were previously available through a data share.
BRecover and query data that has been recently deleted or updated.
CUndrop a user who was previously dropped and recover all the user’s data.
DMonitor the queries that were run on a virtual warehouse in the last 90 days.
What is a key feature of Snowflake data storage?
AData is automatically encrypted.
BStored data is not compressed.
CSnowflake limits the amount of data that can be stored.
DStoring data does not increase the cost of using Snowflake.
What is a key characteristic of Snowflake Secure Data Sharing?
AData is physically copied to the data consumer’s account.
BShared data is read-only and no data is copied.
CData consumers can modify shared data.
DData sharing requires exporting data files.
What can be used in Snowflake to create a copy of a table without incurring storage costs?
AA transient table
BA directory table
CTime Travel
DA clone
What is the default Time Travel data retention period?
A1 day
B7 days
C45 days
D90 days
What is the PRIMARY benefit for data consumers using the Snowflake Marketplace?
AData consumers can access and export shared data using the public internet.
BData consumers can update tables shared from another Snowflake account.
CData consumers can purchase and access data from providers who do not have Snowflake accounts
DShared data is available to data consumers when data providers make changes to the data.
Where can data consumers search for third-party data and services that can be used in a Snowflake account?
AAdmin
BApp Packages
CData
DMarketplace
What is the purpose of Time Travel?
ATo allow users to access historical data
BTo automatically manage timestamp data types
CTo facilitate the loading of historical data into Snowflake
DTo ensure that users’ data can be recovered at any time
How does query performance of data shared through the Snowflake Marketplace compare to query performance of data shared through a Data Exchange?
AQueries on data shared in the Snowflake Marketplace are much more performant than queries on data shared in a Data Exchange.
BThere is no difference in query performance on data shared in the Snowflake Marketplace compared to query performance on data shared in a Data Exchange.
CQueries on data shared in the Snowflake Marketplace will run slightly slower than queries run on data shared in a Data Exchange.
DQueries on data shared through a Data Exchange will be twice as performant as a queries run on data shared through the Snowflake Marketplace.
What is the SHOW TABLES LIKE 'table_name%'; SQL command used for in Snowflake?
AIdentify any tables in a schema that include table_name.
BIdentify any tables in a schema that start with the words table_name.
CIdentify any tables in a schema that contain data that references a table named table_name.
DIdentify any Snowflake objects in a schema that are associated with a table named table_name.
What is the purpose of using the SELECT * SQL statement in Snowflake?
ATo select all rows from a table
BTo select all columns from a table
CTo select all queries in a database
DTo select the first 10 columns from a table
Which types of worksheets can be created in Snowsight? (Choose two.)
AJava
BJavascript
CPython
DScala
ESQL
What does a red cell status in a notebook indicate?
AThe cell was modified but has not run yet.
BThe cell ran in the current session without errors.
CThe cell ran in the current session and an error occurred.
DThe cell ran in a previous session and results are from the previous session.
What is the purpose of the Start button in the toolbar of Snowflake Notebooks?
AExecutes a SQL statement.
BInitiates the capture of logging and tracing information.
CBegins the top-down cell-by-cell execution of the notebook.
DInitiates a notebook session and sets its label to active when ready.
What is the purpose of the USE SCHEMA command in Snowflake?
