Free SnowPro Core Recertification Exam COF-R02 Exam Practice Test
COF-R02 Exam Features
In Just $59 You can Access
- All Official Question Types
- Interactive Web-Based Practice Test Software
- No Installation or 3rd Party Software Required
- Customize your practice sessions (Free Demo)
- 24/7 Customer Support
Total Questions: 330
-
- (Exam Topic 3) 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?
Answer: B Next Question -
- (Exam Topic 2) Which of the following can be executed/called with Snowpipe?
Answer: C Next Question -
- (Exam Topic 2) During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Answer: B Next Question -
- (Exam Topic 3) A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?
Answer: B Next Question -
- (Exam Topic 2) What Snowflake role must be granted for a user to create and manage accounts?
Answer: A Next Question -
- (Exam Topic 3) What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Answer: B Next Question -
- (Exam Topic 2) Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Answer: D,E Next Question -
- (Exam Topic 3) When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Answer: B Next Question -
- (Exam Topic 3) Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Answer: B,C Next Question -
- (Exam Topic 1) Snowflake is designed for which type of workloads? (Choose two.)
Answer: A,C Next Question
Total Questions: 330