COF-R02 by Snowflake Actual Free Exam Q&As

Question 1

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)

A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA). B. The ACCOUNTADMIN role must be granted to only one user. C. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role. D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible. E. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

Discussion 0

Correct Answer: A,D Vote an answer

Question 2

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

A. In the metadata of the pipe for 64 days B. In the metadata of the target table for 64 days C. In the metadata of the pipe for 14 days D. In the metadata of the target table for 14 days

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which data type can be used to store geospatial data in Snowflake?

A. Variant B. Geometry C. Object D. Geography

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

In which use cases does Snowflake apply egress charges?

A. Data sharing within a specific region B. Database replication C. Query result retrieval D. Loading data into Snowflake

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 5

What are ways to create and manage data shares in Snowflake? (Select TWO)

A. Through the Snowflake web interface (Ul) B. Through SQL commands C. Using the CREATE SHARE AS SELECT * TABLE command D. Through the enable__share=true parameter E. Through the DATA_SHARE=TRUE parameter

Discussion 0

Correct Answer: B,D Vote an answer

Question 6

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A. Each Snowflake account must be hosted in a different cloud vendor and region B. Each Snowflake account can be hosted in a different cloud vendor and region. C. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region. D. All Snowflake accounts must be hosted in the same cloud vendor and region

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 7

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

A. False B. True

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

What is cached during a query on a virtual warehouse?

A. Any columns accessed during the query B. All columns in a micro-partition C. All rows accessed during the query D. The columns in the result set of the query

Discussion 0

Correct Answer: A Vote an answer

Question 9

What can be used to view warehouse usage over time? (Select Two).

A. The WAREHOUSE_METERING__HISTORY View B. The Query history view C. The load HISTORY view D. The billing and usage tab in the Snowflake web Ul E. The show warehouses command

Discussion 0

Correct Answer: A,D Vote an answer

Question 10

What affects whether the query results cache can be used?

A. If the virtual warehouse has been suspended B. If the referenced data in the table has changed C. If multiple users are using the same virtual warehouse D. If the query contains a deterministic function

Discussion 0

Correct Answer: A Vote an answer

Question 11

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

A. File URL B. Scoped URL C. Pre-signed URL D. Signed URL

Discussion 0

Correct Answer: D Vote an answer

Question 12

Which statement describes pruning?

A. The filtering or disregarding of micro-partitions that are not needed to return a query. B. The ability to allow the result of a query to be accessed as if it were a table. C. The return of micro-partitions values that overlap with each other to reduce a query's runtime. D. A service that is handled by the Snowflake Cloud Services layer to optimize caching.

Discussion 0

Correct Answer: A Vote an answer

Snowflake SnowPro Core Recertification - COF-R02 Exam Practice Test