Exam Prep 1

Exam Prep 1

Professional Development

40 Qs

quiz-placeholder

Similar activities

berpikir komputasional-2

berpikir komputasional-2

Professional Development

38 Qs

Computer Networks Quiz

Computer Networks Quiz

Professional Development

40 Qs

SNS Multiple Choice Questions

SNS Multiple Choice Questions

Professional Development

40 Qs

Values Education 9

Values Education 9

Professional Development

35 Qs

IT Support Service Level 3 — Exam Paper (Set–1)

IT Support Service Level 3 — Exam Paper (Set–1)

Professional Development

40 Qs

Quiz

Quiz

Professional Development

39 Qs

Simulazione Esame Architetture IT e Blockchain

Simulazione Esame Architetture IT e Blockchain

Professional Development

36 Qs

OSN 2020

OSN 2020

Professional Development

36 Qs

Exam Prep 1

Exam Prep 1

Assessment

Quiz

Information Technology (IT)

Professional Development

Practice Problem

Hard

Created by

Blue Azul

Used 6+ times

FREE Resource

AI

Enhance your content in a minute

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

40 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

5 mins • 1 pt

Which commands can only be executed using SnowSQL? (Choose two.)

COPY INTO

GET

LIST

PUT

REMOVE

2.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table.

What will the query from the view return?

The data from the permanent table.

The data from the temporary table.

An error stating that the view would not be compiled.

An error stating that the referenced object could not be uniquely identified.

3.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?

SnowSQL

Dashboards

Python worksheets

Provider Studio

4.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?

TO_JSON

TO_VARIANT

OBJECT_INSERT

OBJECT_CONSTRUCT

5.

MULTIPLE SELECT QUESTION

5 mins • 1 pt

What user setting can be configured to disable Multi-Factor Authentication (MFA) for a Snowflake user? (Choose two.)

DISABLE_MFA

MINS_TO_BYPASS_MFA

PASSWORD

MINS_TO_UNLOCK

MUST_CHANGE_PASSWORD

6.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

parse_json()

json_extract_path_text()

object_construct()

flatten

7.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

What computer language can be selected when creating User-Defined Functions (UDF) using the Snowpark API?

Swift

JavaScript

Python

SQL

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?