Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 651:

  When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

  A. Concurrency

  B. Performance

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 652:

  What is the lowest Snowflake edition that offers Time Travel up to 90 days?

  A. standard Edition

  B. Premier Edition

  C. Enterprise Edition

  D. Business Critical Edition

  Correct Answer: C

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

• Question 653:

  Select the three types of tables that exist within Snowflake. Choose 3 answers

  A. Temporary

  B. Transient

  C. Provisioned

  D. Permanent

  Correct Answer: ABD

  Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 654:

  True or False: During data unloading, only JSON and CSV files can be compressed.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

• Question 655:

  Which of the following statements are true of Snowflake data loading? Choose 3 answers

  A. VARIANT "nut" values are not the same as SQL Null values

  B. It is recommended to do frequent, single row DMLS

  C. It is recommended to validate the data before loading into the Snowflake target table

  D. It is recommended to use staging tables to manage MERGE statements

  Correct Answer: ACD

• Question 656:

  What command is used to load files into an Internal Stage within Snowflake? Select one.

  A. PUT

  B. COPY INTO

  C. TRANSFER

  D. INSERT

  Correct Answer: A

  You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO [table] command when loading data into a table from the staged files.

• Question 657:

  Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

  A. Micro-partitions

  B. Clustering keys

  C. Key partitions

  D. Clustered partitions

  Correct Answer: B

  Reference: https://community.snowflake.com/s/article/Snowflake-What-the-Cluster

• Question 658:

  When creating a user it is advisable sable to: Choose 2 answers

  A. Set the user to be initially disabled

  B. Force an immediate password change

  C. Set a default role for the user

  D. Set the number of minutes to unlock to 15 minutes

  E. Set the users access to expire within a specified timeframe

  Correct Answer: BC

• Question 659:

  Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

  A. MIN(< < column value>>)

  B. COPY

  C. SUM(<< column value >>)

  D. UPDATE

  Correct Answer: BCD

• Question 660:

  What is the minimum Snowflake edition that provides data sharing?

  A. Standard

  B. Premier

  C. Enterprise

  D. Business Critical Edition

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing