[Q95-Q113] COF-C02 by Snowflake Actual Free Exam Questions And Answers [UPDATED 2022]

5/5 - (1 vote)

COF-C02 by Snowflake Actual Free Exam Questions And Answers [UPDATED 2022]

COF-C02 Questions Truly Valid For Your Snowflake Exam!

QUESTION 95
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

QUESTION 96
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

True

False

QUESTION 97
True or False: You can define multiple columns within a clustering key on a table.

True

False

QUESTION 98
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

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

The object immediately becomes unavailable for all Data Consumers

Any additional data arriving after this point in time will not be visible to Data Consumers

The Data Consumers stop seeing data updates and become responsible for storage charges for the object

A static copy of the object at the time the privilege was revoked is created In the Data Consumers’ accounts

QUESTION 100
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

True

False

Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

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

show grants to user USER1;

show grants of user USER1;

describe user USER1;

show grants on user USER1;

QUESTION 102
What happens to the underlying table data when a CLUSTER BY clause is added to a
Snowflake table?

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

QUESTION 103
What is a limitation of a Materialized View?

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN

There are several limitations to using materialized views:
A materialized view can query only a single table.
Joins, including self-joins, are not supported.

QUESTION 104
A company’s security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days.
Which of the following statements will return the required information?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

QUESTION 105
Which copy INTO command outputs the data into one file?

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

QUESTION 106
What is the recommended method for loading data into Snowflake?

Load row by row

Load data in batch

Load data by writing it In the Snowflake Web Interface (UI)

Load data via frequent, angle row DML’s

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

Time Travel – 1 day. Fail-safe – 1 day

Time Travel – 0 days. Fail-safe – 1 day

Time Travel – 1 day. Fail-safe – 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

QUESTION 108
When creating a user it is advisable sable to: Choose 2 answers

Set 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 users access to expire within a specified timeframe

QUESTION 109
What is the minimum Snowflake edition that provides data sharing?

Standard

Premier

Enterprise

Business Critical Edition

QUESTION 110
What is the recommended file sizing for data loading using Snowpipe?

A compressed file size greater than 100 MB, and up to 250 MB

A compressed file size greater than 100 GB, and up to 250 GB

A compressed file size greater than 10 MB, and up to 100 MB

A compressed file size greater than 1 GB, and up to 2 GB

https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

QUESTION 111
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

view @my_stage

list @my_stage

show @my_stage

display @my_stage

QUESTION 112
Which of the following are common use cases for zero-copy cloning? Choose 3 answers

Quick provisioning of Dev and Test/QA environments

Data backups

Point in time snapshots

Performance optimization

QUESTION 113
True or False: Pipes can be suspended and resumed.

True

False