SnowPro Core Practice Test

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

Question 266

What is the default Time Travel retention period?

  1. 1 day
  2. 7 days
  3. 45 days
  4. 90 days

Question 267

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Choose two.)

  1. Load files that are approximately 25 MB or smaller.
  2. Remove all dates and timestamps.
  3. Load files that are approximately 100-250 MB (or larger).
  4. Avoid using embedded characters such as commas for numeric data types.
  5. Remove semi-structured data types.

Question 268

Which schema has the RESOURCE_MONITORS view?

  1. ACCOUNT_USAGE
  2. READER_ACCOUNT_USAGE
  3. INFORMATION_SCHEMA
  4. WAREHOUSE_USAGE_SCHEMA

Question 269

What is the purpose of enabling Federated Authentication on a Snowflake account?

  1. Disables the ability to use key pair and basic authentication (e.g., username/password) when connecting
  2. Allows dual Multi-Factor Authentication (MFA) when connecting to Snowflake
  3. Forces users to connect through a secure network proxy
  4. Allows users to connect using secure single sign-on (SSO) through an external identity provider

Question 270

Which Snowflake partner category is represented at the top of this diagram (labeled 1)?

  1. Business Intelligence
  2. Machine Learning and Data Science
  3. Security and Governance
  4. Data Integration