[Q63-Q82] Download Snowflake COF-C01 Sample Questions [Sep-2022]

4/5 - (14 votes)

Download Snowflake COF-C01 Sample Questions [Sep-2022]

Real COF-C01 Exam Questions and Answers FREE

NEW QUESTION 63
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

SHOW TABLES;

SHOW STORAGE BY TABLE;

Information Schema -> TABLE_STORAGE_METRICS

Information Schema -> TASLE_HISTORY

NEW QUESTION 64
Which of the following commands are not blocking operations?
Choose 2 answers

UPDATE

INSERT

MERGE

COPY

NEW QUESTION 65
True or False: You can define multiple columns within a clustering key on a table.

True

False

NEW QUESTION 66
In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Compute Layer

Database Layer

Cloud Service Layer

NEW QUESTION 67
Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

NEW QUESTION 68
How many shares can be consumed by single Data Consumer?

100, but can be increased by contacting support

Unlimited

NEW QUESTION 69
Which of the following are common use cases for zero-copy cloning? Choose 3 answers

Quick provisioning of Dev and Test/QA environments

Data backups

Point in time snapshots

Performance optimization

NEW QUESTION 70
What are the three layers that make up Snowflake’s architecture? Choose 3 answer

Compute

Tri-Secret Secure

Storage

Cloud Services

NEW QUESTION 71
Which of the following objects is not covered by Time Travel?

Tables

Schemas

Databases

Stages

NEW QUESTION 72
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

True

False

NEW QUESTION 73
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Database

Tables

Warehouses

Worksheets

NEW QUESTION 74
Which item in the Data Warehouse migration process does not apply in Snowflake>

Migrate Users

Migrate Schemas

Migrate Indexes

Build the Data pipeline

NEW QUESTION 75
What is the lowest Snowflake edition that offers Time Travel up to 90 days.

standard Edition

Premier Edition

Enterprise Edition

Business Critical Edition

NEW QUESTION 76
Which object allows you to limit the number of credits consumed within a Snowflake account?

Account usage Tracking

Resource Monitor

Warehouse Limit Parameter

Credit Consumption Tracker

NEW QUESTION 77
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

NEW QUESTION 78
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

NEW QUESTION 79
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

NEW QUESTION 80
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers

Temporary Tables

Transient Tables

Provisional Tables

Permanent Tables

NEW QUESTION 81
How would you execute a series of SQL statements using Task?

include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask…. AS call stored_prc1(); call stored_proc2t);

A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask…. AS call stored_proc_multiple_statements_inside():

Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

NEW QUESTION 82
Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

Loading …

Truly Beneficial For Your Snowflake Exam: https://www.prepawaytest.com/Snowflake/COF-C01-practice-exam-dumps.html

Leave a Reply Cancel reply