Topic 2: Exam pool B
Users are responsible for data storage costs until what occurs?
A.
Data expires from Time Travel
B.
Data expires from Fail-safe
C.
Data is deleted from a table
D.
Data is truncated from a table
Data expires from Fail-safe
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
A.
VARIANT
B.
VARRAY
C.
STRUCT
D.
ARRAY
E.
QUEUE
VARIANT
ARRAY
Which Snowflake layer is always leveraged when accessing a query from the result cache?
A.
Metadata
B.
Data Storage
C.
Compute
D.
Cloud Services
Cloud Services
What is the maximum Time Travel retention period for a temporary Snowflake table?
A.
90 days
B.
1 day
C.
7 days
D.
45 days
1 day
When should a multi-cluster warehouse be used in auto-scaling mode?
A.
When it is unknown how much compute power is needed
B.
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
C.
If the runtime of the executed query is very slow
D.
When a large number of concurrent queries are run on the same warehouse
When a large number of concurrent queries are run on the same warehouse
What COPY INTO SQL command should be used to unload data into multiple files?
A.
SINGLE=TRUE
B.
MULTIPLE=TRUE
C.
MULTIPLE=FALSE
D.
SINGLE=FALSE
MULTIPLE=FALSE
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates. How can this worksheet be shared?
A.
Create a zero-copy clone of the worksheet and grant permissions to teammates
B.
Create a private Data Exchange so that any teammate can use the worksheet
C.
Share the worksheet with teammates within Snowsight
D.
Create a database and grant all permissions to teammates
Share the worksheet with teammates within Snowsight
Which minimum Snowflake edition allows for a dedicated metadata store?
A.
Standard
B.
Enterprise
C.
Business Critical
D.
Virtual Private Snowflake
Virtual Private Snowflake
Which file formats are supported for unloading data from Snowflake? (Choose two.)
A.
Avro
B.
JSON
C.
ORC
D.
XML
E.
Delimited (CSV, TSV, etc.)
ORC
Delimited (CSV, TSV, etc.)
Reference: https://docs.snowflake.com/en/user-guide/data-unloadprepare.
html#:~:text=Supported-File-Formats,-
The-following-file&text=Delimited-(CSV%2C-TSV%2C-etc,is-comma-(i.e.-CSV).&text=File-format-options-specify-the,the-format-of-the-data
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?
A.
Use data encryption.
B.
Use dynamic data masking.
C.
Use secure materialized views.
D.
Revoke all roles for functional managers and end users.
Use dynamic data masking.
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
A.
Management of metadata
B.
Computing the data
C.
Maintaining Availability Zones
D.
Infrastructure security
E.
Parsing and optimizing queries
Management of metadata
Parsing and optimizing queries
What are supported file formats for unloading data from Snowflake? (Choose three.)
A.
XML
B.
JSON
C.
Parquet
D.
ORC
E.
AVRO
F.
CSV
JSON
Parquet
CSV
| Page 15 out of 42 Pages |
| 9101112131415161718192021 |
| COF-C02 Practice Test Home |
Real-World Scenario Mastery: Our COF-C02 practice exam don't just test definitions. They present you with the same complex, scenario-based problems you'll encounter on the actual exam.
Strategic Weakness Identification: Each practice session reveals exactly where you stand. Discover which domains need more attention, before SnowPro Core Certification Exam (COF-C02) exam day arrives.
Confidence Through Familiarity: There's no substitute for knowing what to expect. When you've worked through our comprehensive COF-C02 practice exam questions pool covering all topics, the real exam feels like just another practice session.
Copyright © All Rights Reserved