Valid COF-C02 Exam Dumps are Your best Choice to Pass

Category:

Comments:

0 Comments

Post Date:

March 12, 2023

If you are looking to take your career in SnowPro Core Certification to the next level, the COF-C02 certification is an excellent option. To prepare for the COF-C02 exam, you need to have a deep understanding of Snowflake products and how to configure them. The best way to prepare for the exam is by using COF-C02 exam dumps questions, which give you a better understanding of the format of the exam. This will help you become familiar with the types of questions you can expect on the actual COF-C02 exam, and it will give you a chance to practice your test-taking skills. Test free online COF-C02 exam dumps questions below.

Page 1 of 11

1. What is a responsibility of Snowflake's virtual warehouses?

Infrastructure management

Metadata management

Query execution

Query parsing and optimization

Management of the storage layer

2. Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

3. What are value types that a VARIANT column can store? (Select TWO)

STRUCT

OBJECT

BINARY

ARRAY

CLOB

4. Which Snowflake architectural layer is responsible for a query execution plan?

Compute

Data storage

Cloud services

Cloud provider

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

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.

6. Which of the following describes the Snowflake Cloud Services layer?

Coordinates activities in the Snowflake account

Executes queries submitted by the Snowflake account users

Manages quotas on the Snowflake account storage

Manages the virtual warehouse cache to speed up queries

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

Account

Database

Organization

Schema

Virtual warehouse

8. When cloning a database, what is cloned with the database? (Choose two.)

Privileges on the database

Existing child objects within the database

Future child objects within the database

Privileges on the schemas within the database

Only schemas and tables within the database

9. The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

In the metadata of the target table for 14 days

In the metadata of the pipe for 14 days

In the metadata of the target table for 64 days

In the metadata of the pipe for 64 days

10. If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Page 2 of 11

11. Which statement about billing applies to Snowflake credits?

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running

12. Which Snowflake layer is always leveraged when accessing a query from the result cache?

Metadata

Data Storage

Compute

Cloud Services

13. Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Files

External tables

Secure User-Defined Functions (UDFs)

Sequences

Streams

14. Which feature allows a user the ability to control the organization of data in a micro-partition?

Range Partitioning

Search Optimization Service

Automatic Clustering

Horizontal Partitioning

15. What is the name of the SnowSQLfile that can store connection information?

history

config

snowsqLcnf

snowsql.pubkey

16. Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

COPY INTO

CREATE PIPE

INSERT INTO

TABLE STREAM

17. What is the recommended compressed file size range for continuous data loads using Snowpipe?

8-16 MB

16-24 MB

10-99 MB

100-250 MB

18. What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

The ability to scale up warehouses

The use of warehouse auto scaling

The ability to resize warehouses

Use of multi-clustered warehouses

The use of warehouse indexing

19. What is a characteristic of the Snowflake Query Profile?

It can provide statistics on a maximum number of 100 queries per week.

It provides a graphic representation of the main components of the query processing.

It provides detailed statistics about which queries are using the greatest number of compute resources.

It can be used by third-party software using the Query Profile AP

20. In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

Page 3 of 11

21. A materialized view should be created when which of the following occurs? (Choose two.)

There is minimal cost associated with running the query.

The query consumes many compute resources every time it runs.

The base table gets updated frequently.

The query is highly optimized and does not consume many compute resources.

The results of the query do not change often and are used frequently.

22. What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

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

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

24. How many network policies can be assigned to an account or specific user at a time?

One

Two

Three

Unlimited

25. What file formats does Snowflake support for loading semi-structured data? (Choose three.)

TSV

JSON

PDF

Avro

Parquet

JPEG

26. What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

The Pipe load history is reset to empty.

The REFRESH command is executed.

The stage will be purged.

The destination table is truncated.

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

True

False

28. What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

The ACCOUNTADMIN role must be granted to only one user.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

29. What is the minimum Snowflake edition required for row level security?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

30. Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

PURGE

MODIFY

REMOVE

DELETE

Page 4 of 11

31. Will data cached in a warehouse be lost when the warehouse is resized?

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

No. because the size of the cache is independent from the warehouse size

Yes. became the new compute resource will no longer have access to the cache encryption key

32. Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Compute resources

Query execution

Authentication

Data storage

Metadata

33. What affects whether the query results cache can be used?

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

