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

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

List of questions

Question 151

Report Export Collapse

Users are responsible for data storage costs until what occurs?

Data expires from Time Travel
Data expires from Time Travel
Data expires from Fail-safe
Data expires from Fail-safe
Data is deleted from a table
Data is deleted from a table
Data is truncated from a table
Data is truncated from a table
Suggested answer: B
Explanation:

Users are responsible for data storage costs in Snowflake until the data expires from the Fail-safe period. Fail-safe is the final stage in the data lifecycle, following Time Travel, and provides additional protection against accidental data loss.Once data exits the Fail-safe state, users are no longer billed for its storage

asked 23/09/2024
Mathias Gontek
46 questions

Question 152

Report Export Collapse

What affects whether the query results cache can be used?

If the query contains a deterministic function
If the query contains a deterministic function
If the virtual warehouse has been suspended
If the virtual warehouse has been suspended
If the referenced data in the table has changed
If the referenced data in the table has changed
If multiple users are using the same virtual warehouse
If multiple users are using the same virtual warehouse
Suggested answer: C
Explanation:

The query results cache can be used as long as the data in the table has not changed since the last time the query was run.If the underlying data has changed, Snowflake will not use the cached results and will re-execute the query1.

asked 23/09/2024
Joseph Varghese
43 questions

Question 153

Report Export Collapse

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

SELECT SUM (ORDER_AMT) FROM SALES;
SELECT SUM (ORDER_AMT) FROM SALES;
SELECT AVG(ORDER_QTY) FROM SALES;
SELECT AVG(ORDER_QTY) FROM SALES;
SELECT MIN(ORDER_AMT) FROM SALES;
SELECT MIN(ORDER_AMT) FROM SALES;
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
Suggested answer: B
Explanation:

Operations that do not require compute resources are typically those that can leverage previously cached results. However, if no queries have been executed previously, all the given operations would require compute to execute.It's important to note that certain operations like DDL statements and queries that hit the result cache do not consume compute credits2.

asked 23/09/2024
Ruben Dallibor
33 questions

Question 154

Report Export Collapse

How many days is load history for Snowpipe retained?

1 day
1 day
7 days
7 days
14 days
14 days
64 days
64 days
Suggested answer: C
Explanation:

Snowpipe retains load history for 14 days.This allows users to view and audit the data that has been loaded into Snowflake using Snowpipe within this time frame3.

asked 23/09/2024
Danilo Paolucci
46 questions

Question 155

Report Export Collapse

How can a row access policy be applied to a table or a view? (Choose two.)

Within the policy DDL
Within the policy DDL
Within the create table or create view DDL
Within the create table or create view DDL
By future APPLY for all objects in a schema
By future APPLY for all objects in a schema
Within a control table
Within a control table
Using the command ALTER <object> ADD ROW ACCESS POLICY ;
Using the command ALTER <object> ADD ROW ACCESS POLICY ;
Suggested answer: A, E
Explanation:

A row access policy can be applied to a table or a view within the policy DDL when defining the policy.Additionally, an existing row access policy can be applied to a table or a view using theALTER <object> ADD ROW ACCESS POLICY command

asked 23/09/2024
First Last
37 questions

Question 156

Report Export Collapse

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

JOIN
JOIN
COPY INTO
COPY INTO
PUT
PUT
GET
GET
Suggested answer: C
Explanation:

ThePUTcommand is used to load data files into a Snowflake stage.This command uploads data files from a local file system to a specified stage in Snowflake

asked 23/09/2024
Aleksandar Burdin
28 questions

Question 157

Report Export Collapse

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Reader
Reader
Consumer
Consumer
Vendor
Vendor
Standard
Standard
Personalized
Personalized
Suggested answer: C, E
Explanation:

In the Snowflake Data Marketplace, the types of data listings available include 'Vendor', which refers to the providers of data, and 'Personalized', which indicates customized data offerings tailored to specific consumer needs45.

asked 23/09/2024
Antonio Ferri
35 questions

Question 158

Report Export Collapse

What is the maximum Time Travel retention period for a temporary Snowflake table?

90 days
90 days
1 day
1 day
7 days
7 days
45 days
45 days
Suggested answer: B
Explanation:

The maximum Time Travel retention period for a temporary Snowflake table is 1 day.This is the standard retention period for temporary tables, which allows for accessing historical data within a 24-hour window

asked 23/09/2024
Krishnan S Sridhar
39 questions

Question 159

Report Export Collapse

When should a multi-cluster warehouse be used in auto-scaling mode?

When it is unknown how much compute power is needed
When it is unknown how much compute power is needed
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
If the runtime of the executed query is very slow
If the runtime of the executed query is very slow
When a large number of concurrent queries are run on the same warehouse
When a large number of concurrent queries are run on the same warehouse
Suggested answer: D
Explanation:

A multi-cluster warehouse should be used in auto-scaling mode when there is a need to handle a large number of concurrent queries.Auto-scaling allows Snowflake to automatically add or remove compute clusters to balance the load, ensuring that performance remains consistent during varying levels of demand

asked 23/09/2024
Jimmy Raiford
49 questions

Question 160

Report Export Collapse

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

Amazon Web Services
Amazon Web Services
Docker
Docker
IBM Cloud
IBM Cloud
Microsoft Azure Cloud
Microsoft Azure Cloud
Google Cloud Platform
Google Cloud Platform
Oracle Cloud
Oracle Cloud
Suggested answer: A, D, E
Explanation:

Snowflake supports the use of external stages with Amazon Web Services (AWS), Microsoft Azure Cloud, and Google Cloud Platform (GCP).These platforms allow users to stage data externally and integrate with Snowflake for data loading operations

asked 23/09/2024
Ronald Zegwaard
47 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).