High Value Snowflake COF-C02 Test Questions Online

NEW QUESTION 1

Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

• A. Java
• B. Javascript
• C. Scala
• D. Python
• E. SQL

Answer: BE

Explanation:
User-Defined Function (UDF) handlers must be written inline for Javascript and SQL. These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.

NEW QUESTION 2

What persistent data structures are used by the search optimization service to improve the performance of point lookups?

• A. Micro-partitions
• B. Clustering keys
• C. Equality searches
• D. Search access paths

Answer: D

Explanation:
The search optimization service in Snowflake uses persistent data structures known as search access paths to improve the performance of point lookups. These structures enable efficient retrieval of data by reducing the amount of data scanned during queries.
✑ Search Access Paths:
✑ Point Lookups:
✑ Performance Improvement:
References:
✑ Snowflake Documentation: Search Optimization Service
✑ Snowflake Documentation: Understanding Search Access Paths

NEW QUESTION 3

Which key access control concept does Snowflake descibe as a defined level of access to an object?

• A. Grant
• B. Privilege
• C. Role
• D. Session

Answer: B

Explanation:
In Snowflake, the term "privilege" refers to a defined level of access to an object. Privileges are specific actions that roles can perform on securable objects in Snowflake, such as tables, views, warehouses, databases, and schemas. These privileges are granted to roles and can be further granted to users through their roles, forming the basis of Snowflake??s access control framework.References:Snowflake Documentation on Access Control Privileges

NEW QUESTION 4

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

• A. Gathering the hourly credit usage for an account
• B. Compiling an account's average cloud services cost over the previous month
• C. Summarizing the throughput of Snowpipe costs for an account
• D. Calculating the funds left on an account's contract

Answer: A

Explanation:
The Snowflake Account_Usage.Metering_History view is used to gather the hourly credit usage for an account. This view provides details on the credits consumed by various services within Snowflake for the last 365 days1.

NEW QUESTION 5

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO
<table> command when loading data from a JSON file into a table?

• A. It flattens multiple arrays into a single array.
• B. It removes the outer array structure and loads separate rows of data
• C. It transforms a pivoted table into an array.
• D. It tokenizes each data string using the defined delimiters.

Answer: B

Explanation:
The STRIP_OUTER_ARRAY parameter in the COPY INTO <table> command is used when loading data from a JSON file into a table. This parameter removes the outer array structure from the JSON data and loads separate rows of data into the table.
✑ Understanding the STRIP_OUTER_ARRAY Parameter:
✑ How It Works:
✑ Example Usage: FROM @my_stage/file.json
FILE_FORMAT = (TYPE = 'JSON' STRIP_OUTER_ARRAY = TRUE);
✑ uk.co.certification.simulator.questionpool.PList@6ef05806
✑ Benefits:
References:
✑ Snowflake Documentation: COPY INTO <table>
✑ Snowflake Documentation: JSON File Format Options

NEW QUESTION 6

What are the least privileges needed to view and modify resource monitors? (Select TWO).

• A. SELECT
• B. OWNERSHIP
• C. MONITOR
• D. MODIFY
• E. USAGE

Answer: CD

Explanation:
To view and modify resource monitors, the least privileges needed are MONITOR and MODIFY. These privileges allow a user to monitor credit usage and make changes to resource monitors3.

NEW QUESTION 7

How many resource monitors can be assigned at the account level?

• A. 1
• B. 2
• C. 3
• D. 4

Answer: A

Explanation:
Snowflake allows for only one resource monitor to be assigned at the account level. This monitor oversees the credit usage of all the warehouses in the account. References: Snowflake Documentation

NEW QUESTION 8

Which security models are used in Snowflake to manage access control? (Select TWO).

• A. Discretionary Access Control (DAC)
• B. Identity Access Management (1AM)
• C. Mandatory Access Control (MAC)
• D. Role-Based Access Control (RBAC)
• E. Security Assertion Markup Language (SAML)

Answer: AD

Explanation:
Snowflake uses both Discretionary Access Control (DAC) and Role-Based Access Control (RBAC) to manage access control. DAC allows object owners to grant access privileges to other users. RBAC assigns permissions to roles, and roles are then granted to users, making it easier to manage permissions based on user roles within the organization.
References:
✑ Snowflake Documentation: Access Control in Snowflake

NEW QUESTION 9

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

