COF-C02 試験問題と解答 - 模擬練習 - 練習問題・模擬試験

Question No : 1
When is the result set cache no longer available? (Select TWO)

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

正解:

Question No : 2
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

A.Compute Credits = 50 Credits Cloud Services = 10
B.Compute Credits = 80 Credits Cloud Services = 5
C.Compute Credits = 10 Credits Cloud Services = 9
D.Compute Credits = 120 Credits Cloud Services = 10
E.Compute Credits = 200 Credits Cloud Services = 26

正解:

Question No : 3
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

A.True
B.False

正解:
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Question No : 4
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A.Custom
B.Economy
C.Optimized
D.Standard

正解:
Explanation:
Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

Question No : 5
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 a table owner has full control and can unset masking policies.
B.Yes, because masking policies only apply to cloned tables.
C.No, because masking policies must always reference specific access roles.
D.No, because ownership of a table does not include the ability to change masking policies

正解:

Question No : 6
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)

B)

C)

D)

A. Option A
B. Option B
C. Option C
D. Option D

正解: A

Question No : 7
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

A.4
B.8
C.16
D.32

正解:
Explanation:
Size specifies the amount of compute resources available per cluster in a warehouse.
Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Question No : 8
Which of the following items does the Cloud services Layer manage? Choose 4 answers

A.user authentication
B.Metadata
C.Query compilation and optimization
D.external blob storage
E.Data security

正解:

Question No : 9
When unloading to a stage, which of the following is a recommended practice or approach?

A.Set SINGLE: = true for larger files
B.Use OBJECT_CONSTRUCT ( * ) when using Parquet
C.Avoid the use of the CAST function
D.Define an individual file format

正解:

Question No : 10
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A.True
B.False

正解:
Explanation:
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

Question No : 11
What happens when a cloned table is replicated to a secondary database? (Select TWO)

A.A read-only copy of the cloned tables is stored.
B.The replication will not be successful.
C.The physical data is replicated
D.Additional costs for storage are charged to a secondary account
E.Metadata pointers to cloned tables are replicated

正解:
Explanation:
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data.
However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storag e%20usage%20for%20your%20account.

Question No : 12
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

A.Customers can change the size of the Warehouse after creation
B.A Warehouse can be resized while running
C.A Warehouse can be configured to suspend after a period of inactivity
D.A Warehouse can be configured to auto-resume when new queries are submitted

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

Question No : 13
Which of the following are common use cases for zero-copy cloning? Choose 3 answers

A.Quick provisioning of Dev and Test/QA environments
B.Data backups
C.Point in time snapshots
D.Performance optimization

正解:
Explanation:
Reference: https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning

Question No : 14
Select the three types of tables that exist within Snowflake. Choose 3 answers

A.Temporary
B.Transient
C.Provisioned
D.Permanent

正解:
Explanation:
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Question No : 15
Which services does the Snowflake Cloud Services layer manage? (Select TWO).

A.Compute resources
B.Query execution
C.Authentication
D.Data storage
E.Metadata

正解:
Explanation:
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
✑ Authentication
✑ Infrastructure management
✑ Metadata management
✑ Query parsing and optimization
✑ Access control

Snowflake COF-C02 問題練習