Snowflake SnowPro Core Practice Exam 3
Save
Terms in this set (104)
A user created a transient table andThe transient table version cannot be retrieved made
several changes to it over theafter 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 indicatesBytes are spilling to external storage.
that a warehouse is sized too small?
If you want a dedicated virtualStandard
warehouse, which is the lowest
SnowFlake edition you should optIn 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 aACCOUNTADMIN
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 a14.
medium sized warehouse with 2 clusters running in auto-scaled modeA medium size warehouse
with one cluster for 3 hours, considering that the firstconsumes four credits per hour. The first
cluster will clusters runs continuously and therun continuously for three hours, consuming 12
second one runs for 30 minutes incredits. 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 goes4 hours into a detached state, which cannot be committed or
rolled back, howIf the transaction is left open or not aborted by the long will Snowflake take to
abort theuser, 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 tableReplicate your account to another region and with a
consumer located in acreate 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 beWhen the procedure is defined to execute as accessed
in a Snowflake scriptingCALLER procedure?
What COPY INTO SQL commandSINGLE=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 fewerthat the result remains in the cache.
than 24 hours, and it takes around 10 minutes to execute. They realizedIn this case,
because the underlying data changes that the underlying data changesevery morning due to
the ETL process, the results because of an ETL process that runscache 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 cacheruns. In
that case, the results of that query will be to save the 10 minutes that the querystored 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, and122 seconds.
it was suspended. After some time, it ran for another 20 seconds. For howYou 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 differencesSnowflake VPS provides a dedicated metadata between the
Virtual Privatestore and pool of computing resources, whereas Snowflake (VPS) and Businessit'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 andThe transient table version cannot be retrieved made
several changes to it over theafter 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 indicatesBytes are spilling to external storage.
that a warehouse is sized too small?
If you want a dedicated virtualStandard
warehouse, which is the lowest
SnowFlake edition you should optIn 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 aACCOUNTADMIN
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 a14.
medium sized warehouse with 2 clusters running in auto-scaled modeA medium size warehouse
with one cluster for 3 hours, considering that the firstconsumes four credits per hour. The first
cluster will clusters runs continuously and therun continuously for three hours, consuming 12
second one runs for 30 minutes incredits. 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 goes4 hours into a detached state, which cannot be committed or
rolled back, howIf the transaction is left open or not aborted by the long will Snowflake take to
abort theuser, 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 tableReplicate your account to another region and with a
consumer located in acreate 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 beWhen the procedure is defined to execute as accessed
in a Snowflake scriptingCALLER procedure?
What COPY INTO SQL commandSINGLE=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 fewerthat the result remains in the cache.
than 24 hours, and it takes around 10 minutes to execute. They realizedIn this case,
because the underlying data changes that the underlying data changesevery morning due to
the ETL process, the results because of an ETL process that runscache 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 cacheruns. In
that case, the results of that query will be to save the 10 minutes that the querystored 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, and122 seconds.
it was suspended. After some time, it ran for another 20 seconds. For howYou 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 differencesSnowflake VPS provides a dedicated metadata between the
Virtual Privatestore and pool of computing resources, whereas Snowflake (VPS) and Businessit'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