• A. Use multi-clustered warehousing to scale out warehouse capacity.
• B. Scale up the warehouse size to allow Queries to execute faster.
• C. Stop and start the warehouse to clear the queued queries
• D. Migrate some queries to a new warehouse to reduce load
• E. Limit user access to the warehouse so fewer queries are run against it.

Answer: AB

Explanation:
To address a high volume of queries queuing in a warehouse, Snowflake recommends two best practices:
✑ A. Use multi-clustered warehousing to scale out warehouse capacity: This approach allows for the distribution of queries across multiple clusters within a warehouse, effectively managing the load and reducing the queue volume.
✑ B. Scale up the warehouse size to allow Queries to execute faster: Increasing the size of the warehouse provides more compute resources, which can reduce the time it takes for queries to execute and thus decrease the number of queries waiting in the queue.
These strategies help to optimize the performance of the warehouse by ensuring that resources are scaled appropriately to meet demand.
References:
✑ Snowflake Documentation on Multi-Cluster Warehousing
✑ SnowPro Core Certification best practices

NEW QUESTION 10

How does the Snowflake search optimization service improve query performance?

• A. It improves the performance of range searches.
• B. It defines different clustering keys on the same source table.
• C. It improves the performance of all queries running against a given table.
• D. It improves the performance of equality searche

Answer: D

Explanation:
The Snowflake Search Optimization Service is designed to enhance the performance of specific types of queries on large tables. The correct answer is:
✑ D. It improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table's columns, which significantly speeds up the retrieval of rows based on those equality search conditions.
This optimization is particularly beneficial for large tables where traditional scans might be inefficient for equality searches. By using the Search Optimization Service, Snowflake can leverage the search indexes to quickly locate the rows that match the search criteria without scanning the entire table.
References:
✑ Snowflake Documentation: Search Optimization Service at Snowflake Documentation

NEW QUESTION 11

What are characteristic of Snowsight worksheet? (Select TWO.)

• A. Worksheets can be grouped under folder, and a folder of folders.
• B. Each worksheet is a unique Snowflake session.
• C. Users are limited to running only one on a worksheet.
• D. The Snowflake session ends when a user switches worksheets.
• E. Users can import worksheets and share them with other users.

Answer: AE

Explanation:
Characteristics of Snowsight worksheets in Snowflake include:
✑ A. Worksheets can be grouped under folders, and a folder of folders: This organizational feature allows users to efficiently manage and categorize their worksheets within Snowsight, Snowflake's web-based UI, enhancing the user experience by keeping related worksheets together.
✑ E. Users can import worksheets and share them with other users: Snowsight supports the sharing of worksheets among users, fostering collaboration by allowing users to share queries, analyses, and findings. This feature is crucial for collaborative data exploration and analysis workflows.
References:
✑ Snowflake Documentation: Snowsight (UI for Snowflake)

NEW QUESTION 12

Who can activate a network policy for users in a Snowflake account? (Select TWO)

• A. ACCOUNTADMIN
• B. USERADMIN
• C. PUBLIC
• D. SYSADMIN
• E. Any role that has the global ATTACH POLICY privilege

Answer: AE

Explanation:
Network policies in Snowflake are used to control access to Snowflake accounts based on IP address ranges. These policies can be activated by specific roles that have the necessary privileges.
✑ Role: ACCOUNTADMIN:
✑ Role with Global ATTACH POLICY Privilege:
References:
✑ Snowflake Documentation: Network Policies

NEW QUESTION 13

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

• A. ACCOUNTADMIN
• B. SECURITYADMIN
• C. SYSADMIN
• D. ORGADMIN

Answer: A

Explanation:
By default, the ACCOUNTADMIN role in Snowflake has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function. This function is used to set global account parameters, impacting the entire Snowflake account's configuration and behavior. The ACCOUNTADMIN role is the highest-level administrative role in Snowflake, granting the necessary privileges to manage account settings and security features, including the use of global account parameters.
References:
✑ Snowflake Documentation: SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER

NEW QUESTION 14

Where can a user find and review the failed logins of a specific user for the past 30 days?

• A. The USERS view in ACCOUNT_USAGE
• B. The LOGIN_HISTORY view in ACCOUNT_USAGE
• C. The ACCESS_HISTORY view in ACCOUNT_USAGE
• D. The SESSIONS view in ACCOUNT_USAGE

Answer: B

