SAMPLE QUESTIONS Flashcards

1
Q

Which of the following will contribute to your account level storage usage?

A
  • Snowflake Internal Stage

- Database (and the tables in it)

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

What are the connectors & programs that can be downloaded under the Download section of Snowflake web UI?

A
  • ODBC Driver
  • JDBC Driver
  • SnowSQL
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A snowflake share…

A
  • has information about the consumer(s)

- is a container that contains objects to be shared

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

To close a database your current role must have which privilege on the source database?

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

Which properties can be set for a multi-cluster warehouse?

A
  • MIN_CLUSTER_COUNT
  • MAX_CLUSTER_COUNT
  • AUTO_RESUME
  • AUTO_SUSPEND
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The binary data type can store what amount of data?

A

8 MB

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

How much data can the VARCHAR data type store?

A

16MB

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