Summer Sale Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

Pass the Snowflake SnowPro Core Certification COF-C03 Questions and answers with Dumpstech

Exam COF-C03 Premium Access

View all detail and faqs for the COF-C03 exam

Go to Exam

Practice at least 50% of the questions to maximize your chances of passing.

Viewing page 10 out of 18 pages

Viewing questions 181-200 out of questions

Questions # 181:

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Options:

Configure the user to be initially disabled.

Force an immediate password change.

Set a default role for the user.

Set the number of minutes to unlock to 15 minutes.

Set the user ' s access to expire within a specified timeframe.

Questions # 182:

What are benefits of using Snowpark with Snowflake? (Select TWO).

Options:

Snowpark uses a Spark engine to generate optimized SQL query plans.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

Snowpark does not require that a separate cluster be running outside of Snowflake.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Questions # 183:

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

Options:

No virtual warehouse will be used, data will be read from the result cache.

No virtual warehouse will be used, data will be read from the local disk cache.

The default virtual warehouse will be used to read all data.

The virtual warehouse that is defined at the session level will be used to read all data.

Questions # 184:

What is the difference between a stored procedure and a User-Defined Function (UDF)?

Options:

Stored procedures can execute database operations while UDFs cannot.

Returning a value is required in a stored procedure while returning values in a UDF is optional.

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

Questions # 185:

Which REST API can be used with unstructured data?

Options:

inscrtFilcs

insertReport

GET /api/tiles/

loadHistoryScan

Questions # 186:

Which Snowflake tool would be BEST to troubleshoot network connectivity?

Options:

SnowCLI

SnowUI

SnowSQL

SnowCD

Questions # 187:

At what levels can a resource monitor be configured? (Select TWO).

Options:

Account

Database

Organization

Schema

Virtual warehouse

Questions # 188:

Which statement describes pruning?

Options:

The filtering or disregarding of micro-partitions that are not needed to return a query.

The return of micro-partitions values that overlap with each other to reduce a query ' s runtime.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

The ability to allow the result of a query to be accessed as if it were a table.

Questions # 189:

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

Options:

Scale up the existing warehouse.

Create separate warehouses for each user.

Create separate warehouses for each workload.

Stop loading and querying data at the same time.

Questions # 190:

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

Options:

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

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

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

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

Questions # 191:

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called " CONSUMER "

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

Options:

The reader account will automatically use the Standard edition of Snowflake.

The reader account compute will be billed to the provider account.

The reader account can clone data the provider has shared, but cannot re-share it.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Questions # 192:

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

Options:

Table definition

Stage definition

Session level

COPY INTO TABLE statement

Questions # 193:

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Options:

Create a view.

Cluster a table.

Enable the search optimization service.

Enable Time Travel.

Index a table.

Questions # 194:

Which of the following statements describes a schema in Snowflake?

Options:

A logical grouping of objects that belongs to a single database

A logical grouping of objects that belongs to multiple databases

A named Snowflake object that includes all the information required to share a database

A uniquely identified Snowflake account within a business entity

Questions # 195:

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

Options:

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;

Questions # 196:

Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?

Options:

Cross join

Inner join

Natural join

Outer join

Questions # 197:

How would a user run a multi-cluster warehouse in maximized mode?

Options:

Configure the maximum clusters setting to " Maximum. "

Turn on the additional clusters manually after starting the warehouse.

Set the minimum Clusters and maximum Clusters settings to the same value.

Set the minimum clusters and maximum clusters settings to different values.

Questions # 198:

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

Options:

A VARIANT column

A column with very low cardinality

A column with very high cardinality

A column that is most actively used in selective filters

A column that is most actively used in join predicates

Questions # 199:

Which objects together comprise a namespace in Snowflake? (Select TWO).

Options:

Account

Database

Schema

Table

Virtual warehouse

Questions # 200:

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

Options:

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When the user does not want to have to manually turn on the warehouse each time it is needed

When the warehouse is shared across different teams

Viewing page 10 out of 18 pages

Viewing questions 181-200 out of questions