SnowPro-Core Practice Exam Questions and Answers

A.  

Data is hashed by the cluster key to facilitate fast searches for common data values

B.  

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.  

Smaller micro-partitions are created for common data values to allow for more parallelism

D.  

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

A.  

Credits are billed per-minute with a 60-minute minimum

B.  

Credits are used to pay for cloud data storage usage

C.  

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.  

Credits are consumed based on the warehouse size and the time the warehouse is running

A.  

A Materialized View cannot support any aggregate functions

B.  

A Materialized View can only reference up to two tables

C.  

A Materialized View cannot be joined with other tables

D.  

A Materialized View cannot be defined with a JOIN

A.  

ACCOUNTADMIN

B.  

ORGADMIN

C.  

SECURITYADMIN

D.  

SYSADMIN

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

A.  

Bytes scanned

B.  

Bytes sent over the network

C.  

Number of partitions scanned

D.  

Percentage scanned from cache

E.  

External bytes scanned

A.  

A read-only copy of the cloned tables is stored.

B.  

The replication will not be successful.

C.  

The physical data is replicated

D.  

Additional costs for storage are charged to a secondary account

E.  

Metadata pointers to cloned tables are replicated

A.  

All data from all of the files on the stage will be appended to the table

B.  

Only data about new customers from the new files will be appended to the table

C.  

The operation will fail with the error uncertain files in stage.

D.  

All data from only the newly-added files will be appended to the table.

A.  

Customer-managed encryption keys through Tri-Secret Secure

B.  

Automatic encryption of all data

C.  

Up to 90 days of data recovery through Time Travel

D.  

Object-level access control

E.  

Column-level security to apply data masking policies to tables and views

A.  

The load HISTORY view

B.  

The Query history view

C.  

The show warehouses command

D.  

The WAREHOUSE_METERING__HISTORY View

E.  

The billing and usage tab in the Snowflake web Ul