SnowPro-Core Exam Dumps - SnowPro Core Certification Exam

Go to page:

<< First
Prev
3
4
5
6
7
8
9
10
11
12
Next
Last >>

Question # 57

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Bytes spilled to local cache.

Bytes spilled to local storage.

Bytes spilled to remote cache.

Bytes spilled to remote storage.

Bytes spilled to remote metastore.

Full Access

Question # 58

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Indefinitely

Until the result_cache expires

Until the retention_time is met

Until the expiration time is exceeded

Full Access

Question # 59

Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

Java

Javascript

Scala

Python

SQL

Full Access

Question # 60

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 INTO for bulk unloading where the default option is SINGLE - TRUE.

It uses COPY INTO to copy the data from a table into one or more files in an external stage only.

Full Access

Question # 61

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

Cloud Services

Database Storage

Query Processing

Metadata Management

Full Access

Question # 62

What is used to diagnose and troubleshoot network connections to Snowflake?

SnowCD

Snowpark

Snowsight

SnowSQL

Full Access

Question # 63

How would a user execute a series of SQL statements using a task?

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1

WHERE ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS

call stored_proc1(); call stored_proc2();

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

Full Access

Question # 64

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Use auto-ingest Snowpipes to load large files in a serverless model.

Produce the largest files possible, reducing the overall number of files to process.

Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Full Access