Free SnowPro Core Certification Exam COF-C02 Exam Practice Test

What is the MINIMUM permission needed to access a file URL from an external stage?

• MODIFY
• READ
• SELECT
• USAGE

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.Which Snowflake feature will support this?

• Row access policies
• Data masking policies
• Data encryption
• Role based access control

What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).

• Auto-suspend
• Cache size
• Default role
• Resource monitor
• Storage size

What causes objects in a data share to become unavailable to a consumer account?

• The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.
• The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.
• The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
• The consumer account acquires the data share through a private data exchange.

How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

• 32
• 64
• 128
• 256

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

• Clone the data from the production account to the non-production account.
• Create a data share from the production account to the non-production account.
• Create a subscription in the production account and have it publish to the non-production account.
• Create a reader account using the production account and link the reader account to the non-production account.

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format optionWhat does the STRIP_OUTER_ARRAY file format do?

• It removes the last element of the outer array.
• It removes the outer array structure and loads the records into separate table rows,
• It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
• It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

When should a multi-cluster virtual warehouse be used in Snowflake?

• When queuing is delaying query execution on the warehouse
• When there is significant disk spilling shown on the Query Profile
• When dynamic vertical scaling is being used in the warehouse
• When there are no concurrent queries running on the warehouse

Which pages are included in the Activity area of Snowsight? (Select TWO).

• Contacts
• Sharing settings
• Copy History
• Query History
• Automatic Clustering History

What can a Snowflake user do with the information included in the details section of a Query Profile?

• Determine the total duration of the query.
• Determine the role of the user who ran the query.
• Determine the source system that the queried table is from.
• Determine if the query was on structured or semi-structured data.