Snowflake Quiz 2

Snowflake Quiz 2

Professional Development

10 Qs

quiz-placeholder

Similar activities

POST TEST ISO 9001 (BEAT ICT 2)

POST TEST ISO 9001 (BEAT ICT 2)

Professional Development

15 Qs

Football Quiz

Football Quiz

KG - Professional Development

15 Qs

tutorial course for internal medicine resident

tutorial course for internal medicine resident

Professional Development

12 Qs

Astro

Astro

5th Grade - Professional Development

11 Qs

Workshop: MCP Server for Boosting Productivity

Workshop: MCP Server for Boosting Productivity

Professional Development

10 Qs

[FSDA Jan'23 Seoul] Quiz - Orientation Week

[FSDA Jan'23 Seoul] Quiz - Orientation Week

Professional Development

10 Qs

Realme C67 Test

Realme C67 Test

Professional Development

13 Qs

Islamic Quiz 🕌

Islamic Quiz 🕌

Professional Development

10 Qs

Snowflake Quiz 2

Snowflake Quiz 2

Assessment

Quiz

Specialty

Professional Development

Practice Problem

Hard

Created by

Pooja J

Used 7+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which of the following two statements are correct about fail safe?

Fail Safe is same as Time Travel

Failsafe provides a non configurable 7- days period during which historical data is recoverable by Snowflake

Failsafe provides a non configurable 90 days period during which historical data is recoverable by Snowflake

Failsafe ensures historical data is protected in the event of the system failure or other catastrophic event like hardware failure or security breach

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Local Disk cache

Metadata

Result set cache

All of the above

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the name of the parameter which is used to control the query result cache use?

USE_CACHED_RESULT

USE_RESULT_CACHE

RESULT_CACHE_USE

RESULT_SET_CACHE_USE

4.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

What is a responsibility of Snowflake’s virtual warehouses?(Select all that apply)

Infrastructure management

Metadata management

Query parsing and optimization

Query execution

All of the above

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Auto-resume applies only for the queries which use Result set cache

The ability to auto-suspend a warehouse is only available in the Standard and Enterprise edition.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

A user cannot specify a default warehouse when using the ODBC driver.

The default virtual warehouse size can be changed at any time.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Data is duplicated when a table is cloned.

True

false

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Failover and Failback is a feature of which edition?

Enterprise

Standard

Business Critical

VPS

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?