Summer Sale Coupon - 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sbfdisc

COF-C02 PDF

$44

$109.99

3 Months Free Update

Add to Cart
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

COF-C02 PDF + Testing Engine

$70.4

$175.99

3 Months Free Update

Add to Cart
  • Exam Name: SnowPro Core Certification Exam
  • Last Update: Apr 18, 2024
  • Questions and Answers: 501
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

COF-C02 Engine

$52.8

$131.99

3 Months Free Update

Add to Cart
  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

COF-C02 Practice Exam Questions with Answers SnowPro Core Certification Exam Certification

Question # 6

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

Full Access
Question # 7

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

A.

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

B.

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

C.

A Snowflake account can both provide and consume shared data.

D.

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

E.

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

Full Access
Question # 8

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

A.

Schema stage

B.

Named stage

C.

User stage

D.

Stream stage

E.

Table stage

F.

Database stage

Full Access
Question # 9

What type of query benefits the MOST from search optimization?

A.

A query that uses only disjunction (i.e., OR) predicates

B.

A query that includes analytical expressions

C.

A query that uses equality predicates or predicates that use IN

D.

A query that filters on semi-structured data types

Full Access
Question # 10

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

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Full Access
Question # 11

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A.

Schema Stage

B.

User Stage

C.

Database Stage

D.

Table Stage

E.

External Named Stage

F.

Internal Named Stage

Full Access
Question # 12

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A.

Whether or not it is also a secure view

B.

How often the underlying base table is queried

C.

How often the base table changes

D.

Whether the materialized view has a cluster key defined

E.

How often the materialized view is queried

Full Access
Question # 13

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

A.

Configure the user to be initially disabled.

B.

Force an immediate password change.

C.

Set a default role for the user.

D.

Set the number of minutes to unlock to 15 minutes.

E.

Set the user's access to expire within a specified timeframe.

Full Access
Question # 14

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

A.

Load files that are approximately 25 MB or smaller.

B.

Remove all dates and timestamps.

C.

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

D.

Avoid using embedded characters such as commas for numeric data types

E.

Remove semi-structured data types

Full Access
Question # 15

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

A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB

Full Access
Question # 16

Which of the following describes external functions in Snowflake?

A.

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

B.

They contain their own SQL code.

C.

They call code that is stored inside of Snowflake.

D.

They can return multiple rows for each row received

Full Access
Question # 17

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Full Access
Question # 18

Which command can be used to stage local files from which Snowflake interface?

A.

SnowSQL

B.

Snowflake classic web interface (Ul)

C.

Snowsight

D.

.NET driver

Full Access
Question # 19

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

A.

CSV (Unzipped)

B.

Parquet

C.

CSV (Gzipped)

D.

ORC

Full Access
Question # 20

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

A.

True

B.

False

Full Access
Question # 21

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 22

Which Snowflake feature is used for both querying and restoring data?

A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

Full Access
Question # 23

What is the recommended file sizing for data loading using Snowpipe?

A.

A compressed file size greater than 100 MB, and up to 250 MB

B.

A compressed file size greater than 100 GB, and up to 250 GB

C.

A compressed file size greater than 10 MB, and up to 100 MB

D.

A compressed file size greater than 1 GB, and up to 2 GB

Full Access
Question # 24

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?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 25

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A.

Pipes

B.

Streams

C.

Tasks

D.

Procedures

Full Access
Question # 26

What are common issues found by using the Query Profile? (Choose two.)

A.

Identifying queries that will likely run very slowly before executing them

B.

Locating queries that consume a high amount of credits

C.

Identifying logical issues with the queries

D.

Identifying inefficient micro-partition pruning

E.

Data spilling to a local or remote disk

Full Access
Question # 27

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

A.

Local disk caching

B.

Authentication and access control

C.

Metadata management

D.

Query processing

E.

Database storage

Full Access
Question # 28

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

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Full Access
Question # 29

Which data type can be used to store geospatial data in Snowflake?

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Full Access
Question # 30

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

A.

The ability to scale up warehouses

B.

The use of warehouse auto scaling

C.

The ability to resize warehouses

D.

Use of multi-clustered warehouses

E.

The use of warehouse indexing

Full Access
Question # 31

True or False: A Virtual Warehouse can be resized while suspended.

A.

True

B.

False

Full Access
Question # 32

How long is Snowpipe data load history retained?

A.

As configured in the create pipe settings

B.

Until the pipe is dropped

C.

64 days

D.

14 days

Full Access
Question # 33

What is a limitation of a Materialized View?

A.

A Materialized View cannot support any aggregate functions

B.

A Materialized View can only reference up to two tables

C.

A Materialized View cannot be joined with other tables

D.

A Materialized View cannot be defined with a JOIN

Full Access
Question # 34

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

A.

Internal stages

B.

Incremental backups

C.

Time Travel

D.

Zero-copy clones

E.

Fail-safe

Full Access
Question # 35

The Snowflake Cloud Data Platform is described as having which of the following architectures?

A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Full Access
Question # 36

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

A.

Clustering

B.

Materialized Views

C.

Zero-copy Cloning

D.

Search Optimization Service

Full Access
Question # 37

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

A.

Modify the columns in the underlying table

B.

Use the ALTER VIEW command to update the view

C.

Recreate the view with the required changes

D.

Materialize the view to perform the changes

Full Access
Question # 38

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

A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Full Access
Question # 39

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

A.

CHECK_OPTION

B.

IS_SECURE

C.

IS_UPDATEABLE

D.

TABLE_NAME

Full Access