wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Snowflake Quiz

Total questions: 25

Worksheet time: 52mins

Name
Class
Date
1.

which are 3 layers in snowflake architecture

a)

Security Layer

b)

Query processing

c)

Database Storage

d)

Product Catalog

e)

Cloud Services

2.

Snowflake can be hosted on which cloud platforms ?

a)

AWS

b)

Oracle Cloud

c)

Google Cloud

d)

Azure

e)

IBM cloud

3.

Compute cost will not increase if we increase the size of warehouse. (True/False)

a)

False

b)

True

4.

We can change the size of warehouse even when it is executing the queries. (True/False)

a)

True

b)

False

5.

Which feature in snowflake allow user to un-drop table which is already dropped?

a)

Fail Safe

b)

Time Travel

c)

Data replication

d)

Zero copy Clone

6.

Which snowflake object will check the credit consumption and alert the user ?

a)

Credit checker

b)

Warehouse Monitor

c)

Resource Monitor

d)

Credit threshold

e)

Credit Monitor

7.

Which of the following are not snowflake editions.

a)

Enterprise Edition

b)

Virtual Private Snowflake

c)

Basic Edition

d)

Business Critical Edition

e)

Premium Edition

8.

Query Optimization occurs in which layer of snowflake architecture ?

a)

Query Processing layer

b)

Database Storage layer

c)

Optimization layer

d)

Cloud Services

9.

Data changes made in Clone object is not reflected on to its source object.

(True/False)

a)

True

b)

False

10.

Consider a table of size 1 GB. This table is cloned and the cloned object's size is also 1 GB. (True/False)

a)

False

b)

True

11.

Promoting a secondary (i.e. replica) database in an available region to serve as the primary database. Which feature best suits this statement ?

a)

Replication

b)

Fail Safe

c)

Failover

d)

Time Travel

12.

Which type of cache remains for 24 Hours by default ?

a)

Remote Disk Cache

b)

Result Cache

c)

Metadata Cache

d)

Local Disk Cache

e)

Temporary Cache

13.

Select count(*) from EMPLOYEE ;

Which cache will be used for this query ?

a)

Result Cache

b)

Metadata Cache

c)

Local Cache

d)

Remote Disk

e)

None of the above

14.

There is no need for stage file to have same number of columns as target table for loading using COPY statement ?

(True/False)

a)

False

b)

True

15.

Snowsql is a Java based Command line Interface?

a)

True

b)

False

16.

When a warehouse of large size is used for an hour then how many credits are used?

a)

4

b)

8

c)

16

d)

32

17.

Which of the following is the maximum Time Travel Retention in Days for permanent tables?

a)

60

b)

90

c)

100

d)

1

18.

Snowflake data is encrypted in transit and not encrypted at rest?

a)

False

b)

True

19.

Which among below statements are true.

a)

Increase warehouse size to handle complex queries

b)

Decrease warehouse size to handle complex queries

c)

Decreasing warehouse size will save the credits

d)

Increasing warehouse size will save the credits

e)

Active warehouse will consume credits even if it is not executing queries

20.

Which among below statements are False

a)

Account >> Database >> Table >> Schema

b)

Schema >> Account >> Database >> Table

c)

Account >> Schema >> Database >> Table

d)

Account >> Database >> Schema >> Table

e)

Account >> Database >> Schema >> User >> Table

21.

Which snowflake object is used to capture changes in snowflake table(CDC - change data capture) ?

a)

Task

b)

Stream

c)

Resource Monitor

d)

Pipe

22.

Select the statements which are correct/True

a)

Scale up means increasing warehouse size

b)

Scale out means increasing warehouse size

c)

Scale up means adding more clusters to warehouse

d)

Scale out means adding more clusters to warehouse

23.

We can connect to snowflake using which of the below snowflake connectors/drivers/CLI ?

a)

Snowflake connector for python

b)

Snowflake connector for spark

c)

JDBC Driver

d)

Snowsql

24.

In system provided role hierarchy, ACCOUNTADMIN is parent role of SYSADMIN & SECURITYADMIN.

(True/False)

a)

False

b)

True

25.

Types of Internal stage ?

a)

Named Internal Stage

b)

User Stage

c)

Table Stage

d)

External Stage

e)

Database Stage