SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 45 of 54, with answer review and explanations.

Question 221

Which of the following significantly improves the performance of selective point lookup queries on a table?

  1. Clustering
  2. Materialized Views
  3. Zero-copy Cloning
  4. Search Optimization Service

Question 222

Which of the following accurately describes shares?

  1. Tables, secure views, and secure UDFs can be shared
  2. Shares can be shared
  3. Data consumers can clone a new table from a share
  4. Access to a share cannot be revoked once granted

Question 223

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

  1. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
  2. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
  3. The ACCOUNTADMIN role must be granted to only one user.
  4. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
  5. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Question 224

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Choose two.)

  1. Bytes scanned
  2. Bytes sent over the network
  3. Number of partitions scanned
  4. Percentage scanned from cache
  5. External bytes scanned

Question 225

What is the minimum Snowflake edition required for row level security?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake