Font size
WorksheetsSnowflake Quiz
Total questions: 25
Worksheet time: 52mins
which are 3 layers in snowflake architecture
Security Layer
Query processing
Database Storage
Product Catalog
Cloud Services
Snowflake can be hosted on which cloud platforms ?
AWS
Oracle Cloud
Google Cloud
Azure
IBM cloud
Compute cost will not increase if we increase the size of warehouse. (True/False)
False
True
We can change the size of warehouse even when it is executing the queries. (True/False)
True
False
Which feature in snowflake allow user to un-drop table which is already dropped?
Fail Safe
Time Travel
Data replication
Zero copy Clone
Which snowflake object will check the credit consumption and alert the user ?
Credit checker
Warehouse Monitor
Resource Monitor
Credit threshold
Credit Monitor
Which of the following are not snowflake editions.
Enterprise Edition
Virtual Private Snowflake
Basic Edition
Business Critical Edition
Premium Edition
Query Optimization occurs in which layer of snowflake architecture ?
Query Processing layer
Database Storage layer
Optimization layer
Cloud Services
Data changes made in Clone object is not reflected on to its source object.
(True/False)
True
False
Consider a table of size 1 GB. This table is cloned and the cloned object's size is also 1 GB. (True/False)
False
True
Promoting a secondary (i.e. replica) database in an available region to serve as the primary database. Which feature best suits this statement ?
Replication
Fail Safe
Failover
Time Travel
Which type of cache remains for 24 Hours by default ?
Remote Disk Cache
Result Cache
Metadata Cache
Local Disk Cache
Temporary Cache
Select count(*) from EMPLOYEE ;
Which cache will be used for this query ?
Result Cache
Metadata Cache
Local Cache
Remote Disk
None of the above
There is no need for stage file to have same number of columns as target table for loading using COPY statement ?
(True/False)
False
True
Snowsql is a Java based Command line Interface?
True
False
When a warehouse of large size is used for an hour then how many credits are used?
4
8
16
32
Which of the following is the maximum Time Travel Retention in Days for permanent tables?
60
90
100
1
Snowflake data is encrypted in transit and not encrypted at rest?
False
True
Which among below statements are true.
Increase warehouse size to handle complex queries
Decrease warehouse size to handle complex queries
Decreasing warehouse size will save the credits
Increasing warehouse size will save the credits
Active warehouse will consume credits even if it is not executing queries
Which among below statements are False
Account >> Database >> Table >> Schema
Schema >> Account >> Database >> Table
Account >> Schema >> Database >> Table
Account >> Database >> Schema >> Table
Account >> Database >> Schema >> User >> Table
Which snowflake object is used to capture changes in snowflake table(CDC - change data capture) ?
Task
Stream
Resource Monitor
Pipe
Select the statements which are correct/True
Scale up means increasing warehouse size
Scale out means increasing warehouse size
Scale up means adding more clusters to warehouse
Scale out means adding more clusters to warehouse
We can connect to snowflake using which of the below snowflake connectors/drivers/CLI ?
Snowflake connector for python
Snowflake connector for spark
JDBC Driver
Snowsql
In system provided role hierarchy, ACCOUNTADMIN is parent role of SYSADMIN & SECURITYADMIN.
(True/False)
False
True
Types of Internal stage ?
Named Internal Stage
User Stage
Table Stage
External Stage
Database Stage
