[2026年04月27日] COF-C02テストエンジンお試しセット、COF-C02問題集PDF [Q558-Q581]

[2026年04月27日] COF-C02テストエンジンお試しセット、COF-C02問題集PDF

最新のSnowflake COF-C02のPDFと問題集で（2026）無料試験問題解答

Snowflake COF-C02試験は、Snowflakeを使用しているデータ専門家にとって貴重な認証です。この試験では、幅広いトピックをカバーしており、スノーフレークのアーキテクチャ、機能、ベストプラクティスを深く理解する必要があります。この認定は、データの専門家がキャリアの見通しを強化するのに役立ち、クライアントと雇用主に専門知識を実証する優れた方法です。

 

質問 # 558
Which Snowflake privilege is required on a pipe object to pause or resume pipes?

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

正解：C

解説：
OPERATE. In Snowflake, to pause or resume a pipe, theOPERATEprivilege is required on the pipe object.
TheOPERATEprivilege allows users to perform operational tasks on specific objects such as pipes, tasks, and streams. Specifically, for a pipe, theOPERATEprivilege enables the user to execute theALTER PIPE ... SET PIPE_EXECUTION_PAUSED=TRUEorALTER PIPE ... SET PIPE_EXECUTION_PAUSED=FALSEcommands, which are used to pause or resume the pipe, respectively.
Here's a step-by-step explanation and reference:
Understanding Pipe Operations:Pipes in Snowflake are used for continuous data loading from staging areas into Snowflake tables. Managing pipes involves operations such as creating, monitoring, pausing, and resuming.
Privileges for Pipe Operations:TheOPERATEprivilege is essential for pausing and resuming pipes. This privilege is more specific than general object access privileges likeSELECTorUSAGEand is tailored for operational control.
Granting the OPERATE Privilege:To grant theOPERATEprivilege on a pipe, an administrator or a user with the necessary grants can execute the SQL command:
GRANTOPERATEONPIPE <pipe_name>TOROLE <role_name>;
Pausing and Resuming Pipes:Once theOPERATEprivilege is granted, the user or role can pause the pipe using:
ALTERPIPE <pipe_name>SETPIPE_EXECUTION_PAUSED=TRUE;
To resume the pipe, they use:
ALTERPIPE <pipe_name>SETPIPE_EXECUTION_PAUSED=FALSE;
Reference:For more information on pipe operations and privileges, you can refer to Snowflake's official documentation on pipes and security access control: https://docs.snowflake.com/en/sql-reference/sql/grant- privilege.html and https://docs.snowflake.com/en/user-guide/data-pipelines-intro.html#managing-pipes

質問 # 559
Which file format option should be used when unloading data into a stage to create a CSV or a JSON file?

• A. FILE_EXTENSION
• B. TRIM_SPACE
• C. PARSE_HEADER
• D. SKIP_HEADER

正解：A

質問 # 560
Which statement accurately describes Snowflake's architecture?

• A. It uses a local data repository for all compute nodes in the platform.
• B. It is a hybrid of traditional shared-disk and shared-nothing database architectures.
• C. It reorganizes loaded data into internal optimized, compressed, and row-based format.
• D. It is a blend of shared-disk and shared-everything database architectures.

正解：B

質問 # 561
What is the minimum Snowflake edition required to create a materialized view?

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

正解：A

解説：
Materialized views in Snowflake are a feature that allows for the pre-computation and storage of query results for faster query performance. This feature is available starting from the Enterprise Edition of Snowflake. It is not available in the Standard Edition, and while it is also available in higher editions like Business Critical and Virtual Private Snowflake, the Enterprise Edition is the minimum requirement.
References:
* Snowflake Documentation on CREATE MATERIALIZED VIEW1.
* Snowflake Documentation on Working with Materialized Views
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%

質問 # 562
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

• A. Duo Mobile
• B. Google Authenticator
• C. Okta Verify
• D. Microsoft Authenticator

正解：A

解説：
Snowflake's default Multi-Factor Authentication (MFA) service is powered by Duo Security.
Users are required to install the Duo Mobile application on their devices to use MFA for increased login security when connecting to Snowflake.
This service is managed entirely by Snowflake, and users donot need to sign up separately with Duo1.

