ExamGecko
Search Search Login
Home Home / Snowflake / COF-C02

Snowflake COF-C02 Practice Test - Questions Answers, Page 30

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
Which minimum Snowflake edition allows for a dedicated metadata store?
How can the outer array structure of a semi-structured file be removed?
Who can access the data published in a Data Exchange?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
What virtual warehouse configuration should be used when processing a large number of complex queries?
Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How does the search optimization service improve query performance?

Question 291

Report
Export
Collapse

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

A.
1 minute
A.
1 minute
Answers
B.
2 minutes
B.
2 minutes
Answers
C.
6 minutes
C.
6 minutes
Answers
D.
8 minutes
D.
8 minutes
Answers
Suggested answer: B

Explanation:

In a multi-cluster warehouse with an economy scaling policy, queries will wait in the queue for 2 minutes before another cluster is started. This is to minimize costs by allowing queries to queue up for a short period before adding additional compute resources. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 292

Report
Export
Collapse

What happens when a database is cloned?

A.
It does not retain any privileges granted on the source object.
A.
It does not retain any privileges granted on the source object.
Answers
B.
It replicates all granted privileges on the corresponding source objects.
B.
It replicates all granted privileges on the corresponding source objects.
Answers
C.
It replicates all granted privileges on the corresponding child objects.
C.
It replicates all granted privileges on the corresponding child objects.
Answers
D.
It replicates all granted privileges on the corresponding child schema objects.
D.
It replicates all granted privileges on the corresponding child schema objects.
Answers
Suggested answer: A

Explanation:

When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it. References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 293

Report
Export
Collapse

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

A.
NUMBER
A.
NUMBER
Answers
B.
OBJECT
B.
OBJECT
Answers
C.
STRING
C.
STRING
Answers
D.
VARCHAR
D.
VARCHAR
Answers
E.
VARIANT
E.
VARIANT
Answers
Suggested answer: B, E

Explanation:

Snowflake supports semi-structured data types, which include OBJECT and VARIANT. These data types are capable of storing JSON-like data structures, allowing for flexibility in data representation.OBJECT can directly contain VARIANT, and thus indirectly contain any other data type, including itself1.

Question 294

Report
Export
Collapse

Snowflake's hierarchical key mode includes which keys? (Select TWO).

A.
Account master keys
A.
Account master keys
Answers
B.
Database master keys
B.
Database master keys
Answers
C.
File keys
C.
File keys
Answers
D.
Secure view keys
D.
Secure view keys
Answers
E.
Schema master keys
E.
Schema master keys
Answers
Suggested answer: A, C

Explanation:

Snowflake's hierarchical key model includes several levels of keys, where Account master keys and File keys are part of this hierarchy.Account master keys are used to encrypt all the data within an account, while File keys are used to encrypt individual files within the database2.

Question 295

Report
Export
Collapse

How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

A.
Use Snowpipe.
A.
Use Snowpipe.
Answers
B.
Use the INSERT command.
B.
Use the INSERT command.
Answers
C.
Use an external table.
C.
Use an external table.
Answers
D.
Use the COPY command.
D.
Use the COPY command.
Answers
Suggested answer: D

Explanation:

Snowflake recommends using the COPY command for bulk loading data batches from files already available in cloud storage.This command allows for efficient and large-scale data loading operations from files staged in cloud storage into Snowflake tables3.

Question 296

Report
Export
Collapse

What role is required to use Partner Connect?

A.
ACCOUNTADMIN
A.
ACCOUNTADMIN
Answers
B.
ORGADMIN
B.
ORGADMIN
Answers
C.
SECURITYADMIN
C.
SECURITYADMIN
Answers
D.
SYSADMIN
D.
SYSADMIN
Answers
Suggested answer: A

Explanation:

To use Partner Connect, the ACCOUNTADMIN role is required.Partner Connect allows account administrators to easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake

Question 297

Report
Export
Collapse

How does a scoped URL expire?

A.
When the data cache clears.
A.
When the data cache clears.
Answers
B.
When the persisted query result period ends.
B.
When the persisted query result period ends.
Answers
C.
The encoded URL access is permanent.
C.
The encoded URL access is permanent.
Answers
D.
The length of time is specified in the expiration_time argument.
D.
The length of time is specified in the expiration_time argument.
Answers
Suggested answer: B

Explanation:

A scoped URL expires when the persisted query result period ends, which is typically after the results cache expires.This is currently set to 24 hours

Question 298

Report
Export
Collapse

Which features make up Snowflake's column level security? (Select TWO).

A.
Continuous Data Protection (CDP)
A.
Continuous Data Protection (CDP)
Answers
B.
Dynamic Data Masking
B.
Dynamic Data Masking
Answers
C.
External Tokenization
C.
External Tokenization
Answers
D.
Key pair authentication
D.
Key pair authentication
Answers
E.
Row access policies
E.
Row access policies
Answers
Suggested answer: B, C

Explanation:

Snowflake's column level security features include Dynamic Data Masking and External Tokenization.Dynamic Data Masking uses masking policies to selectively mask data at query time, while External Tokenization allows for the tokenization of data before loading it into Snowflake and detokenizing it at query runtime5.

Question 299

Report
Export
Collapse

What is the difference between a stored procedure and a User-Defined Function (UDF)?

A.
Stored procedures can execute database operations while UDFs cannot.
A.
Stored procedures can execute database operations while UDFs cannot.
Answers
B.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
B.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
Answers
C.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
C.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
Answers
D.
Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
D.
Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
Answers
Suggested answer: A

Explanation:

Stored procedures in Snowflake can perform a variety of database operations, including DDL and DML, whereas UDFs are designed to return values and cannot execute database operations1.

Question 300

Report
Export
Collapse

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

A.
When users will be using compute at different times throughout a 24/7 period
A.
When users will be using compute at different times throughout a 24/7 period
Answers
B.
When managing a steady workload
B.
When managing a steady workload
Answers
C.
When the compute must be available with no delay or lag time
C.
When the compute must be available with no delay or lag time
Answers
D.
When the user does not want to have to manually turn on the warehouse each time it is needed
D.
When the user does not want to have to manually turn on the warehouse each time it is needed
Answers
E.
When the warehouse is shared across different teams
E.
When the warehouse is shared across different teams
Answers
Suggested answer: B, C

Explanation:

Disabling auto-suspend for a virtual warehouse is recommended when there is a steady workload, which ensures that compute resources are always available.Additionally, it is advisable to disable auto-suspend when immediate availability of compute resources is critical, eliminating any startup delay

Total 716 questions
Go to page: of 72
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms