• ホーム
  • ブログ
  • [2023年06月] 検証済み Snowflake 試験問題集 COF-R02 試験学習ガイド [Q102-Q127]

[2023年06月] 検証済み Snowflake 試験問題集 COF-R02 試験学習ガイド [Q102-Q127]

Share

[2023年06月] 検証済みSnowflake試験問題集でCOF-R02試験学習ガイド

ベスト品質のSnowflake COF-R02試験解答リアル練習試験問題集で[2023]


SnowPro Core Recertification（Snowflake COF-R02）試験は、既にSnowPro Core Examを合格したSnowflakeユーザーがスキルを更新する必要がある認定試験です。この試験の目的は、Snowflakeユーザーが最新のSnowflakeの機能とベストプラクティスについて常に知っていることを保証することです。この試験は、Snowflakeテクノロジーで働くプロフェッショナルが業界で競争力を維持したい場合に必要不可欠です。


Snowflake COF-R02（SnowPro Core Recertification）試験は、以前にSnowPro Core認定を取得し、認定を更新する必要があるSnowflakeプロフェッショナル向けに設計されています。試験は、Snowflakeのコアコンセプトと機能の個人の知識と理解を評価することを意図しています。Snowflakeアーキテクチャ、セキュリティ、データロード、クエリ、パフォーマンスチューニングなど、幅広いトピックをカバーしています。試験は難しく、Snowflakeのコア機能と機能性について堅実な理解が必要です。

 

質問 # 102
How are serverless features billed?

  • A. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
  • B. Per second multiplied by an automatic sizing for the job
  • C. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
  • D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

正解：D


質問 # 103
Which of the following accurately describes shares?

  • A. Access to a share cannot be revoked once granted
  • B. Shares can be shared
  • C. Data consumers can clone a new table from a share
  • D. Tables, secure views, and secure UDFs can be shared

正解：D


質問 # 104
Which of the following terms best describes Snowflake's database architecture?

  • A. Cloud-native shared memory
  • B. Multi-cluster, shared data
  • C. Columnar shared nothing
  • D. Shared disk

正解：B

解説：
Explanation
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.


質問 # 105
Which of the following describes how clustering keys work in Snowflake?

  • A. Clustering keys sort the designated columns over time, without blocking DML operations
  • B. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
  • C. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
  • D. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

正解：A


質問 # 106
The Snowflake Search Optimization Services supports improved performance of which kind of query?

  • A. Selective point lookup queries
  • B. Queries against large tables where frequent DML occurs
  • C. Queries against a subset of columns in a table
  • D. Queries against tables larger than 1 TB

正解：A

解説：
Reference:
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimiza
%20point,OBJECT%2C%20and%20ARRAY%20columns)


質問 # 107
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

  • A. Object-level access control
  • B. Up to 90 days of data recovery through Time Travel
  • C. Customer-managed encryption keys through Tri-Secret Secure
  • D. Column-level security to apply data masking policies to tables and views
  • E. Automatic encryption of all data

正解：A、E

解説：
Explanation
https://docs.snowflake.com/en/user-guide/intro-editions.html


質問 # 108
When is the result set cache no longer available? (Select TWO)

  • A. When another warehouse is used to execute the query
  • B. When it has been 24 hours since the last query
  • C. When the warehouse used to execute the query is suspended
  • D. When another user executes the query
  • E. When the underlying data has changed

正解：B、E


質問 # 109
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

  • A. Yes, because masking policies only apply to cloned tables.
  • B. No, because masking policies must always reference specific access roles.
  • C. No, because ownership of a table does not include the ability to change masking policies
  • D. Yes, because a table owner has full control and can unset masking policies.

正解：D


質問 # 110
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

  • A. Tables
  • B. Materialized views
  • C. Sequences
  • D. Procedures
  • E. Secure User Defined Functions (UDFs)

正解：A、E

解説：
Explanation
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
* Tables
* External tables
* Secure views
* Secure materialized views
* Secure UDFs
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html


質問 # 111
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));

  • A. To validate external table files in table t1 across all sessions
  • B. To validate a file for errors before it gets executed using a COPY command
  • C. To return errors from the last executed COPY command into table t1 in the current session
  • D. To validate task SQL statements against table t1 in the last 14 days

