SOL-C01 Practice Questions

A.  

USERADMIN

B.  

SNOWFLAKE_ADMIN

C.  

SNOWFLAKE_DBA

D.  

DATA_ENGINEER

A.  

BLOB

B.  

JSON

C.  

VARIANT

D.  

VARCHAR

A.  

TRANSLATE

B.  

CLASSIFY_TEXT / AI_CLASSIFY

C.  

COUNT_TOKENS

D.  

PARSE_DOCUMENT

A.  

It allows more concurrent users to connect.

B.  

It can process larger and more complex queries faster.

C.  

It gains more storage capacity.

D.  

It reduces the cost of running queries.

A.  

STRING

B.  

TEXT

C.  

VARCHAR

D.  

VARIANT

A.  

Any Snowflake account administrator can enable Data Exchange through the web interface with a single click.

B.  

Activation of the Data Exchange feature generally requires a request to Snowflake Support, who then enable it for the specific account.

C.  

Data Exchange is automatically enabled for all Snowflake accounts upon creation.

D.  

Activation of the Data Exchange feature requires a specific SQL command to be executed by the ACCOUNTADMIN role.

A.  

Drag-and-drop interface

B.  

Command-line input

C.  

Manual data entry

D.  

Only supports cloud storage

A.  

External stages reduce data storage costs because data is stored outside Snowflake.

B.  

External stages provide automatic data purging after successful loads.

C.  

External stages are more secure than internal stages for sensitive data.

D.  

External stages reduce the number of objects in a database.

A.  

COMPLETE

B.  

SENTIMENT

C.  

SUMMARIZE

D.  

TRANSLATE

A.  

To manage and enforce permissions on objects

B.  

To define user tasks

C.  

To optimize query execution plans

D.  

To control which data types users can query