Snow2

Snow2

Professional Development

13 Qs

quiz-placeholder

Similar activities

SAP Quiz

SAP Quiz

Professional Development

10 Qs

Chapter 1 BOSH

Chapter 1 BOSH

Professional Development

10 Qs

Food Additives Quiz 1

Food Additives Quiz 1

University - Professional Development

16 Qs

Audit Sampling Day 1 Recap

Audit Sampling Day 1 Recap

Professional Development

10 Qs

naruto

naruto

KG - Professional Development

10 Qs

EMPOWER

EMPOWER

Professional Development

11 Qs

Analyzing a menu

Analyzing a menu

Professional Development

10 Qs

COMM&IN SAFETY AND SECURITY TRAINING

COMM&IN SAFETY AND SECURITY TRAINING

Professional Development

10 Qs

Snow2

Snow2

Assessment

Quiz

Specialty

Professional Development

Practice Problem

Hard

Created by

Ismael Navarro Cruz

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?