SnowPro Core Certification Exam (COF-C02) Questions and Answers
Question 25
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Options:
A.
Add and remove members.
B.
Delete data categories.
C.
Approve and deny listing approval requests.
D.
Transfer listing ownership.
E.
Transfer ownership of a provider profile.
Answer:
A, C
Explanation:
Explanation:
An account administrator in the Data Exchange can perform tasks such as adding and removing members and approving or denying listing approval requests. These tasks are part of managing the Data Exchange and ensuring that only authorized listings and members are part of it12.
Question 26
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Options:
A.
CREATE STAGE
B.
COPY INTO
C.
COPY INTO
D.
CREATE PIPE
Answer:
C
Explanation:
Explanation:
The COPY INTO command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage1.
Question 27
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
Options:
A.
USERADMIN
B.
ORGADMIN
C.
SYSADMIN
D.
SECURITYADMIN
Answer:
D
Explanation:
Explanation:
The SECURITYADMIN role in Snowflake can manage any object grant globally, including modifying and revoking grants. This role has the necessary privileges to oversee and control access to all securable objects within the Snowflake environment4.
Question 28
What is the relationship between a Query Profile and a virtual warehouse?
Options:
A.
A Query Profile can help users right-size virtual warehouses.
B.
A Query Profile defines the hardware specifications of the virtual warehouse.
C.
A Query Profile can help determine the number of virtual warehouses available.
D.
A Query Profile automatically scales the virtual warehouse based on the query complexity.
Answer:
A
Explanation:
Explanation:
A Query Profile provides detailed execution information for a query, which can be used to analyze the performance and behavior of queries. This information can help users optimize and right-size their virtual warehouses for better efficiency. References: [COF-C02] SnowPro Core Certification Exam Study Guide