SnowPro Core Exam dumps PDF | Exam-Dumps.net (Page: 22)

QUESTION: 169

Network policies can be set at which Snowflake levels? (Choose two.)

Role
Schema
User
Database
Account
Tables

Answer(s): C,E

Reference:

https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

Reveal Solution Next Question

QUESTION: 170

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day.
Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days.
Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days.

Answer(s): D

Reveal Solution Next Question

QUESTION: 171

Which of the following objects are contained within a schema? (Choose two.)

Role
Stream
Warehouse
External table
User
Share

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 172

Which of the following statements describe features of Snowflake data caching? (Choose two.)

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
When the data cache is full, the least-recently used data will be cleared to make room.
A user can only access their own queries from the query result cache.
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
The RESULT_SCAN table function can access and filter the contents of the query result cache.

Answer(s): B,E

Reveal Solution Next Question

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Compress the file and load the compressed file.
Split the file into multiple files in the recommended size range (100 MB - 250 MB).
Use a larger-sized warehouse.
Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Answer(s): D

Reveal Solution Next Question