Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

Authorization to execute CREATE statements comes only from which role?

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

What do temporary and transient tables have m common in Snowflake? (Select TWO).

A.

Both tables have no Fail-safe period.

B.

Both tables have data retention period maximums of one day.

C.

Both tables are visible only to a single user session.

D.

For both tables the retention period ends when the tables are dropped.

E.

For both tables, the retention period does not end when the session ends

Which function is used to unload a relational table into a JSON file*?

A.

PARSE_JSON

B.

JSON_EXTRACT_PATH_TEXT

C.

OBJECT_CONSTRUCT

D.

TO_JSON

A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O.

How can this be prevented m the future?

A.

Convert the virtual warehouse to Maximized mode.

B.

Increase the size of the virtual warehouse.

C.

Increase the auto suspend time in the virtual warehouse.

D.

Increase the number of clusters in the virtual warehouse.

What happens to event notifications that are received when an automated Snowpipe is paused?

A.

They are immediately dropped from the internal metadata.

B.

They are stored indefinitely in the internal metadata until the pipe is manually resumed.

C.

They are permanently stored in the internal metadata and processed once the pipe is resumed.

D.

They enter a retention period of 14 days, after which they are dropped from the internal metadata.

What is the MAXIMUM size limit for a record of a VARIANT data type?

A.

8MB

B.

16MB

C.

32MB

D.

128MB

How long does Snowflake retain information in the ACCESS HISTORY view?

A.

7 days

B.

14 days

C.

28 days

D.

365 days

What is used to diagnose and troubleshoot network connections to Snowflake?

A.

SnowCD

B.

Snowpark

C.

Snowsight

D.

SnowSQL

By definition, a secure view is exposed only to users with what privilege?

A.

IMPORT SHARE

B.

OWNERSHIP

C.

REFERENCES

D.

USAGE

How would a user run a multi-cluster warehouse in maximized mode?

A.

Configure the maximum clusters setting to "Maximum."

B.

Turn on the additional clusters manually after starting the warehouse.

C.

Set the minimum Clusters and maximum Clusters settings to the same value.

D.

Set the minimum clusters and maximum clusters settings to different values.

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

A.

USAGE

B.

OPERATE

C.

MONITOR

D.

MODIFY

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A.

Cloud services layer

B.

Compute layer

C.

Storage layer

D.

Cloud agnostic layer

Which statement describes how Snowflake supports reader accounts?

A.

A reader account can consume data from the provider account that created it and combine it with its own data.

B.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

A.

A User-Defined Table Function (UDTF)

B.

A Scalar User Function (UDF)

C.

A stored procedure

D.

A task

Which of the following can be used when unloading data from Snowflake? (Choose two.)

A.

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B.

Use the ENCODING file format option to change the encoding from the default UTF-8.

C.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

A.

The columns that are queried in the select clause.

B.

The columns with very high cardinality.

C.

The columns with many different values.

D.

The columns most actively used in the select filters.

How many resource monitors can be assigned at the account level?

A.

1

B.

2

C.

3

D.

4

What can a Snowflake user do with the information included in the details section of a Query Profile?

A.

Determine the total duration of the query.

B.

Determine the role of the user who ran the query.

C.

Determine the source system that the queried table is from.

D.

Determine if the query was on structured or semi-structured data.

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

A.

Swift

B.

JavaScript

C.

Python

D.

SQL

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

A.

A VARIANT column

B.

A column with very low cardinality

C.

A column with very high cardinality

D.

A column that is most actively used in selective filters

E.

A column that is most actively used in join predicates