[UPDATED 2024] Getting COF-C02 Certification Made Easy! [Q143-Q167] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

NEW QUESTION 143
What is the MINIMUM permission needed to access a file URL from an external stage?

MODIFY

READ

SELECT

USAGE

NEW QUESTION 144
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

NUMBER

OBJECT

STRING

VARCHAR

VARIANT

NEW QUESTION 145
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 146
Which Snowflake layer is associated with virtual warehouses?

Cloud services

Query processing

Elastic memory

Database storage

NEW QUESTION 147
A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?

Permanent

Transient

Temporary

Externa

NEW QUESTION 148
What are the responsibilities of Snowflake’s Cloud Service layer? (Choose three.)

Authentication

Resource management

Virtual warehouse caching

Query parsing and optimization

Query execution

Physical storage of micro-partitions

NEW QUESTION 149
What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

Reorder the rows in a relational table and then unload the rows into a file

Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

Reorder the data columns according to a target table definition and then unload the rows into the table.

Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

NEW QUESTION 150
Which table function is used to perform additional processing on the results of a previously-run query?

QUERY_HISTORY

RESULT_SCAN

DESCRIBE_RESULTS

QUERY HISTORY BY SESSION

NEW QUESTION 151
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

10

50

64

256

NEW QUESTION 152
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

NEW QUESTION 153
What is the purpose of a Query Profile?

To profile how many times a particular query was executed and analyze its u^age statistics over time.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

NEW QUESTION 154
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

CONTENT

PATH

BYTE_SIZE

INDEX

DATATYPE

NEW QUESTION 155
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

VARIANT

VARRAY

STRUCT

ARRAY

QUEUE

NEW QUESTION 156
Which command can be used to load data into an internal stage?

LOAD

copy

GET

PUT

NEW QUESTION 157
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.

NEW QUESTION 158
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.

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

True

False

NEW QUESTION 160
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

Authy

Duo Security

One Login

RSA SecurlD Access

NEW QUESTION 161
What activities can a user with the ORGADMIN role perform? (Select TWO).

Create an account for an organization.

Edit the account data for an organization.

Delete the account data for an organization.

View usage information for all accounts in an organization.

Select all the data in tables for all accounts in an organization.

NEW QUESTION 162
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

NEW QUESTION 163
True or False: All Snowflake table types include fail-safe storage.

True

False

NEW QUESTION 164
Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?

Account -> Schema -> Database -> Table

Account -> Database -> Schema -> Table

Database -> Schema -> Table -> Account

Database -> Table -> Schema -> Account

NEW QUESTION 165
While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

NEW QUESTION 166
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

True

False

NEW QUESTION 167
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

Compress the file and load the compressed file.

Split the file into multiple files in the recommended size range (100 MB – 250 MB).

Use a larger-sized warehouse.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.