Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 351:

  Which URL type should be used to get a permanent URL to a file in a stage?

  A. File URL

  B. Pre-signed URL

  C. Saved URL

  D. Scoped URL

  Correct Answer: A

• Question 352:

  When executing a COPY INTO command, performance can be negatively affected by using which optional parameter on a large number of files?

  A. FILE_FORMAT

  B. PATTERN

  C. VALIDATION_MODE

  D. FILES

  Correct Answer: B

• Question 353:

  Which operation will produce an error in Snowflake?

  A. Inserting duplicate values into a PRIMARY KEY column

  B. Inserting a NULL into a column with a NOT NULL constraint

  C. Inserting duplicate values into a column with a UNIQUE constraint

  D. Inserting a value to FOREIGN KEY column that does not match a value in the column referenced

  Correct Answer: B

• Question 354:

  Which levels can apply network policies? (Choose two.)

  A. Account

  B. Database

  C. Role

  D. Schema

  E. User

  Correct Answer: AE

• Question 355:

  Floating point values are truncated when unloaded to which file format?

  A. ORC

  B. CSV

  C. Avro

  D. Parquet

  Correct Answer: B

• Question 356:

  What Snowflake function should be used to unload relational data to JSON?

  A. BUILD_STAGE_FILE_URL()

  B. OBJECT_CONSTRUCT()

  C. PARSE_JSON()

  D. TO_VARIANT()

  Correct Answer: B

• Question 357:

  Which command would return an empty sample?

  A. select * from testtable sample ();

  B. select * from testtable sample (0);

  C. select * from testtable sample (null);

  D. select * from testtable sample (none);

  Correct Answer: B

• Question 358:

  Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Choose two.)

  A. Search optimization service

  B. Automatic clustering

  C. Row access policies

  D. Multi-cluster virtual warehouses

  E. Secure views

  Correct Answer: AB

• Question 359:

  What is the Snowflake multi-clustering feature for virtual warehouses used for?

  A. To improve the data unloading process to the cloud

  B. To improve data loading from very large data sets

  C. To improve concurrency for users and queries

  D. To speed up slow or stalled queries

  Correct Answer: C

• Question 360:

  What causes objects in a data share to become unavailable to a consumer account?

  A. The DATA_RETENTION_IT parameter in the consumer account is set to 0.

  B. The consumer account runs the GRANT INPORTED PRIVILEGES command on the data share every 24 hours.

  C. The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

  D. The consumer account acquires the data share through a private data exchange.

  Correct Answer: C