Actual Snowflake COF-C02 Preparation Exams Online

NEW QUESTION 1

Which command is used to unload data from a Snowflake table into a file in a stage?

• A. COPY INTO
• B. GET
• C. WRITE
• D. EXTRACT INTO

Answer: A

Explanation:
The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage. This command allows for the export of data from Snowflake tables into flat files, which can then be used for further analysis, processing, or storage in external systems.
References:
✑ Snowflake Documentation on Unloading Data
✑ Snowflake SnowPro Core: Copy Into Command to Unload Rows to Files in Named Stage

NEW QUESTION 2

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

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

Answer: C

Explanation:
The minimum Snowflake edition required for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery is the Business Critical edition. References: Snowflake Documentation3.

NEW QUESTION 3

Which command is used to unload files from an internal or external stage to a local file system?

• A. COPY INTO
• B. GET
• C. PUT
• D. TRANSFER

Answer: B

Explanation:
The command used to unload files from an internal or external stage to a local file system in Snowflake is the GET command. This command allows users to download data files that have been staged, making them available on the local file system for further use23.

NEW QUESTION 4

Which task is supported by the use of Access History in Snowflake?

• A. Data backups
• B. Cost monitoring
• C. Compliance auditing
• D. Performance optimization

Answer: C

Explanation:
Access History in Snowflake is primarily utilized for compliance auditing. The Access History feature provides detailed logs that track data access and modifications, including queries that read from or write to database objects. This information is crucial for organizations to meet regulatory requirements and to perform audits related to data access and usage.
✑ Role of Access History:Access History logs are designed to help organizations understand who accessed what data and when. This is particularly important for compliance with various regulations that require detailed auditing capabilities.
✑ How Access History Supports Compliance Auditing:
Reference:For more information on how Access History supports compliance auditing, refer to the Snowflake documentation on Access History: https://docs.snowflake.com/en/sql-reference/account-usage/access_history.html

NEW QUESTION 5

What transformations are supported when loading data into a table using the COPY INTO
<table> command? (Select TWO).

• A. Column reordering
• B. Column omission
• C. JOIN function
• D. FLATTEN function
• E. GROUP BY function

Answer: AB

Explanation:
The COPY INTO <table> command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.

NEW QUESTION 6

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

• A. Default Time Travel Retention is set to 0 day
• B. Maximum Time Travel Retention is 30 day
• C. Fail Safe retention time is 1 day.
• D. Default Time Travel Retention is set to 1 da
• E. Maximum Time Travel Retention is 365 day
• F. Fail Safe retention time is 7 days.
• G. Default Time Travel Retention is set to 0 day
• H. Maximum Time Travel Retention is 90 day
• I. Fail Safe retention time is 7 days.
• J. Default Time Travel Retention is set to 1 da
• K. Maximum Time Travel Retention is 90 day
• L. Fail Safe retention time is 7 days.
• M. Default Time Travel Retention is set to 7 day
• N. Maximum Time Travel Retention is 1 da
• O. Fail Safe retention time is 90 days.
• P. Default Time Travel Retention is set to 90 day
• Q. Maximum Time Travel Retention is 7 day
• R. Fail Safe retention time is 356 days.

Answer: D

Explanation:
In the Snowflake Enterprise Edition, the default Time Travel retention is set to 1 day, the maximum Time Travel retention can be set up to 90 days, and the Fail-safe retention time is 7 days3.

NEW QUESTION 7

Which command is used to remove files from either external cloud storage or an internal staged

• A. DELETE
• B. REMOVE
• C. TRUNCATE
• D. DROP

Answer: B

Explanation:
The REMOVE command in Snowflake is used to delete files from either external cloud storage locations or internal stages. This command helps manage staged files by removing them when they are no longer needed, which is useful for maintaining organization and managing storage costs.
References:
✑ Snowflake Documentation: REMOVE Command

NEW QUESTION 8

A sales table FCT_SALES has 100 million records. The following Query was executed
SELECT COUNT (1) FROM FCT SALES;
How did Snowflake fulfill this query?

• A. Query against the result set cache
• B. Query against a virtual warehouse cache
• C. Query against the most-recently created micro-partition
• D. Query against the metadata excite

Answer: D

Explanation:
Snowflake is designed to optimize query performance by utilizing metadata for certain types of queries. When executing a COUNT query, Snowflake can often fulfill the request by accessing metadata about the table??s row count, rather than scanning the entire table or micro-partitions. This is particularly efficient for large tables like FCT_SALES with a significant number of records. The metadata layer maintains statistics about the table, including the row count, which enables Snowflake to quickly return the result of a COUNT query without the need to perform a full scan. References:
✑ Snowflake Documentation on Metadata Management
✑ SnowPro® Core Certification Study Guide

NEW QUESTION 9

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

• A. Standard
• B. Premium
• C. Enterprise
• D. Business Critical

Answer: D

Explanation:
https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

NEW QUESTION 10

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

• A. Pre-signed URL
• B. Scoped URL
• C. Signed URL
• D. File URL

Answer: A

