SnowPro Core practice test

1. Question 1 · 1

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

   Choose one answer.

   • Micro-partitions
   • Clustering keys
   • Key partitions
   • Clustered partitions

2. Question 2 · 1

   Which statement best describes `clustering`?

   Choose one answer.

   • Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
   • The database administrator must define the clustering methodology for each Snowflake table
   • The clustering key must be included on the COPY command when loading data into Snowflake
   • Clustering can be disabled within a Snowflake account

3. Question 3 · 1

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

   Choose one answer.

   • Account
   • Database
   • Schema
   • Table

4. Question 4 · 1

   Which task is supported by the use of Access History in Snowflake?

   Choose one answer.

   • Data backups
   • Cost monitoring
   • Compliance auditing
   • Performance optimization

5. Question 5 · 1

   Which feature of Snowflake’s Continuous Data Protection (CDP) has associated costs?

   Choose one answer.

   • Fail-safe
   • Network policies
   • End-to-end encryption
   • Multi-Factor Authentication (MFA)

6. Question 6 · 1

   When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

   Choose one answer.

   • File URL
   • Scoped URL
   • Relative URL
   • Pre-Signed URL

7. Question 7 · 1

   Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

   Choose one answer.

   • Column compression
   • Data clustering
   • Micro-partitioning
   • Metadata management

8. Question 8 · 1

   A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database. Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

   Choose one answer.

   • CREATE TABLE [table_name] LIKE TABLE_A;
   • CREATE VIEW [view_name] AS SELECT * FROM TABLE_A;
   • CREATE TABLE [table_name] AS SELECT * FROM TABLE_A;
   • CREATE MATERIALIZED VIEW [view_name] AS SELECT * FROM TABLE_A;

9. Question 9 · 1

   In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

   Choose one answer.

   • READ
   • REFERENCES
   • REFERENCE_USAGE
   • USAGE

10. Question 10 · 1

    Which function can be used with the COPY INTO [LOCATION] statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?

    Choose one answer.

    • FLATTEN
    • OBJECT_AS
    • OBJECT_CONSTRUCT
    • TO_VARIANT

11. Question 11 · 1

    Which type of role can be granted to a share?

    Choose one answer.

    • Account role
    • Custom role
    • Database role
    • Secondary role

12. Question 12 · 1

    When unloading data with the COPY INTO [location] command, what is the purpose of the PARTITION BY parameter option?

    Choose one answer.

    • To sort the contents of the output file by the specified expression.
    • To delimit the records in the output file using the specified expression.
    • To include a new column in the output using the specified window function expression.
    • To split the output into multiple files, one for each distinct value of the specified expression.

13. Question 13 · 1

    What are potential impacts of storing non-native values like dates and timestamps in a VARIANT column in Snowflake?

    Choose one answer.

    • Faster query performance and increased storage consumption
    • Slower query performance and increased storage consumption
    • Faster query performance and decreased storage consumption
    • Slower query performance and decreased storage consumption

14. Question 14 · 1

    Which of the following statements is true of Snowflake micro-partitioning?

    Choose one answer.

    • Micro-partitioning has been known to introduce data skew
    • Micro-partitioning: requires a partitioning schema to be defined up front
    • Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
    • Micro-partitioning can be disabled within a Snowflake account

15. Question 15 · 1

    Which views are included in the DATA_SHARING_USAGE schema? (Choose two.)

    Choose one answer.

    • ACCESS_HISTORY
    • DATA_TRANSFER_HISTORY
    • WAREHOUSE_METERING_HISTORY
    • MONETIZED_USAGE_DAILY
    • LISTING_TELEMETRY_DAILY

Paid access to all 1292 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.