Free SnowPro Core Recertification Exam Practice Questions

A.  

The user has the appropriate privileges on the objects associated with the query

B.  

Micro-partitions have been reclustered since the query was last run

C.  

The new query is run using the same virtual warehouse as the previous query

D.  

The query includes a User Defined Function (UDF)

E.  

The query has been run within 24 hours of the previously-run query

A.  

COPY INTO

B.  

GET

C.  

WRITE

D.  

EXTRACT INTO

A.  

True

B.  

False

A.  

Bytes scanned

B.  

Bytes sent over the network

C.  

Number of partitions scanned

D.  

Percentage scanned from cache

E.  

External bytes scanned

A.  

list @file__stage

B.  

show @file__stage

C.  

view @file__stage

D.  

verify @file__stage

A.  

Alation

B.  

DataRobot

C.  

dbt

D.  

Tableau

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

A.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

B.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

C.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

D.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

A.  

Clustering

B.  

Indexing

C.  

Fragmenting

D.  

Using INDEX__HINTS