Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

A.

Fail-safe

B.

Network policies

C.

End-to-end encryption

D.

Multi-Factor Authentication (MFA)

Which Snowflake tool or feature enables governed sharing of datasets with a selected group of consumers that are invited, internal or external, to a Snowflake user's company?

A.

Snowflake Marketplace

B.

Data Exchange

C.

Replication

D.

Snowpipe

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

A.

Permanent

B.

Transient

C.

Temporary

D.

Externa

Which command will create an ARRAY output from inputs 'a' and 'b'?

A.

ARRAY_CONSTRUCT('a', 'b');

B.

TO_ARRAY('a', 'b');

C.

AS_ARRAY('a', 'b');

D.

LISTAGG('a', 'b');

Which privilege allows a user to change the state of a virtual warehouse that was set to AUTO_RESUME = FALSE?

A.

APPLYBUDGET

B.

MONITOR

C.

OPERATE

D.

USAGE

Use of what parameter will allow files to be loaded even if the file metadata has expired?

A.

MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE

B.

ENFORCE_LENGTH = TRUE

C.

PURGE = TRUE

D.

LOAD_UNCERTAIN_FILES = TRUE

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON To SHARE ;

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

When do Snowflake object owners lose their ability to make grant decisions?

A.

When the object owner has been granted a database role

B.

When the object owner has been granted an account role

C.

When the object is part of a managed access schema

D.

When the object is part of a regular schema

What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?

A.

Scale-up by resizing the warehouse.

B.

Scale-out with a multi-cluster warehouse.

C.

Disable auto-suspend on the warehouse.

D.

Enable auto-resume on the warehouse.

Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

A.

NOTIF

B.

NOTIFY_USERS

C.

SUSPEND

D.

SUSPEND_IMMEDIATE

Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?

A.

APPROXIMATE_SIMILARITY

B.

JAROWINKLER_SIMILARITY

C.

APPROXIMATE_JACCARD_INDEX

D.

MINHASH COMBINE

A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.

Which Snowflake do it the user's IP address does not match the user-level network policy rules?

A.

Log the user out.

B.

Deactivate the network policy.

C.

Prevent the user from executing additional queries.

D.

Allow the user to continue until the session or login token expires.

When cloning a schema, which Snowflake object will not be included in the clone?

A.

An external stage

B.

A named internal stage

C.

A task

D.

A User-Defined Function (UDF)

Which URL type permits temporary access to a staged file without granting privileges to the stage?

A.

Pre-signed URL

B.

Scoped URL

C.

File URL

D.

Build_Stage_File_URL

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

A.

Pruning

B.

Spilling

C.

Initialization

D.

Local Disk I/O

E.

Percentage of data read from cache

Who can access the data published in a Data Exchange?

A.

Only the data provider who published the data

B.

Any Snowflake user, regardless of their role or permissions

C.

Any user who has been provided with a unique Data Exchange URL

D.

Only the users that the data provider has invited to the Data Exchange

Which transformation techniques are supported for bulk loading data into Snowflake using the copy into

command? (Select TWO)

A.

Column grouping

B.

Column omission

C.

Column reordering

D.

Column aggregation

E.

Selection of a limited number of rows

Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?

A.

ACCESS_HOSTORY

B.

LOGIN_HISTORY

C.

SESSIONS

D.

QUERY HISTORY

What privileges or user roles are required to get or request access to data that is available in the Snowflake Marketplace? (Select TWO).

A.

MANAGE SHARE

B.

IMPORT SHARE

C.

USERADMIN

D.

SECURITYADMIN

E.

ACCOUNTADMIN

A user wants to access stored in a stage without authenticating into Snowflake.

Which type of URL should be used?

A.

File URL

B.

Staged URL

C.

Scoped URL

D.

Pre-signed URL