By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
A0 days
B1 day
C7 days
D14 days
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
AAccount
BDatabase
CSchema
DTable
What type of function returns one value for each invocation?
AAggregate
BScalar
CTable
DWindow
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
AMicro-partitions
BClustering keys
CEquality searches
DSearch access paths
Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?
A
B
C
D
Which of the following SQL statements will list the version of the drivers currently being used?
AExecute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
BExecute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
CExecute SELECT CURRENT_CLIENT(); from an application
DExecute SELECT CURRENT-VERSION(); from the Python Connector
What action can be performed using the GET command in Snowflake?
AAutomatically rename downloaded files.
BAutomatically decrypt downloaded data on a client machine.
CDownload data files from Snowflake internal stages to a local directory/folder.
DDownload data files from Snowflake external stages to a local directory/folder.
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
AThe type of SQL statements executed
BThe number of tables or databases queried
CThe amount of data stored in the warehouse
DThe length of time the compute resources in each cluster run
What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?
AFaster query performance and increased storage consumption
BSlower query performance and increased storage consumption
CFaster query performance and decreased storage consumption
DSlower query performance and decreased storage consumption
A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
What will Snowflake do if the user's IP address does not match the user-level network policy rules?
ALog the user out.
BDeactivate the network policy.
CPrevent the user from executing additional queries.
DAllow the user to continue until the session or login token expires.
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
Preview
