SnowPro-Core Exam Dumps - SnowPro Core Certification Exam

Go to page:

<< First
Prev
1
2
3
4
5
6
7
8
9
10
Next
Last >>

Question # 4

In a Snowflake role hierarchy, what is the top-level role?

SYSADMIN

ORGADMIN

ACCOUNTADMIN

SECURITYADMIN

Full Access

Question # 5

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Full Access

Question # 6

A user created 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?

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

The transient table version cannot be retrieved after 24 hours.

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

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

Full Access

Question # 7

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Use the DROP command after the load completes.

Specify the TEMPORARY option when creating the file format.

Specify the PURGE copy option in the COPY INTO

command.

Use the REMOVE command after the load completes.

Use the DELETE LOAD HISTORY command after the load completes.

Full Access

Â command, which will automatically delete the files after they have been successfully loaded.Â Additionally, you can use theÂ REMOVEÂ command after the load completes to manually delete the files from the stage12.

References =Â DROP STAGE,Â REMOVE

Question # 8

Which minimum Snowflake edition allows for a dedicated metadata store?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Full Access