Snowflake COF-R02 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

AThe warehouse size does not change until all queries currently running in the warehouse have completed.

BThe warehouse size does not change until all queries currently in the warehouse queue have completed.

CThe warehouse size does not change until the warehouse is suspended and restarted.

DIt does not return from the command until the warehouse has finished changing its size.

Correct : D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AThe warehouse size does not change until all queries currently running in the warehouse have completed.

BThe warehouse size does not change until all queries currently in the warehouse queue have completed.

CThe warehouse size does not change until the warehouse is suspended and restarted.

DIt does not return from the command until the warehouse has finished changing its size.

0 / 1500

Question 3

Which of the following are characteristics of security in Snowflake?

AAccount and user authentication is only available with the Snowflake Business Critical edition.

BSupport for HIPAA and GDPR compliance is available for UI Snowflake editions.

CPeriodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

DPrivate communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AAccount and user authentication is only available with the Snowflake Business Critical edition.

BSupport for HIPAA and GDPR compliance is available for UI Snowflake editions.

CPeriodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

DPrivate communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

0 / 1500

Question 4

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

ASHOW GRANTS ON ROLE DATA_SCIENCE

BSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

CSHOW GRANTS TO USER INQUISITIVE_PERSON

DSHOW GRANTS OF ROLE DATA_SCIENCE

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASHOW GRANTS ON ROLE DATA_SCIENCE

BSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

CSHOW GRANTS TO USER INQUISITIVE_PERSON

DSHOW GRANTS OF ROLE DATA_SCIENCE

0 / 1500

Question 5

Which Snowflake tool would be BEST to troubleshoot network connectivity?

ASnowCLI

BSnowUI

CSnowSQL

DSnowCD

Correct : D

https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASnowCLI

BSnowUI

CSnowSQL

DSnowCD

0 / 1500

Master Snowflake COF-R02 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: