Latest COF-C02 Actual Free Exam Updated 630 Questions [Q182-Q203]

COF-C02 Snowflake

admin -

July 30, 2024

4.6/5 - (5 votes)

Latest COF-C02 Actual Free Exam Updated 630 Questions

Online Questions – Valid Practice COF-C02 Exam Dumps Test Questions

Snowflake COF-C02, also known as the SnowPro Core Certification Exam, is a comprehensive assessment of an individual’s knowledge and skills in working with the Snowflake cloud data platform. SnowPro Core Certification Exam certification is designed for professionals who want to demonstrate their proficiency in using Snowflake to manage data warehousing, data lakes, and data engineering tasks. By passing the SnowPro Core Certification Exam, individuals can prove their expertise in using Snowflake to solve complex data challenges and help their organizations unlock the full potential of their data.

Q182. Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

Directory tables in Snowflake are used to store metadata about data files in a stage. They are not separate database objects but are conceptually similar to external tables. Directory tables do not have grantable privileges of their own

Q183. Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

DATA_RETENTION_TIME_IN_DAYS

MAX_DATA_EXTENSION_TIME_IN_DAYS

MIN_DATA_RETENTION_TIME_IN_DAYS

MAX CONCURRENCY LEVEL

The parameter DATA_RETENTION_TIME_IN_DAYS can be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.

Q184. Which use case does the search optimization service support?

Disjuncts (OR) in join predicates

LIKE/ILIKE/RLIKE join predicates

Join predicates on VARIANT columns

Conjunctions (AND) of multiple equality predicates

The search optimization service in Snowflake supports use cases involving conjunctions (AND) of multiple equality predicates. This service enhances the performance of queries that include multiple equality conditions by utilizing search indexes to quickly filter data without scanning entire tables or partitions. It’s particularly beneficial for improving the response times of complex queries that rely on specific data matching across multiple conditions.
References:
* Snowflake Documentation: Search Optimization Service

