Udemy Snowpro Core Certification - Practice Questions
Test 2 ; Questions and Answers (A+)
What are some general indicators that a clustering key is required on a table? Correct Ans--
The query performance has slowed down over time
- The size of the table is multi-terabytes
- Large clustering depth
True or False: Resource monitors can manage a single virtual warehouse, a collection of
virtual warehouses, or the entire Snowflake account. Correct Ans-True
True or False: Snowflake stores all data at rest unencrypted unless configured by the
customer. Correct Ans-False
Which of the following requirements can be fulfilled by only a secure UDF? Correct Ans--
There is a requirement to protect data by limiting a subset of rows from the result set
- There is a requirement to protect data by limiting some table columns from the result set
Which of the following statements is true regarding the USERADMIN role? Correct Ans--
Can create new roles
, Udemy Snowpro Core Certification - Practice Questions
Test 2 ; Questions and Answers (A+)
- Can create new users
Which of the following statements are true regarding External Tables? Correct Ans-- Views
can be created on top of an external table
- An external table allows querying of data in cloud storage with requiring it to be loaded into
Snowflake first
True or False: The data is physically copied into new micro-partitions during a clone operation.
Correct Ans-False
- Zero copy cloning does not actually physically copy the data
Which of the following is a web-based interface to Snowflake? Correct Ans-Snowsight
Which of the following statements are true regarding Snowpark? Correct Ans-- When using
Snowpark, Snowflake operation are performed lazily
- Function defined in Snowparkk can be pushed down to the server (Snowflake) for execution
Test 2 ; Questions and Answers (A+)
What are some general indicators that a clustering key is required on a table? Correct Ans--
The query performance has slowed down over time
- The size of the table is multi-terabytes
- Large clustering depth
True or False: Resource monitors can manage a single virtual warehouse, a collection of
virtual warehouses, or the entire Snowflake account. Correct Ans-True
True or False: Snowflake stores all data at rest unencrypted unless configured by the
customer. Correct Ans-False
Which of the following requirements can be fulfilled by only a secure UDF? Correct Ans--
There is a requirement to protect data by limiting a subset of rows from the result set
- There is a requirement to protect data by limiting some table columns from the result set
Which of the following statements is true regarding the USERADMIN role? Correct Ans--
Can create new roles
, Udemy Snowpro Core Certification - Practice Questions
Test 2 ; Questions and Answers (A+)
- Can create new users
Which of the following statements are true regarding External Tables? Correct Ans-- Views
can be created on top of an external table
- An external table allows querying of data in cloud storage with requiring it to be loaded into
Snowflake first
True or False: The data is physically copied into new micro-partitions during a clone operation.
Correct Ans-False
- Zero copy cloning does not actually physically copy the data
Which of the following is a web-based interface to Snowflake? Correct Ans-Snowsight
Which of the following statements are true regarding Snowpark? Correct Ans-- When using
Snowpark, Snowflake operation are performed lazily
- Function defined in Snowparkk can be pushed down to the server (Snowflake) for execution
