COF-C03 시험 - Snowflake실제시험문제와 답 - 778문항

Question No : 1

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

A.Custom Edition
B.Virtual Private Snowflake
C.Business Critical Edition
D.Standard Edition
E.Enterprise Edition

정답:
Explanation:
To manage compliance with Personal Identifiable Information (PII) requirements, the Virtual Private Snowflake and Business Critical Editions of Snowflake should be used. These editions provide advanced security features necessary for handling sensitive data

Question No : 2

Which of the following is a data tokenization integration partner?

A.Protegrity
B.Tableau
C.DBeaver
D.SAP

정답:
Explanation:
Protegrity is listed as a data tokenization integration partner for Snowflake. This partnership allows Snowflake users to utilize Protegrity’s tokenization solutions within the Snowflake environment3.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

Question No : 3

The Snowflake Cloud Data Platform is described as having which of the following architectures?

A.Shared-disk
B.Shared-nothing
C.Multi-cluster shared data
D.Serverless query engine

정답:
Explanation:
Snowflake’s architecture is described as a multi-cluster, shared data architecture. This design combines the simplicity of a shared-disk architecture with the performance and scale-out benefits of a shared-nothing architecture, using a central repository accessible from all compute nodes2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

Question No : 4

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A.INSERT
B.PUT
C.GET
D.COPY

정답:
Explanation:
The COPY command is used in Snowflake to load data from files located in an external stage into a table. This command allows for efficient and parallelized data loading from various file formats1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

Question No : 5

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

A.Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
B.The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
C.SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
D.A user cannot specify a default warehouse when using the ODBC driver.
E.The default virtual warehouse size can be changed at any time.

정답:
Explanation:
Snowflake virtual warehouses support a configuration file and command line options in SnowSQL to specify a default warehouse, which is characteristic
C. Additionally, the size of a virtual warehouse can be changed at any time, which is characteristic
E. These features provide flexibility and ease of use in managing compute resources2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

Question No : 6

What type of query benefits the MOST from search optimization?

A.A query that uses only disjunction (i.e., OR) predicates
B.A query that includes analytical expressions
C.A query that uses equality predicates or predicates that use IN
D.A query that filters on semi-structured data types

정답:
Explanation:
Search optimization in Snowflake is designed to improve the performance of queries that are selective and involve point lookup operations using equality and IN predicates. It is particularly beneficial for queries that access columns with a high number of distinct values1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

Question No : 7

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A.30 days
B.7 days
C.48 hours
D.24 hours

정답:
Explanation:
For a temporary table, the maximum total Continuous Data Protection (CDP) charges incurred are for the duration of the session in which the table was created, which does not exceed 24 hours2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation2

Question No : 8

Which of the following describes the Snowflake Cloud Services layer?

A.Coordinates activities in the Snowflake account
B.Executes queries submitted by the Snowflake account users
C.Manages quotas on the Snowflake account storage
D.Manages the virtual warehouse cache to speed up queries

정답:
Explanation:
The Snowflake Cloud Services layer is a collection of services that coordinate activities across Snowflake, tying together all the different components to process user requests, from login to query dispatch1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1

Question No : 9

When cloning a database, what is cloned with the database? (Choose two.)

A.Privileges on the database
B.Existing child objects within the database
C.Future child objects within the database
D.Privileges on the schemas within the database
E.Only schemas and tables within the database

정답:
Explanation:
When cloning a database in Snowflake, the clone includes all privileges on the database as well as existing child objects within the database, such as schemas, tables, views, etc. However, it does not include future child objects or privileges on schemas within the database2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

Question No : 10

What is the minimum Snowflake edition that has column-level security enabled?

A.Standard
B.Enterprise
C.Business Critical
D.Virtual Private Snowflake

정답:
Explanation:
Column-level security, which allows for the application of masking policies to columns in tables or views, is available starting from the Enterprise edition of Snowflake1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1

Question No : 11

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

A.Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
B.Scaling out adds clusters of varying sizes to a virtual warehouse.
C.Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
D.Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
E.Scaling up resizes a virtual warehouse so it can handle more complex workloads.
F.Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

정답:
Explanation:
Scaling out in Snowflake involves adding clusters of the same size to a virtual warehouse, which allows for handling more concurrent queries without affecting the performance of individual queries. Scaling up refers to resizing a virtual warehouse to increase its compute resources, enabling it to handle more complex workloads and larger queries more efficiently.

Question No : 12

Which of the following are best practices for loading data into Snowflake? (Choose three.)

A.Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
B.Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
C.Enclose fields that contain delimiter characters in single or double quotes.
D.Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
E.When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
F.Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

정답:
Explanation:
Best practices for loading data into Snowflake include aiming for data file sizes between 100 MB and 250 MB when compressed, as this size is optimal for parallel processing and minimizes overhead. Enclosing fields with delimiter characters in quotes ensures proper field recognition during the load process. Splitting large files into smaller ones allows for better distribution of the load across compute resources, enhancing performance and efficiency.

Question No : 13

True or False: Snowpipe via REST API can only reference External Stages as source.

A.True
B.False

정답:
Explanation:
Snowpipe via REST API can reference both named internal stages within Snowflake and external stages, such as Amazon S3, Google Cloud Storage, or Microsoft Azure1. This means that Snowpipe is not limited to only external stages as a source for data loading.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Question No : 14

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

A.The Pipe load history is reset to empty.
B.The REFRESH command is executed.
C.The stage will be purged.
D.The destination table is truncated.

정답:
Explanation:
When a pipe is recreated using the CREATE OR REPLACE PIPE command, the load history of the pipe is reset. This means that Snowpipe will consider all files in the stage as new and will attempt to load them, even if they were loaded previously by the old pipe2.

Question No : 15

Which command sets the Virtual Warehouse for a session?

A.COPY WAREHOUSE FROM <<config file>>;
B.SET WAREHOUSE = <<warehouse name>>;
C.USE WAREHOUSE <<warehouse name>>;
D.USE VIRTUAL_WAREHOUSE <<warehouse name>>;

정답:
Explanation:
The command USE WAREHOUSE <<warehouse name>>; is used to set the virtual warehouse for the current session in Snowflake. This command specifies which virtual warehouse to use for executing queries in that session1.
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

Snowflake COF-C03 시험