有効なCOF-C02テスト解答Snowflake COF-C02試験PDF問題を試そう
Snowflake COF-C02認定リアル2025年最新の模擬試験合格させます
質問 # 159
Which function should be used to find the query ID of the second query executed in a current session?
- A. Select LAST_QUERY_ID-2)
- B. Select LAST_QUERY_ID{1)
- C. Select LAST_QUERY_ID{2)
- D. Select LAST_QUERY_ID{2)
正解：B
質問 # 160
Which SQL command can be used to see the CREATE definition of a masking policy?
- A. LIST MASKING POLICIES
- B. DESCRIBE MASKING POLICY
- C. SHOW MASKING POLICIES
- D. GET_DDL
正解：D
質問 # 161
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.
質問 # 162
Which statement describes Snowflake tables?
- A. Snowflake tables are the physical instantiation of data loaded into Snowflake.
- B. Snowflake tables arc logical representation of underlying physical data.
- C. Snowflake tables are owned by a use.
- D. Snowflake tables require that clustering keys be defined lo perform optimally.
正解：B
質問 # 163
What does Snowflake recommend regarding database object ownership? (Select TWO).
- A. Create objects with SYSADMIN.
- B. Create objects with ACCOUNTADMIN and do not reassign ownership.
- C. Create objects with a custom role and grant this role to SYSADMIN.
- D. Create objects with SECURITYADMIN to ease granting of privileges later.
- E. Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.
正解：A、C
質問 # 164
What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
- A. It removes object or array elements containing null values.
- B. It removes null values from all columns in the data.
- C. It skips rows with null values during the loading process.
- D. It converts null values to empty strings during loading.
正解：A
解説：
The STRIP NULL_VALUES file format option, when set to TRUE, removes object or array elements that contain null values during the loading process of semi-structured data files into Snowflake. This ensures that the data loaded into Snowflake tables does not contain these null elements, which can be useful when the "null" values in files indicate missing values and have no other special meaning2.
質問 # 165
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
- A. Stage definition
- B. Table definition
- C. Session level
- D. COPY INTO TABLE statement
正解：D
質問 # 166
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
- A. 0
- B. 1
- C. 2
- D. 3
正解：A
解説：
For the ALLOWED VALUES tag property, the maximum number of possible string values for a single tag is
256. This allows for a wide range of values to be assigned to a tag when it is set on an object
質問 # 167
When an object is created in Snowflake. who owns the object?
- A. The current active primary role
- B. The public role
- C. The user's default role
- D. The owner of the parent schema
正解：A
解説：
In Snowflake, when an object is created, it is owned by the role that is currently active. This active role is the one that is being used to execute the creation command. Ownership implies full control over the object, including the ability to grant and revoke access privileges. This is specified in Snowflake's documentation under the topic of Access Control, which states that "the role in use at the time of object creation becomes the owner of the object." Reference:
Snowflake Documentation: Object Ownership
質問 # 168
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
- A. The schema owner
- B. The database owner
- C. The object owner
- D. The Snowflake user's role
正解：A
解説：
In a managed access schema, the schema owner retains the OWNERSHIP privilege of any tables added to the schema. This means that while object owners have certain privileges over the objects they create, only the schema owner can manage privilege grants on these objects1.
質問 # 169
Which formats does Snowflake store unstructured data in? (Choose two.)
- A. BLOB
- B. GeoJSON
- C. Object
- D. XML
- E. Array
正解：B、D
解説：
Snowflake supports storing unstructured data and provides native support for semi-structured file formats such as JSON, Avro, Parquet, ORC, and XML1. GeoJSON, being a type of JSON, and XML are among the formats that can be stored in Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide
質問 # 170
Which commands are restricted in owner's rights stored procedures? (Select TWO).
- A. DESCRIBE
- B. MERGE
- C. SHOW
- D. DELETE
- E. INSERT
正解：A、C
解説：
In owner's rights stored procedures, certain commands are restricted to maintain security and integrity. The SHOW and DESCRIBE commands are limited because they can reveal metadata and structure information that may not be intended for all roles.
質問 # 171
Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
- A. REMOVE
- B. TRUNCATE
- C. DELETE
- D. DROP
正解：A
解説：
The REMOVE command is used in Snowflake to delete files from a stage after they have been successfully ingested into Snowflake tables. This command helps manage storage by allowing users to clean up staged files that are no longer needed, ensuring that the stage does not accumulate unnecessary data over time. Unlike DELETE, DROP, or TRUNCATE commands, which are used for managing data within Snowflake tables or dropping objects, REMOVE specifically targets the management of files in stages.References: Snowflake Documentation on Stages and File Management
質問 # 172
Which TABLE function helps to convert semi-structured data to a relational representation?
- A. CHECK_JSON
- B. FLATTEN
- C. PARSE_JSON
- D. TO_JSON
正解：C
質問 # 173
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
- A. Metadata Management
- B. Cloud Services
- C. Database Storage
- D. Query Processing
正解：C
質問 # 174
What are the benefits of the replication feature in Snowflake? (Select TWO).
- A. Time Travel
- B. Database failover and fallback
- C. Data security
- D. Disaster recovery
- E. Fail-safe
正解：B、D
解説：
The replication feature in Snowflake provides several benefits, with disaster recovery and database failover and fallback being two of the primary advantages. Replication allows for the continuous copying of data from one Snowflake account to another, ensuring that a secondary copy of the data is available in case of outages or disasters. This capability supports disaster recovery strategies by allowing operations to quickly switch to the replicated data in a different account or region. Additionally, it facilitates database failover and fallback procedures, ensuring business continuity and minimizing downtime.
Reference:
Snowflake Documentation: Data Replication
質問 # 175
......
COF-C02試験問題と有効なCOF-C02問題集PDF：https://www.passtest.jp/Snowflake/COF-C02-shiken.html
COF-C02ブレーン問題集学習ガイドにはヒントとコツで試験合格を目指そう：https://drive.google.com/open?id=19YYtaWp5wOzPpV9YApXkMmNrASXTqea5