QuizizzSnowflake from dump base part 2

QuizizzSnowflake from dump base part 2

Professional Development

100 Qs

quiz-placeholder

Similar activities

Tebak youtuber Minecraft

Tebak youtuber Minecraft

KG - Professional Development

99 Qs

Hamilton College Family Quiz 2

Hamilton College Family Quiz 2

KG - Professional Development

100 Qs

401-500

401-500

Professional Development

100 Qs

GOKULAM  (QUIZZ 8)

GOKULAM (QUIZZ 8)

Professional Development

100 Qs

Kewirausahaan Dasar

Kewirausahaan Dasar

11th Grade - Professional Development

100 Qs

Pretest menuju guru yang profesional

Pretest menuju guru yang profesional

Professional Development

100 Qs

Product Training Forklift

Product Training Forklift

Professional Development

100 Qs

DAY I--ALE JAN 2022

DAY I--ALE JAN 2022

Professional Development

100 Qs

QuizizzSnowflake from dump base part 2

QuizizzSnowflake from dump base part 2

Assessment

Quiz

Other

Professional Development

Practice Problem

Hard

Created by

Juan Pulido

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

100 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

4.0
8.0
16.0
32.0

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE:
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USERI;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. MYSCHEMA TO USER1;
GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDE.MYSCHEMA TO MYROLE;

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Yes, because a table owner has full control and can unset masking policies.
Yes, because masking policies only apply to cloned tables.
No, because masking policies must always reference specific access roles.
No, because ownership of a table does not include the ability to change masking policies

4.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Custom
Economy
Economy
Standard

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Verdadero
falso

6.

MULTIPLE SELECT QUESTION

1 min • 1 pt

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Compute Credits = 50 Credits Cloud Services = 10
Compute Credits = 80 Credits Cloud Services = 5
Compute Credits = 10 Credits Cloud Services = 9
Compute Credits = 120 Credits Cloud Services = 10
Compute Credits = 200 Credits Cloud Services = 26

7.

MULTIPLE SELECT QUESTION

1 min • 1 pt

When is the result set cache no longer available? (Select TWO)

When another warehouse is used to execute the query
When another user executes the query
When the underlying data has changed
When the warehouse used to execute the query is suspended
When it has been 24 hours since the last query

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?