COF-C02 - Latest Training Dumps

[Feb 10, 2023] COF-C02 Questions Truly Valid For Your Snowflake Exam!

COF-C02 Actual Questions – Instant Download Tests Free Updated Today!

QUESTION 97
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

QUESTION 98
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

Bytes sent over network

Percentage scanned from cache

Partitions total

Bytes spilled to local storage

Partitions scanned

QUESTION 99
What is the recommended Snowflake data type to store semi-structured data like JSON?

VARCHAR

RAW

LOB

VARIANT

QUESTION 100
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 101
True or False: Fail-safe can be disabled within a Snowflake account.

True

False

QUESTION 102
Which command is used to unload data from a Snowflake table into a file in a stage?

COPY INTO

GET

WRITE

EXTRACT INTO

QUESTION 103
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 104
Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

QUESTION 105
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

QUESTION 106
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

QUESTION 107
What are value types that a VARIANT column can store? (Select TWO)

STRUCT

OBJECT

BINARY

ARRAY

CLOB

Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

QUESTION 108
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.

QUESTION 109
Which of the following terms best describes Snowflake’s database architecture?

Columnar shared nothing

Shared disk

Multi-cluster, shared data

Cloud-native shared memory

QUESTION 110
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

Scaling out adds clusters of varying sizes to a virtual warehouse.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

QUESTION 111
In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

Query result retrieval

Database replication

Loading data into Snowflake

Loading …

Get instant access of 100% real exam questions with verified answers: https://www.trainingdump.com/Snowflake/COF-C02-practice-exam-dumps.html

Category COF-C02

[Feb 10, 2023] COF-C02 Questions Truly Valid For Your Snowflake Exam! [Q97-Q111]