Snowflake SnowPro Core Exam Practice Test

Page: 1 / 14
Total 427 questions
Question 1

Which object can be used with Secure Data Sharing?



Answer : A

Viewscan be used with Secure Data Sharing in Snowflake.Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.


Question 2

Which Snowflake table objects can be shared with other accounts? (Select TWO).



Answer : B, D

In Snowflake,permanent tablesandexternal tablescan be shared with other accounts using Secure Data Sharing.Temporary tables, transient tables, and UDTFs are not shareable objects


Question 3

What transformations are supported when loading data into a table using the COPY INTO

command? (Select TWO).



Answer : A, B

TheCOPY INTO <table>command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.


Question 4

Which Snowflake database object can be used to track data changes made to table data?



Answer : C

AStreamobject in Snowflake is used for change data capture (CDC), which records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes3.


Question 5

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?



Answer : C

TheBUILD_STAGE_FILE_URLfunction generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.


Question 6

How can performance be optimized for a query that returns a small amount of data from a very large base table?



Answer : C

The search optimization service in Snowflake is designed to improve the performance of selective point lookup queries on large tables, which is ideal for scenarios where a query returns a small amount of data from a very large base table1. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide


Question 7

Which privilege must be granted by one role to another role, and cannot be revoked?



Answer : C

The OWNERSHIP privilege is unique in that it must be granted by one role to another and cannot be revoked. This ensures that the transfer of ownership is deliberate and permanent, reflecting the importance of ownership in managing access and permissions.


Page:    1 / 14   
Total 427 questions