Snowflake


COF-C02


SnowPro Core Certification


https://killexams.com/pass4sure/exam-detail/COF-C02

Question: 64


What happens when a Data Provider revokes privileges to a Share on an object in their source database?

  1. The object immediately becomes unavailable for all Data Consumers

  2. Any additional data arriving after this point in time will not be visible to Data Consumers

  3. The Data Consumers stop seeing data updates and become responsible for storage charges for the object

  4. A static copy of the object at the time the privilege was revoked is created In the Data Consumers’ accounts


Answer: A


on: 65


esults are stored in the Result Cache for how long after they are last accessed, assuming no data change occurred?

our ours ours ours


r: D ation:

nce: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse


on: 66


f the following statements would be used to export/unload data from Snowflake? PY INTO @stage

ORT TO @stage ERT INTO @stage

PORT_TO_STAGE (stage = > @Wage, select = > ‘select * from t1);


r: A ation:

Questi


Query r s have


  1. 1 H

  2. 3 H

  3. 12 h

  4. 24 h


Answe Explan Refere

Questi


Which o

  1. CO

  2. EXP

  3. INS

  4. EX


Answe


Explan


Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html


Question: 67


A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?

  1. The primary cluster in the virtual warehouse

  2. The entire virtual warehouse

  3. The database in which the virtual warehouse resides

  4. The Queries currently being run on the virtual warehouse

Answer: B Explanation:

https://docs.snowflake.com/en/user-guide/warehouses- overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.


Question: 68


True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.


r: B ation:

nce: https://docs.snowflake.com/en/user-guide/credits.html


on: 69


re true of Snowflake roles?

rants to objects are given to roles, and never to users

rder to do DML/DOL, a user needs to have selected a single role that has that specific access to the obje on

ublic role controls at other roles

Roles are a subset of users and users own objects In Snowflake


r: A,B


on: 70


f the following connectors are available in the Downloads section of the Snowflake web Interface (UI) ers

wSQL BC

  1. True

  2. False


Answe Explan Refere

Questi


Which a

  1. All g

  2. In o ct and

    operati

  3. The p D.


Answe


Questi


Which o Choose

2 answ

  1. Sno

  2. OD

  3. R

  4. HIVE


Answer: A,B Explanation:

Reference: https://docs.snowflake.com/en/user-guide/connecting.html


Question: 71

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

  1. VARIANT

  2. ARRAY

  3. VARCHAR

  4. XML

  5. BLOB



docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data


RIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJE Y.


ximum length of a VARIANT is 16 MB.


wflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or of data. Each element is accessed by specifying its position in the array.


on: 72


opy INTO command outputs the data into one file? GLE=TRUE

X_FILE_NUMBER=1 E_NUMBER=1 LTIPLE=FAISE


r: B


on: 73


False: It is possible to query data from an Internal or named External stage without loading the data int ake.

Answer: A,B Explanation: https://

A VA CT and

ARRA


The ma


A Sno more

pieces


Questi


Which c

  1. SIN

  2. MA

  3. FIL

  4. MU


Answe


Questi


True or o

Snowfl

  1. True

  2. False


Answer: A


Question: 74


The FLATEEN function is used to query which type of data in Snowflake?

  1. Structured data

  2. Semi-structured data

  3. Both of the above

  4. None of the above


Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html


FLATTEN is used to unnest semi-structured data. Don’t see an application for structured data as by definition it shouldn’t be nested.


Question: 75


f the following statements describes a benefit of Snowflake’s separation of compute and storage? (Cho ply.)

wth of storage and compute are tightly coupled together age expands without the requirement to add more compute

mpute can be scaled up or down without the requirement to add more storage tiple compute clusters can access stored data without contention


r: B,C,D


ation:


nce: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehouse

-storage-and-compute-65d2dffd450f


on: 76


f the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.) alidation_mode option is used when creating an Internal Stage

dation_mode=return_all_errors is a parameter of the copy command

alidation_mode option will validate data to be loaded by the copy statement while completing the load urn the rows that could not be loaded without error

alidation_mode option will validate data to be loaded by the copy statement without completing the loa urn possible errors


r: B,D

Which o ose all

that ap

  1. Gro

  2. Stor

  3. Co

  4. Mul


Answe


Explan


Refere doesnt-

separate


Questi


Which o

  1. The v

  2. vali

  3. The v and

    will ret

  4. The v d and

will ret


Answe


Explanation:


Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html


Question: 77


Which Snowflake partner specializes in data catalog solutions?

  1. Alation

  2. DataRobot

  3. dbt

  4. Tableau


Alation provides Data Cataloging functionality. They state they are the ‘One Place to Find, Understand, & Govern Data Across an Enterprise.


https://docs.snowflake.com/en/user-guide/ecosystem-all.html



mber of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers omplexity of each query

ONCURRENT_QUERY_UMIT parameter set on the Snowflake account ize of the data required for each query

ool that s executing the query


r: A,C


ation:


nce: https://docs.snowflake.com/en/user-guide/warehouses-overview.html


on: 79


caling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved: currency

ormance


r: A ation:

nce: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html


on: 80

Question: 78


The nu

  1. The c

  2. The C

  3. The s

  4. The t


Answe Explan Refere

Questi


When s

  1. Con

  2. Perf


Answe Explan Refere

Questi


True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

  1. True

  2. False


Answer: A Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html