ExamGecko
Home / Snowflake / COF-C02
Ask Question

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

Question list
Search

Question 311

Report
Export
Collapse

Which pages are included in the Activity area of Snowsight? (Select TWO).

Contacts
Contacts
Sharing settings
Sharing settings
Copy History
Copy History
Query History
Query History
Automatic Clustering History
Automatic Clustering History
Suggested answer: D, E

Explanation:

The Activity area of Snowsight includes the Query History page, which allows users to monitor and view details about queries executed in their account, including performance data1.It also includes the Automatic Clustering History, which provides insights into the automatic clustering operations performed on tables2.

asked 23/09/2024
Harry Meijer
44 questions

Question 312

Report
Export
Collapse

Which kind of Snowflake table stores file-level metadata for each file in a stage?

Directory
Directory
External
External
Temporary
Temporary
Transient
Transient
Suggested answer: A

Explanation:

The kind of Snowflake table that stores file-level metadata for each file in a stage is a directory table.A directory table is an implicit object layered on a stage and stores file-level metadata about the data files in the stage3.

asked 23/09/2024
Marie Joyce Candice Dancel
42 questions

Question 313

Report
Export
Collapse

Which parameter prevents streams on tables from becoming stale?

MAXDATAEXTENSIONTIMEINDAYS
MAXDATAEXTENSIONTIMEINDAYS
MTN_DATA_RETENTION_TTME_TN_DAYS
MTN_DATA_RETENTION_TTME_TN_DAYS
LOCK_TIMEOUT
LOCK_TIMEOUT
STALE_AFTER
STALE_AFTER
Suggested answer: A

Explanation:

The parameter that prevents streams on tables from becoming stale is MAXDATAEXTENSIONTIMEINDAYS.This parameter specifies the maximum number of days for which Snowflake can extend the data retention period for the table to prevent streams on the table from becoming stale4.

asked 23/09/2024
ALEXANDRE NGUYEN
36 questions

Question 314

Report
Export
Collapse

A user needs to create a materialized view in the schema MYDB.MYSCHEM

Which statements will provide this access?
Which statements will provide this access?
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K'-'SCHEMA TO USER! ;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K'-'SCHEMA TO USER! ;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
Suggested answer: A

Explanation:

To provide a user with the necessary access to create a materialized view in a schema, the user must be granted a role that has the CREATE MATERIALIZED VIEW privilege on that schema.First, the role is granted to the user, and then the privilege is granted to the role

asked 23/09/2024
Anna Fagulova
31 questions

Question 315

Report
Export
Collapse

Which objects together comprise a namespace in Snowflake? (Select TWO).

Account
Account
Database
Database
Schema
Schema
Table
Table
Virtual warehouse
Virtual warehouse
Suggested answer: B, C

Explanation:

In Snowflake, a namespace is comprised of a database and a schema.The combination of a database and schema uniquely identifies database objects within an account

asked 23/09/2024
Alex Ng
41 questions

Question 316

Report
Export
Collapse

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

Scale up the existing warehouse.
Scale up the existing warehouse.
Create separate warehouses for each user.
Create separate warehouses for each user.
Create separate warehouses for each workload.
Create separate warehouses for each workload.
Stop loading and querying data at the same time.
Stop loading and querying data at the same time.
Suggested answer: C

Explanation:

Snowflake recommends creating separate warehouses for each workload to resolve performance issues caused by shared virtual warehouses.This ensures that the resources are not being overutilized by one user's activities, thereby affecting the performance of another user's activities4.

asked 23/09/2024
Conceicao Damasceno
34 questions

Question 317

Report
Export
Collapse

How long does Snowflake retain information in the ACCESS HISTORY view?

7 days
7 days
14 days
14 days
28 days
28 days
365 days
365 days
Suggested answer: D

Explanation:

Snowflake retains information in the ACCESS HISTORY view for 365 days.This allows users to query the access history of Snowflake objects within the last year1.

asked 23/09/2024
Rafael Pabon
44 questions

Question 318

Report
Export
Collapse

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

The data from the permanent table.
The data from the permanent table.
The data from the temporary table.
The data from the temporary table.
An error stating that the view could not be compiled.
An error stating that the view could not be compiled.
An error stating that the referenced object could not be uniquely identified.
An error stating that the referenced object could not be uniquely identified.
Suggested answer: A

Explanation:

When a view is defined on a permanent table, and a temporary table with the same name is created in the same schema, the query from the view will return the data from the permanent table.Temporary tables are session-specific and do not affect the data returned by views defined on permanent tables2.

asked 23/09/2024
Tom Ogan
34 questions

Question 319

Report
Export
Collapse

What is used to diagnose and troubleshoot network connections to Snowflake?

SnowCD
SnowCD
Snowpark
Snowpark
Snowsight
Snowsight
SnowSQL
SnowSQL
Suggested answer: A

Explanation:

SnowCD (Snowflake Connectivity Diagnostic Tool) is used to diagnose and troubleshoot network connections to Snowflake.It runs a series of connection checks to evaluate the network connection to Snowflake

asked 23/09/2024
ahmad hafiz
35 questions

Question 320

Report
Export
Collapse

Which REST API can be used with unstructured data?

inscrtFilcs
inscrtFilcs
insertReport
insertReport
GET /api/tiles/
GET /api/tiles/
loadHistoryScan
loadHistoryScan
Suggested answer: C

Explanation:

The REST API used with unstructured data in Snowflake is GET /api/files/, which retrieves (downloads) a data file from an internal or external stage4.

asked 23/09/2024
Thomaz Stepheson
44 questions
Total 716 questions
Go to page: of 72