Netguru - Snowflake SnowPro Certification
Preparation Set – Qs & As
What object do you need to create to fetch data from private cloud locations?
A. Storage Integration
B. Only Stage
C. Nothing, just pass source URL to a query
D. Storage Connection ✔️Ans - A. Storage Integration
What parameter should be changed to modify table retention time?
A. DATA_RETENTION
B. DATA_RETENTION_TIME_IN_DAYS
C. DATA_RETENTION_TIME
D. DATA_RETENTION_PERIOD ✔️Ans - B.
DATA_RETENTION_TIME_IN_DAYS
If a user has the role ACCOUNTADMIN assigned it's a best practice to always
use this role. TRUE or FALSE? ✔️Ans - FALSE
If we have multiple roles assigned to our user we can change the role within
that given session. TRUE or FALSE? ✔️Ans - TRUE
All the privileges of the USERADMIN are contained in the SECURITYADMIN.
TRUE or FALSE? ✔️Ans - TRUE
Which role gets assign to every newly created user by default?
A. SYSADMIN
B. USERADMIN
C. PUBLIC ✔️Ans - C. PUBLIC
What precaution should not be taken regarding the role of ACCOUNTADMIN?
A. Assign this role only to a limited number of people in your organization
B. All users assigned the ACCOUNTADMIN role should use multi-factor
authentication for login
,C. Restrict the privileges of the ACCOUNTADMIN role
D. Assign this role to at least 2 users ✔️Ans - C. Restrict the privileges of the
ACCOUNTADMIN roleB. ACCOUNTADMIN
What is the top-level role in Snowflake?
A. SYSADMIN
B. ACCOUNTADMIN
C. SECURITYADMIN
D. USERADMIN ✔️Ans - B. ACCOUNTADMIN
What is the purpose of materialized views?
A. Reduce storage cost for large tables
B. Speed up expensive and complex views
C. To improve query security ✔️Ans - B. Speed up expensive and complex
views
How are materialized views updated if the underlying data has changed?
A. This update is automatically managed by Snowflake
B. We have to set up tasks and streams for that
C. We have to update the view using a sql command ✔️Ans - A. This update
is automatically managed by Snowflake
What happens after a stream is consumed?
A. The stream will be dropped
B. The stream will be empty
C. The values for METADATA$ACTION will change
D. Nothing will happen ✔️Ans - B. The stream will be empty
What is tracked in streams if APPEND_ONLY option is set to TRUE?
A. INSERTS and DELETES
B. INSERTS and UPDATES
C. INSERTS only
D. UPDATES only ✔️Ans - C. INSERTS only
,If we create a tree of tasks, one child can have multiple parent tasks. TRUE or
FALSE? ✔️Ans - FALSE
How can we consume a stream?
A. Using the CONSUME command
B. Using a SELECT on a stream
C. Using the stream with an INSERT or CREATE TABLE statement ✔️Ans - C.
Using the stream with an INSERT or CREATE TABLE statement
What values can the column METADATA$ACTION contain?
A. INSERT, UPDATE or DELETE
B. INSERT or DELETE
C. TRUE or FALSE ✔️Ans - B. INSERT or DELETE
One task can execute multiple SQL statements. TRUE or FALSE? ✔️Ans -
FALSE
What compute resource is used to execute the SQL statement in a task?
A. Virtual warehouse managed by Snowflake
B. The virtual warehouse that is specified in the task ✔️Ans - B. The virtual
warehouse that is specified in the task
We can directly query from a stream. What is returned if we do so?
A. All original columns and no additional columns
B. Only the columns of the original table that have changed and 3 additional
columns containing information about the change
C. All the columns of the original table that have changed and 3 additional
columns containing information about the change ✔️Ans - C. All the columns
of the original table that have changed and 3 additional columns containing
information about the change
Sampling using SYSTEM method is often slower than the ROW method. TRUE
or FALSE? ✔️Ans - FALSE
If we want to share data with non-Snowflake users ...
, A. ... it's best to set up a trial account for the consumer
B. ... it's best to set up a reader account for the consumer
C. ... it's best to set up a dedicated role and user within the provider's account
✔️Ans - B. ... it's best to set up a reader account for the consumer
What virtual warehouse is used if we share data with a non-Snowflake user
using a reader account?
A. A dedicated virtual warehouse of the provider account has to be set up
B. The consumer has to provide billing information and will have to set up an
own virtual warehouse
C. A dedicated virtual warehouse managed by Snowflake will be used to
process queries ✔️Ans - A. A dedicated virtual warehouse of the provider's
account has to be set up
We can share secure views and normal views. TRUE or FALSE? ✔️Ans -
FALSE
The data will not be copied and therefore the consumer will not be charged
for data storage. TRUE or FALSE? ✔️Ans - TRUE
What virtual warehouse is used if the consumer is querying from a shared
table?
A. The consumer's virtual warehouse
B. The provider's virtual warehouse
C. A virtual warehouse managed by Snowflake ✔️Ans - A. The consumer's
virtual warehouse
If we make changes made to the source object this will be reflected/updated
in the clone object as well. TRUE or FALSE? ✔️Ans - FALSE
If we clone a table this clone will also contain the data of the source table from
the moment it has been cloned - even though no additional storage is needed
for the initial clone. TRUE or FALSE? ✔️Ans - TRUE
If a table is cloned also the cluster keys will be inherited. TRUE or FALSE?
✔️Ans - TRUE
Preparation Set – Qs & As
What object do you need to create to fetch data from private cloud locations?
A. Storage Integration
B. Only Stage
C. Nothing, just pass source URL to a query
D. Storage Connection ✔️Ans - A. Storage Integration
What parameter should be changed to modify table retention time?
A. DATA_RETENTION
B. DATA_RETENTION_TIME_IN_DAYS
C. DATA_RETENTION_TIME
D. DATA_RETENTION_PERIOD ✔️Ans - B.
DATA_RETENTION_TIME_IN_DAYS
If a user has the role ACCOUNTADMIN assigned it's a best practice to always
use this role. TRUE or FALSE? ✔️Ans - FALSE
If we have multiple roles assigned to our user we can change the role within
that given session. TRUE or FALSE? ✔️Ans - TRUE
All the privileges of the USERADMIN are contained in the SECURITYADMIN.
TRUE or FALSE? ✔️Ans - TRUE
Which role gets assign to every newly created user by default?
A. SYSADMIN
B. USERADMIN
C. PUBLIC ✔️Ans - C. PUBLIC
What precaution should not be taken regarding the role of ACCOUNTADMIN?
A. Assign this role only to a limited number of people in your organization
B. All users assigned the ACCOUNTADMIN role should use multi-factor
authentication for login
,C. Restrict the privileges of the ACCOUNTADMIN role
D. Assign this role to at least 2 users ✔️Ans - C. Restrict the privileges of the
ACCOUNTADMIN roleB. ACCOUNTADMIN
What is the top-level role in Snowflake?
A. SYSADMIN
B. ACCOUNTADMIN
C. SECURITYADMIN
D. USERADMIN ✔️Ans - B. ACCOUNTADMIN
What is the purpose of materialized views?
A. Reduce storage cost for large tables
B. Speed up expensive and complex views
C. To improve query security ✔️Ans - B. Speed up expensive and complex
views
How are materialized views updated if the underlying data has changed?
A. This update is automatically managed by Snowflake
B. We have to set up tasks and streams for that
C. We have to update the view using a sql command ✔️Ans - A. This update
is automatically managed by Snowflake
What happens after a stream is consumed?
A. The stream will be dropped
B. The stream will be empty
C. The values for METADATA$ACTION will change
D. Nothing will happen ✔️Ans - B. The stream will be empty
What is tracked in streams if APPEND_ONLY option is set to TRUE?
A. INSERTS and DELETES
B. INSERTS and UPDATES
C. INSERTS only
D. UPDATES only ✔️Ans - C. INSERTS only
,If we create a tree of tasks, one child can have multiple parent tasks. TRUE or
FALSE? ✔️Ans - FALSE
How can we consume a stream?
A. Using the CONSUME command
B. Using a SELECT on a stream
C. Using the stream with an INSERT or CREATE TABLE statement ✔️Ans - C.
Using the stream with an INSERT or CREATE TABLE statement
What values can the column METADATA$ACTION contain?
A. INSERT, UPDATE or DELETE
B. INSERT or DELETE
C. TRUE or FALSE ✔️Ans - B. INSERT or DELETE
One task can execute multiple SQL statements. TRUE or FALSE? ✔️Ans -
FALSE
What compute resource is used to execute the SQL statement in a task?
A. Virtual warehouse managed by Snowflake
B. The virtual warehouse that is specified in the task ✔️Ans - B. The virtual
warehouse that is specified in the task
We can directly query from a stream. What is returned if we do so?
A. All original columns and no additional columns
B. Only the columns of the original table that have changed and 3 additional
columns containing information about the change
C. All the columns of the original table that have changed and 3 additional
columns containing information about the change ✔️Ans - C. All the columns
of the original table that have changed and 3 additional columns containing
information about the change
Sampling using SYSTEM method is often slower than the ROW method. TRUE
or FALSE? ✔️Ans - FALSE
If we want to share data with non-Snowflake users ...
, A. ... it's best to set up a trial account for the consumer
B. ... it's best to set up a reader account for the consumer
C. ... it's best to set up a dedicated role and user within the provider's account
✔️Ans - B. ... it's best to set up a reader account for the consumer
What virtual warehouse is used if we share data with a non-Snowflake user
using a reader account?
A. A dedicated virtual warehouse of the provider account has to be set up
B. The consumer has to provide billing information and will have to set up an
own virtual warehouse
C. A dedicated virtual warehouse managed by Snowflake will be used to
process queries ✔️Ans - A. A dedicated virtual warehouse of the provider's
account has to be set up
We can share secure views and normal views. TRUE or FALSE? ✔️Ans -
FALSE
The data will not be copied and therefore the consumer will not be charged
for data storage. TRUE or FALSE? ✔️Ans - TRUE
What virtual warehouse is used if the consumer is querying from a shared
table?
A. The consumer's virtual warehouse
B. The provider's virtual warehouse
C. A virtual warehouse managed by Snowflake ✔️Ans - A. The consumer's
virtual warehouse
If we make changes made to the source object this will be reflected/updated
in the clone object as well. TRUE or FALSE? ✔️Ans - FALSE
If we clone a table this clone will also contain the data of the source table from
the moment it has been cloned - even though no additional storage is needed
for the initial clone. TRUE or FALSE? ✔️Ans - TRUE
If a table is cloned also the cluster keys will be inherited. TRUE or FALSE?
✔️Ans - TRUE
