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?
The object immediately becomes unavailable for all Data Consumers
Any additional data arriving after this point in time will not be visible to Data Consumers
The Data Consumers stop seeing data updates and become responsible for storage charges for the object
A static copy of the object at the time the privilege was revoked is created In the Data Consumers’ accounts
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
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);
Questi
Query r s have
1 H
3 H
12 h
24 h
Questi
Which o
CO
EXP
INS
EX
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?
The primary cluster in the virtual warehouse
The entire virtual warehouse
The database in which the virtual warehouse resides
The Queries currently being run on the virtual warehouse
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.
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
on: 70
f the following connectors are available in the Downloads section of the Snowflake web Interface (UI) ers
wSQL BC
True
False
Questi
Which a
All g
In o ct and
operati
The p D.
Questi
Which o Choose
2 answ
Sno
OD
R
HIVE
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)
VARIANT
ARRAY
VARCHAR
XML
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
on: 73
False: It is possible to query data from an Internal or named External stage without loading the data int ake.
A VA CT and
ARRA
The ma
A Sno more
pieces
Questi
Which c
SIN
MA
FIL
MU
Questi
True or o
Snowfl
True
False
Question: 74
The FLATEEN function is used to query which type of data in Snowflake?
Structured data
Semi-structured data
Both of the above
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
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
Which o ose all
that ap
Gro
Stor
Co
Mul
Explan
Refere doesnt-
separate
Questi
Which o
The v
vali
The v and
will ret
The v d and
will ret
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html
Question: 77
Which Snowflake partner specializes in data catalog solutions?
Alation
DataRobot
dbt
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
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
nce: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
on: 80
Question: 78
The nu
The c
The C
The s
The t
Questi
When s
Con
Perf
Questi
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
True
False
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html