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

Select an option, then click Submit answer.

• ○ Log the user out.
• ○ Deactivate the network policy.
• ○ Prevent the user from executing additional queries.
• ○ Allow the user to continue until the session or login token expires.

Select an option, then click Submit answer.

• ○ Pipe
• ○ Stage
• ○ Secure view
• ○ Materialized view
• ○ Shared table

Select an option, then click Submit answer.

• ○ Account
• ○ Database
• ○ Schema
• ○ Table

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

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.

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