34. What is the minimum Snowflake edition that has column-level security enabled?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

35. What is the recommended way to change the existing file format type in my format from CSV to JSON?

ALTER FILE FORMAT my_format SET TYPE=JSON;

ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

REPLACE FILE FORMAT my format TYPE-JSON;

36. How can a user change which columns are referenced in a view?

Modify the columns in the underlying table

Use the ALTER VIEW command to update the view

Recreate the view with the required changes

Materialize the view to perform the changes

37. Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Internal stages

Incremental backups

Time Travel

Zero-copy clones

Fail-safe

38. Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

SHOW STORAGE BY TABLE;

SHOW TABLES;

Information Schema -> TABLE_HISTORY

Information Schema -> TABLE_FUNCTION

Information Schema -> TABLE_STORAGE_METRICS

39. Which file formats are supported for unloading data from Snowflake? (Choose two.)

Avro

JSON

ORC

XML

Delimited (CSV, TSV, etc.)

40. How can a Snowflake user access a JSON object, given the following table? (Select TWO).

src:salesperson.name

src:sa1esPerson. name

src:salesperson.Name

SRC:salesperson.name

SRC:salesperson.Name

Page 5 of 11

41. In the Snowflake access control model, which entity owns an object by default?

The user who created the object

The SYSADMIN role

Ownership depends on the type of object

The role used to create the object

42. What is the minimum Snowflake edition required to use Dynamic Data Masking?

Standard

Enterprise

Business Critical

Virtual Private Snowflake (VPC)

43. Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

USAGE

OPERATE

MONITOR

MODIFY

44. What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

45. What does Snowflake's search optimization service support?

External tables

Materialized views

Tables and views that are not protected by row access policies

Casts on table columns (except for fixed-point numbers cast to strings)

46. Which of the following are best practices for loading data into Snowflake? (Choose three.)

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

47. If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The columns that are queried in the select clause.

The columns with very high cardinality.

The columns with many different values.

The columns most actively used in the select filters.

48. Which Snowflake technique can be used to improve the performance of a query?

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

49. What role is required to use Partner Connect?

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

SYSADMIN

50. How many resource monitors can be assigned at the account level?

Page 6 of 11

51. A user has unloaded data from Snowflake to a stage.

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

list @file__stage

show @file__stage

view @file__stage

verify @file__stage

52. A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

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

CSV (Unzipped)

Parquet

CSV (Gzipped)

ORC

54. What is used to diagnose and troubleshoot network connections to Snowflake?

SnowCD

Snowpark

Snowsight

SnowSQL

55. What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica

Power Bl

Adobe

Data Robot

56. Which statement MOST accurately describes clustering in Snowflake?

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The clustering key must be included in the COPY command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

57. Network policies can be set at which Snowflake levels? (Choose two.)

Role

Schema

User

Database

Account

Tables

58. Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

Search optimization service

Automatic clustering

Row access policies

Multi-cluster virtual warehouses

Secure views

59. True or False: Snowpipe via REST API can only reference External Stages as source.

True

False

60. Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

External Tokenization

External Tables

Materialized Views

User-Defined Table Functions (UDTF)

Page 7 of 11

61. A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Increase the warehouse size from Medium to 2X

Increase the value for the parameter MAX_CONCURRENCY_LEVE

Configure the warehouse to a multi-cluster warehouse.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECOND

62. Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Each Snowflake account can be hosted in a different cloud vendor and region.

Each Snowflake account must be hosted in a different cloud vendor and region

All Snowflake accounts must be hosted in the same cloud vendor and region

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

63. What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

READ

OWNERSHIP

USAGK

WRTTF

64. How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Use Snowpipe.

Use the INSERT command.

Use an external table.

Use the COPY command.

65. 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?

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.

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

67. Which of the following describes how clustering keys work in Snowflake?

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

68. Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

69. When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Stop and start the warehouse to clear the queued queries

Migrate some queries to a new warehouse to reduce load

Limit user access to the warehouse so fewer queries are run against it.

70. Which command sets the Virtual Warehouse for a session?

COPY WAREHOUSE FROM <>;

SET WAREHOUSE = <>;

USE WAREHOUSE <>;

USE VIRTUAL_WAREHOUSE <>;

Page 8 of 11

71. Which statement describes how Snowflake supports reader accounts?

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

72. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Users

Tables

