When performing a GROUP BY, which characteristics will improve performance?

Fewer distinct values in the GROUP BY columns

More distinct values in the GROUP BY columns

Using Indexed columns in the GROUP BY columns

Gathering Statistics on the GROUP BY columns

You load data from a stage using COPY INTO. You wish to load the data again, effectively duplicating the rows. How would you do this?

Perform the COPY INTO with the FORCE option

Perform the COPY INTO with the DUPLICATE option

Perform the same COPY INTO command a second time

What are ways you can define when a task should run?

Specify the AFTER option to automatically run a child task after its parent task has successfully completed.

Specify an interval of time after which the task should run (such as 60 minutes).

Use CRON sytax to specify a time, date, day of the week, and similar options.

Click the scheduling options in the Task wizard.

Which view do you use to see the status of your tasks?

INFORMATION_SCHEMA.TASK_HISTORY

INFORMATION_SCHEMA.QUERY_HISTORY

INFORMATION_SCHEMA.SERVERLESS_TASK_HISTORY

What do High-Performing Functions do?

Estimate approximate values using litle memory

Provide procedural logic that SQL alone does not support

Typically run slower in order to produce precise results

Perform aggregate functions on a subset of input rows

Which are true of User Defined Functions?

Can be defined as secure so unauthorized users cannot see the underlying definition or tables

Return either one (scalar) or more (tabular) rows

Can include DDL to create and modify tables

For login access on your organization's Snowflake account, you can create a network policy to allow or block access based on:

subnet range, such as countries or continents (using CIDR notation)

Which are true of authorization in Snowflake?

Row-level authorization limits which rows a user sees based on their current role, user, or account.

Secure views and UDFs prevent unauthorized users from seeing their underlying query logic or source data.

Privileges are assigned to roles.

Queries of a secure view are optimized to run faster because when users are blocked, processing steps are bypassed.

If you were querying a table earlier, but now the query returns an error message and you no longer see the table in the Object Browser, what should you check first?

Check which role you are currently using, as you may have switched to a role that does not have access to the table.

Check with someone who can use the ACCOUNTADMIN role and ask them to make sure nothing happened to the table.

Check with other users to find out if someone deleted the table.

Check with Snowflake support to ask them to retrieve the table with Fail-safe.

How does Snowflake most commonly store semi-structured data, such as JSON, Avro, Parquet, ORC, and XML?

Stored as JSON, AVRO, PARQUET, ORC, or XML data types

Stored as CLOB, NCLOB, LOB, or BSON data types

How can you operate on values stored in semi-structured format, for example, to compare values, add or average values, or filter them?

CAST the values to SQL data types

Use the FLATTEN command to pull out nested values

Directly query the VARIANT column

Data sharing is _________.

available only for read-only access

subject to data transfer costs from Provider to Consumer

What can Consumers do with a share?

Join rows of a share with rows of an existing table in their own account

Copy shared data into another table in their own account with CREATE TABLE AS…

Import the same share to multiple "database" definitions in their own account

With an Economy scale-out policy, how many minutes could a query be waiting before starting?

There is no wait; A new cluster is started as soon as required

You can define this wait time with the parameter MAX_QUERY_WAIT_TIME

With Economy, a query could potentially wait forever

Which are recommended to save on Snowflake storage costs?

Reduce default Time travel settings on objects where appropriate.

Remove transient objects that are no longer needed.

Use COPY INTO with the PURGE option or check internal stages for already-loaded files.

Opt for pay-as-you-use pricing over capacity pricing.

To save on compute costs, which are recommended?

Use Resource Monitors to help control compute usage.

Use multi-cluster warehouses with auto-scaling.

Set the auto-suspend value to short timeframes (1 minute or less).

Always select the smallest size virtual warehouse.

Which of these are potential causes of poor micro-partition pruning?

Using a WHERE x LIKE '%something%'

Filtering on any column other than the date

Using SELECT in the FROM clause

What does a FILE FORMAT do?

Describe how to read input files

Format the data being written to the table

Which are true about STAGES?

A stage is a cloud file respository

A stage can be internal or external

Stages disappear as soon as all files are loaded

You can manually create named stages, user stages, or table stages

Which are true about FORMATS?

A file format stores information needed to parse input files for loading

File formats store data of a particular type

You must specify a file format as part of every COPY INTO command

When is Snowflake responsible for encrypting files in a stage?

When the file is tagged "secure"

When the client fails to encrypt the file

EOD Fundamentals Quiz

Quiz

•

Instructional Technology

•

Professional Development

•

Practice Problem

•

Hard

Sydney Cucchiara

Used 5+ times

FREE Resource

54 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

What are the types of scaling?

Across

Up/Down

Blocked/Through

Back/Out

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Metadata is managed in which layer?

Compute Layer

Data Storage Layer

Cloud Services Layer

Cloud Vendor (Azure, AWS, GCP)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How does Snowflake eliminate irrelevant data from scans?

Defragmentation

Pruning

Indexes

Gaussian elimination

4.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

What are the four components of your session context?

Schema

Database

Role

Group

Warehouse

5.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

How can you connect to Snowflake?

JDBC

Snowsight

Snowclient

SnowSQL

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How could you protect a table with sensitive columns from being accessed by certain roles, without consuming more storage?

Create a secure materialized view on the sensitive table, grant access only to the secure materialized view

Create a secure view on the sensitive table, grant access only to the secure view

Create a materialized view on the sensitive table, grant access only to the materialized view

Create a view on the sensitive table, grant access only to the view.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You execute "create table MyTable (column1 varchar(50));". What is the name of the table created?

MyTable

mytable

"MyTable"

MYTABLE

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

50 questions 2 ICT

Quiz

•

Professional Development

50 questions

แนวข้อสอบโครงงานคอมพิวเตอร์

Quiz

•

Professional Development

50 questions

CIS CSM #4

Quiz

•

Professional Development

59 questions

Tables in Word

Quiz

•

5th Grade - Professio...

54 questions

Cuestionario Semana 2

Quiz

•

KG - Professional Dev...

51 questions

ICT 450-500

Quiz

•

Professional Development

Popular Resources on Wayground

10 questions

Forest Self-Management

Lesson

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

30 questions

Thanksgiving Trivia

Quiz

•

9th - 12th Grade

30 questions

Thanksgiving Trivia

Quiz

•

6th Grade

11 questions

Would You Rather - Thanksgiving

Lesson

•

KG - 12th Grade

48 questions

The Eagle Way

Quiz

•

6th Grade

10 questions

Identifying equations

Quiz

•

KG - University

10 questions

Thanksgiving

Lesson

•

5th - 7th Grade

Discover more resources for Instructional Technology

20 questions

HS2C2 AB QUIZIZZ

Quiz

•

1st Grade - Professio...

EOD Fundamentals Quiz

54 questions

What are the types of scaling?

Metadata is managed in which layer?

How does Snowflake eliminate irrelevant data from scans?

What are the four components of your session context?

How can you connect to Snowflake?

How could you protect a table with sensitive columns from being accessed by certain roles, without consuming more storage?

You execute "create table MyTable (column1 varchar(50));". What is the name of the table created?

While troubleshooting, you want a way to quickly locate all queries related to a specific workload. What feature would help with this?

You execute the following statements: ALTER ACCOUNT SET DATA_RETENTION_TIME_IN_DAYS = 5; ALTER TABLE mytable SET DATA_RETENTION_TIME_IN_DAYS = 10; How many days of retention will be effective on mytable?

What caches do we have in Snowflake?

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Instructional Technology