[Jul 24, 2023] COF-C02 PDF Recently Updated Questions Dumps to Improve Exam Score [Q171-Q187] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

NEW QUESTION 171
What is the default File Format used in the COPY command if one is not specified?

CSV

JSON

Parquet

XML

NEW QUESTION 172
How long is Snowpipe data load history retained?

As configured in the create pipe settings

Until the pipe is dropped

64 days

14 days

NEW QUESTION 173
What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Users who are trying to use the warehouse will receive an error message until the resizing is complete

NEW QUESTION 174
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

NEW QUESTION 175
What are the three layers that make up Snowflake’s architecture? Choose 3 answer

Compute

Tri-Secret Secure

Storage

Cloud Services

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

True

False

NEW QUESTION 177
Which statements are true of micro-partitions? Choose 2 answers

They are approximately 16MB in size

They are stored compressed only if COMPRESS=TRUE on Table

They are Immutable

They are only encrypted in the Enterprise edition and above

NEW QUESTION 178
How many network policies can be assigned to an account or specific user at a time?

One

Two

Three

Unlimited

NEW QUESTION 179
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Materialized views

Sequences

Procedures

Tables

Secure User Defined Functions (UDFs)

NEW QUESTION 180
In a Snowflake role hierarchy, what is the top-level role?

SYSADMIN

ORGADMIN

ACCOUNTADMIN

SECURITYADMIN

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

NEW QUESTION 182
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Compute layer

Storage layer

Cloud infrastructure layer

Cloud services layer

NEW QUESTION 183
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

NEW QUESTION 184
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Reader

Consumer

Vendor

Standard

Personalized

NEW QUESTION 185
Which of the following significantly improves the performance of selective point lookup queries on a table?

Clustering

Materialized Views

Zero-copy Cloning

Search Optimization Service

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

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