Snowflake COF-C02 Cert Guide PDF 100% Cover Real Exam Questions [Q286-Q304] : Free Exams Dumps Materials : http://exams.dumpsmaterials.com

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

Database

Tables

Warehouses

Worksheets

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

The explain plan output is available graphically.

An explain plan can be used to conduct performance analysis without executing a query.

An explain plan will handle queries with temporary tables and the query profiler will not.

An explain plan’s output will display automatic data skew optimization information.

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.

True

False

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

True

False

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

Temporary Tables

Transient Tables

Provisional Tables

Permanent Tables

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

8KB

16MB

50MB

4000GB

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?

Standard

Premium

Enterprise

Business Critical

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

New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts

All database objects can be included In a shared database

Reader Accounts are created and funded by Data Prowlers

Shared databases are read-only

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.)

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in database DB1 to role MYROLE;

grant SELECT on future tables in database DB1 to role MYROLE;

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

Duo Security

OAuth

Okta

Single Sign-On (SSO)

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

An FTP server with TLS encryption

An HTTPS server with WebDAV

A Google Cloud storage bucket

A Windows server file share on 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?

Okta Verify

Duo Mobile

Microsoft Authenticator

Google Authenticator

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

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

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?

4 minutes

10 minutes

14 minutes

24 minutes

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

True

False

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

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

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

A query that uses only disjunction (i.e., OR) predicates

A query that includes analytical expressions

A query that uses equality predicates or predicates that use IN

A query that filters on semi-structured data types

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

The number of queries that ran using the Warehouse.

The size of the Warehouse and the number of clusters that ran within a given time period.

The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

The number of users who accessed the Warehouse.

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

Data storage

Dynamic data masking

Partition scanning

User authentication

Infrastructure management