Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 1:

  Which of the following roles is recommended to be used to create and manage users and roles?

  A. SYSADMIN

  B. SECURITYADMIN

  C. PUBLIC

  D. ACCOUNTADMIN

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/security-access-control-overview.html "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

• Question 2:

  True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

  A. True

  B. False

  Correct Answer: A

• Question 3:

  True or False: It is possible to load data into Snowflake without creating a named File Format object.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

• Question 4:

  To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  A. Configure the Maximum Clusters setting to "Auto-Scale"

  B. Set the Warehouse type to "Auto"

  C. Set the Minimum Clusters and Maximum Clusters settings to the same value

  D. Set the Minimum Clusters and Maximum Clusters settings to the different values

  Correct Answer: D

  Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

• Question 5:

  True or False: You can resize a Virtual Warehouse while queries are running.

  A. True

  B. False

  Correct Answer: A

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

• Question 6:

  True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

• Question 7:

  What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

  A. Standard

  B. Premier

  C. Enterprise

  D. Business Critical Edition

  Correct Answer: C

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

• Question 8:

  What is the most granular object that the Time Travel retention period can be defined on? Select one.

  A. Account

  B. Database

  C. Schema

  D. Table

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html#data-retention-period

• Question 9:

  True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

  A. True

  B. False

  Correct Answer: A

  Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

• Question 10:

  What is the recommended Snowflake data type to store semi-structured data like JSON?

  A. VARCHAR

  B. RAW

  C. LOB

  D. VARIANT

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html