Free SnowPro Core Certification Exam Practice Questions

A.  

Compress the file and load the compressed file.

B.  

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.  

Use a larger-sized warehouse.

D.  

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

A.  

Row level access policies

B.  

Data masking policies

C.  

Data encryption

D.  

Time Travel

E.  

External tokenization

A.  

Avro

B.  

JSON

C.  

ORC

D.  

XML

E.  

Delimited (CSV, TSV, etc.)

A.  

90 days

B.  

1 day

C.  

7 days

D.  

45 days

A.  

A query that uses only disjunction (i.e., OR) predicates

B.  

A query that includes analytical expressions

C.  

A query that uses equality predicates or predicates that use IN

D.  

A query that filters on semi-structured data types

A.  

Removing a column from the query SELECT list

B.  

Stopping the virtual warehouse that the query is running against

C.  

Clustering of the data used by the query

D.  

Executing the RESULTS_SCAN() table function

E.  

Changing a column that is not in the cached query

A.  

Configure the warehouse to a size larger than generally required

B.  

Set the minimum and maximum clusters to autoscale

C.  

Use the standard warehouse scaling policy

D.  

Use the economy warehouse scaling policy

A.  

When it is unknown how much compute power is needed

B.  

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.  

If the runtime of the executed query is very slow

D.  

When a large number of concurrent queries are run on the same warehouse

A.  

COPY_INTO < location > command

B.  

Data replication

C.  

Snowpipe

D.  

Direct share

A.  

Queued queries will be dropped.

B.  

The warehouse will shut down.

C.  

A new cluster will be started.

D.  

Queries will be redirected to another warehouse.

A.  

ALTER SHARE

B.  

CREATE SHARE

C.  

DESCRIBE SHARE

D.  

GRANT < privilege > ... TO SHARE

A.  

SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);

B.  

SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);

C.  

SELECT * FROM MY_TABLE SAMPLE (5 ROWS);

D.  

SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);

A.  

If the table and sequence are in the same schema, the cloned table will reference the source sequence.

B.  

If the table and sequence are in the same schema, the cloned table will reference the cloned sequence.

C.  

If the table and sequence are in different schemas, the cloned table will reference the source sequence.

D.  

If the table and sequence are in different schemas, the cloned table will no longer have a default value for the column.

E.  

If the table and sequence are in the same schema, the cloned table will use the most-recently generated value from the source sequence.

A.  

List

B.  

Table

C.  

Array

D.  

DataFrame

A.  

Anyone who has the URL can access the referenced file for the life of the token.

B.  

Only the user who generates the URL can use the URL to access the referenced file.

C.  

Only the users who have roles with sufficient privileges on the URL can access the referenced file.

D.  

The role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.

A.  

INTEGER

B.  

GEOMETRY

C.  

FLOAT

D.  

VARIANT

E.  

BOOLEAN

A.  

It specifies which table partition will be used to copy data.

B.  

It partitions unloaded table rows into separate files.

C.  

It defines the partitioning scheme for the target table.

D.  

It filters the rows to be unloaded based on partition values.

A.  

LOAD

B.  

copy

C.  

GET

D.  

PUT

A.  

SHOW GRANTS ON ROLE < Role Name >

B.  

SHOW ROLES < Role Name >

C.  

SHOW GRANTS TO ROLE < Role Name >

D.  

SHOW GRANTS FOR ROLE < Role Name >

A.  

LOAD_UNCERTAIN_FILES

B.  

LOAD_EXPIRED_FILES

C.  

FORCE

D.  

ENFORCE_LENGTH

E.  

PURGE