リアルCOF-C02試験PDFテストエンジン 練習テスト問題
Snowflake COF-C02リアル2023年最新のブレーン問題集で模擬試験問題集
質問 39
Which of the following can be used when unloading data from Snowflake? (Choose two.)
- A. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
- B. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
- C. Use the ENCODING file format option to change the encoding from the default UTF-8.
- D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
- E. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
正解: D,E
質問 40
When cloning a database, what is cloned with the database? (Choose two.)
- A. Privileges on the schemas within the database
- B. Future child objects within the database
- C. Existing child objects within the database
- D. Only schemas and tables within the database
- E. Privileges on the database
正解: C,D
質問 41
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers
- A. Temporary Tables
- B. Provisional Tables
- C. Permanent Tables
- D. Transient Tables
正解: A,D
質問 42
What feature can be used to reorganize a very large table on one or more columns?
- A. Key partitions
- B. Clustering keys
- C. Clustered partitions
- D. Micro-partitions
正解: B
解説:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
質問 43
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
- A. When the system has enough load for 6 minutes
- B. When the system has enough load for 10 minutes
- C. When the system has enough load for 8 minutes
- D. When the system has enough load for 2 minutes
正解: B
質問 44
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
- A. Transient table
- B. Clustered table
- C. Materialized view
- D. Secure view
- E. Sequence
正解: A,B
質問 45
What is the minimum Snowflake edition required to create a materialized view?
- A. Business Critical Edition
- B. Enterprise Edition
- C. Standard Edition
- D. Virtual Private Snowflake Edition
正解: B
解説:
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.
質問 46
True or False: A Virtual Warehouse can be resized while suspended.
- A. False
- B. True
正解: B
質問 47
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
- A. The warehouse size does not change until all queries currently in the warehouse queue have completed.
- B. It does not return from the command until the warehouse has finished changing its size.
- C. The warehouse size does not change until the warehouse is suspended and restarted.
- D. The warehouse size does not change until all queries currently running in the warehouse have completed.
正解: B
質問 48
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
- A. Fail-safe
- B. Incremental backups
- C. Time Travel
- D. Internal stages
- E. Zero-copy clones
正解: A,C
解説:
Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.
Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.
Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.
https://docs.snowflake.com/en/user-guide/data-availability.html
質問 49
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A. Bulk copy from an Internal Stage
- B. The Snowflake Web Interface (UT) data loading wizard
- C. Continuous load using Snowpipe REST API
- D. Bulk copy from an External Stage
正解: B,C,D
質問 50
Which cache type is used to cache data output from SQL queries?
- A. Local file cache
- B. Remote cache
- C. Result cache
- D. Metadata cache
正解: C
解説:
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
質問 51
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
- A. Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days. - B. Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days. - C. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days. - D. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - E. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - F. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day.
正解: E
質問 52
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
- A. Create a private Data Exchange so that any teammate can use the worksheet
- B. Share the worksheet with teammates within Snowsight
- C. Create a database and grant all permissions to teammates
- D. Create a zero-copy clone of the worksheet and grant permissions to teammates
正解: B
質問 53
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
- A. Create a task that runs a copy into operation from an external stage every 5 minutes
- B. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
- C. Create a task that runs a GET operation to intermittently check for new files
- D. Create a task that puts the files in an internal stage and automate the data loading wizard
正解: B
解説:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
質問 54
Which formats are supported for unloading data from Snowflake? Choose 2 answers
- A. JSON
- B. Delimited (CSV, TSV, etc.)
- C. Avro
- D. ORC
正解: A,B
質問 55
Which Snowflake tool would be BEST to troubleshoot network connectivity?
- A. SnowSQL
- B. SnowCD
- C. SnowCLI
- D. SnowUI
正解: B
解説:
https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.
質問 56
Which cache type is used to cache data output from SQL queries?
- A. Local file cache
- B. Remote cache
- C. Result cache
- D. Metadata cache
正解: C
質問 57
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
- A. Google Cloud Platform
- B. Amazon Web Services
- C. Oracle Cloud
- D. Docker
- E. IBM Cloud
- F. Microsoft Azure Cloud
正解: A,D,F
質問 58
Which of the following objects can be shared through secure data sharing?
- A. Task
- B. External table
- C. Stored procedure
- D. Masking policy
正解: B
解説:
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
Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables
質問 59
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
- A. Stored Procedures
- B. Tables
- C. Roles
- D. Secure Views
- E. Secure User-Defined Functions (UDFs)
- F. Schemas
正解: C,E,F
質問 60
......
最速準備で試験合格！COF-C02問題の事前予備：https://jp.fast2test.com/COF-C02-premium-file.html
リリースSnowflake COF-C02更新された問題PDF：https://drive.google.com/open?id=1cPSc9y_x1xDo7lNUz8NXvHifDVDWSuxl