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

A.

IMPORT SHARE

B.

OWNERSHIP

C.

REFERENCES

D.

USAGE

Which SQL command can be used to see the CREATE definition of a masking policy?

A.

SHOW MASKING POLICIES

B.

DESCRIBE MASKING POLICY

C.

GET_DDL

D.

LIST MASKING POLICIES

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

A.

Cloud Services

B.

Database Storage

C.

Query Processing

D.

Metadata Management

A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

A.

When after 2-3 consecutive checks the system determines that the load on the mostloaded cluster could be redistributed.

B.

When after 5-6 consecutive checks the system determines that the load on the mostloaded cluster could be redistributed.

C.

When after 5-6 consecutive checks the system determines that the load on the leastloaded cluster could be redistributed.

D.

When after 2-3 consecutive checks the system determines that the load on the leastloaded cluster could be redistributed.

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

A.

The clone always stays in sync with the original table.

B.

The clone has better query performance.

C.

The clone is created almost instantly.

D.

The clone will have time travel history from the original table.

E.

The clone saves space by not duplicating storage.

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

A.

Reorder the rows in a relational table and then unload the rows into a file

B.

Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

C.

Reorder the data columns according to a target table definition and then unload the rows into the table.

D.

Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

Data storage for individual tables can be monitored using which commands and/or objects?
(Choose two.)

A.

SHOW STORAGE BY TABLE;

B.

SHOW TABLES;

C.

Information Schema -> TABLE_HISTORY

D.

Information Schema -> TABLE_FUNCTION

E.

Information Schema -> TABLE_STORAGE_METRICS

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

A.

CREATE_SHARE on the account

B.

SHARE on databases and schemas

C.

SELECT on tables used by the secure view

D.

REFERENCE_USAGE on databases

How does a scoped URL expire?

A.

When the data cache clears.

B.

When the persisted query result period ends.

C.

The encoded URL access is permanent.

D.

The length of time is specified in the expiration_time argument.

Which TABLE function helps to convert semi-structured data to a relational representation?

A.

CHECK_JSON

B.

TO_JSON

C.

FLATTEN

D.

PARSE_JSON

Which kind of Snowflake table stores file-level metadata for each file in a stage?

A.

Directory

B.

External

C.

Temporary

D.

Transient

Which Snowflake feature will allow small volumes of data to continuously load into
Snowflake and will incrementally make the data available for analysis?

A.

COPY INTO

B.

CREATE PIPE

C.

INSERT INTO

D.

TABLE STREAM