SnowPro Core

The fail-safe retention period is how many days?A . 1 dayB . 7 daysC . 45 daysD . 90 daysView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

Account-level storage usage can be monitored via:A . The snowflake wet Interface (UI) in the Databases section.B . The Snowflake web interface (UI) in the Account -> Billing a usage sectionC . The Information Schema -> ACCOUNT_USAGE_HISTORY ViewD . The Account usage Schema - > ACCOUNT_USAGE_METRICS ViewView AnswerAnswer: D

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?A . 1 HourB . 3 HoursC . 12 hoursD . 24 hoursView AnswerAnswer: D Explanation: Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Which type of table corresponds to a single Snowflake session?A . TemporaryB . TranslentC . ProvisionalD . PermanentView AnswerAnswer: A

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.A . TrueB . FalseView AnswerAnswer: B

Which statement best describes '' clustering''?A . Clustering represents the way data is grouped together and stored within snowflake's micro-partitionsB . The database administrator must define the clustering methodology for each Snowflake table.C . The clustering key must be included on the COPV command when loading data into Snowflake.D ....

What is the recommended method for loading data into Snowflake?A . Load row by rowB . Load data in batchC . Load data by writing it In the Snowflake Web Interface (UI)D . Load data via frequent, angle row DML'sView AnswerAnswer: B

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)A . Customers can change the size of the Warehouse after creationB . A Warehouse can be resized while runningC . A Warehouse can be configured to suspend after a period of inactivityD . A Warehouse can...

True or False: You can resize a Virtual Warehouse while queries are running.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

What is the lowest Snowflake edition that offers Time Travel up to 90 days.A . standard EditionB . Premier EditionC . Enterprise EditionD . Business Critical EditionView AnswerAnswer: C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-availability.html