Search Header Logo

snow10

Authored by Ismael Navarro Cruz

Specialty

Professional Development

12 Questions

Used 1+ times

snow10
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

The data retention period is reduced to a minimum of 14 days

The data retention period is permanently extended for the table

The data retention period is temporarily extended to the stream’s offset

The data retention period is not affected by the stream consumption

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

In Snowflake, what allows users to perform recursive queries?

QUALIFY

LATERAL

PIVOT

CONNECT BY

3.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Which languages are supported for writing in-line user-defined functions (UDFs) in Snowflake? (Choose two.)

JavaScript

SQL

Python

R

Java

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the minimum role required to create and manage data shares?

ACCOUNTADMIN

SECURITYADMIN

SYSADMIN

USERADMIN

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In Snowflake, if a pipe is paused, what happens to the incoming events?

All events are dropped

Events are retained in metadata for 14 days until the pipe is manually resumed

Events are retained until the pipe is automatically resumed

Events are stored indefinitely in metadata

6.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which are valid functions to check the data type in a VARIANT column? (Choose two.)

IS_GEOGRAPHY

IS_XML

IS_JSON

IS_NULL_VALUE

IS_DATE_VALUE

7.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

What are valid options for the FIELD_OPTIONALLY_ENCLOSED_BY function in Snowflake? (Choose two.)

'NULL'

NULL

NONE

'NONE'

Enclosed by apostrophe (')

Access all questions and much more by creating a free account

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?