Snow15

Snow15

Professional Development

13 Qs

quiz-placeholder

Similar activities

SQL quizz

SQL quizz

Professional Development

13 Qs

Sharing Session_Introduction of SCM

Sharing Session_Introduction of SCM

Professional Development

12 Qs

snow6

snow6

Professional Development

12 Qs

snow10

snow10

Professional Development

12 Qs

Christmas Trivia

Christmas Trivia

KG - Professional Development

10 Qs

BÀI 6 - K12

BÀI 6 - K12

Professional Development

10 Qs

AA Holiday Trivia Cheer

AA Holiday Trivia Cheer

Professional Development

16 Qs

ความรู้พื้นฐานการจัดดการข้อมูลขนาดใหญ่ (Big Data)

ความรู้พื้นฐานการจัดดการข้อมูลขนาดใหญ่ (Big Data)

Professional Development

10 Qs

Snow15

Snow15

Assessment

Quiz

Specialty

Professional Development

Medium

Created by

Ismael Navarro Cruz

Used 1+ times

FREE Resource

13 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the default value in the Snowflake Web Interface (UI) for auto suspending a Virtual Warehouse?

  • 1 minute

  • 5 minutes

  • 10 minutes

  • 15 minutes

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is a feature of a stored procedure in Snowflake?

  • They can be created as secure and hide the underlying metadata from all users.

  • They can access tables from a single database.

  • They can only contain a single SQL statement.

  • They can be created to run with a caller's rights or an owner's rights.

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which statement accurately describes a characteristic of a materialized view?

A materialized view can query only a single table.

Data accessed through materialized views can be stale.

Materialized view refreshes need to be maintained by the user.

Querying a materialized view is slower than executing a query against the base table of the view.

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the maximum compressed row size in Snowflake?

  • 8KB

  • 16MB

  • 50MB

  • 4000GB

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?

Improved performance for small, simple queries

Improved performance for large, complex queries

Decreased performance for large, complex queries

Decreased consumption of Snowflake credits

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

When does a materialized view get suspended in Snowflake?

When a column is added to the base table

When a column is dropped from the base table

When a DML operation is run on the base table

When the base table is reclustered

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which role has the ability to create and manage users and roles?

  • ORGADMIN

  • USERADMIN

  • SYSADMIN

  • SECURITYADMIN

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?