General Flashcards

1
Q

Sharing, Cloning, Replication: Tables

A

All for tables, except can’t replicated temporary table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Sharing, Cloning, Replication: External table

A

Can only be shared

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Sharing, Cloning, Replication: Views

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Sharing, Cloning, Replication: Materialized View

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Sharing, Cloning, Replication: Streams

A

Can only be cloned

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Sharing, Cloning, Replication: Tasks

A

Can only be cloned

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Sharing, Cloning, Replication: Pipes

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Sharing, Cloning, Replication: File Formats

A

Cloning, Replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Sharing, Cloning, Replication: Internal Stages

A

None

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Sharing, Cloning, Replication: External Stages

A

Cloning Only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Sharing, Cloning, Replication: Automatic Clustering

A

Cloning and Replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Sharing, Cloning, Replication: Sequences

A

Cloning and Replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Sharing, Cloning, Replication: Stored Procedures

A

Replication Only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Sharing, Cloning, Replications: UDFs

A

Sharing and Replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Sharing, Cloning, Replications: Masking Policies

A

Replication Only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

The load history gets reset to empty

17
Q

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

A

3 to 4

18
Q

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

A

Insert - Only

19
Q

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

A

True

20
Q

File URL is ideal for

A

Custom applications that require access to unstructured data files

21
Q

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

A

SYSTEM$CLUSTERING_DEPTH
SYSTEM$CLUSTERING_INFORMATION

22
Q

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

A

Return an entire table, including all rows in the table

23
Q

What is the expiration period of a File URL?

A

It is permanent

24
Q

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

A

Truncate

25
Q

T/F External Tables can be shared

A

True

26
Q

A user’s default role is

A

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

27
Q

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

A

SHOW PARAMETERS

28
Q

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

A

Window function

29
Q

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

A

JSON and Parquet only

30
Q

What is created for each Kafka Topic

A

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

31
Q

What types of views exist for snowflake

A

secure
materialized
standard

32
Q

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

A

FORCE=TRUE
LOAD_UNCERTAIN_FILES=TRUE

33
Q

Stored Procedure or UDF evaluates to a value

A

UDF

34
Q

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

A

False

35
Q

What does an ORGADMIN do

A

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

36
Q

T/F A task can execute multiple sql statements

A

False

37
Q

At what frequency does Snowflake rotate the object keys?

A

30 days

38
Q

The major benefits of defining Clustering Keys are

A

To improve query performance
to help optimize table maintenance