Get The Most Updated COF-C02 Dumps To SnowPro Core Certification
Snowflake Certified COF-C02 Dumps Questions Valid COF-C02 Materials
NEW QUESTION # 192
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).
- A. True
- B. False
Answer: B
NEW QUESTION # 193
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
- A. Specify the TEMPORARY option when creating the file format.
- B. Use the REMOVE command after the load completes.
- C. Use the DELETE LOAD HISTORY command after the load completes.
- D. Specify the PURGE copy option in the COPY INTO <table> command.
- E. Use the DROP <file> command after the load completes.
Answer: B,D
NEW QUESTION # 194
Which are true of Snowflake roles?
- A. Roles are a subset of users and users own objects In Snowflake
- B. All grants to objects are given to roles, and never to users
- C. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
- D. The public role controls at other roles
Answer: B,C
NEW QUESTION # 195
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
- A. Configure the warehouse to a multi-cluster warehouse.
- B. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
- C. Increase the warehouse size from Medium to 2XL.
- D. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
Answer: D
NEW QUESTION # 196
What is the purpose of an External Function?
- A. To call code that executes outside of Snowflake
- B. To run a function in another Snowflake database
- C. To share data in Snowflake with external parties
- D. To ingest data from on-premises data sources
Answer: A
NEW QUESTION # 197
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A. A Google Cloud storage bucket
- B. A Windows server file share on Azure
- C. An FTP server with TLS encryption
- D. An HTTPS server with WebDAV
Answer: A
NEW QUESTION # 198
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A. True
- B. False
Answer: A
NEW QUESTION # 199
Which object allows you to limit the number of credits consumed within a Snowflake account?
- A. Warehouse Limit Parameter
- B. Account usage Tracking
- C. Credit Consumption Tracker
- D. Resource Monitor
Answer: D
NEW QUESTION # 200
Select the different types of Internal Stages: (Choose three.)
- A. User Stage
- B. Schema Stage
- C. Named Stage
- D. Table Stage
Answer: A,C,D
NEW QUESTION # 201
For a multi-cluster Warehouse, the number of credits billed is calculated on:
- A. The number of queries that ran using the Warehouse.
- B. The size of the Warehouse and the number of clusters that ran within a given time period.
- C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
- D. The number of users who accessed the Warehouse.
Answer: B
NEW QUESTION # 202
How are serverless features billed?
- A. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
- B. Per second multiplied by an automatic sizing for the job
- C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
- D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account
Answer: D
NEW QUESTION # 203
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. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
- D. Create a task that runs a GET operation to intermittently check for new files
Answer: C
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 204
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
- A. PUT
- B. COPY
- C. GET
- D. SELECT
Answer: C
NEW QUESTION # 205
By definition, a secure view is exposed only to users with what privilege?
- A. OWNERSHIP
- B. USAGE
- C. IMPORT SHARE
- D. REFERENCES
Answer: B
NEW QUESTION # 206
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
- A. True
- B. False
Answer: B
NEW QUESTION # 207
What type of query benefits the MOST from search optimization?
- A. A query that uses only disjunction (i.e., OR) predicates
- B. A query that includes analytical expressions
- C. A query that uses equality predicates or predicates that use IN
- D. A query that filters on semi-structured data types
Answer: C
Explanation:
Reference: https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use
NEW QUESTION # 208
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
- A. Query processing
- B. Metadata management
- C. Database storage
- D. Authentication and access control
- E. Local disk caching
Answer: A,B
NEW QUESTION # 209
......
COF-C02 Premium PDF & Test Engine Files with 503 Questions & Answers: https://www.2pass4sure.com/SnowPro-Core/COF-C02-actual-exam-braindumps.html
Current COF-C02 Exam Dumps [2023] Complete Snowflake Exam Smoothly: https://drive.google.com/open?id=1yhxiZfpNCKIsXbedt-2ETuWM0GHDbfws