Snowflake SnowPro Core Recertification - SnowPro Core Recertification (COF-R02) Exam
Page: 3 / 12
Total 60 questions
Question #11 (Topic: Exam A)
What type of function returns one value for each invocation?
A. Aggregate
B. Scalar
C. Table
D. Window
Answer: B
Question #12 (Topic: Exam A)
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
A. Micro-partitions
B. Clustering keys
C. Equality searches
D. Search access paths
Answer: D
Question #13 (Topic: Exam A)
Which command can be used to unload data into an external named stage in Snowflake?
A. PUT
B. CREATE <object>
C. COPY INTO <table>
D. COPY INTO <location>
Answer: D
Question #14 (Topic: Exam A)
Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?
A. 
B. 
C. 
D. 
B.
C.
D.
Answer: C
Question #15 (Topic: Exam A)
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
A. An FTP server with TLS encryption
B. An HTTPS server with WebDAV
C. A Google Cloud storage bucket
D. A Windows server file share on Azure
Answer: C