質問 # 563
To use the overwrite option on insert, which privilege must be granted to the role?

• A. truncate
• B. UPDATE
• C. DELETE
• D. SELECT

正解：C

解説：
To use the overwrite option on insert in Snowflake, the DELETE privilege must be granted to the role. This is because overwriting data during an insert operation implicitly involves deleting the existing data before inserting the new data.
* Understanding the Overwrite Option: The overwrite option (INSERT OVERWRITE) allows you to replace existing data in a table with new data. This operation is particularly useful for batch-loading scenarios where the entire dataset needs to be refreshed.
* Why DELETE Privilege is Required: Since the overwrite operation involves removing existing rows in the table, the executing role must have the DELETE privilege to carry out both the deletion of old data and the insertion of new data.
* Granting DELETE Privilege:
* To grant the DELETE privilege to a role, an account administrator can execute the following SQL command:
sqlCopy code
GRANT DELETE ON TABLE my_table TO ROLE my_role;
Reference: For additional details on inserting data with the overwrite option and the required privileges, consult the Snowflake documentation on data loading:
https://docs.snowflake.com/en/sql-reference/sql/insert.html

質問 # 564
What is one of the characteristics of data shares?

• A. Data shares utilize secure views for sharing view objects.
• B. Data shares are cloud agnostic and can cross regions by default.
• C. Data shares support full DML operations.
• D. Data shares work by copying data to consumer accounts.

正解：A

解説：
Data sharing in Snowflake allows for live, read-only access to data across different Snowflake accounts without the need to copy or transfer the data. One of the characteristics of data shares is the ability to use secure views. Secure views are used within data shares to restrict the access of shared data, ensuring that consumers can only see the data that the provider intends to share, thereby preserving privacy and security.
Reference:
Snowflake Documentation: Understanding Secure Views in Data Sharing

質問 # 565
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

• A. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE
  MYROLE;
• B. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• C. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;
• D. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

正解：A

質問 # 566
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

• A. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
• B. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
• C. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
• D. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
• E. Scaling out adds clusters of varying sizes to a virtual warehouse.
• F. Scaling up resizes a virtual warehouse so it can handle more complex workloads.

正解：B、F

質問 # 567
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

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

正解：C

解説：
Periodic rekeying of micro-partitions is a feature that requires the Enterprise Edition of Snowflake or higher. This feature is part of Snowflake's comprehensive approach to encryption key management, ensuring data security through regular rekeying1. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

質問 # 568
What tasks can an account administrator perform in the Data Exchange? (Select TWO).

• A. Add and remove members.
• B. Delete data categories.
• C. Approve and deny listing approval requests.
• D. Transfer listing ownership.
• E. Transfer ownership of a provider profile.

正解：A、C

解説：
An account administrator in the Data Exchange can perform tasks such as adding and removing members and approving or denying listing approval requests. These tasks are part of managing the Data Exchange and ensuring that only authorized listings and members are part of it12.

質問 # 569
What type of function returns one value for each Invocation?

• A. Aggregate
• B. Scalar
• C. Table
• D. Window

正解：B

質問 # 570
Which table function will return the output of a previously-run command?

• A. FLATTEN
• B. TASKHISTORY
• C. QUERY_HISTORY
• D. RESULT_SCAN

正解：D

解説：
* The RESULT_SCAN function returns the output of a previously executed query by referencing its query ID.
* Example:
SELECT * FROM RESULT_SCAN('query_id');
* Other functions like QUERY_HISTORY or TASK_HISTORY provide metadata about queries but do not return query results.
References:
* Snowflake Documentation: RESULT_SCAN Function

質問 # 571
Which feature allows a user the ability to control the organization of data in a micro-partition?

• A. Horizontal Partitioning
• B. Range Partitioning
• C. Search Optimization Service
• D. Automatic Clustering

正解：A

質問 # 572
User-level network policies can be created by which of the following roles? (Select TWO).

• A. ROLEADMIN
• B. ACCOUNTADMIN
• C. USERADMIN
• D. SYSADMIN
• E. SECURITYADMIN

正解：B、E

解説：
User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN role has the highest level of privileges across the account, including the ability to manage network policies. The SECURITYADMIN role is specifically responsible for managing security objects within Snowflake, which includes the creation and management of network policies.
Reference:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Network Policies1
Section 1.3 - SnowPro Core Certification Study Guide

