Pass Your Next COF-C02 Certification Exam Easily & Hassle Free
Free Snowflake COF-C02 Exam Question Practice Exams
NEW QUESTION # 54
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 55
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
- A. Roles
- B. Databases
- C. Accounts
- D. Users
- E. Warehouses
Answer: A,D
NEW QUESTION # 56
What is the minimum Snowflake edition required to create a materialized view?
- A. Virtual Private Snowflake Edition
- B. Business Critical Edition
- C. Standard Edition
- D. Enterprise Edition
Answer: D
NEW QUESTION # 57
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
- A. Number of partitions scanned
- B. Bytes scanned
- C. External bytes scanned
- D. Percentage scanned from cache
- E. Bytes sent over the network
Answer: A,B
NEW QUESTION # 58
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
- A. OAuth
- B. Single Sign-On (SSO)
- C. Okta
- D. Duo Security
Answer: D
NEW QUESTION # 59
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A. Task
- B. Pipe
- C. External stage
- D. Stream
Answer: B
Explanation:
Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 60
Where can a user find and review the failed logins of a specific user for the past 30 days?
- A. The LOGIN_HISTORY view in ACCOUNT_USAGE
- B. The SESSIONS view in ACCOUNT_USAGE
- C. The ACCESS_HISTORY view in ACCOUNT_USAGE
- D. The USERS view in ACCOUNT_USAGE
Answer: A
NEW QUESTION # 61
When unloading to a stage, which of the following is a recommended practice or approach?
- A. Use OBJECT_CONSTRUCT ( * ) when using Parquet
- B. Set SINGLE: = true for larger files
- C. Define an individual file format
- D. Avoid the use of the CAST function
Answer: D
NEW QUESTION # 62
Which of the following describes external functions in Snowflake?
- A. They call code that is stored inside of Snowflake.
- B. They can return multiple rows for each row received
- C. They are a type of User-defined Function (UDF).
- D. They contain their own SQL code.
Answer: C
Explanation:
Explanation
External functions are user-defined functions that are stored and executed outside of Snowflake.
External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.
https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20u
NEW QUESTION # 63
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 64
What happens to historical data when the retention period for an object ends?
- A. The data is cloned into a historical object.
- B. The data moves to Fail-safe
- C. Time Travel on the historical data is dropped.
- D. The object containing the historical data is dropped.
Answer: D
NEW QUESTION # 65
Which stage type can be altered and dropped?
- A. Database stage
- B. Table stage
- C. External stage
- D. User stage
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages
NEW QUESTION # 66
At what levels can a resource monitor be configured? (Select TWO).
- A. Virtual warehouse
- B. Database
- C. Schema
- D. Organization
- E. Account
Answer: A,E
NEW QUESTION # 67
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
- A. An explain plan will handle queries with temporary tables and the query profiler will not.
- B. The explain plan output is available graphically.
- C. An explain plan can be used to conduct performance analysis without executing a query.
- D. An explain plan's output will display automatic data skew optimization information.
Answer: C
NEW QUESTION # 68
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
- A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- B. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
- C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
- D. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
Answer: B
NEW QUESTION # 69
Which item in the Data Warehouse migration process does not apply in Snowflake>
- A. Migrate Schemas
- B. Migrate Users
- C. Migrate Indexes
- D. Build the Data pipeline
Answer: C
NEW QUESTION # 70
What feature can be used to reorganize a very large table on one or more columns?
- A. Key partitions
- B. Micro-partitions
- C. Clustered partitions
- D. Clustering keys
Answer: D
NEW QUESTION # 71
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
- A. MONITOR
- B. OPERATE
- C. MODIFY
- D. USAGE
Answer: B
Explanation:
Reference:
https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privileg
NEW QUESTION # 72
What affects whether the query results cache can be used?
- A. If the virtual warehouse has been suspended
- B. If multiple users are using the same virtual warehouse
- C. If the referenced data in the table has changed
- D. If the query contains a deterministic function
Answer: A
NEW QUESTION # 73
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 74
......
Ace COF-C02 Certification with 503 Actual Questions: https://pass4sure.actualtorrent.com/COF-C02-exam-guide-torrent.html