SnowPro Core

Here you have the best Snowflake SnowPro Core practice exam questions

  • You have 1350 total questions to study from
  • Each page has 5 questions, making a total of 270 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on October 17, 2025
  • This site is not affiliated with or endorsed by Snowflake.
Question 1 of 1350
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
    Correct Answer: B

    Snowflake provides a mechanism called 'clustering keys' that allows customers to manage and optimize the clustering of their data. This method enables users to specify key columns that control how the data is physically stored and accessed, improving query performance for specified patterns.

Question 2 of 1350
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
    Correct Answer: B, D

    The two valid Snowflake Virtual Warehouse Scaling Policies are Economy and Standard. The Economy policy helps to minimize cost by reducing the number of active warehouses when the workload decreases, while the Standard policy provides balanced performance by scaling the number of warehouses based on the query load.

Question 3 of 1350
True or False: A single database can exist in more than one Snowflake account.
    Correct Answer: B

    A single database cannot exist in more than one Snowflake account. Each database is associated with one specific Snowflake account. While data can be shared between accounts or replicated, each instance of a database is unique to a single account.

Question 4 of 1350
Which of the following roles is recommended to be used to create and manage users and roles?
    Correct Answer: B

    The SECURITYADMIN role is designed specifically to handle security-related tasks, including the creation and management of users and roles. This role has the necessary privileges to manage all aspects of user and role administration, making it the recommended choice for these tasks. This aligns with the principle of least privilege, ensuring that higher-level administrative privileges are not unnecessarily granted.

Question 5 of 1350
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
    Correct Answer: A

    Bulk unloading of data from Snowflake supports the use of a SELECT statement. The COPY INTO command can accept a SELECT statement which allows the results of the query to be written to files and stored in the specified location. This feature makes it possible to unload data based on specific query criteria.