snow5

snow5

Professional Development

12 Qs

quiz-placeholder

Similar activities

Trivia Challenge 29 May 2023

Trivia Challenge 29 May 2023

Professional Development

10 Qs

Ke ANSORAN II

Ke ANSORAN II

Professional Development

10 Qs

GSD Phase 2 Review

GSD Phase 2 Review

Professional Development

15 Qs

วิชาระบบปฏิบัติการเบื้องต้น หน่วยที่ 1  หลักการพื้นฐานของระบบคอม

วิชาระบบปฏิบัติการเบื้องต้น หน่วยที่ 1 หลักการพื้นฐานของระบบคอม

Professional Development

10 Qs

PRECISION VS ACCURACY

PRECISION VS ACCURACY

Professional Development

14 Qs

Cold water level two 2

Cold water level two 2

Professional Development

16 Qs

Client consultation exam prep

Client consultation exam prep

Professional Development

17 Qs

Basic QC di Industri Pangan

Basic QC di Industri Pangan

10th Grade - Professional Development

8 Qs

snow5

snow5

Assessment

Quiz

Specialty

Professional Development

Practice Problem

Medium

Created by

Ismael Navarro Cruz

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

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

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 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

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What happens when a Snowflake user changes the data retention period at the schema level?

All child objects will retain data for the new retention period.

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

All child objects with an explicit retention period will be overridden with the new retention period.

All explicit child object retention periods will remain unchanged.

3.

MULTIPLE SELECT QUESTION

1 min • 1 pt

How can a Snowflake user sample 10 rows from a table named SNOWPRO? (Choose two.)

SELECT * FROM SNOWPRO SAMPLE SYSTEM (10)

SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS)

SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10)

SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10 ROWS)

SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS)

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What data type is used to ingest semi-structured data into a Snowflake table?

BOOLEAN

NUMBER

VARBINARY

VARIANT

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which security feature is used to connect or log in to a Snowflake account?

Network policy

SCIM

Role-Based Access Control (RBAC)

Key pair authentication

6.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Given the statement template below, which database objects can be added to a share? (Choose two.) GRANT ON TO SHARE ;

Secure functions

Stored procedures

Streams

Tables

Tasks

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

Persisted query results

QUERY_HISTORY view

Query acceleration service

Query Profile

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?