Free Preparation Discussions
MENU
Snowflake COF-R02 Exam
- Topic 1: Single Topic
Free Snowflake COF-R02 Exam Actual Questions
The questions for COF-R02 were last updated On Apr. 22, 2024
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE=RETURN_n_ROWS|RETURN_ERRORS|RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data filesinsteadof loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!