Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

Free SnowPro Core Certification Exam Practice Questions

Question # 321

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

Options:

A.  

The objects are dropped.

B.  

The objects enter the Fail-safe period.

C.  

The objects enter the Time Travel period.

D.  

The objects are immediately moved to the provider account.

Discussion 0
Question # 322

What is a directory table in Snowflake?

Options:

A.  

A separate database object that is used to store file-level metadata

B.  

An object layered on a stage that is used to store file-level metadata

C.  

A database object with grantable privileges for unstructured data tasks

D.  

A Snowflake table specifically designed for storing unstructured files

Discussion 0
Question # 323

Which privilege must be granted by one role to another role, and cannot be revoked?

Options:

A.  

MONITOR

B.  

OPERATE

C.  

OWNERSHIP

D.  

ALL

Discussion 0
Question # 324

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

Options:

A.  

It removes null values from all columns in the data.

B.  

It converts null values to empty strings during loading.

C.  

It skips rows with null values during the loading process.

D.  

It removes object or array elements containing null values.

Discussion 0
Question # 325

What factors impact storage costs in Snowflake? (Select TWO).

Options:

A.  

The account type

B.  

The storage file format

C.  

The cloud region used by the account

D.  

The type of data being stored

E.  

The cloud platform being used

Discussion 0

COF-C02 PDF

COF-C02 PDF (Printable)
$54.25
$154.99

COF-C02 Testing Engine

COF-C02 PDF (Printable)
$59.5
$169.99

COF-C02 PDF + Testing Engine

COF-C02 PDF (Printable)
$74.55
$212.99

Free Exams Sample Questions