New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Snowflake SOL-C01 - SnowPro Associate: Platform Certification Exam

Page: 4 / 7
Total 214 questions

Which role is a system defined role in Snowflake?

A.

USERADMIN

B.

SNOWFLAKE_ADMIN

C.

SNOWFLAKE_DBA

D.

DATA_ENGINEER

What is the LIST command used for in Snowflake?

A.

Lists all the users assigned to a given role.

B.

Lists all the files in a given stage.

C.

Lists all the tables in a specific schema.

D.

Lists all the privileges granted on a specific object.

What are computer language considerations when using Snowflake interfaces? (Select TWO).

A.

Notebook cells can be written in Python.

B.

Databases can process queries using Scala.

C.

Notebook cells can be written in SQL.

D.

Worksheets can only be written in SQL.

E.

Dashboards can be written in JavaScript.

Which of the following is true about Snowflake clones?

A.

Clones can only be created from databases, not tables or schemas.

B.

Clones initially consume minimal/no storage, with storage only being used for changes made to the clone or the original.

C.

Clones consume the same storage as the original object.

D.

Clones are automatically synchronized with the original object.

What is the purpose of a role hierarchy in Snowflake?

A.

To define the sequence of SQL queries

B.

To organize roles and grant inherited privileges

C.

To manage network settings

D.

To store raw data

What are virtual warehouses in Snowflake?

A.

A compute resource

B.

A worksheet for writing queries

C.

A type of user account

D.

A storage location for data files

Which Snowflake Cortex LLM function allows a user to specify which model will be used?

A.

COMPLETE

B.

SENTIMENT

C.

SUMMARIZE

D.

TRANSLATE

What is the purpose of the "auto-suspend" feature in Snowflake virtual warehouses?

A.

To automatically increase the size of the warehouse during peak load

B.

To automatically shut down the warehouse after a period of inactivity

C.

To automatically add more nodes to the warehouse

D.

To automatically reduce the number of clusters

What a Database in Snowflake cant contain?

A.

Views

B.

Tables

C.

Role

D.

Database Role

Which statement is true regarding internal stages?

A.

Internal stages can only be used for semi-structured data

B.

Internal stages are accessed with external cloud provider credentials

C.

Internal stages are managed and stored within Snowflake

D.

Internal stages can only be used for structured data