Free SnowPro Core Recertification Exam Practice Questions

A.  

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

B.  

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

C.  

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

D.  

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

A.  

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.  

When the data cache is full, the least-recently used data will be cleared to make room.

C.  

A user can only access their own queries from the query result cache.

D.  

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.  

The RESULT_SCAN table function can access and filter the contents of the query result cache.

A.  

90 days

B.  

1 day

C.  

7 days

D.  

45 days

A.  

Files

B.  

External tables

C.  

Secure User-Defined Functions (UDFs)

D.  

Sequences

E.  

Streams

A.  

Clustering

B.  

Materialized Views

C.  

Zero-copy Cloning

D.  

Search Optimization Service

A.  

view @my_stage

B.  

list @my_stage

C.  

show @my_stage

D.  

display @my_stage

A.  

No virtual warehouse will be used, data will be read from the result cache.

B.  

No virtual warehouse will be used, data will be read from the local disk cache.

C.  

The default virtual warehouse will be used to read all data.

D.  

The virtual warehouse that is defined at the session level will be used to read all data.

A.  

The columns that are queried in the select clause.

B.  

The columns with very high cardinality.

C.  

The columns with many different values.

D.  

The columns most actively used in the select filters.

A.  

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B.  

Allows a user to import the files in a sequential order

C.  

Increases the latency staging and accuracy when loading the data

D.  

Allows optimization of parallel operations

A.  

Data is live, ready-to-query, and can be personalized.

B.  

Data needs to be loaded into a cloud provider as a consumer account.

C.  

Data is not available for copying or moving to an individual Snowflake account.

D.  

Data is available without copying or moving.

E.  

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.