DUMPS
BASE
EXAM DUMPS
SNOWFLAKE
COF-C02
28% OFF Automatically For You
SnowPro Core Certification Exam (February 2024) Snowflake COF-C02 Dumps V13.03 - Pass Your Exam with Confidence 1.The fail-safe retention period is how many days?
A. 1 day
B. 7 days
C. 45 days
D. 90 days
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
2.True or False: A 4X-Large Warehouse may, at times, take longer to provision than a
X-Small Warehouse.
A. True
B. False
Answer: A
Explanation:
You can experiment the same with snowflake UI.
3.How would you determine the size of the virtual warehouse used for a task?
A. Root task may be executed concurrently (i.e. multiple instances), it is
recommended to leave some margins in the execution window to avoid missing
instances of execution
B. Querying (select) the size of the stream content would help determine the
warehouse size. For example, if querying large stream content, use a larger
warehouse size
C. If using the stored procedure to execute multiple SQL statements, it's best to test
run the stored procedure separately to size the compute resource first
D. Since task infrastructure is based on running the task body on schedule, it's
recommended to configure the virtual warehouse for automatic concurrency handling
using Multi-cluster warehouse (MCW) to match the task schedule
Answer: D
4.The Information Schema and Account Usage Share provide storage information for
which of the following objects? (Choose three.)
A. Users
B. Tables
C. Databases
D. Internal Stages
Answer: BCD (February 2024) Snowflake COF-C02 Dumps V13.03 - Pass Your Exam with Confidence 5.What is the default File Format used in the COPY command if one is not specified?
A. CSV
B. JSON
C. Parquet
D. XML
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
6.True or False: Reader Accounts are able to extract data from shared data objects
for use outside of Snowflake.
A. True
B. False
Answer: B
7.True or False: Loading data into Snowflake requires that source data files be no
larger than 16MB.
A. True
B. False
Answer: B
Explanation:
By default, COPY INTO location statements separate table data into a set of output
files to take advantage of parallel operations. The maximum size for each file is set
using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but
can be increased to accommodate larger files. The maximum file size supported is 5
GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data
to a single output file (at the potential cost of decreased performance), specify the
SINGLE = true copy option in your statement. You can optionally specify a name for
the file in the path.
8.True or False: A Virtual Warehouse can be resized while suspended.
A. True
B. False
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-
of-resizing-a-suspended-warehouse
9.True or False: When you create a custom role, it is a best practice to immediately
BASE
EXAM DUMPS
SNOWFLAKE
COF-C02
28% OFF Automatically For You
SnowPro Core Certification Exam (February 2024) Snowflake COF-C02 Dumps V13.03 - Pass Your Exam with Confidence 1.The fail-safe retention period is how many days?
A. 1 day
B. 7 days
C. 45 days
D. 90 days
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
2.True or False: A 4X-Large Warehouse may, at times, take longer to provision than a
X-Small Warehouse.
A. True
B. False
Answer: A
Explanation:
You can experiment the same with snowflake UI.
3.How would you determine the size of the virtual warehouse used for a task?
A. Root task may be executed concurrently (i.e. multiple instances), it is
recommended to leave some margins in the execution window to avoid missing
instances of execution
B. Querying (select) the size of the stream content would help determine the
warehouse size. For example, if querying large stream content, use a larger
warehouse size
C. If using the stored procedure to execute multiple SQL statements, it's best to test
run the stored procedure separately to size the compute resource first
D. Since task infrastructure is based on running the task body on schedule, it's
recommended to configure the virtual warehouse for automatic concurrency handling
using Multi-cluster warehouse (MCW) to match the task schedule
Answer: D
4.The Information Schema and Account Usage Share provide storage information for
which of the following objects? (Choose three.)
A. Users
B. Tables
C. Databases
D. Internal Stages
Answer: BCD (February 2024) Snowflake COF-C02 Dumps V13.03 - Pass Your Exam with Confidence 5.What is the default File Format used in the COPY command if one is not specified?
A. CSV
B. JSON
C. Parquet
D. XML
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
6.True or False: Reader Accounts are able to extract data from shared data objects
for use outside of Snowflake.
A. True
B. False
Answer: B
7.True or False: Loading data into Snowflake requires that source data files be no
larger than 16MB.
A. True
B. False
Answer: B
Explanation:
By default, COPY INTO location statements separate table data into a set of output
files to take advantage of parallel operations. The maximum size for each file is set
using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but
can be increased to accommodate larger files. The maximum file size supported is 5
GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data
to a single output file (at the potential cost of decreased performance), specify the
SINGLE = true copy option in your statement. You can optionally specify a name for
the file in the path.
8.True or False: A Virtual Warehouse can be resized while suspended.
A. True
B. False
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-
of-resizing-a-suspended-warehouse
9.True or False: When you create a custom role, it is a best practice to immediately
