Notifications

Clear all

COF-C02

Share and discuss the opinions about the dumps with all COF-C02 Q&As.

Topic Title

Views

Posts

Participants

Which of the following statements will return the required information?

Orval, 3 weeks ago

2

1

No replies

According to recommended best practice, what should be done to reduce the Queue volume?

Esteban, 2 months ago

40

1

No replies

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Giovanni, 2 months ago

18

1

No replies

What feature can be used to reorganize a very large table on one or more columns?

Antwan, 2 months ago

16

1

No replies

What SQL command would be used to view all roles that were granted to user.1?

Rolando, 2 months ago

29

1

No replies

Which Snowflake partner specializes in data catalog solutions?

Galen, 2 months ago

22

1

No replies

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

Ali, 2 months ago

25

1

No replies

Which SQL command should be used to validate which data was loaded into the stage?

Orval, 3 months ago

148

1

No replies

What is the minimum duration charged when starting a virtual warehouse?

Mikel, 3 months ago

89

1

No replies

What is a responsibility of Snowflake's virtual warehouses?

Esteban, 3 months ago

36

1

No replies

When can a Virtual Warehouse start running queries?

Antwan, 3 months ago

37

1

No replies

In which use cases does Snowflake apply egress charges?

Harris, 3 months ago

83

1

No replies

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Jacques, 3 months ago

58

1

No replies

What happens when an external or an internal stage is dropped? (Select TWO).

Gonzalo, 3 months ago

42

1

No replies

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

Eldridge, 3 months ago

55

1

No replies

How would you determine the size of the virtual warehouse used for a task?

Vicente, 3 months ago

64

1

No replies

Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

Rocky, 3 months ago

182

1

No replies

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

Nathaniel, 3 months ago

58

1

No replies

What are the default Time Travel and Fail-safe retention periods for transient tables?

Rolando, 3 months ago

10

1

No replies

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Galen, 3 months ago

55

1

No replies

What is the minimum Snowflake edition required to create a materialized view?

Lloyd, 3 months ago

30

1

No replies

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

Octavio, 3 months ago

58

1

No replies

What is the MOST performant file format for loading data in Snowflake?

Esteban, 3 months ago

68

1

No replies

What happens when a Data Provider revokes privileges to a Share on an object in their source database?

Mikel, 3 months ago

71

1

No replies

Share: