Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 501:

  How can the COPY command be used to unload data from a table to an internal stage?

  A. COPY INTO

  B. COPY INTO

  C. COPY INTO with single-true

  D. COPY INTO S3://

  Correct Answer: AB

• Question 502:

  What is the MINIMUM configurable idle timeout value for a session policy in Snowflake?

  A. 2 minutes

  B. 5 minutes

  C. 10 minutes

  D. 15 minutes

  Correct Answer: B

• Question 503:

  Which command is used to unload data from a Snowflake table to an external stage?

  A. COPY INTO

  B. COPY INTO followed by GET

  C. GET

  D. COPY INTO followed by PUT

  Correct Answer: A

• Question 504:

  What is a characteristic of materialized views in Snowflake?

  A. Materialized views do not allow joins.

  B. Clones of materialized views can be created directly by the user.

  C. Multiple tables can be joined in the underlying query of a materialized view.

  D. Aggregate functions can be used as window functions in materialized views.

  Correct Answer: A

• Question 505:

  Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

  A. Directory

  B. File

  C. Pre-signed

  D. Scoped

  Correct Answer: C

• Question 506:

  Which SQL command will download all the data files from an internal table stage named TBL_EMPLOYEE to a local window directory or folder on a client machine in a folder named folder with space within the C drive?

  A. GET @%TBL_EMPLOYEE 'file://C:\folder with space\';

  B. GET @%TBL_EMPLOYEE 'file://C:/folder with space/';

  C. PUT 'file://C:\folder with space\*' @%TBL_EMPLOYEE;

  D. PUT 'file://C:/folder with space/*' @%TBL_EMPLOYEE;

  Correct Answer: A

• Question 507:

  What is generally the FASTEST way to bulk load data files from a stage?

  A. Specifying a list of specific files to load

  B. Loading by path (internal stages) / prefix

  C. Using the Snowpipe REST API

  D. Using pattern matching to identify specific files by pattern

  Correct Answer: A

• Question 508:

  How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

  A. Use the SHOW STAGES command.

  B. Use the DESCRIBE STAGE command.

  C. Use the GET_ABSOLUTE_PATH function.

  D. Use the GET_STAGE_LOCATION function.

  Correct Answer: D

• Question 509:

  A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.

  Which file function should be used?

  A. BUILD_SCOPED_FILE_URL

  B. BUILD_STAGE_FILE_URL

  C. GET_PRESIGNED_URL

  D. GET_STAGE_LOCATION

  Correct Answer: C

• Question 510:

  The use of which Snowflake table type will reduce costs when working with ETL workflows?

  A. External

  B. Permanent

  C. Temporary

  D. Transient

  Correct Answer: C