Search Header Logo

snow6

Authored by Ismael Navarro Cruz

Specialty

Professional Development

Used 3+ times

snow6
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which file functions are non-deterministic? (Choose two.)

BUILD_SCOPED_FILE_URL

BUILD_STAGE_FILE_URL

GET_ABSOLUTE_PATH

GET_PRESIGNED_URL

GET_RELATIVE_PATH

2.

MULTIPLE SELECT QUESTION

1 min • 1 pt

How can a Snowflake user optimize query performance in Snowflake? (Choose two.)

Create a view.

Cluster a table.

Enable the search optimization service.

Enable Time Travel.

Index a table.

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

ACCOUNTADMIN

SECURITYADMIN

SYSADMIN

ORGADMIN

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

ARRAY

OBJECT

TEXT

VARIANT

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

Resource monitor

Account_usage.query_history

Information_schema.warehouse_load_history

Information_schema.warehouse_metering_history

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which Snowflake object can be created to be temporary?

Role

Stage

User

Storage integration

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which stream type can be used for tracking the records in external tables?

Append-only

External

Insert-only

Standard

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?