← Back to exam page

Free SNOWPRO-CORE-RECERTIFICATION – Snowflake SNOWPRO-CORE-RECERTIFICATION Practice Test Question

Loading demo links...

Showing 4–6 of 6 questions

Question 4 (Topic 1)

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

Select an option, then click Submit answer.

  • ○ The type of SQL statements executed
  • ○ The number of tables or databases queried
  • ○ The amount of data stored in the warehouse
  • ○ The length of time the compute resources in each cluster run
Question 5 (Topic 1)

When a Snowflake user loads CSV data from a stage, which COPY INTO <table> command guideline should they follow?

Select an option, then click Submit answer.

  • ○ The CSV field delimiter must be a comma character (',').
  • ○ The number of columns in each row should be consistent.
  • ○ The data file in the stage must be in a compressed format.
  • ○ The data file must have the same number of columns as the target table.
Question 6 (Topic 1)

When does a materialized view get suspended in Snowflake?

Select an option, then click Submit answer.

  • ○ When a column is added to the base table
  • ○ When a column is dropped from the base table
  • ○ When a DML operation is run on the base table
  • ○ When the base table is reclustered