Q185. What is the default character set used when loading CSV files into Snowflake?

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(C For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

Q186. Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

Bytes scanned

Bytes written to result

Partitions scanned

Partitions total

Percentage scanned from cache

The statistics that can be used to identify queries with inefficient pruning are ‘Partitions scanned’ and
‘Partitions total’. These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.

Q187. Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

Their default role should be set to SYSTEMADMIN (the lower of the two)

They should not set up multi_Factor Authentication (MFA)-as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

They should only access and ‘step into’ the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

They should use the SYSADMIN role to perform administrative work on database objects

Q188. What COPY INTO SQL command should be used to unload data into multiple files?

SINGLE=TRUE

MULTIPLE=TRUE

MULTIPLE=FALSE

SINGLE=FALSE

The COPY INTO SQL command with the option SINGLE=FALSE is used to unload data into multiple files.
This option allows the data to be split into multiple files during the unload process. References: SnowPro Core Certification COPY INTO SQL command unload multiple files

Q189. Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

Security

Data storage

Data visualization

Query computation

Metadata management

Q190. Which role allows a SnowFlake user to view table-level storage utilization information from the TABLE_STORAGE_METRICS view by the default?

ACCOUNTADMIN

SECURYADMIN

SYSADMIN

USERADMIN

Q191. Which command can be used to stage local files from which Snowflake interface?

SnowSQL

Snowflake classic web interface (Ul)

Snowsight

.NET driver

Explanation
https://docs.snowflake.com/en/user-guide/snowsql-use.html

Q192. How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

ACCESS_HISTORY

LOAD_HISTORY

QUERY_HISTORY

REST EVENT HISTORY

To monitor updates, such as SCIM API requests sent to Snowflake by the identity provider, an administrator can use the REST EVENT HISTORY feature. This feature allows administrators to query historical data about REST API calls made to Snowflake, including those related to user and role management through SCIM (System for Cross-domain Identity Management).
The REST EVENT HISTORY table function returns information about REST API calls made over a specified period. It is particularly useful for auditing and monitoring purposes, especially when integrating Snowflake with third-party identity providers that use SCIM for automated user provisioning and deprovisioning.
An example query to check for SCIM API requests might look like this:
SELECT * FROM
TABLE(information_schema.rest_event_history(date_range_start=>dateadd(‘hours’,-1,current_timestamp()))) WHERE request_type = ‘SCIM’; This query returns details on SCIM API requests made in the last hour, including the request type, the identity provider’s details, and the outcome of each request.
Reference: Snowflake Documentation on REST EVENT HISTORY
(https://docs.snowflake.com/en/sql-reference/functions/rest_event_history.html)

Q193. Which Snowflake tool would be BEST to troubleshoot network connectivity?

SnowCLI

SnowUI

SnowSQL

SnowCD

SnowCD (Snowflake Connectivity Diagnostic Tool) is the best tool provided by Snowflake for troubleshooting network connectivity issues. It helps diagnose and resolve issues related to connecting to Snowflake services
https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivi

Q194. Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

Authy

Duo Security

One Login

RSA SecurlD Access

Snowflake integrates Duo Security to support Multi-Factor Authentication (MFA). This feature provides increased login security for users connecting to Snowflake, and it is managed completely by Snowflake without the need for users to sign up separately with Duo4.

Q195. What can be used to view warehouse usage over time? (Select Two).

The load HISTORY view

The Query history view

The show warehouses command

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

To view warehouse usage over time, the Query history view and the
WAREHOUSE_METERING__HISTORY View can be utilized. The Query history view allows users to monitor the performance of their queries and the load on their warehouses over a specified period1. The WAREHOUSE_METERING__HISTORY View provides detailed information about the workload on a warehouse within a specified date range, including average running and queued loads2. References:
[COF-C02] SnowPro Core Certification Exam Study Guide

Q196. Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

Q197. Snowflake’s access control framework combines which models for securing data? (Select TWO).

Attribute-based Access Control (ABAC 1

Discretionary Access Control (DAC)

Access Control List (ACL)

Role-based Access Control (RBAC)

Rule-based Access Control (RuBAC)

Snowflake’s access control framework utilizes a combination of Discretionary Access Control (DAC) and Role-based Access Control (RBAC). DAC in Snowflake allows the object owner to grant access privileges to other roles. RBAC involves assigning roles to users and then granting privileges to those roles. Through roles, Snowflake manages which users have access to specific objects and what actions they can perform, which is central to security and governance in the Snowflake environment.References: Snowflake Documentation on Access Control,

Q198. What is the minimum Snowflake edition required to create a materialized view?

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.

Q199. What happens when a cloned table is replicated to a secondary database? (Select TWO)

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

When a cloned table is replicated to a secondary database in Snowflake, the following occurs:
* C. The physical data is replicated: The actual data of the cloned table is physically replicated to the secondary database. This ensures that the secondary database has its own copy of the data, which can be used for read-only purposes or failover scenarios1.
* E. Metadata pointers to cloned tables are replicated: Along with the physical data, the metadata pointers that refer to the cloned tables are also replicated. This metadata includes information about the structure of the table and any associated properties2.
It’s important to note that while the physical data and metadata are replicated, the secondary database is typically read-only and cannot be used for write operations. Additionally, while there may be additional storage costs associated with the secondary account, this is not a direct result of the replication process but rather a consequence of storing additional data.
References:
* SnowPro Core Exam Prep – Answers to Snowflake’s LEVEL UP: Backup and Recovery
* Snowflake SnowPro Core Certification Exam Questions Set 10

Q200. When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database. References: SnowPro Core Certification cloning database stored procedures views

Q201. True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True

False

Q202. What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

Temporary table

External table

Secure view

Materialized view

A materialized view in Snowflake is a database object derived from a query specification, stored for later use, and can significantly speed up expensive aggregations on large data sets. Materialized views store the result of their underlying query, reducing the need to recompute the result each time the view is accessed. This makes them ideal for improving the performance of read-heavy, aggregate-intensive queries.
References:
* Snowflake Documentation: Using Materialized Views

Q203. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Loading …