ExamGecko
Login
Home / Snowflake / COF-C02 / List of questions
Ask Question

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

List of questions

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?

1 minute
1 minute
2 minutes
2 minutes
6 minutes
6 minutes
8 minutes
8 minutes
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

asked 23/09/2024
james james
37 questions

Question 292

Report Export Collapse

What happens when a database is cloned?

It does not retain any privileges granted on the source object.
It does not retain any privileges granted on the source object.
It replicates all granted privileges on the corresponding source objects.
It replicates all granted privileges on the corresponding source objects.
It replicates all granted privileges on the corresponding child objects.
It replicates all granted privileges on the corresponding child objects.
It replicates all granted privileges on the corresponding child schema objects.
It replicates all granted privileges on the corresponding child schema objects.
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

asked 23/09/2024
Sukhpreet Sidhu
43 questions

Question 293

Report Export Collapse

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

NUMBER
NUMBER
OBJECT
OBJECT
STRING
STRING
VARCHAR
VARCHAR
VARIANT
VARIANT
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.

asked 23/09/2024
Henri Geimer
40 questions

Question 294

Report Export Collapse

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

Account master keys
Account master keys
Database master keys
Database master keys
File keys
File keys
Secure view keys
Secure view keys
Schema master keys
Schema master keys
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.

asked 23/09/2024
Ismaiel Al-Mufleh
47 questions

Question 295

Report Export Collapse

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

Use Snowpipe.
Use Snowpipe.
Use the INSERT command.
Use the INSERT command.
Use an external table.
Use an external table.
Use the COPY command.
Use the COPY command.
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.

asked 23/09/2024
Nivenl Surnder
37 questions

Question 296

Report Export Collapse

What role is required to use Partner Connect?

ACCOUNTADMIN
ACCOUNTADMIN
ORGADMIN
ORGADMIN
SECURITYADMIN
SECURITYADMIN
SYSADMIN
SYSADMIN
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

asked 23/09/2024
taheireem shaikh
41 questions

Question 297

Report Export Collapse

How does a scoped URL expire?

When the data cache clears.
When the data cache clears.
When the persisted query result period ends.
When the persisted query result period ends.
The encoded URL access is permanent.
The encoded URL access is permanent.
The length of time is specified in the expiration_time argument.
The length of time is specified in the expiration_time argument.
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

asked 23/09/2024
Mark Anthony Simon
46 questions

Question 298

Report Export Collapse

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

Continuous Data Protection (CDP)
Continuous Data Protection (CDP)
Dynamic Data Masking
Dynamic Data Masking
External Tokenization
External Tokenization
Key pair authentication
Key pair authentication
Row access policies
Row access policies
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.

asked 23/09/2024
István Balla
43 questions

Question 299

Report Export Collapse

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

Stored procedures can execute database operations while UDFs cannot.
Stored procedures can execute database operations while UDFs cannot.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
Returning a value is required in a stored procedure while returning values in a UDF is optional.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
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.
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.
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.

asked 23/09/2024
Tobi Space
47 questions

Question 300

Report Export Collapse

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

When users will be using compute at different times throughout a 24/7 period
When users will be using compute at different times throughout a 24/7 period
When managing a steady workload
When managing a steady workload
When the compute must be available with no delay or lag time
When the compute must be available with no delay or lag time
When the user does not want to have to manually turn on the warehouse each time it is needed
When the user does not want to have to manually turn on the warehouse each time it is needed
When the warehouse is shared across different teams
When the warehouse is shared across different teams
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

asked 23/09/2024
Pavol Adamcin
38 questions
Total 716 questions
Go to page: of 72
Open VPLUS File
Convert VPLUS to PDF

Related questions

How can the outer array structure of a semi-structured file be removed?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
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?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
How does the search optimization service improve query performance?
What is a key feature of Snowflake architecture?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).