Explanation:
The LOGIN_HISTORY view in the ACCOUNT_USAGE schema provides information about login attempts, including both successful and failed logins. This view can be used to review the failed login attempts of a specific user for the past 30 days. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 15

Authorization to execute CREATE <object> statements comes only from which role?

• A. Primary role
• B. Secondary role
• C. Application role
• D. Database role

Answer: A

Explanation:
In Snowflake, the authorization to executeCREATE <object>statements, such as creating tables, views, databases, etc., is determined by the role currently set as the user's primary role. The primary role of a user or session specifies the set of privileges(including creation privileges) that the user has. While users can have multiple roles, only the primary role is used to determine what objects the user can create unless explicitly specified in the session.
Reference: This is based on the principle of Role-Based Access Control (RBAC) in Snowflake, where roles are used to manage access permissions. The official Snowflake documentation on Understanding and Using Roles would be the best resource to verify this information: https://docs.snowflake.com/en/user-guide/security-access-control- overview.html#roles

NEW QUESTION 16

Which SQL statement will require a virtual warehouse to run?

• A. SELECT COUNT{*) FROM TBL_EMPLOYEE;
• B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);
• C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT)VALUES(1,'Adam*,20000,* Finance');
• D. CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER,EMP_NAME VARCHAR(30),EMP_SALARY NUMBER, DEPT VARCHAR{20));

Answer: C

Explanation:
A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided:
✑ C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY,
DEPT) VALUES(1,'Adam',20000,'Finance');This SQL statement performs a data modification operation (DML) by inserting a new record into theTBL_EMPLOYEEtable, which requires computational resources provided by a virtual warehouse to execute.
References:
✑ Snowflake Documentation: Understanding Virtual Warehouses

NEW QUESTION 17

What optional properties can a Snowflake user set when creating a virtual warehouse?
(Select TWO).

• A. Auto-suspend
• B. Cache size
• C. Default role
• D. Resource monitor
• E. Storage size

Answer: AD

Explanation:
When creating a virtual warehouse in Snowflake, users have the option to set several properties to manage its behavior and resource usage. Two of these optional properties are Auto-suspend and Resource monitor.
✑ Auto-suspend:This property defines the period of inactivity after which the warehouse will automatically suspend. This helps in managing costs by stopping the warehouse when it is not in use.
CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = 'XSMALL'
AUTO_SUSPEND = 300; -- Auto-suspend after 5 minutes of inactivity
✑ Resource monitor:Users can assign a resource monitor to a warehouse to control and limit the amount of credit usage. Resource monitors help in setting quotas and alerts for warehouse usage.
CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = 'XSMALL'
RESOURCE_MONITOR = 'my_resource_monitor';
References:
✑ Snowflake Documentation: Creating Warehouses
✑ Snowflake Documentation: Resource Monitors

NEW QUESTION 18

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

• A. Standard Edition
• B. Enterprise Edition
• C. Business Critical Edition
• D. Virtual Private Snowflake Edition

Answer: C

Explanation:
The minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data is the Business Critical Edition. This edition offers enhanced security features necessary for compliance with regulations such as HIPAA and HITRUST CSF4.

NEW QUESTION 19

A single user of a virtual warehouse has set the warehouse to auto-resume and auto- suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
* 1. Runs a query that takes 3 minutes to complete
* 2. Leaves for 15 minutes
* 3. Returns and runs a query that takes 10 seconds to complete
* 4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

• A. 4 minutes
• B. 10 minutes
• C. 14 minutes
• D. 24 minutes

Answer: C

Explanation:
The billable compute time includes the time the warehouse is running queries plus the auto-suspend time after the last query if the warehouse is not manually suspended. In this scenario, the warehouse runs for 3 minutes, suspends after 10 minutes of inactivity, resumes for a 10-second query, and then is manually suspended. The total billable time is the sum of the initial 3 minutes, the 10 minutes of auto-suspend time, and the brief period for the 10-second query, which is rounded up to the next full minute due to Snowflake??s billing practices. References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 20

A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

• A. The user will be unable to enter a password.
• B. The user will encounter an error, and will not be able to log in.
• C. The user will be able to log into Snowflake successfully.
• D. After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

Answer: A

Explanation:
When federated authentication is activated in Snowflake, users authenticate via an external identity provider (IdP) rather than using Snowflake-managed credentials. Therefore, a user with a password defined by Snowflake will be unable to enter a password and must use their IdP credentials to log in.

NEW QUESTION 21
......