[Mar-2024] SnowPro Core COF-C02 Exam Practice Dumps [Q124-Q149]

[Mar-2024] SnowPro Core COF-C02 Exam Practice Dumps

2024 COF-C02 Premium Files Test pdf - Free Dumps Collection

NEW QUESTION # 124
Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

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

Answer: D

NEW QUESTION # 125
Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

• A. ARRAY
• B. VARIANT
• C. TEXT
• D. BINARY
• E. VARCHAK

Answer: A,B

NEW QUESTION # 126
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

• A. Scaling rhythmically
• B. Scaling max
• C. Scaling out
• D. Scaling Up

Answer: C

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

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

Answer: D

NEW QUESTION # 128
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

• A. 1 minutes
• B. 10 minutes
• C. 5 minutes
• D. 15 minutes

Answer: B

NEW QUESTION # 129
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A. User
• B. View
• C. Table
• D. Schema
• E. Role
• F. Internal stage

Answer: C,D

NEW QUESTION # 130
Which of the following are benefits of micro-partitioning? (Select TWO)

• A. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• B. Micro-partitions are immutable objects that support the use of Time Travel.
• C. Rows are automatically stored in sorted order within micro-partitions
• D. Micro-partitions cannot overlap in their range of values
• E. Micro-partitions can be defined on a schema-by-schema basis

Answer: C,D

NEW QUESTION # 131
Which of the following DML commands isn't supported by Snowflake?

• A. UPDATE
• B. TRUNCATE TABLE
• C. MERGE
• D. UPSERT

Answer: D

NEW QUESTION # 132
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

• A. Secure User-Defined Functions (UDFs)
• B. Schemas
• C. Tables
• D. Secure Views
• E. Stored Procedures
• F. Roles

Answer: A,C,D

NEW QUESTION # 133
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

• A. True
• B. False

Answer: B

NEW QUESTION # 134
What is the MINIMUM permission needed to access a file URL from an external stage?

• A. MODIFY
• B. USAGE
• C. READ
• D. SELECT

Answer: C

NEW QUESTION # 135
What privilege should a user be granted to change permissions for new objects in a managed access schema?

• A. Grant the OWNERSHIP privilege on the database.
• B. Grant ALL privileges on the schema.
• C. Grant the MANAGE GRANTS global privilege.
• D. Grant the OWNERSHIP privilege on the schema.

Answer: C

NEW QUESTION # 136
Which Snowflake tool would be BEST to troubleshoot network connectivity?

• A. SnowSQL
• B. SnowCLI
• C. SnowCD
• D. SnowUI

Answer: C

Explanation:
https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.

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

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

Answer: D

NEW QUESTION # 138
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

• A. The size of the data required for each query
• B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
• C. The tool that s executing the query
• D. The complexity of each query

Answer: A,D

NEW QUESTION # 139
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

• A. GET
• B. SELECT
• C. COPY
• D. PUT

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html

NEW QUESTION # 140
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

• A. True
• B. False

Answer: B

NEW QUESTION # 141
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

• A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
• B. Allows optimization of parallel operations
• C. Increases the latency staging and accuracy when loading the data
• D. Allows a user to import the files in a sequential order

Answer: B

NEW QUESTION # 142
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

• A. Create a task that puts the files in an internal stage and automate the data loading wizard
• B. Create a task that runs a copy into operation from an external stage every 5 minutes
• C. Create a task that runs a GET operation to intermittently check for new files
• D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Answer: D

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

NEW QUESTION # 143
When should a multi-cluster warehouse be used in auto-scaling mode?

• A. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• B. When it is unknown how much compute power is needed
• C. If the runtime of the executed query is very slow
• D. When a large number of concurrent queries are run on the same warehouse

Answer: D

NEW QUESTION # 144
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

• A. All Snowflake accounts must be hosted in the same cloud vendor and region
• B. Each Snowflake account must be hosted in a different cloud vendor and region
• C. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
• D. Each Snowflake account can be hosted in a different cloud vendor and region.

Answer: B

Explanation:
https://docs.snowflake.com/en/user-guide/intro-regions.html

NEW QUESTION # 145
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?

• A. If User2 has the sysadmin role they will be able to see the results.
• B. If User2 has the securityadmin role they will be able to see the results.
• C. If User2 has the ACCOUNTADMIN role they will be able to see the results.
• D. User2 will be unable to view the result set of the query executed by User1.

Answer: A

NEW QUESTION # 146
What is a responsibility of Snowflake's virtual warehouses?

• A. Query parsing and optimization
• B. Infrastructure management
• C. Metadata management
• D. Query execution
• E. Permanent storage of micro-partitions

Answer: D

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20re

NEW QUESTION # 147
Which of the following objects can be cloned? (Choose four.)

• A. Tables
• B. Named File Formats
• C. Databases
• D. Schemas
• E. Shares
• F. Users

Answer: A,B,C,D

NEW QUESTION # 148
How would a user run a multi-cluster warehouse in maximized mode?

• A. Turn on the additional clusters manually after starting the warehouse.
• B. Set the minimum Clusters and maximum Clusters settings to the same value.
• C. Configure the maximum clusters setting to "Maximum."
• D. Set the minimum clusters and maximum clusters settings to different values.

Answer: D

NEW QUESTION # 149
......

Get ready to pass the COF-C02 Exam right now using our SnowPro Core Exam Package: https://www.pass4leader.com/Snowflake/COF-C02-exam.html

A fully updated 2024 COF-C02 Exam Dumps exam guide from training expert Pass4Leader: https://drive.google.com/open?id=1y9kVHUKa4pCSQot03PNLCD18gATM29r7