Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 421:

  What command should be used to move data from a Snowflake database table into one or more files in an external stage?

  A. GET

  B. COPY INTO

  C. PUT

  D. SHOW

  Correct Answer: B

• Question 422:

  What criteria does Snowflake use to determine the current role when initiating a session? (Choose two.)

  A. If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

  B. If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

  C. If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

  D. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

  E. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

  Correct Answer: AB

• Question 423:

  Which features make up Snowflake's column level security? (Choose two.)

  A. Continuous Data Protection (CDP)

  B. Dynamic Data Masking

  C. External Tokenization

  D. Key pair authentication

  E. Row access policies

  Correct Answer: BC

• Question 424:

  What is the MAXIMUM size limit for a record of a VARIANT data type?

  A. 8 MB

  B. 16 MB

  C. 32 MB

  D. 128 MB

  Correct Answer: B

• Question 425:

  Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake (VPS)

  Correct Answer: D

• Question 426:

  What information is stored in the ACCESS_HISTORY view?

  A. History of the files that have been loaded into Snowflake

  B. Names and owners of the roles that are currently enabled in the session

  C. Query details such as the objects included and the user who executed the query

  D. Details around the privileges that have been granted for all objects in an account

  Correct Answer: C

• Question 427:

  Which SQL commands should be used to write a recursive query if the number of levels is unknown? (Choose two.)

  A. CONNECT BY

  B. LISTAGG

  C. MATCH RECOGNIZE

  D. QUALIFY

  E. WITH

  Correct Answer: AE

• Question 428:

  Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

  A. Access history

  B. Data classification

  C. Dynamic Data Masking

  D. Object tagging

  Correct Answer: A

• Question 429:

  How can a Snowflake user improve long-running query performance?

  A. Reduce the virtual warehouse size.

  B. Cluster the underlying table being queried.

  C. Disable the result cache.

  D. Add ORDER BY to the query.

  Correct Answer: B

• Question 430:

  Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?

  A. FORCE = TRUE

  B. FORCE = FALSE

  C. LOAD_UNCERTAIN_FILES = TRUE

  D. LOAD_UNCERTAIN_FILES = FALSE

  Correct Answer: A