(2022) PASS COF-C01 exam with Snowflake COF-C01 Real Exam Questions [Q22-Q45] : Best Free Exam Guide : http://free.exams4sures.com

NO.22 Select the three types of tables that exist within Snowflake.
Choose 3 answers

Temporary

Transient

Provisioned

Permanent

NO.23 Which of the following statements are true of Snowflake data loading? Choose 3 answers

VARIANT “nut” values are not the same as SQL Null values

It is recommended to do frequent, single row DMLS

It is recommended to validate the data before loading into the Snowflake target table

It is recommended to use staging tables to manage MERGE statements

NO.24 Snowflake is designed for which type of workloads? (Choose two.)

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

NO.25 True or False: You can define multiple columns within a clustering key on a table.

True

False

NO.26 True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

True

False

NO.27 To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Configure the Maximum Clusters setting to “Auto-Scale”

Set the Warehouse type to “Auto”

Set the Minimum Clusters and Maximum Clusters settings to the same value

Set the Minimum Clusters and Maximum Clusters settings to the different values

NO.28 Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Database

Tables

Warehouses

Worksheets

NO.29 Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers

Java

JavaScript

SQL

Python

NO.30 Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

NO.31 True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

NO.32 What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Standard

Premier

Enterprise

Business Critical Edition

NO.33 True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

NO.34 True or False: An active warehouse is required to run a COPY INTO statement.

True

False

NO.35 True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

True

False

NO.36 True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

True

False

NO.37 True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True

False

NO.38 True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

True

False

NO.39 What command is used to load files into an Internal Stage within Snowflake? Select one.

PUT

COPY INTO

TRANSFER

INSERT

NO.40 Which of the following is true of Snowpipe via REST API? Choose 2 answers

you can only use it on internal Stages

All COPY INTO options are available fluting pipe creation

Snowflake automatically manages the compute required to execute the Pipe’s copy into commands

Snowpipe keeps track of which files it has loaded

NO.41 which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

Bulk copy from an External Stage

Continuous load using Snowpipe REST API

The Snowflake Web Interface (UT) data loading wizard

Bulk copy from an Internal Stage

NO.42 What is the minimum duration charged when starting a virtual warehouse?

1 second

1 minute

1 hour

1 day

NO.43 If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

All Snowflake sessions using the warehouse are terminated.

The last query using the warehouse completes.

There are no users loaned into Snowflake.

The Warehouse is inactive for a specified period of time.

NO.44 If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

128

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

JSON

Parquet

XML