Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 721:

  What is the MOST performant file format for loading data in Snowflake?

  A. CSV (Unzipped)

  B. Parquet

  C. CSV (Gzipped)

  D. ORC

  Correct Answer: C

• Question 722:

  The fail-safe retention period is how many days?

  A. 1 day

  B. 7 days

  C. 45 days

  D. 90 days

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

• Question 723:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management

  B. Metadata management

  C. Query execution

  D. Query parsing and optimization

  E. Management of the storage layer

  Correct Answer: C

• Question 724:

  Which of the following commands cannot be used within a reader account?

  A. CREATE SHARE

  B. ALTER WAREHOUSE

  C. DROP ROLE

  D. SHOW SCHEMAS

  E. DESCRBE TABLE

  Correct Answer: A

• Question 725:

  Which Snowflake partner specializes in data catalog solutions?

  A. Alation

  B. DataRobot

  C. dbt

  D. Tableau

  Correct Answer: A

  Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, and Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html

• Question 726:

  A user has unloaded data from Snowflake to a stage

  Which SQL command should be used to validate which data was loaded into the stage?

  A. list @file__stage

  B. show @file__stage

  C. view @file__stage

  D. verify @file__stage

  Correct Answer: A

• Question 727:

  When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

  A. Use multi-clustered warehousing to scale out warehouse capacity.

  B. Scale up the warehouse size to allow Queries to execute faster.

  C. Stop and start the warehouse to clear the queued queries

  D. Migrate some queries to a new warehouse to reduce load

  E. Limit user access to the warehouse so fewer queries are run against it.

  Correct Answer: AD

• Question 728:

  Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

  A. Standard

  B. Premium

  C. Enterprise

  D. Business Critical

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/privatelink-azure.html

• Question 729:

  What is the recommended file sizing for data loading using Snowpipe?

  A. A compressed file size greater than 100 MB, and up to 250 MB

  B. A compressed file size greater than 100 GB, and up to 250 GB

  C. A compressed file size greater than 10 MB, and up to 100 MB

  D. A compressed file size greater than 1 GB, and up to 2 GB

  Correct Answer: A

  https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

• Question 730:

  Which command is used to unload data from a Snowflake table into a file in a stage?

  A. COPY INTO

  B. GET

  C. WRITE

  D. EXTRACT INTO

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.