[2023年12月13日] 完全版には更新されたのはSnowPro Core（COF-C02）認定サンプル問題
最新のSnowflake COF-C02リアル試験問題集PDF
質問 # 203
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
- A. Secure Views
- B. Schemas
- C. Roles
- D. Tables
- E. Secure User-Defined Functions (UDFs)
- F. Stored Procedures
正解：A、D、E
質問 # 204
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
- A. Directory tables do not have their own grantable privileges.
- B. Directory tables store data file metadata.
- C. A directory table will be automatically added to a stage.
- D. A directory table is a separate database object.
- E. Directory table data can not be refreshed manually.
正解：A、B
質問 # 205
What does Snowflake's search optimization service support?
- A. External tables
- B. Materialized views
- C. Tables and views that are not protected by row access policies
- D. Casts on table columns (except for fixed-point numbers cast to strings)
正解：C
質問 # 206
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
- A. A Data Exchange allows groups of accounts to share data privately among the accounts.
- B. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
- C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
- D. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
- E. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
正解：A
質問 # 207
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 can be used to conduct performance analysis without executing a query.
- B. The explain plan output is available graphically.
- C. An explain plan will handle queries with temporary tables and the query profiler will not.
- D. An explain plan's output will display automatic data skew optimization information.
正解：A
質問 # 208
What privilege should a user be granted to change permissions for new objects in a managed access schema?
- A. Grant ALL privileges on the schema.
- B. Grant the OWNERSHIP privilege on the database.
- C. Grant the OWNERSHIP privilege on the schema.
- D. Grant the MANAGE GRANTS global privilege.
正解：D
質問 # 209
Which stage type can be altered and dropped?
- A. User stage
- B. Table stage
- C. External stage
- D. Database stage
正解：B
解説：
Explanation
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages
質問 # 210
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
- A. Pipes
- B. Tasks
- C. Streams
- D. Procedures
正解：C
解説：
Explanation
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%
質問 # 211
What is the default character set used when loading CSV files into Snowflake?
- A. ISO S859-1
- B. ANSI_X3.A
- C. UTF-8
- D. UTF-16
正解：C
質問 # 212
What is the minimum Snowflake edition required to create a materialized view?
- A. Enterprise Edition
- B. Standard Edition
- C. Virtual Private Snowflake Edition
- D. Business Critical Edition
正解：A
解説：
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.
質問 # 213
What feature can be used to reorganize a very large table on one or more columns?
- A. Micro-partitions
- B. Clustering keys
- C. Key partitions
- D. Clustered partitions
正解：B
解説：
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
質問 # 214
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
- A. Standard
- B. Enterprise
- C. Premier
- D. Business Critical Edition
正解：B
質問 # 215
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
- A. True
- B. False
正解：B
質問 # 216
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate fluctuations in workload
- B. To accommodate a more complex workload
- C. To accommodate more users
- D. To accommodate more queries
正解：B
質問 # 217
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
- A. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
- B. Each Snowflake account can be hosted in a different cloud vendor and region.
- C. Each Snowflake account must be hosted in a different cloud vendor and region
- D. All Snowflake accounts must be hosted in the same cloud vendor and region
正解：C
解説：
https://docs.snowflake.com/en/user-guide/intro-regions.html
質問 # 218
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
- A. Customer managed keys (Tri-secret secure)
- B. Database replication and failover
- C. Native support for geospatial data
- D. Automated index management
- E. Extended time travel
正解：B、E
質問 # 219
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
- A. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
- B. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
- C. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
- D. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
- E. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
- F. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
正解：B、D、E
質問 # 220
......
Snowflake COF-C02問題集で一発合格を目指すならこれ！：https://jp.fast2test.com/COF-C02-premium-file.html
COF-C02練習テスト問題更新されたのは503問があります：https://drive.google.com/open?id=1JDcL0v9z2nzRW9D0CbiyPGAahCHjibXh