[2026年03月23日] 心強いCOF-C02のPDF問題集はCOF-C02問題
正真正銘のCOF-C02問題集で無料PDF問題で合格させる
質問 # 449
Which privilege is required to use the search optimization service in Snowflake?
- A. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
- B. GRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
- C. GRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>
- D. GRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE <role>
正解：A
解説：
To utilize the search optimization service in Snowflake, the correct syntax for granting privileges to a role involves specific commands that include adding search optimization capabilities:
Option C: GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>.
This command grants the specified role the ability to implement search optimization at the schema level, which is essential for enhancing search capabilities within that schema.
Options A and B do not include the correct verb "ADD," which is necessary for this specific type of grant command in Snowflake. Option D incorrectly mentions the database level, as search optimization privileges are typically configured at the schema level, not the database level.
References:Snowflake documentation on the use of GRANT statements for configuring search optimization.
質問 # 450
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
- A. WRTTF
- B. USAGK
- C. OWNERSHIP
- D. READ
正解：B
質問 # 451
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
- A. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - B. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day. - C. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - D. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days. - E. Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days. - F. Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days.
正解：A
質問 # 452
What Snowflake role must be granted for a user to create and manage accounts?
- A. SECURITYADMIN
- B. ACCOUNTADMIN
- C. ORGADMIN
- D. SYSADMIN
正解：B
質問 # 453
Which of the following describes a Snowflake stored procedure?
- A. They can be created as secure and hide the underlying metadata from the user.
- B. They can only access tables from a single database.
- C. They can contain only a single SQL statement.
- D. They can be created to run with a caller's rights or an owner's rights.
正解：A
解説：
Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html
質問 # 454
True or False: A Virtual Warehouse can be resized while suspended.
- A. False
- B. True
正解：B
解説：
Virtual Warehouses in Snowflake can indeed be resized while they are suspended. Resizing a warehouse involves changing the number of compute resources (servers) allocated to it, which can be done to adjust performance and cost. When a warehouse is suspended, it is not currently running any queries, but its definition and metadata remain intact, allowing for modifications like resizing.
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse
質問 # 455
Which Snowflake tool would be BEST to troubleshoot network connectivity?
- A. SnowSQL
- B. SnowUI
- C. SnowCD
- D. SnowCLI
正解：C
解説：
SnowCD (Snowflake Connectivity Diagnostic Tool) is the best tool provided by Snowflake for troubleshooting network connectivity issues. It helps diagnose and resolve issues related to connecting to Snowflake services
https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%
20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.
質問 # 456
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- B. validation_mode=return_all_errors is a parameter of the copy command
- C. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- D. The validation_mode option is used when creating an Internal Stage
正解：B、C
質問 # 457
When creating a custom role that will be allowed to create warehouses and databases, which system-defined role does Snowflake recommend also be assigned to the custom role?
- A. USERADMIN
- B. SYSADMIN
- C. SECURITYADMIN
- D. ACCOUNTADMIN
正解：B
質問 # 458
Which security feature is available in all Snowflake editions?
- A. Object-level access control
- B. Object tagging
- C. Customer-managed encryption keys
- D. Data masking policies
正解：A
解説：
* Object-level access control is available in all Snowflake editions.
* This feature allows administrators to grant and revoke permissions on specific objects (e.g., tables, schemas, databases) to control access at a granular level.
* Other features like data masking policies and customer-managed encryption keys are available only in higher Snowflake editions.
References:
* Snowflake Documentation: Object-Level Access Control
* Snowflake Editions Comparison
質問 # 459
Which statement describes how Snowflake supports reader accounts?
- A. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
- B. A reader account can consume data from the provider account that created it and combine it with its own data.
- C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
- D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
正解：C
質問 # 460
Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
- A. ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
- B. ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
- C. ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';
- D. ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
正解：C
解説：
To use key pair authentication in Snowflake, you need to set the public key for the user. This allows the user to authenticate using their private key.
Generate Key Pair: Generate a public and private key pair.
Set Public Key:
ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';
Authentication: The user can now authenticate by signing requests with the corresponding private key.
Reference:
Snowflake Documentation: Key Pair Authentication & Key Rotation
Snowflake Documentation: ALTER USER
質問 # 461
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The queries currently being run by the Virtual Warehouse
- B. The primary duster in the virtual warehouse
- C. The database the Virtual Warehouse resides in
- D. The entire Virtual Warehouse
正解：D
質問 # 462
Which statement accurately describes Snowflake's architecture?
- A. It reorganizes loaded data into internal optimized, compressed, and row-based format.
- B. It is a hybrid of traditional shared-disk and shared-nothing database architectures.
- C. It is a blend of shared-disk and shared-everything database architectures.
- D. It uses a local data repository for all compute nodes in the platform.
正解：B
解説：
Snowflake's architecture is unique in that it combines elements of both traditional shared-disk and shared-nothing database architectures. This hybrid approach allows Snowflake to offer the scalability and performance benefits of a shared-nothing architecture (with compute and storage separated) while maintaining the simplicity and flexibility of a shared-disk architecture in managing data across all nodes in the system.
This results in an architecture that provides on-demand scalability, both vertically and horizontally, without sacrificing performance or data cohesion.
References:
* Snowflake Documentation: Snowflake Architecture
質問 # 463
The Snowflake Search Optimization Services supports improved performance of which kind of query?
- A. Queries against tables larger than 1 TB
- B. Selective point lookup queries
- C. Queries against large tables where frequent DML occurs
- D. Queries against a subset of columns in a table
正解：B
解説：
The Snowflake Search Optimization Service is designed to support improved performance for selective point lookup queries. These are queries that retrieve specific records from a database, often based on a unique identifier or a small set of criteria3.
質問 # 464
What is the outcome of querying a VARIANT column using an invalid path?
- A. An empty siring
- B. NULL
- C. Undefined data
- D. An invalid identifier error
正解：D
質問 # 465
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
- A. How often the materialized view is queried
- B. Whether the materialized view has a cluster key defined
- C. How often the base table changes
- D. How often the underlying base table is queried
- E. Whether or not it is also a secure view
正解：B、C
解説：
The credit consumption for maintaining a materialized view is impacted by how often the base table changes
© and whether the materialized view has a cluster key defined (D). Changes to the base table can trigger a refresh of the materialized view, consuming credits. Additionally, having a cluster key defined can optimize the performance and credit usage during the materialized view's maintenance. References: SnowPro Core Certification materialized viewcredit consumption
質問 # 466
Which user preferences can be set for a user profile in Snowsight? (Select TWO).
- A. Multi-Factor Authentication (MFA)
- B. Username
- C. Default schema
- D. Default database
- E. Notification
正解：C、D
解説：
In Snowsight, Snowflake's web interface, user preferences can be customized to enhance the user experience.
Among these preferences, users can set a default database and default schema. These settings streamline the user experience by automatically selecting the specified database and schema when the user initiates a new session or query, reducing the need to manually specify these parameters for each operation. This feature is particularly useful for users who frequently work within a specific database or schema context.References:Snowflake Documentation on Snowsight User Preferences
質問 # 467
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
- A. The number of queries executed
- B. The duration of the queries that are executed
- C. The length of time the warehouse is running
- D. The size of the virtual warehouse
- E. The number of active users assigned to the warehouse
正解：C、D
解説：
Credit charges for Snowflake virtual warehouses are calculated based on the size of the virtual warehouse and the length of time the warehouse is running. The size determines the compute resources available, and charges are incurred for the time these resources are utilized
質問 # 468
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
- A. Pie chart
- B. Heat grid
- C. Area chart
- D. Box plot
正解：C
解説：
Snowsight, Snowflake's user interface for exploring, analyzing, and visualizing data, supports a variety of chart types for creating dashboards and visualizations. One of the supported chart types in Snowsight is the Area Chart (A). Area charts are useful for representing quantities over time and can be used to highlight volume change and rate of change, as well as to compare multiple quantities.
While Snowsight supports many types of visualizations to help users analyze their data effectively, including line charts, bar charts, and scatter plots, it's important to select the specific reference documentation or release notes for the most current list of supported chart types, as Snowflake continues to enhance and update Snowsight's capabilities.
As of the last update, Box plots (B), Heat grids (C), and Pie charts (D) are types of visualizations that may be supported in various analytics and visualization tools, but for the specific context of Snowsight's currently confirmed features, Area charts are a verified option for users to visualize their data.
質問 # 469
This query was executed:
Assuming the weather_events table has not changed, which query would benefit from cached results?
- A. SELECT DISTINCT(severity) FROM weather_events ; if run within 24 hours after the initial query execution
- B. select distinct (severity) from weather_events; if run within 24 hours after the initial query execution
- C. select distinct(severity) from weather_events; if run within 48 hours after the initial query execution
- D. SELECT DISTINCT(severity) FROM weather_events we; if run within 24 hours after the initial query execution
正解：C
質問 # 470
What are characteristic of Snowsight worksheet? (Select TWO.)
- A. Each worksheet is a unique Snowflake session.
- B. Users can import worksheets and share them with other users.
- C. The Snowflake session ends when a user switches worksheets.
- D. Users are limited to running only one on a worksheet.
- E. Worksheets can be grouped under folder, and a folder of folders.
正解：B、E
解説：
Characteristics of Snowsight worksheets in Snowflake include:
A). Worksheets can be grouped under folders, and a folder of folders: This organizational feature allows users to efficiently manage and categorize their worksheets within Snowsight, Snowflake's web-based UI, enhancing the user experience by keeping related worksheets together.
E). Users can import worksheets and share them with other users: Snowsight supports the sharing of worksheets among users, fostering collaboration by allowing users to share queries, analyses, and findings.
This feature is crucial for collaborative data exploration and analysis workflows.
References:
Snowflake Documentation: Snowsight (UI for Snowflake)
質問 # 471
Which activities are included in the Cloud Sen/ices layer? (Select TWO).
- A. User authentication
- B. Infrastructure management
- C. Partition scanning
- D. Dynamic data masking
- E. Data storage
正解：A、B
解説：
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
質問 # 472
Who can create network policies within Snowflake? (Select TWO).
- A. A role with the CREATE SECURITY INTEGRATION privilege
- B. SECURITYADMIN or higher roles
- C. A role with the CREATE NETWORK POLICY privilege
- D. ORCADMIN only
- E. SYSADMIN only
正解：B、C
質問 # 473
When connecting to Snowflake using SnowSQL, what are ways to explicitly specify the password? (Select TWO).
- A. Use an OAuth token
- B. Use public and private key pair authentication
- C. Enter through an interactive prompt
- D. Specify using SNOWSQL_PWD environment variables
- E. Run a web-based authorization flow
正解：C、D
質問 # 474
......
結果を保証するには最新2026年03月無料：https://jp.fast2test.com/COF-C02-premium-file.html
有効な問題最新版を無料で試そうCOF-C02試験問題集解答：https://drive.google.com/open?id=1JDcL0v9z2nzRW9D0CbiyPGAahCHjibXh