SnowPro Core Practice Test

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

Question 226

The is the minimum Fail-safe retention time period for transient tables?

  1. 1 day
  2. 7 days
  3. 12 hours
  4. 0 days

Question 227

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

  1. Informatica
  2. Power BI
  3. Adobe
  4. Data Robot

Question 228

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

  1. Data is live, ready-to-query, and can be personalized.
  2. Data needs to be loaded into a cloud provider as a consumer account.
  3. Data is not available for copying or moving to an individual Snowflake account.
  4. Data is available without copying or moving.
  5. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Question 229

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

  1. Whether or not it is also a secure view
  2. How often the underlying base table is queried
  3. How often the base table changes
  4. Whether the materialized view has a cluster key defined
  5. How often the materialized view is queried

Question 230

What COPY INTO SQL command should be used to unload data into multiple files?

  1. SINGLE=TRUE
  2. MULTIPLE=TRUE
  3. MULTIPLE=FALSE
  4. SINGLE=FALSE