Snowflake COF-C02 Cert Guide PDF 100% Cover Real Exam Questions [Q286-Q304]

NEW QUESTION 286
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

NEW QUESTION 287
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

NEW QUESTION 288
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

NEW QUESTION 289
True or False: Snowflake charges additional fees to Data providers for each share they create.

NEW QUESTION 290
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers

NEW QUESTION 291
What is the maximum compressed row size in Snowflake?

NEW QUESTION 292
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

NEW QUESTION 293
Which of the following statements about data sharing are true? choose 2 answers

NEW QUESTION 294
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

NEW QUESTION 295
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

NEW QUESTION 296
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

NEW QUESTION 297
A company strongly encourages all Snowflake users to self-enroll in Snowflake’s default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

NEW QUESTION 298
Which statement is true about running tasks in Snowflake?

NEW QUESTION 299
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

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

NEW QUESTION 301
What actions will prevent leveraging of the ResultSet cache? (Choose two.)

NEW QUESTION 302
What type of query benefits the MOST from search optimization?

NEW QUESTION 303
For a multi-cluster Warehouse, the number of credits billed is calculated on:

NEW QUESTION 304
Which activities are included in the Cloud Sen/ices layer? (Select TWO).