A company's security audit requires generating a report listing all Snowflake logins (e.g..date and user) within the last 90 days. Which of the following statements will return the required information?

A.

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;

B.

SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())

C.

SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D.

SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

A.

The primary cluster in the virtual warehouse

B.

The entire virtual warehouse

C.

The database in which the virtual warehouse resides

D.

The Queries currently being run on the virtual warehouse

In which use cases does Snowflake apply egress charges?

A.

Data sharing within a specific region

B.

Query result retrieval

C.

Database replication

D.

Loading data into Snowflake

True or False: A Virtual Warehouse can be resized while suspended.

A.

True

B.

False

Which Snowflake feature is used for both querying and restoring data?

A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

What are ways to create and manage data shares in Snowflake? (Select TWO)

A.

Through the Snowflake web interface (Ul)

B.

Through the DATA_SHARE=TRUE parameter

C.

Through SQL commands

D.

Through the enable__share=true parameter

E.

Using the CREATE SHARE AS SELECT * TABLE command

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

When is the result set cache no longer available? (Select TWO)

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

A.

Yes, because a table owner has full control and can unset masking policies.

B.

Yes, because masking policies only apply to cloned tables.

C.

No, because masking policies must always reference specific access roles.

D.

No, because ownership of a table does not include the ability to change masking policies

A user reated a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table. How can this be accomplished?

A.

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

B.

The transient table version cannot be retrieved after 24 hours.

C.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

D.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe
storage.