最新 [2026年02月06日]COF-C02試験正確解答SnowPro Core Certification ExamのPDF問題
あなたのキャリアーを稼いで飛躍せよSnowflake 975問題
Snowflake COF-C02認定試験は、Snowflakeのデータウェアハウジングプラットフォームの専門知識を実証したい専門家にとって貴重なツールです。この試験は、Snowflakeのテクノロジーを使用してデータウェアハウスを設計、構築、管理する候補者の能力をテストするように設計されています。この試験は、アーキテクチャと管理、パフォーマンスの最適化とスケーリング、データモデリング、クエリと最適化の4つのセクションに分かれています。候補者は、Snowproコア認定を取得するには、4つのセクションすべてを渡す必要があります。
質問 # 426
Which of the following statements describe features of Snowflake data caching? (Choose two.)
- A. The RESULT_SCAN table function can access and filter the contents of the query result cache.
- B. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
- C. When the data cache is full, the least-recently used data will be cleared to make room.
- D. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
- E. A user can only access their own queries from the query result cache.
正解：A、C
解説：
Snowflake's data caching features include the ability to clear the least-recently used data when the data cache is full to make room for new data. Additionally, the RESULT_SCAN table function can access and filter the contents of the query result cache, allowing users to retrieve and work with the results of previous queries. The other statements are incorrect: the data cache is not saved on the remote storage layer when a virtual warehouse is suspended, users can access queries from the query result cache that were run by other users, and there is no setting called USE_METADATA_CACHE in Snowflake. Reference: Caching in the Snowflake Cloud Data Platform, Optimizing the warehouse cache
質問 # 427
A large JSON file contains a single array with many 10 MB JSON objects that include NULLs. The NULLs are meaningful and do not indicate any missing values.
What file format parameters will ensure that all of the data is loaded into Snowflake?
- A. TYPE = JSON, STRIP_OUTER_ARRAY = FALSE, STRIP_NULL_VALUES = FALSE
- B. TYPE = JSON, STRIP_OUTER_ARRAY = FALSE, STRIP_NULL_VALUES = TRUE
- C. TYPE = JSON, STRIP_OUTER_ARRAY = TRUE, STRIP_NULL_VALUES = FALSE
- D. TYPE = JSON, STRIP_OUTER_ARRAY = TRUE, STRIP_NULL_VALUES = TRUE
正解：C
質問 # 428
Which operation can be performed on Snowflake external tables?
- A. ALTER
- B. JOIN
- C. INSERT
- D. RENAME
正解：B
解説：
Snowflake external tables are read-only, which means data manipulation language (DML) operations like INSERT, RENAME, or ALTER cannot be performed on them. However, external tables can be used for query and join operations3.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
質問 # 429
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
- A. Multi-Factor Authentication (MFA)
- B. Network policies
- C. OAuth
- D. Single Sign-On (SSO)
正解：A
解説：
Multi-Factor Authentication (MFA) provides increased login security for users connecting to Snowflake. Snowflake's MFA is powered by Duo Security service, which adds an additional layer of security during the login process.
質問 # 430
A size X-Small virtual warehouse ran for 90 seconds and was shut down. The warehouse was then run for another 30 seconds before being shut down again.
How many seconds will be billed?
- A. 90 seconds
- B. 120 seconds
- C. 180 seconds
- D. 150 seconds
正解：A
質問 # 431
A column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
- A. DATA:employee.name
- B. data:Employee.name
- C. Data:employee.name
- D. data:employee.name
正解：D
解説：
In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive. Therefore, to extract the employee's name from the
"Data" column, the correct syntax is data:employee.name.
質問 # 432
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
- A. GET_STATE_LOCATION
- B. GET_PRESENT_URL
- C. BUILD_SCOPED_FILE_URL
- D. BUILD_STAGE_FILE_URL
正解：D
解説：
Purpose: The BUILD_STAGE_FILE_URL function generates a temporary, pre-signed URL that allows you to access a file within a Snowflake stage (internal or external). This URL requires authentication to use.
Key Points:
Security: The URL has a limited lifespan, enhancing security.
Use Cases: Sharing staged data with external tools or applications, or downloading it directly.
Snowflake Documentation (BUILD_STAGE_FILE_URL): https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url.html
質問 # 433
By default, which role can create resource monitors?
- A. ACCOUNTADMIN
- B. USERADMIN
- C. SYSADMIN
- D. SECURITYADMIN
正解：A
解説：
The role that can by default create resource monitors in Snowflake is theACCOUNTADMINrole. Resource monitors are a crucial feature in Snowflake that allows administrators to track and control the consumption of compute resources, ensuring that usage stays within specified limits. The creation and management of resource monitors involve defining thresholds for credits usage, setting up notifications, and specifying actions to be taken when certain thresholds are exceeded.
Given the significant impact that resource monitors can have on the operational aspects and billing of a Snowflake account, the capability to create and manage them is restricted to theACCOUNTADMINrole. This role has the broadest set of privileges in Snowflake, including the ability to manage all aspects of the account, such as users, roles, warehouses, databases, and resource monitors, among others.
References:
* Snowflake Documentation on Resource Monitors: Managing Resource Monitors
質問 # 434
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
- A. Retrieval optimization
- B. Query pruning
- C. Caching
- D. Cluster depth
正解：B
質問 # 435
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
- A. select * from directory(@bronzestage);
- B. select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));
- C. select metadata$filename from @bronzestage;
- D. list @bronzestage;
正解：A
解説：
Explanation
According to the Snowflake documentation , a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve the Snowflake-hosted file URL to each file in the stage. A file URL has the following format:
https://<account_identifier>/api/files/<db_name>.<schema_name>.<stage_name>/<relative_path> Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage is B. select * from directory(@bronzestage);
質問 # 436
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
- A. Enterprise
- B. Standard
- C. Business Critical
- D. Virtual Private Snowflake (VPS)
正解：D
質問 # 437
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
- A. User Stage
- B. Table Stage
- C. Schema Stage
- D. Internal Named Stage
- E. Database Stage
- F. External Named Stage
正解：A、B、D
解説：
The Snowflake PUT command is used to upload files from a local file system to Snowflake stages, specifically the user stage, table stage, and internal named stage. These stages are where the data files are temporarily stored before being loaded into Snowflake tables
質問 # 438
Which type of Snowflake virtual warehouse provides 16 times the memory for each node and is recommended for larger workloads like Machine Learning (ML) training?
- A. A multi-cluster warehouse
- B. A Snowpark-optimized warehouse
- C. A size 6XL warehouse
- D. A standard warehouse
正解：B
解説：
The Snowpark-optimized warehouse is designed with significantly higher memory per node, making it ideal for machine learning (ML) training and other memory-intensive workloads. Snowpark-optimized warehouses provide the necessary computational power and memory for complex, large-scale data processing tasks.
Standard and multi-cluster warehouses do not offer the same memory advantage, while the 6XL warehouse is large but not specifically optimized for memory-intensive operations.
質問 # 439
User-level network policies can be created by which of the following roles? (Select TWO).
- A. USERADMIN
- B. ROLEADMIN
- C. ACCOUNTADMIN
- D. SYSADMIN
- E. SECURITYADMIN
正解：A、E
質問 # 440
A stream can be created on which Snowflake objects to record data manipulation language(DML) changes?
(Select TWO).
- A. Standard tables
- B. Standard tables
- C. Standard views
- D. Pipes
- E. Schemas
- F. Database
正解：A、B
解説：
Snowflake streams are objects that enable users to track changes (inserts, updates, and deletes) to the data in tables, facilitating real-time data processing and integration workflows. Streams can be created on standard tables, capturing DML changes made to these tables so that downstream processes can consume the changes incrementally. This feature supports efficient data ETL, replication, and real-time analytics by providing a mechanism to process only the data that has changed. Note: The correct options should likely include a distinction between "Standard tables" and another object type such as "External tables" rather than repeating
"Standard tables" twice.
References: Snowflake Documentation on Streams
質問 # 441
What happens to foreign key constraints when a table is cloned to another database?
- A. The cloned table will reference the primary key in the source table
- B. The cloned table will lose all references to the primary key.
- C. The cloned table will lose all references to the foreign and primary keys.
- D. All referenced tables will be cloned.
正解：C
解説：
* When a table is cloned in Snowflake, it creates a duplicate of the table's data and metadata. However, foreign key constraints and primary key references are not retained in the cloned table.
* This behavior is because Snowflake treats constraints as informational and does not enforce them during query execution.
* As a result, the cloned table will lose all references to both foreign and primary keys.
Why Other Options Are Incorrect:
* A. All referenced tables will be cloned: Only the specific table is cloned, not its referenced tables.
* B. The cloned table will reference the primary key in the source table: References to primary keys are lost during cloning.
* C. The cloned table will lose all references to the primary key: While correct for primary keys, this does not account for foreign keys, making it incomplete.
References:
* Cloning Tables in Snowflake
質問 # 442
What type of account can be used to share data with a consumer who does have a Snowflake account?
- A. Organization
- B. Reader
- C. Data provider
- D. Data consumer
正解：B
質問 # 443
What type of function returns one value for each Invocation?
- A. Aggregate
- B. Table
- C. Scalar
- D. Window
正解：C
解説：
Scalar functions in Snowflake (and SQL in general) are designed to return a single value for each invocation.
They operate on a single value and return a single result, making them suitable for a wide range of data transformations and calculations within queries.
References:
* Snowflake Documentation: Functions
質問 # 444
......
正真正銘のベスト資料はCOF-C02オンライン練習試験：https://jp.fast2test.com/COF-C02-premium-file.html
練習できるCOF-C02にはFast2test画期的なあなたをSnowPro Core Certification Exam試験合格させます合格率：https://drive.google.com/open?id=1JDcL0v9z2nzRW9D0CbiyPGAahCHjibXh