Big Halloween Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Snowflake COF-C02 Practice Exam with Questions & Answers | Set: 11

Questions 201

Which command can be used to load data files into a Snowflake stage?

Options:
A.

JOIN

B.

COPY INTO

C.

PUT

D.

GET

Snowflake COF-C02 Premium Access
Questions 202

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Options:
A.

Execute a COPY command

B.

Updating data

C.

Snowpipe

D.

AUTOMATIC__CLUSTERING

E.

Scaling up a warehouse

Questions 203

What happens when an external or an internal stage is dropped? (Select TWO).

Options:
A.

When dropping an external stage, the files are not removed and only the stage is dropped

B.

When dropping an external stage, both the stage and the files within the stage are removed

C.

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

D.

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

E.

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Questions 204

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

Options:
A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Questions 205

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Options:
A.

The table contains a column that has very low cardinality

B.

DML statements that are being issued against the table are blocked

C.

The table has a small number of micro-partitions

D.

Queries on the table are running slower than expected

E.

The clustering depth for the table is large

Questions 206

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

Options:
A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

Questions 207

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Options:
A.

Query against the result set cache

B.

Query against a virtual warehouse cache

C.

Query against the most-recently created micro-partition

D.

Query against the metadata excite

Questions 208

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Options:
A.

Data is hashed by the cluster key to facilitate fast searches for common data values

B.

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.

Smaller micro-partitions are created for common data values to allow for more parallelism

D.

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Questions 209

Will data cached in a warehouse be lost when the warehouse is resized?

Options:
A.

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

C.

No. because the size of the cache is independent from the warehouse size

D.

Yes. became the new compute resource will no longer have access to the cache encryption key

Questions 210

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

Options:
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

Questions 211

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

Options:
A.

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;

B.

SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())

C.

SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;

D.

SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;

Questions 212

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Options:
A.

Pipe

B.

External stage

C.

Task

D.

Stream

Questions 213

How would you determine the size of the virtual warehouse used for a task?

Options:
A.

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B.

Querying(select)the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C.

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D.

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Questions 214

Which of the following objects can be shared through secure data sharing?

Options:
A.

Masking policy

B.

Stored procedure

C.

Task

D.

External table

Questions 215

Which cache type is used to cache data output from SQL queries?

Options:
A.

Metadata cache

B.

Result cache

C.

Remote cache

D.

Local file cache

Questions 216

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

Options:
A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Questions 217

What data is stored in the Snowflake storage layer? (Select TWO).

Options:
A.

Snowflake parameters

B.

Micro-partitions

C.

Query history

D.

Persisted query results

E.

Standard and secure view results

Questions 218

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

Options:
A.

Materialized views

B.

Sequences

C.

Procedures

D.

Tables

E.

Secure User Defined Functions (UDFs)

Questions 219

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

Options:
A.

True

B.

False

Questions 220

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

Options:
A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB