Snowflake COF-C02 Practice Test - Questions Answers, Page 32
List of questions
Related questions
Question 311

Which pages are included in the Activity area of Snowsight? (Select TWO).
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.
Question 312

Which kind of Snowflake table stores file-level metadata for each file in a stage?
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.
Question 313

Which parameter prevents streams on tables from becoming stale?
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.
Question 314

A user needs to create a materialized view in the schema MYDB.MYSCHEM
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
Question 315

Which objects together comprise a namespace in Snowflake? (Select TWO).
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
Question 316

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?
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.
Question 317

How long does Snowflake retain information in the ACCESS HISTORY view?
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.
Question 318

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?
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.
Question 319

What is used to diagnose and troubleshoot network connections to Snowflake?
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
Question 320

Which REST API can be used with unstructured data?
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.
Question