General

Question 1

Sharing, Cloning, Replication: Tables

Answer 1

All for tables, except can’t replicated temporary table

Question 2

Sharing, Cloning, Replication: External table

Answer 2

Can only be shared

Question 3

Sharing, Cloning, Replication: Views

Answer 3

Secured Views can be shared and views ca be replicated.
Views can be cloned as part of a schema or db clone, but not alone

Question 4

Sharing, Cloning, Replication: Materialized View

Answer 4

Can be shared and replicated
Can only be cloned as part of the schema or db clone, but not alone

Question 5

Sharing, Cloning, Replication: Streams

Answer 5

Can only be cloned

Question 6

Sharing, Cloning, Replication: Tasks

Answer 6

Can only be cloned

Question 7

Sharing, Cloning, Replication: Pipes

Answer 7

None. Can only be cloned as part of a clone of a db or schema if it does not reference an internal stage

Question 8

Sharing, Cloning, Replication: File Formats

Answer 8

Cloning, Replication

Question 9

Sharing, Cloning, Replication: Internal Stages

Answer 9

None

Question 10

Sharing, Cloning, Replication: External Stages

Answer 10

Cloning Only

Question 11

Sharing, Cloning, Replication: Automatic Clustering

Answer 11

Cloning and Replication

Question 12

Sharing, Cloning, Replication: Sequences

Answer 12

Cloning and Replication

Question 13

Sharing, Cloning, Replication: Stored Procedures

Answer 13

Replication Only

Question 14

Sharing, Cloning, Replications: UDFs

Answer 14

Sharing and Replication

Question 15

Sharing, Cloning, Replications: Masking Policies

Answer 15

Replication Only

Question 16

If you recreate a pipe using CREATE OR REPLACE PIPE command. What does happen to load history if the Snowpipe gets recreated?

Answer 16

The load history gets reset to empty

Question 17

How many maximum columns (or expressions) are recommended for a cluster key?

Answer 17

3 to 4

Question 18

Which stream type is supported for streams on the external table only?

Answer 18

Insert - Only

Question 19

T/F Pattern matching using a regular expression is generally slow

Answer 19

True

Question 20

File URL is ideal for

Answer 20

Custom applications that require access to unstructured data files

Question 21

Which systems function can help find the overlap depth of a table’s micro-partitions?

Answer 21

SYSTEM$CLUSTERING_DEPTH
SYSTEM$CLUSTERING_INFORMATION

Question 22

select * from t1 sample row(100); What would the above query return?

Answer 22

Return an entire table, including all rows in the table

Question 23

What is the expiration period of a File URL?

Answer 23

It is permanent

Question 24

Which command will delete all the data from a table, but keep the table

Answer 24

Truncate

Question 25

T/F External Tables can be shared

Answer 25

True

Question 26

A user's default role is

Answer 26

The role a user gets to set to each time they login

Question 27

Which SQL command determines whether a network policy is set on the account or for a specific user?

Answer 27

SHOW PARAMETERS

Question 28

Select the type of function that can operate on a subset of rows within the set of input rows.

Answer 28

Window function

Question 29

What are the supported file formats for data unloading in Snowflake?

Answer 29

JSON and Parquet only

Question 30

What is created for each Kafka Topic

Answer 30

One pipe to ingest the data for each topic partition One table for each topic One internal stage to temp store data files for each topic

Question 31

What types of views exist for snowflake

Answer 31

secure materialized standard

Question 32

How can you load a file where the file's metadata has expired

Answer 32

FORCE=TRUE LOAD_UNCERTAIN_FILES=TRUE

Question 33

Stored Procedure or UDF evaluates to a value

Answer 33

UDF

Question 34

T/F You can use your username and password to login to the rest api

Answer 34

False

Question 35

What does an ORGADMIN do

Answer 35

manages operations at the organization level Can create accounts in the organization Can view all accounts in the org, and all regions enabled Can view usage information across the org

Question 36

T/F A task can execute multiple sql statements

Answer 36

False

Question 37

At what frequency does Snowflake rotate the object keys?

Answer 37

30 days

Question 38

The major benefits of defining Clustering Keys are

Answer 38

To improve query performance to help optimize table maintenance