最新の[2026年05月20日]COF-C03試験問題集で有効で更新された問題集
無料お試しまもなく終了！100%有効なCOF-C03試験問題集には783問があります
質問 # 268
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
- A. RETURN_ERRORS
- B. RETURN_n_ROWS
- C. RETURN ALL ERRORS
- D. RETURN_-1_R0WS
正解：A
解説：
The RETURN_ERRORS value in the VALIDATION_MODE option of the COPY command instructs Snowflake to validate the data files and return errors encountered across all specified files, including those that were partially loaded during an earlier load2. References: [COF-C02] SnowPro Core Certification Exam Study Guide
質問 # 269
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
- A. Network policies
- B. Fail-safe
- C. Access control
- D. Time Travel
正解：D
解説：
Snowflake's Time Travel feature is used for the maintenance of historical data, allowing users to access and restore data that has been changed or deleted within a defined period4.
質問 # 270
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. Extended time travel
- D. Native support for geospatial data
- E. Automated index management
正解：B、C
解説：
The Snowflake Enterprise edition includes database replication and failover for business continuity and disaster recovery, as well as extended time travel capabilities for longer data retention periods1.
質問 # 271
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
- A. There are multiple SQL UDFs with different names but the same number of arguments or argument types.
- B. There are multiple SOL UDFs with the same names and the same number of arguments.
- C. There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.
- D. There are multiple SQL UDFs with the same names and the same number of argument types.
正解：C
解説：
In Snowflake, overloading refers to the creation of multiple User-Defined Functions (UDFs) with the same name but differing in the number or types of their arguments. This feature allows for more flexible function usage, as Snowflake can differentiate between functions based on the context of their invocation, such as the types or the number of arguments passed. Overloading helps to create more adaptable and readable code, as the same function name can be used for similar operations on different types of data.
References:
Snowflake Documentation: User-Defined Functions
質問 # 272
Which command can be performed on a Snowflake secure view?
- A. SELECT
- B. UPDATE
- C. INSERT
- D. DELETE
正解：C
質問 # 273
What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?
- A. Disable auto-suspend on the warehouse.
- B. Scale-out with a multi-cluster warehouse.
- C. Enable auto-resume on the warehouse.
- D. Scale-up by resizing the warehouse.
正解：D
質問 # 274
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
- A. 8 hours
- B. 4 hours
- C. 2 hours
- D. 1 hour
正解：B
解説：
When using the ALLOW_CLIENT_MFA_CACHING parameter, a cached Multi-Factor Authentication (MFA) token is valid for up to 4 hours.This allows for continuous, secure connectivity without users needing to respond to an MFA prompt at the start of each connection attempt to Snowflake within this timeframe2.
質問 # 275
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
- A. list @bronzestage;
- B. select * from table(information_schema.stage_directory_file_registration_history(
- C. select * from directory(@bronzestage);
- D. select metadata$filename from @bronzestage;
正解：C
解説：
The query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage is select * from directory(@bronzestage).This query retrieves a list of all files on the stage along with metadata, including the Snowflake file URL for each file3.
質問 # 276
What are characteristics of reader accounts in Snowflake? (Select TWO).
- A. Reader accounts enable data consumers to access and query data shared by the provider.
- B. Reader account users can share data to other reader accounts.
- C. Data consumers are responsible for reader account setup and data usage costs.
- D. A single reader account can consume data from multiple provider accounts.
- E. Reader account users cannot add new data to the account.
正解：A、E
解説：
Characteristics of reader accounts in Snowflake include:
A . Reader account users cannot add new data to the account: Reader accounts are intended for data consumption only. Users of these accounts can query and analyze the data shared with them but cannot upload or add new data to the account.
E . Reader accounts enable data consumers to access and query data shared by the provider: One of the primary purposes of reader accounts is to allow data consumers to access and perform queries on the data shared by another Snowflake account, facilitating secure and controlled data sharing.
References:
Snowflake Documentation: Reader Accounts
質問 # 277
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
- A. The data from the temporary table.
- B. An error stating that the referenced object could not be uniquely identified.
- C. An error stating that the view could not be compiled.
- D. The data from the permanent table.
正解：D
解説：
When a view is defined on a permanent table, and a temporary table with the same name is created in the same schema, the query from the view will return the data from the permanent table.Temporary tables are session-specific and do not affect the data returned by views defined on permanent tables2.
質問 # 278
What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?
- A. Cloning
- B. Fail-safe
- C. Time Travel
- D. Account replication
正解：B
解説：
Fail-safe is a non-configurable feature in Snowflake that provides an additional layer of data protection beyond Time Travel. Time Travel allows users to access historical data within a configurable period (up to 90 days), while Fail-safe provides an additional 7-day period during which Snowflake retains historical data to recover from significant data loss or corruption incidents. This period is not accessible by users but can be used by Snowflake support to assist in data recovery efforts.References: Snowflake Documentation on Fail-safe and Time Travel
質問 # 279
What best practice recommendations will help prevent timeouts when using the PUT command to load large data sets? (Select TWO).
- A. Enable the overwrite option.
- B. Load the data into a table stage.
- C. Use a semi-structured file format.
- D. Increase the PARALLEL option value.
- E. Compress the files before loading.
正解：D、E
解説：
To avoid timeouts during large data uploads with the PUT command in Snowflake, it is recommended to:
Compress files before loading: Compressed files are smaller and upload faster, reducing the risk of timeouts.
Increase the PARALLEL option value: This option allows more simultaneous upload threads, improving upload speed and efficiency for large datasets.
Semi-structured file formats and table staging do not directly impact timeouts, while enabling overwrite does not prevent timeouts but rather controls overwriting of existing files.
質問 # 280
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
- A. A user cannot specify a default warehouse when using the ODBC driver.
- B. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
- C. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
- D. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
- E. The default virtual warehouse size can be changed at any time.
正解：D、E
解説：
Snowflake virtual warehouses support a configuration file and command line options in SnowSQL to specify a default warehouse, which is characteristic C. Additionally, the size of a virtual warehouse can be changed at any time, which is characteristic E.These features provide flexibility and ease of use in managing compute resources2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation
質問 # 281
Which activities are included in the Cloud Sen/ices layer? (Select TWO).
- A. Dynamic data masking
- B. Data storage
- C. Infrastructure management
- D. User authentication
- E. Partition scanning
正解：C、D
解説：
The Cloud Services layer in Snowflake includes activities such as user authentication and infrastructure management.This layer coordinates activities across Snowflake, including security enforcement, query compilation and optimization, and more
質問 # 282
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
- A. Comma-separated JSON
- B. Plain text file containing XML elements
- C. Newline Delimited JSON
- D. Binary file in Avro
- E. Binary file in Parquet
正解：C、E
解説：
Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats.
B . Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing and analysis. It is especially suited for complex nested data structures.
D . Newline Delimited JSON (NDJSON): This format represents JSON records separated by newline characters, facilitating the storage and processing of multiple, separate JSON objects in a single file.
These formats are chosen for their efficiency and compatibility with data analytics tools and ecosystems, enabling seamless integration and processing of exported data.
References:
Snowflake Documentation: Data Unloading
質問 # 283
How often are the Account and Table master keys automatically rotated by Snowflake?
- A. 60 Days
- B. 365 Days.
- C. 30 Days
- D. 90 Days
正解：C
解説：
Snowflake automatically rotates the Account and Table master keys when they are more than 30 days old.Active keys are retired, and new keys are created, ensuring robust security through frequent key changes1
質問 # 284
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
- A. Directory table data can not be refreshed manually.
- B. Directory tables store data file metadata.
- C. Directory tables do not have their own grantable privileges.
- D. A directory table is a separate database object.
- E. A directory table will be automatically added to a stage.
正解：B、C
解説：
Directory tables in Snowflake are used to store metadata about data files in a stage. They are not separate database objects but are conceptually similar to external tables.Directory tables do not have grantable privileges of their own
質問 # 285
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A. Tables
- B. Procedures
- C. Materialized views
- D. Secure User Defined Functions (UDFs)
- E. Sequences
正解：A、D
解説：
Secure sharing in Snowflake allows users to share specific objects with other Snowflake accounts without physically copying the data, thus not consuming additional storage. Tables and Secure User Defined Functions (UDFs) are among the objects that can be shared using this feature. Materialized views, sequences, and procedures are not shareable objects in Snowflake.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Secure Data Sharing1
質問 # 286
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
- A. (12,2)
- B. (14,8)
- C. (10,4)
- D. (15,9)
正解：D
解説：
When unloading floating-point number columns to CSV or JSON files, Snowflake truncates the values to approximately 15 significant digits with 9 digits following the decimal point, which can be represented as (15,9). This ensures a balance between accuracy and efficiency in representing floating-point numbers in text-based formats, which is essential for data interchange and processing applications that consume these files.
References:
Snowflake Documentation: Data Unloading Considerations
質問 # 287
How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?
- A. Use the alter warehouse command on an active Snowpark-optimized warehouse.
- B. Use the ALTER warehouse command on a suspended Standard virtual warehouse.
- C. Use the ALTER WAREHOUSE command on an active Standard virtual warehouse
- D. Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.
正解：B
解説：
To change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse, the warehouse must be in a suspended state. This ensures that no operations are disrupted during the modification process.
Suspend the Warehouse: Ensure that the warehouse is suspended.
ALTER WAREHOUSE my_warehouse SUSPEND;
Alter the Warehouse: Modify the warehouse to be Snowpark-optimized.
ALTER WAREHOUSE my_warehouse SET WAREHOUSE_TYPE = 'SNOWPARK-OPTIMIZED'; Resume the Warehouse: Resume the warehouse to make it operational.
ALTER WAREHOUSE my_warehouse RESUME;
References:
Snowflake Documentation: Creating Snowpark-Optimized Warehouses
Snowflake Documentation: ALTER WAREHOUSE
質問 # 288
What virtual warehouse feature or setting will reduce the performance impact when running larger-than-average queries by offloading portions of the query processing work to shared compute resources?
- A. Disabling auto-suspend
- B. Using the query acceleration service
- C. Using a multi-cluster virtual warehouse
- D. Using the search optimization service
正解：B
質問 # 289
......
COF-C03試験問題集で100%高得点させるCOF-C03試験解答がこちら：https://www.passtest.jp/Snowflake/COF-C03-shiken.html
検証済みのCOF-C03試験問題成功確定させます：https://drive.google.com/open?id=1Lh4mfxWoGZotyWsNN2h1e5nY8TQTI-qu