Snowflake Knowledge check Quiz

/20
Created by Paul Sammy

Snowflake Quiz basic

SNOWDBA Knowledge Checker Test 1.0

20 Questions chosen at Random to test your knowledge.

 

You have 3 minutes so think fast.

1 / 20

What is Snowsight?

2 / 20

How many days of Query History can be viewed from ribbon item 'History' in the WebUI?

3 / 20

What commands are used to allow or deny access on an objects to a roles?

4 / 20

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

5 / 20

Which of the below are attributes of a secure view?

6 / 20

'WAREHOUSE_METERING_HISTORY' view shows how much cloud service compute an account has used?

7 / 20

When a task is created it is initially suspended?

8 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

9 / 20

Which best describes the useradmin Role?

10 / 20

Data Shares can only be dropped once approved by a Consumer?

11 / 20

How Long does a COPY INTO bulk load retain load history?

12 / 20

Which of the below system Roles by default can create a Data Share?

13 / 20

Which pipes are cloned with Zero Copy Cloning?

14 / 20

During a Data Unload which option can we specify so data is not split into separate files?

15 / 20

Business intelligence (BI) can be described by which of the below?

16 / 20

Which of the below are components of ELT?

17 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

18 / 20

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

19 / 20

During data Unload we cannot use a SQL query to target the data to extract?

20 / 20

Running a virtual warehouse consumes which of the below?

Your score is

0%