
Snow2
Authored by Ismael Navarro Cruz
Specialty
Professional Development
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the MAXIMUM Time Travel retention period for a transient table?
0 days
1 day
7 days
90 days
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is the advantage of using a reader account?
It can be used by a client that does not have a Snowflake account
It is read-only and prevents the shared data from being updated by the provider.
It can be connected to a Snowflake account in a different region.
It provides limited access to the data share and is therefore cheaper for the data provider.
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What command is used to export or unload data from Snowflake?
PUT @mystage
GET @mystage
Copy INTO @mystage
INSERT @mystage
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which user object property requires contacting Snowflake Support in order to set a value for it?
DISABLED
MINS_TO_BYPASS MFA
MINS_TO_BYPASS_NETWORK_POLICY
MINS_TO_UNLOCK
5.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
When unloading data, which file formats are supported by the COPY INTO command? (Choose two.)
Avro
JSON
ORC
Parquet
XML
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?
ACCOUNTADMIN
SYSADMIN
Tables will be standalone or orphaned.
The role that dropped the custom role.
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which role can execute the SHOW ORGANIZATION ACCOUNTS command successfully?
ACCOUNTADMIN
SECURITYADMIN
ORGADMIN
USERADMIN
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?