Databases

Internal Stages

73. Which Snowflake URL type is used by directory tables?

File

Pre-signed

Scoped

Virtual-hosted style

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

75. Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

76. True or False: Fail-safe can be disabled within a Snowflake account.

True

False

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

78. Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Compute layer

Storage layer

Cloud infrastructure layer

Cloud services layer

79. What can a Snowflake user do in the Admin area of Snowsight?

Analyze query performance.

Write queries and execute them.

Provide an overview of the listings in the Snowflake Marketplace.

Connect to Snowflake partners to explore extended functionality.

80. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An Aggregate Operacor node is present

The query is spilling to remote storage

Page 9 of 11

81. Which data types does Snowflake support when querying semi-structured data? (Select TWO)

VARIANT

ARRAY

VARCHAR

XML

BLOB

82. Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

Allows a user to import the files in a sequential order

Increases the latency staging and accuracy when loading the data

Allows optimization of parallel operations

83. When should a multi-cluster warehouse be used in auto-scaling mode?

When it is unknown how much compute power is needed

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

If the runtime of the executed query is very slow

When a large number of concurrent queries are run on the same warehouse

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

85. What features does Snowflake Time Travel enable?

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

86. Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

parse_json()

json_extract_path_text()

object_construct()

flatten

87. In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

When the system has enough load for 2 minutes

When the system has enough load for 6 minutes

When the system has enough load for 8 minutes

When the system has enough load for 10 minutes

88. How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

89. When unloading data to an external stage, what is the MAXIMUM file size supported?

1GB

5GB

10 GB

16 GB

90. What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

The shared objects are transferred.

The shared objects are copied.

The shared objects become accessible.

The shared objects can be re-shared.

Page 10 of 11

91. Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

92. How does Snowflake handle the bulk unloading of data into single or multiple files?

It assigns each unloaded data file a unique name.

It uses the put command to download the data by default.

It uses COPY INTO for bulk unloading where the default option is SINGLE - TRU

It uses COPY INTO to copy the data from a table into one or more files in an external stage only.

93. When is the result set cache no longer available? (Select TWO)

When another warehouse is used to execute the query

When another user executes the query

When the underlying data has changed

When the warehouse used to execute the query is suspended

When it has been 24 hours since the last query

94. Which command can be used to load data files into a Snowflake stage?

JOIN

COPY INTO

PUT

GET

95. By default, which Snowflake role is required to create a share?

ORGADMIN

SECURITYADMIN

SHAREADMIN

ACCOUNTADMIN

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

97. What are supported file formats for unloading data from Snowflake? (Choose three.)

XML

JSON

Parquet

ORC

AVRO

CSV

98. What is true about sharing data in Snowflake? (Choose two.)

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

99. Users are responsible for data storage costs until what occurs?

Data expires from Time Travel

Data expires from Fail-safe

Data is deleted from a table

Data is truncated from a table

100. The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Local disk caching

Authentication and access control

Metadata management

Query processing

Database storage

Page 11 of 11

101. What data is stored in the Snowflake storage layer? (Select TWO).

Snowflake parameters

Micro-partitions

Query history

Persisted query results

Standard and secure view results

102. What internal stages are available in Snowflake? (Choose three.)

Schema stage

Named stage

User stage

Stream stage

Table stage

Database stage

103. Which file format will keep floating-point numbers from being truncated when data is unloaded?

CSV

JSON

ORC

Parquet

TAGS:

COF-C02, COF-C02 exam dumps

Notify of

Label

Name*

Email*

Website

Label

Name*

Email*

Website

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Get COF-C02 Dumps Full Version

Q&As: 629
Versions: PDF and Software Download Now

About Dumpsinfo

Dumpsinfo is a good platform providing the latest exam information and dumps questions for all IT certification exams. You can study all the latest exam dumps questions online.

[email protected]

Mon - Sat 9:00am - 6:00pm

Valid COF-C02 Exam Dumps are Your best Choice to Pass

Related

Posts

Prepare ADA-C01 Exam with Using ADA-C01 Dump Questions

Valid DEA-C01 Exam Dumps are Your best Choice to Pass

Prepare DSA-C02 Exam with Using DSA-C02 Dump Questions

SnowPro Core Dumps Guarantee You Pass SnowPro Core Exam Easily

About Us

EMAIL

Services

Opening Hours