COF-R02 시험 - Snowflake실제시험문제와 답 - 330문항

Question No : 1

Will data cached in a warehouse be lost when the warehouse is resized?

A.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
B.Yes. because the compute resource is replaced in its entirety with a new compute resource.
C.No. because the size of the cache is independent from the warehouse size
D.Yes. became the new compute resource will no longer have access to the cache encryption key

정답:

Question No : 2

What can be used to view warehouse usage over time? (Select Two).

A.The load HISTORY view
B.The Query history view
C.The show warehouses command
D.The WAREHOUSE_METERING__HISTORY View
E.The billing and usage tab in the Snowflake web Ul

정답:

Question No : 3

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 : 4

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

A.The user has the appropriate privileges on the objects associated with the query
B.Micro-partitions have been reclustered since the query was last run
C.The new query is run using the same virtual warehouse as the previous query
D.The query includes a User Defined Function (UDF)
E.The query has been run within 24 hours of the previously-run query

정답:

Question No : 5

Which of the following are benefits of micro-partitioning? (Select TWO)

A.Micro-partitions cannot overlap in their range of values
B.Micro-partitions are immutable objects that support the use of Time Travel.
C.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
D.Rows are automatically stored in sorted order within micro-partitions
E.Micro-partitions can be defined on a schema-by-schema basis

정답:
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

Question No : 6

What are the default Time Travel and Fail-safe retention periods for transient tables?

A.Time Travel - 1 day. Fail-safe - 1 day
B.Time Travel - 0 days. Fail-safe - 1 day
C.Time Travel - 1 day. Fail-safe - 0 days
D.Transient tables are retained in neither Fail-safe nor Time Travel

정답:
Explanation:
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manage&text=Temporary%20tables%20can%20also%20have,have%20no %20Fail%2Dsafe%20period.

Question No : 7

Which Snowflake technique can be used to improve the performance of a query?

A.Clustering
B.Indexing
C.Fragmenting
D.Using INDEX__HINTS

정답:
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Question No : 8

Which statement about billing applies to Snowflake credits?

A.Credits are billed per-minute with a 60-minute minimum
B.Credits are used to pay for cloud data storage usage
C.Credits are consumed based on the number of credits billed for each hour that a warehouse runs
D.Credits are consumed based on the warehouse size and the time the warehouse is running

정답:
Explanation:
Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used. https://docs.snowflake.com/en/user-guide/what-are-credits.html

Question No : 9

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A.An FTP server with TLS encryption
B.An HTTPS server with WebDAV
C.A Google Cloud storage bucket
D.A Windows server file share on Azure

정답:

Question No : 10

Which feature is only available in the Enterprise or higher editions of Snowflake?

A.Column-level security
B.SOC 2 type II certification
C.Multi-factor Authentication (MFA)
D.Object-level access control

정답:
Explanation:
https://docs.snowflake.com/en/user-guide/intro-editions.html

Question No : 11

In which use cases does Snowflake apply egress charges?

A.Data sharing within a specific region
B.Query result retrieval
C.Database replication
D.Loading data into Snowflake

정답:
Explanation:
Cloud providers apply data egress charges in either of the following use cases:
✑ Data is transferred from one region to another within the same cloud platform.
✑ Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20data%20egress,out%20of%20the% 20cloud%20platform.

Question No : 12

What features does Snowflake Time Travel enable?

A.Querying data-related objects that were created within the past 365 days
B.Restoring data-related objects that have been deleted within the past 90 days
C.Conducting point-in-time analysis for Bl reporting
D.Analyzing data usage/manipulation over all periods of time

정답:
Explanation:
Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period.
It serves as a powerful tool for performing the following tasks:
✑ Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted.
✑ Duplicating and backing up data from key points in the past.
✑ Analyzing data usage/manipulation over specified periods of time. https://docs.snowflake.com/en/user-guide/data-time-travel.html

Question No : 13

True or False: A Virtual Warehouse can be resized while suspended.

A.True
B.False

정답:
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

Question No : 14

What is the default File Format used in the COPY command if one is not specified?

A.CSV
B.JSON
C.Parquet
D.XML

정답:
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

Question No : 15

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.Create a task that puts the files in an internal stage and automate the data loading wizard
C.Create a task that runs a GET operation to intermittently check for new files
D.Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

정답:
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

Snowflake COF-R02 시험