[Jan-2023] COF-C02 Dumps With 100% Verified Q&As - Pass Guarantee or Full Refund [Q13-Q32]

NEW QUESTION 13
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 14
Which copy INTO command outputs the data into one file?

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

NEW QUESTION 15
What command is used to load files into an Internal Stage within Snowflake?

PUT

COPY INTO

TRANSFER

INSERT

NEW QUESTION 16
Which of the following DML commands isn’t supported by Snowflake?

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

NEW QUESTION 17
Fail-safe is unavailable on which table types?

Temporary

Transient

Provisional

Permanent

NEW QUESTION 18
What feature can be used to reorganize a very large table on one or more columns?

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

NEW QUESTION 19
Which of the following best describes where Snowflake’s metadata is stored?

Within the data files

Inside the Virtual Warehouses

In the Cloud Services Layer

within the drivers

NEW QUESTION 20
Which of the following describes external functions in Snowflake?

They are a type of User-defined Function (UDF).

They contain their own SQL code.

They call code that is stored inside of Snowflake.

They can return multiple rows for each row received

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

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

NEW QUESTION 23
Which statements are true concerning Snowflake’s underlying cloud infrastructure? (Select THREE),

Snowflake data and services are deployed in a single availability zone within a cloud provider’s region.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

Snowflake can be deployed in a customer’s private cloud using the customer’s own compute and storage resources for Snowflake compute and storage

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

All three layers of Snowflake’s architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

Snowflake data and services are deployed in at least three availability zones within a cloud provider’s region

NEW QUESTION 24
When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When you don’t want to have to manually turn on the Warehouse each time a user needs it

NEW QUESTION 25
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Materialized view

Sequence

Secure view

Transient table

Clustered table

NEW QUESTION 26
Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Compute resources

Query execution

Authentication

Data storage

Metadata

NEW QUESTION 27
What is the purpose of multi-cluster virtual warehouses?

To create separate data warehouses to increase query optimization

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

To eliminate or reduce Queuing of concurrent queries

To allow the warehouse to resize automatically

NEW QUESTION 28
A developer is granted ownership of a table that has a masking policy. The developer’s role is not able to see the masked dat a. Will the developer be able to modify the table to read the masked data?

Yes, because a table owner has full control and can unset masking policies.

Yes, because masking policies only apply to cloned tables.

No, because masking policies must always reference specific access roles.

No, because ownership of a table does not include the ability to change masking policies

NEW QUESTION 29
What is the default file size when unloading data from Snowflake using the COPY command?

5 MB

8 GB

16 MB

32 MB

NEW QUESTION 30
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica

Power Bl

Adobe

Data Robot

NEW QUESTION 31
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Standard

Premier

Enterprise

Business Critical Edition

NEW QUESTION 32
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

On-premise availability

Simplicity

Open source based

Concurrency

Performance

[Jan-2023] COF-C02 Dumps With 100% Verified Q&As – Pass Guarantee or Full Refund [Q13-Q32]

Leave a Reply Cancel reply

COF-C02 Practice Tests

Related Certifications

Recent Posts

Categories

Archives