正解：C


質問 # 112
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

  • A. VALIDATION_MODE
  • B. SKIP_BYTE_ORDER_MARK
  • C. STRIP_NULL_VALUES
  • D. REPLACE_INVALID_CHARACTERS

正解：A

解説：
Explanation
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_ _ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:


質問 # 113
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

  • A. False
  • B. True

正解：A

解説：
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html


質問 # 114
What is a responsibility of Snowflake's virtual warehouses?

  • A. Query parsing and optimization
  • B. Query execution
  • C. Permanent storage of micro-partitions
  • D. Infrastructure management
  • E. Metadata management

正解：B

解説：
Reference:
https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20re


質問 # 115
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

  • A. The transient table version cannot be retrieved after 24 hours.
  • B. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
  • C. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
  • D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

正解：A


質問 # 116
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

  • A. Set a default role for the user.
  • B. Force an immediate password change.
  • C. Set the user's access to expire within a specified timeframe.
  • D. Configure the user to be initially disabled.
  • E. Set the number of minutes to unlock to 15 minutes.

正解：C、D


質問 # 117
Select the different types of Internal Stages: (Choose three.)

  • A. Schema Stage
  • B. User Stage
  • C. Named Stage
  • D. Table Stage

正解：B、C、D

解説：
Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal- Named-Stage


質問 # 118
What impacts the credit consumption of maintaining a materialized view? (Choose two.)

  • A. Whether the materialized view has a cluster key defined
  • B. How often the base table changes
  • C. How often the underlying base table is queried
  • D. Whether or not it is also a secure view
  • E. How often the materialized view is queried

正解：A、E


質問 # 119
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

  • A. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
  • B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
  • C. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
  • D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

正解：A


質問 # 120
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?

  • A. Data encryption
  • B. Row access policies
  • C. Role based access control
  • D. Data masking policies

正解：D


質問 # 121
How often are encryption keys automatically rotated by Snowflake?

  • A. 30 Days
  • B. 365 Days
  • C. 60 Days
  • D. 90 Days

正解：A

解説：
Explanation
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old.
Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dman


質問 # 122
When can a Virtual Warehouse start running queries?

  • A. When its provisioning is complete
  • B. 12am-5am
  • C. After replication
  • D. Only during administrator defined time slots

正解：A

解説：
Explanation
https://docs.snowflake.com/en/user-guide/warehouses-overview.html


質問 # 123
Which of the following significantly improves the performance of selective point lookup queries on a table?

  • A. Materialized Views
  • B. Search Optimization Service
  • C. Clustering
  • D. Zero-copy Cloning

正解：C


質問 # 124
What file formats does Snowflake support for loading semi-structured data? (Choose three.)

  • A. PDF
  • B. JSON
  • C. Parquet
  • D. TSV
  • E. Avro
  • F. JPEG

正解：B、C、E


質問 # 125
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.

  • A. Better query scheduling
  • B. Higher storage costs
  • C. Double the numbers of servers In the compute duster
  • D. More micro-partitions

正解：C


質問 # 126
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

  • A. SELECT EVENT_TIMESTAMP, USER_NAME
    FROM table(information_schema.login_history_by_user())
  • B. SELECT EVENT_TIMESTAMP, USER_NAME
    FROM ACCOUNT_USAGE.LOGIN_HISTORY;
  • C. SELECT EVENT_TIMESTAMP, USER_NAME
    FROM ACCOUNT_USAGE.ACCESS_HISTORY;
  • D. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
    FROM ACCOUNT_USAGE.USERS;

正解：B


質問 # 127
......

正真正銘のベスト材料COF-R02：https://jp.fast2test.com/COF-R02-premium-file.html

COF-R02テストエンジン練習試験：https://drive.google.com/open?id=1jil_SbB-xPXYwijEpzUVg-KHc2lmXmk_

関するブログ

もっと
Snowflake認証 COF-R02試験問題集

弊社を連絡する

我々は１２時間以内ですべてのお問い合わせを答えます。

我々の働いている時間： ( GMT 0:00-15:00 )
月曜日から土曜日まで

サポート： 現在連絡 

English Deutsch 繁体中文 한국어

フレンドリーリンク

トップ試験