Snowflake Certification Exam Rated A+ Verified
A defined data set can be shared with customers outside the Snowflake account is? -
ANSWER-Snowflakes's Data Sharing
A defined data set is a point in time snapshot and can be updated by customers is? -
ANSWER-Snowflake's Cloning
A Snowflake mechanism that is used to limit the number of micro-partitions scanned by
a query is called ________?
A) Governor
B) Regulator
C) Pruning
D) None of the above - ANSWER-C) Pruning
All security information is stored in the ___________ layer in the Snowflake
architecture?
A) Storage
B) Compute
C) Service
D) All of the above - ANSWER-C) Service
All statements are true about Data (Storage) except:
A) All data in Snowflake is maintained in databases
B) Each database consists of one or more schemas , and, within these schemas, one or
more tables and/or views
C) Schemas can be thought of as a physical grouping of database objects
D) Snowflake does not place any hard limits on the number of databases, schemas
(within a database), or objects (within a schema) you can create - ANSWER-C)
Schemas can be thought of as a physical grouping of database objects
Logical grouping not physical grouping
An enterprise view of data is useful because:
A) A data set can be stored once and shared multiple times
B) Data set provisioning is assigned to the owner of the data set
C) Data sets can be shared securely
D) All of the above - ANSWER-D) All of the above
Choosing separate accounts in Snowflake enables users to have:
A) Different editions of Snowflake and different regions
B) Billing at the account level
,C) Simpler database object deployment between environments
D) All of the above - ANSWER-D) All of the above
Data Sharing Consumers will have to:
A) Incur the cost of Compute (virtual warehouse)
B) Must create a database based on the share using the ACCOUNTADMIN role
C) Can query shared objects in the same query that they query their own objects
D) All of the above - ANSWER-D) All of the above
Data Sharing Providers will have to:
A) Incur the cost of the data storage - normal rates apply
B) May share a data set with an unlimited number of accounts
C) May set up and manage "Reader Accounts" for consumers who are not already
Snowflake customers
D) All of the above - ANSWER-D) All of the above
Database designer should consider using Clustering Keys when (check all that apply):
A) The tables is very large (multi TB)
B) Table is large enough to reside on many micro-partitions
C) Columns in the table can provide sufficient filtering to select a subset of these micro-
partitions
D) All of the above - ANSWER-D) All of the above
Economy Scaling Policy - ANSWER-Definition:
Conserves credits by favoring keeping running clusters fully-loaded rather than starting
additional clusters, which may result in queries being queued and taking longer to
complete. (default setting)
Cluster Starts....
Only if the system estimates there's enough query load to keep the cluster busy for at
least 6 minutes.
Cluster Shuts down....
After 5 to 6 consecutive successful checks (performed at 1 minute intervals), which
determine whether the load on the least-loaded cluster could be redistributed to the
other clusters without spinning up the cluster again.
How can the user/administrator increase the hit ratio on the local data cache (select all
that apply):
A) Seed the cache with queries
B) Increase the cluster size
C) Alter the data cache memory parameter
, D) All of the above - ANSWER-A & B
How many availability zones does Snowflake replicate to for disaster recovery and high
availability?
A) Zero
B) One
C) Three
D) As many as the user specifies in the configuration - ANSWER-C) Three - Snowflake
automatically does this for each account. It is built-in and fully managed by Snowflake
How many cluster keys can reside on a Snowflake table?
A) 0
B) 1
C) 3
D) 4
E) it depends - ANSWER-B) - only one cluster key can be created on a table (natural
key or defined key)
How many resource monitors can you have at the account level?
A) 0
B) 1
C) 2
D) up to 5
E) unlimited - ANSWER-B) 1
Identify the best practices for ACCOUNTADMIN role and permissions (select all that
apply):
A) This role should be given to any user that need a high level of authority
B) There should be at least two user granted this role
C) All ACCOUNTADMIN users should have multi-factor authentication enabled
D) Objects should not be created using this role
E) All of the above - ANSWER-B, C, & D
If the Credit Quota of a Resource Monitor is reached, suspended warehouses can not
be resumed until one of the conditions is met (select all that apply)?
A) A new billing cycle starts
B) Credit quota of the monitor is increased
C) The credit threshold for the trigger is increased
D) The monitor is no longer assigned to the warehouse
E) The monitor is dropped
F) All of the above - ANSWER-F) All of the above
A defined data set can be shared with customers outside the Snowflake account is? -
ANSWER-Snowflakes's Data Sharing
A defined data set is a point in time snapshot and can be updated by customers is? -
ANSWER-Snowflake's Cloning
A Snowflake mechanism that is used to limit the number of micro-partitions scanned by
a query is called ________?
A) Governor
B) Regulator
C) Pruning
D) None of the above - ANSWER-C) Pruning
All security information is stored in the ___________ layer in the Snowflake
architecture?
A) Storage
B) Compute
C) Service
D) All of the above - ANSWER-C) Service
All statements are true about Data (Storage) except:
A) All data in Snowflake is maintained in databases
B) Each database consists of one or more schemas , and, within these schemas, one or
more tables and/or views
C) Schemas can be thought of as a physical grouping of database objects
D) Snowflake does not place any hard limits on the number of databases, schemas
(within a database), or objects (within a schema) you can create - ANSWER-C)
Schemas can be thought of as a physical grouping of database objects
Logical grouping not physical grouping
An enterprise view of data is useful because:
A) A data set can be stored once and shared multiple times
B) Data set provisioning is assigned to the owner of the data set
C) Data sets can be shared securely
D) All of the above - ANSWER-D) All of the above
Choosing separate accounts in Snowflake enables users to have:
A) Different editions of Snowflake and different regions
B) Billing at the account level
,C) Simpler database object deployment between environments
D) All of the above - ANSWER-D) All of the above
Data Sharing Consumers will have to:
A) Incur the cost of Compute (virtual warehouse)
B) Must create a database based on the share using the ACCOUNTADMIN role
C) Can query shared objects in the same query that they query their own objects
D) All of the above - ANSWER-D) All of the above
Data Sharing Providers will have to:
A) Incur the cost of the data storage - normal rates apply
B) May share a data set with an unlimited number of accounts
C) May set up and manage "Reader Accounts" for consumers who are not already
Snowflake customers
D) All of the above - ANSWER-D) All of the above
Database designer should consider using Clustering Keys when (check all that apply):
A) The tables is very large (multi TB)
B) Table is large enough to reside on many micro-partitions
C) Columns in the table can provide sufficient filtering to select a subset of these micro-
partitions
D) All of the above - ANSWER-D) All of the above
Economy Scaling Policy - ANSWER-Definition:
Conserves credits by favoring keeping running clusters fully-loaded rather than starting
additional clusters, which may result in queries being queued and taking longer to
complete. (default setting)
Cluster Starts....
Only if the system estimates there's enough query load to keep the cluster busy for at
least 6 minutes.
Cluster Shuts down....
After 5 to 6 consecutive successful checks (performed at 1 minute intervals), which
determine whether the load on the least-loaded cluster could be redistributed to the
other clusters without spinning up the cluster again.
How can the user/administrator increase the hit ratio on the local data cache (select all
that apply):
A) Seed the cache with queries
B) Increase the cluster size
C) Alter the data cache memory parameter
, D) All of the above - ANSWER-A & B
How many availability zones does Snowflake replicate to for disaster recovery and high
availability?
A) Zero
B) One
C) Three
D) As many as the user specifies in the configuration - ANSWER-C) Three - Snowflake
automatically does this for each account. It is built-in and fully managed by Snowflake
How many cluster keys can reside on a Snowflake table?
A) 0
B) 1
C) 3
D) 4
E) it depends - ANSWER-B) - only one cluster key can be created on a table (natural
key or defined key)
How many resource monitors can you have at the account level?
A) 0
B) 1
C) 2
D) up to 5
E) unlimited - ANSWER-B) 1
Identify the best practices for ACCOUNTADMIN role and permissions (select all that
apply):
A) This role should be given to any user that need a high level of authority
B) There should be at least two user granted this role
C) All ACCOUNTADMIN users should have multi-factor authentication enabled
D) Objects should not be created using this role
E) All of the above - ANSWER-B, C, & D
If the Credit Quota of a Resource Monitor is reached, suspended warehouses can not
be resumed until one of the conditions is met (select all that apply)?
A) A new billing cycle starts
B) Credit quota of the monitor is increased
C) The credit threshold for the trigger is increased
D) The monitor is no longer assigned to the warehouse
E) The monitor is dropped
F) All of the above - ANSWER-F) All of the above