Explanation:
Pre-signed URLs in Snowflake allow users to access unstructured data without the need for authentication into Snowflake or passing an authorization token. These URLs are open and can be directly accessed or downloaded by any user or application, making them ideal for business intelligence applications or reporting tools that need to display unstructured file contents

NEW QUESTION 11

Which statements reflect valid commands when using secondary roles? (Select TWO).

• A. Use SECONDARY ROLES RESUME
• B. USE SECONDARY ROLES SUSPEND
• C. USE SECONDARY RLES ALL
• D. USE SECONDARY ROLES ADD <Role Name>
• E. Use SECONDARY ROLES NONE

Answer: CE

Explanation:
✑ Incorrect Commands:The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in the context of secondary roles.
References:
✑ Snowflake Documentation (USE SECONDARY
ROLES): https://docs.snowflake.com/en/sql-reference/sql/use-secondary- roles.html

NEW QUESTION 12

Which use case does the search optimization service support?

• A. Disjuncts (OR) in join predicates
• B. LIKE/ILIKE/RLIKE join predicates
• C. Join predicates on VARIANT columns
• D. Conjunctions (AND) of multiple equality predicates

Answer: D

Explanation:
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

NEW QUESTION 13

What is the purpose of the use of the VALIDATE command?

• A. To view any queries that encountered an error
• B. To verify that a SELECT query will run without error
• C. To prevent a put statement from running if an error occurs
• D. To see all errors from a previously run COPY INTO <table> statement

Answer: D

Explanation:
TheVALIDATEcommand in Snowflake is used to check for errors that occurred during the execution of aCOPY INTO <table>statement. This command helps users identify and
resolve data loading issues.
✑ Run the COPY INTO Statement:Execute theCOPY INTO <table>command to load data from a stage into a table.
COPY INTO my_table FROM @my_stage
FILE_FORMAT = (FORMAT_NAME = 'my_format');
✑ Validate the Load:Use theVALIDATEfunction to see if there were any errors during the data load.
SELECT *
FROM TABLE(VALIDATE(my_table, JOB_ID => 'my_copy_job_id'));
✑ Review Errors:TheVALIDATEfunction will return details about any errors that occurred, such as parsing errors or data type mismatches.
References:
✑ Snowflake Documentation: Validating Data Loads
✑ Snowflake Documentation: COPY INTO <table>

NEW QUESTION 14

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

• A. READ
• B. OWNERSHIP
• C. USAGK
• D. WRTTF

Answer: A

Explanation:
The minimum privilege required on an external stage for any role to access unstructured data files using a file URL in the GET REST API is READ. This allows the role to retrieve or download data files from the stage.

NEW QUESTION 15

What type of account can be used to share data with a consumer who does have a Snowflake account?

• A. Data provider
• B. Data consumer
• C. Reader
• D. Organization

Answer: C

Explanation:
A Reader account in Snowflake can be used to share data with a consumer who does not have a Snowflake account. Reader accounts are a type of shared account provided by data providers to external data consumers, allowing them to access and query shared data using Snowflake's web interface without needing their own Snowflake account. References:
✑ Snowflake Documentation: Reader Accounts

NEW QUESTION 16

Which statement accurately describes how a virtual warehouse functions?

• A. Increasing the size of a virtual warehouse will always improve data loading performance.
• B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
• C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
• D. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

Answer: C

Explanation:
A virtual warehouse in Snowflake is an independent compute cluster that performs data processing tasks such as executing SQL queries. Each virtual warehouse is dynamically allocated by Snowflake from the cloud provider's resources and does not share compute resources with other warehouses. This architecture ensures that the performance of one warehouse does not impact the performance of another. Adjusting the size of a virtual warehouse affects its computational power by increasing or decreasing the number of compute nodes, which can improve the performance of data processing tasks depending on the workload.
References:
✑ Snowflake Documentation: Understanding Virtual Warehouses

NEW QUESTION 17

Who can create network policies within Snowflake? (Select TWO).

• A. SYSADMIN only
• B. ORCADMIN only
• C. SECURITYADMIN or higher roles
• D. A role with the CREATE NETWORK POLICY privilege
• E. A role with the CREATE SECURITY INTEGRATION privilege

Answer: CD

Explanation:
In Snowflake, network policies define the allowed IP address ranges from which users can connect to Snowflake, enhancing security by restricting access based on network location. The creation and management of network policies require sufficient privileges. Specifically, a user with theSECURITYADMINrole or any role with higher privileges, such asACCOUNTADMIN, can create network policies. Additionally, a custom role can be granted theCREATE NETWORK POLICYprivilege, enabling users assigned to that role to also create network policies. This approach allows for flexible and secure management of network access to Snowflake.References:Snowflake Documentation on Network Policies

NEW QUESTION 18

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

• A. The objects are dropped.
• B. The objects enter the Fail-safe period.
• C. The objects enter the Time Travel period.
• D. The objects are immediately moved to the provider account.

Answer: A

Explanation:
When the DROP MANAGED ACCOUNT command is executed in Snowflake, it removes the managed account, including all objects created within the account, and access to the account is immediately restricted2.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

NEW QUESTION 19
......