SnowPro Core

Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?A . Account -> Schema -> Database -> TableB . Account -> Database -> Schema -> TableC . Database -> Schema -> Table -> AccountD . Database -> Table -> Schema -> AccountView AnswerAnswer: B Explanation:...

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answersA . MIN(< < column value>>)B . COPYC . SUM(<< column value >>)D . UPDATEView AnswerAnswer: B,C,D

Select the different types of Internal Stages: (Choose three.)A . Named StageB . User StageC . Table StageD . Schema StageView AnswerAnswer: A,B,C Explanation: Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

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

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

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)A . CustomB . EconomyC . OptimizedD . StandardView AnswerAnswer: B,D Explanation: Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)A . UsersB . TablesC . DatabasesD . Internal StagesView AnswerAnswer: A,B,C

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 of the following statements are true of Snowflake releases: (Choose two.)A . They happen approximately weeklyB . They roll up and release approximately monthly, but customers can request early release applicationC . During a release, new customer requests/queries/connections transparently move over to the newer versionD . A customer is...

What happens when a Data Provider revokes privileges to a Share on an object in their source database?A . The object immediately becomes unavailable for all Data ConsumersB . Any additional data arriving after this point in time will not be visible to Data ConsumersC . The Data Consumers stop...