Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 331:

  What actions does the use of the PUT command do automatically? (Choose two.)

  A. It creates a file format object.

  B. It uses the last stage created.

  C. It compresses all files using GZIP.

  D. It encrypts the file data in transit.

  E. It creates an empty target table.

  Correct Answer: CD

• Question 332:

  Which virtual warehouse privilege is required to view a load-monitoring chart?

  A. MONTTOR

  B. MODIFY

  C. OPERATE

  D. USAGE

  Correct Answer: A

• Question 333:

  When unloading data, which file format preserves the data values for floating-point number columns?

  A. Avro

  B. CSV

  C. JSON

  D. Parquet

  Correct Answer: D

• Question 334:

  Which Snowflake table supports unstructured data?

  A. Directory

  B. Transient

  C. Temporary

  D. Permanent

  Correct Answer: A

• Question 335:

  What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

  A. 1

  B. 5

  C. 10

  D. 100

  Correct Answer: C

• Question 336:

  Which function returns the URL of a stage using the stage name as the input?

  A. BUILD_STAGE_FILE_URL

  B. BUILD_SCOPED_FILE_URL

  C. GET_PRESIGNED_URL

  D. GET_STAGE_LOCATION

  Correct Answer: D

• Question 337:

  Which command should a Snowflake user execute to load data into a table?

  A. copy into mytable purge_mode = TRUE;

  B. copy into mytable from @my_int_stage;

  C. copy into mytable file_format = (format_name);

  D. copy into mytable validation = ‘RETURN_ERRORS

  Correct Answer: B

• Question 338:

  How many resource monitors can be applied to a single virtual warehouse?

  A. Zero

  B. One

  C. Eight

  D. Unlimited

  Correct Answer: B

• Question 339:

  Which use case will always cause an exploding join in Snowflake?

  A. A query that has more than 10 left outer joins.

  B. A query that is using a UNION without an ALL.

  C. A query that has not specified join criteria for tables.

  D. A query that has requested too many columns of data.

  Correct Answer: C

• Question 340:

  What are the main differences between the account usage views and the information schema views? (Choose two.)

  A. No active warehouse is needed to query account usage views but one is needed to query information schema views.

  B. Account usage views do not contain data about tables but information schema views do.

  C. Account usage views contain dropped objects but information schema views do not.

  D. Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

  E. Information schema views are read-only but account usage views are not.

  Correct Answer: CD