SnowPro-Core Practice Questions

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.  

A directory table is a separate database object.

B.  

Directory tables store data file metadata.

C.  

A directory table will be automatically added to a stage.

D.  

Directory tables do not have their own grantable privileges.

E.  

Directory table data can not be refreshed manually.

A.  

JOIN

B.  

COPY INTO

C.  

PUT

D.  

GET

A.  

CONTENT

B.  

PATH

C.  

BYTE_SIZE

D.  

INDEX

E.  

DATATYPE

A.  

Compute resources

B.  

Query execution

C.  

Authentication

D.  

Data storage

E.  

Metadata

A.  

COPY INTO

B.  

CREATE PIPE

C.  

INSERT INTO

D.  

TABLE STREAM

A.  

select src:dealership from car_sales;

B.  

select src.dealership from car_sales;

C.  

select src:Dealership from car_sales;

D.  

select dealership from car_sales;

A.  

Automatically creates a File Format object

B.  

Automatically uses the last Stage created

C.  

Automatically compresses files using Gzip

D.  

Automatically encrypts files

A.  

Database

B.  

Tables

C.  

Warehouses

D.  

Worksheets

A.  

Tables

B.  

Schemas

C.  

Databases

D.  

Stages