QUESTION: 537

Which user object property requires contacting Snowflake Support in order to set a value for it?

DISABLED
MINS_TO_BYPASS MFA
MINS_TO_BYPASS_NETWORK_POLICY
MINS_TO_UNLOCK

Answer(s): C

Reveal Solution Next Question

QUESTION: 538

How does Snowflake handle the bulk unloading of data into single or multiple files?

It assigns each unloaded data file a unique name.
It uses the PUT command to download the data by default.
It uses COPY INTOfor bulk unloading where the default option is SINGLE = TRUE.
It uses COPY INTOto copy the data from a table into one or more files in an external stage only.

Answer(s): A

Reveal Solution Next Question

QUESTION: 539

What information is included in the display in the Query Profile? (Choose two.)

Index hints used in query
Credit usage details
Clustering keys details
Details and statistics for the overall query
Graphical representation of the query processing plan

Answer(s): D,E

Reveal Solution Next Question

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.
What should the user do?

Add a clustering key to the table.
Add the search optimization service to the table.
Create a materialized view based on the query.
Enable the query acceleration service for the virtual warehouse.

Answer(s): C

Reveal Solution Next Question

Free SnowPro Core Exam Braindumps (page: 135)

QUESTION: 537

QUESTION: 538

QUESTION: 539

QUESTION: 540