Free SnowPro-Core – SnowPro Core Certification Exam Practice Test Question

Free demo downloads

Loading demo links...

Showing 7–9 of 20 questions

Question 7

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    A directory table is a separate database object.

  • ○

    Directory tables store data file metadata.

  • ○

    A directory table will be automatically added to a stage.

  • ○

    Directory tables do not have their own grantable privileges.

  • ○

    Directory table data can not be refreshed manually.

Question 8

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Select all that apply, then click Submit answer.

  • ○

    The ability to scale up warehouses

  • ○

    The use of warehouse auto scaling

  • ○

    The ability to resize warehouses

  • ○

    Use of multi-clustered warehouses

  • ○

    The use of warehouse indexing

Question 9

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Database replication and failover

  • ○

    Automated index management

  • ○

    Customer managed keys (Tri-secret secure)

  • ○

    Extended time travel

  • ○

    Native support for geospatial data