Snowflake SnowPro Core Practice Exam 3
Save
Terms in this set (104)
A user created a transient table and The transient table version cannot be retrieved
made several changes to it over the after 24 hours
course of several days. There days
after the table was created, the user
would like to go back to the first
version of the table.
How can this be accomplished?
Which Query Profile results indicates Bytes are spilling to external storage.
that a warehouse is sized too small?
If you want a dedicated virtual Standard
warehouse, which is the lowest
SnowFlake edition you should opt In Snowflake, all the Virtual Warehouses are
for? dedicated to the users. If you create a virtual
warehouse, you will only be the one using it.
Which Snowflake role can set up a ACCOUNTADMIN
Snowflake Share by default?
Only the ACCOUNTADMIN role has the "CREATE
SHARE" privilege by default. The privilege can be
granted to additional roles as needed.
,How many credits will consume a 14.
medium sized warehouse with 2
clusters running in auto-scaled mode A medium size warehouse with one cluster
for 3 hours, considering that the first consumes four credits per hour. The first cluster will
clusters runs continuously and the run continuously for three hours, consuming 12
second one runs for 30 minutes in credits. The second one will run for only 30
the second hour? minutes, consuming two credits. The total of the
warehouse will be 14 credits.
If a transaction disconnects and goes 4 hours
into a detached state, which cannot
be committed or rolled back, how If the transaction is left open or not aborted by the
long will Snowflake take to abort the user, Snowflake automatically rolls back the
transaction? transaction after being idle for four hours.
You can still abort a running transaction with the
system function: SYSTEM$ABORT_TRANSACTION.
How can a producer share a table Replicate your account to another region and
with a consumer located in a create a share from that region.
different region?
Data sharing works within the same region;
however, you can replicate your account to
another region and then share data from that
replicated account within that account's region. This
is also true across cloud platforms.
When can user session variables be When the procedure is defined to execute as
accessed in a Snowflake scripting CALLER
procedure?
What COPY INTO SQL command SINGLE=FALSE
should be used to unload data into
multiple files? The default is SINGLE = FALSE (i.e. unload into
multiple files).
, A team runs the same query daily, After the ETL run, execute the identical queries so
generally with a frequency of fewer that the result remains in the cache.
than 24 hours, and it takes around 10
minutes to execute. They realized In this case, because the underlying data changes
that the underlying data changes every morning due to the ETL process, the results
because of an ETL process that runs cache may not be useful for the daily query
every morning. execution. However, suppose the team executes an
identical query immediately after the ETL process
How can they use the results cache runs. In that case, the results of that query will be
to save the 10 minutes that the query stored in the results cache and can be retrieved for
is being executed? subsequent queries. By doing so, the team can
save the 10 minutes that the query is being
executed by retrieving the results from the cache.
A warehouse ran for 62 seconds, and 122 seconds.
it was suspended. After some time, it
ran for another 20 seconds. For how You will be billed for 122 seconds (62 + 60 seconds)
many seconds will you be billed? because warehouses are billed for a minimum of
one minute. The price would be different if the
warehouse wasn't suspended before executing the
second query.
For example, if we had only run a query, and it had
only run for 62 seconds, you would be billed for
these 62 seconds. If it had only run for 20 seconds,
you would've been billed for 60 seconds.
What are the main differences Snowflake VPS provides a dedicated metadata
between the Virtual Private store and pool of computing resources, whereas
Snowflake (VPS) and Business it's not included in the Business Critical Edition.
Critical Editions? Snowflake VPS provides a completely separate
Snowflake environment, isolated from all other
Snowflake accounts, whereas it's not included in
the Business Critical Edition
Save
Terms in this set (104)
A user created a transient table and The transient table version cannot be retrieved
made several changes to it over the after 24 hours
course of several days. There days
after the table was created, the user
would like to go back to the first
version of the table.
How can this be accomplished?
Which Query Profile results indicates Bytes are spilling to external storage.
that a warehouse is sized too small?
If you want a dedicated virtual Standard
warehouse, which is the lowest
SnowFlake edition you should opt In Snowflake, all the Virtual Warehouses are
for? dedicated to the users. If you create a virtual
warehouse, you will only be the one using it.
Which Snowflake role can set up a ACCOUNTADMIN
Snowflake Share by default?
Only the ACCOUNTADMIN role has the "CREATE
SHARE" privilege by default. The privilege can be
granted to additional roles as needed.
,How many credits will consume a 14.
medium sized warehouse with 2
clusters running in auto-scaled mode A medium size warehouse with one cluster
for 3 hours, considering that the first consumes four credits per hour. The first cluster will
clusters runs continuously and the run continuously for three hours, consuming 12
second one runs for 30 minutes in credits. The second one will run for only 30
the second hour? minutes, consuming two credits. The total of the
warehouse will be 14 credits.
If a transaction disconnects and goes 4 hours
into a detached state, which cannot
be committed or rolled back, how If the transaction is left open or not aborted by the
long will Snowflake take to abort the user, Snowflake automatically rolls back the
transaction? transaction after being idle for four hours.
You can still abort a running transaction with the
system function: SYSTEM$ABORT_TRANSACTION.
How can a producer share a table Replicate your account to another region and
with a consumer located in a create a share from that region.
different region?
Data sharing works within the same region;
however, you can replicate your account to
another region and then share data from that
replicated account within that account's region. This
is also true across cloud platforms.
When can user session variables be When the procedure is defined to execute as
accessed in a Snowflake scripting CALLER
procedure?
What COPY INTO SQL command SINGLE=FALSE
should be used to unload data into
multiple files? The default is SINGLE = FALSE (i.e. unload into
multiple files).
, A team runs the same query daily, After the ETL run, execute the identical queries so
generally with a frequency of fewer that the result remains in the cache.
than 24 hours, and it takes around 10
minutes to execute. They realized In this case, because the underlying data changes
that the underlying data changes every morning due to the ETL process, the results
because of an ETL process that runs cache may not be useful for the daily query
every morning. execution. However, suppose the team executes an
identical query immediately after the ETL process
How can they use the results cache runs. In that case, the results of that query will be
to save the 10 minutes that the query stored in the results cache and can be retrieved for
is being executed? subsequent queries. By doing so, the team can
save the 10 minutes that the query is being
executed by retrieving the results from the cache.
A warehouse ran for 62 seconds, and 122 seconds.
it was suspended. After some time, it
ran for another 20 seconds. For how You will be billed for 122 seconds (62 + 60 seconds)
many seconds will you be billed? because warehouses are billed for a minimum of
one minute. The price would be different if the
warehouse wasn't suspended before executing the
second query.
For example, if we had only run a query, and it had
only run for 62 seconds, you would be billed for
these 62 seconds. If it had only run for 20 seconds,
you would've been billed for 60 seconds.
What are the main differences Snowflake VPS provides a dedicated metadata
between the Virtual Private store and pool of computing resources, whereas
Snowflake (VPS) and Business it's not included in the Business Critical Edition.
Critical Editions? Snowflake VPS provides a completely separate
Snowflake environment, isolated from all other
Snowflake accounts, whereas it's not included in
the Business Critical Edition
