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

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

List of questions

Question 301

Report Export Collapse

How does Snowflake handle the bulk unloading of data into single or multiple files?

It assigns each unloaded data file a unique name.
It assigns each unloaded data file a unique name.
It uses the put command to download the data by default.
It uses the put command to download the data by default.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.
Suggested answer: A
Explanation:

When unloading data, Snowflake assigns each file a unique name to ensure there is no overlap or confusion between files.This is part of the bulk unloading process where data is exported from Snowflake tables into flat files3.

asked 23/09/2024
claudine Nguepnang
47 questions

Question 302

Report Export Collapse

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

Table definition
Table definition
Stage definition
Stage definition
Session level
Session level
COPY INTO TABLE statement
COPY INTO TABLE statement
Suggested answer: D
Explanation:

When file format options are specified in multiple locations, the load operation applies the options in the following order of precedence: first, the COPY INTO TABLE statement; second, the stage definition; and third, the table definition1

asked 23/09/2024
Danyail Storey
31 questions

Question 303

Report Export Collapse

Which statement accurately describes a characteristic of a materialized view?

A materialized view can query only a single table.
A materialized view can query only a single table.
Data accessed through materialized views can be stale.
Data accessed through materialized views can be stale.
Materialized view refreshes need to be maintained by the user.
Materialized view refreshes need to be maintained by the user.
Querying a materialized view is slower than executing a query against the base table of the view.
Querying a materialized view is slower than executing a query against the base table of the view.
Suggested answer: B
Explanation:

A characteristic of a materialized view is that the data accessed through it can be stale.This is because the data in a materialized view may not reflect the latest changes in the base tables until the view is refreshed

asked 23/09/2024
Martijn Pollmann
39 questions

Question 304

Report Export Collapse

Which stream type can be used for tracking the records in external tables?

Append-only
Append-only
External
External
Insert-only
Insert-only
Standard
Standard
Suggested answer: B
Explanation:

The stream type that can be used for tracking the records in external tables is 'External'.This type of stream is specifically designed to track changes in external tables

asked 23/09/2024
Kefash White
44 questions

Question 305

Report Export Collapse

What can a Snowflake user do in the Activity section in Snowsight?

Create dashboards.
Create dashboards.
Write and run SQL queries.
Write and run SQL queries.
Explore databases and objects.
Explore databases and objects.
Explore executed query performance.
Explore executed query performance.
Suggested answer: D
Explanation:

In the Activity section in Snowsight, Snowflake users can explore the performance of executed queries.This includes monitoring queries, viewing details about queries, including performance data, and exploring each step of an executed query in the query profile1.

asked 23/09/2024
Lucas Bila
38 questions

Question 306

Report Export Collapse

Which Snowflake URL type is used by directory tables?

File
File
Pre-signed
Pre-signed
Scoped
Scoped
Virtual-hosted style
Virtual-hosted style
Suggested answer: C
Explanation:

The Snowflake URL type used by directory tables is the scoped URL.This type of URL provides access to files in a stage with metadata, such as the Snowflake file URL, for each file

asked 23/09/2024
Yasser Mohamed Mohamed
50 questions

Question 307

Report Export Collapse

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

10
10
50
50
64
64
256
256
Suggested answer: D
Explanation:

For the ALLOWED VALUES tag property, the maximum number of possible string values for a single tag is 256.This allows for a wide range of values to be assigned to a tag when it is set on an object

asked 23/09/2024
Muath Ahmed Saleh AlShuwaer
43 questions

Question 308

Report Export Collapse

What does Snowflake's search optimization service support?

External tables
External tables
Materialized views
Materialized views
Tables and views that are not protected by row access policies
Tables and views that are not protected by row access policies
Casts on table columns (except for fixed-point numbers cast to strings)
Casts on table columns (except for fixed-point numbers cast to strings)
Suggested answer: C
Explanation:

Snowflake's search optimization service supports tables and views that are not protected by row access policies.It is designed to improve the performance of certain types of queries on tables, including selective point lookup queries and queries on fields in VARIANT, OBJECT, and ARRAY (semi-structured) columns1.

asked 23/09/2024
Joe Evanchak
46 questions

Question 309

Report Export Collapse

What action can a user take to address query concurrency issues?

Enable the query acceleration service.
Enable the query acceleration service.
Enable the search optimization service.
Enable the search optimization service.
Add additional clusters to the virtual warehouse
Add additional clusters to the virtual warehouse
Resize the virtual warehouse to a larger instance size.
Resize the virtual warehouse to a larger instance size.
Suggested answer: C
Explanation:

To address query concurrency issues, a user can add additional clusters to the virtual warehouse.This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.

asked 23/09/2024
Mike van den Berg
40 questions

Question 310

Report Export Collapse

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Indefinitely
Indefinitely
Until the result_cache expires
Until the result_cache expires
Until the retention_time is met
Until the retention_time is met
Until the expiration time is exceeded
Until the expiration time is exceeded
Suggested answer: D
Explanation:

A data consumer who has a pre-signed URL can access data files using Snowflake until the expiration time is exceeded.The expiration time is set when the pre-signed URL is generated and determines how long the URL remains valid3.

asked 23/09/2024
Maxime SELLY
45 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).