質問 # 573
How would a user execute a series of SQL statements using a task?

• A. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
• B. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
• C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
• D. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

正解：C

解説：
To execute a series of SQL statements using a task, a user would use a stored procedure that contains multiple SQL statements and invoke this stored procedure from the task. References: Snowflake Documentation2.

質問 # 574
Which of the following objects are contained within a schema? (Choose two.)

• A. User
• B. Stream
• C. External table
• D. Share
• E. Role
• F. Warehouse

正解：B、C

解説：
In Snowflake, a schema is a logical grouping of database objects, which can include streams and external tables. A stream is an object that allows users to query data that has changed in specified tables or views, and an external table is a table that references data stored outside of Snowflake. Roles, warehouses, users, and shares are not contained within a schema. References: SHOW OBJECTS, Database, Schema, & Share DDL

質問 # 575
A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).

• A. Delete provider profiles.
• B. Modify listings properties.
• C. Submit listings for approval/publishing.
• D. Modify incoming listing access requests.
• E. Rename listings.

正解：B、C

解説：
With the create data EXCHANGE listing privilege, a Snowflake user can modify the properties of listings and submit them for approval or publishing on the Data Exchange. This allows them to manage and share data sets with consumers effectively. References: Based on general data exchange practices in cloud services as of
2021.

質問 # 576
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?

• A. Use the SECURITYADMIN role.
• B. Contact Snowflake Support.
• C. Use the USERADMIN role.
• D. Use the SYSADMIN role.

正解：C

解説：
To temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY, the USERADMIN role should be used. This role has the necessary privileges to modify user properties, including setting a temporary bypass for network policies, which can be crucial for enabling access under specific circumstances without permanently altering the network security configuration.
References:
* Snowflake Documentation: User Management

質問 # 577
Which of the following are benefits of micro-partitioning? (Select TWO)

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

正解：B、C

解説：
Micro-partitions in Snowflake are immutable objects, which means once they are written, they cannot be modified. This immutability supports the use of Time Travel, allowing users to access historical data within a defined period. Additionally, micro-partitions can significantly reduce the amount of I/O from object storage to virtual warehouses. This is because Snowflake's query optimizer can skip over micro-partitions that do not contain relevant data for a query, thus reducing the amount of data that needs to be scanned and transferred.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

質問 # 578
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

• A. Secure view
• B. External table
• C. View
• D. Materialized view

正解：D

質問 # 579
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

• A. Maintaining Availability Zones
• B. Infrastructure security
• C. Parsing and optimizing queries
• D. Computing the data
• E. Management of metadata

正解：C、E

質問 # 580
What features does Snowflake Time Travel enable?

• A. Querying data-related objects that were created within the past 365 days
• B. Analyzing data usage/manipulation over all periods of time
• C. Conducting point-in-time analysis for Bl reporting
• D. Restoring data-related objects that have been deleted within the past 90 days

正解：C、D

解説：
Snowflake Time Travel is a powerful feature that allows users to access historical data within a defined period. It enables two key capabilities:
* B. Restoring data-related objects that have been deleted within the past 90 days: Time Travel can be used to restore tables, schemas, and databases that have been accidentally or intentionally deleted within the Time Travel retention period.
* C. Conducting point-in-time analysis for BI reporting: It allows users to query historical data as it appeared at a specific point in time within the Time Travel retention period, which is crucial for business intelligence and reporting purposes.
While Time Travel does allow querying of past data, it is limited to the retention period set for the Snowflake account, which is typically 1 day for standard accounts and can be extended up to 90 days for enterprise accounts. It does not enable querying or restoring objects created or deleted beyond the retention period, nor does it provide analysis over all periods of time.
References:
Snowflake Documentation on Time Travel
SnowPro® Core Certification Study Guide

質問 # 581
......

あなたを合格させるSnowPro Core COF-C02試験問題集で2026年04月27日には975問あります：https://www.passtest.jp/Snowflake/COF-C02-shiken.html

COF-C02無料試験学習ガイド！（更新された975問あります)：https://drive.google.com/open?id=1N5j0B5kKg5L8cl6veKWp6ZxQS4huWdUc